Daily Clear Import Prepay Usage

The following explains what happens with Bookings when a file is imported at Agvance Energy / Transfers / Import / Energy Force / Daily Clear.

Note: The file being imported will have a Booking number in the line, then only that Booking will be considered for use on the Invoice created.

Ignore Booking Product Match

  • If NOT CHECKED, Booking line items will be used ONLY if the product on the Booking matches the product on the Invoice. If there are multiple lines on the Booking that match the product on the Invoice, the line with the lowest unit price will be used first. Sales tax will only use a Booking line item if it matches the prepaid sales tax product setup found at Agvance Energy / Setup / Energy Force in the PrePaid Sales Tax Product Cross Ref grid.
  • If CHECKED, there are three choices for prepay tax:
    • Do Not Prepay Sales Tax – There will be no prepay used for sales tax, regardless of which lines are on the Booking. For the product line on the Invoice, the line with the lowest unit price will be used first, regardless of whether it matches the product on the Booking. This includes Booking lines that use the prepay sales tax product.
    • Use Prepaid Sales Tax Product Setup – Sales tax will only use lines from the Booking where the Booking line matches the prepaid sales tax product setup found at Agvance Energy / Setup / Energy Force in the PrePaid Sales Tax Product Cross Ref grid.  For the product line on the Invoice, the line with the lowest unit price will be used first, regardless of whether it matches the product on the Booking. This option will not use Booking lines for the prepay sales tax product for the product on the Invoice.
    • Use Any Line from the Specific Booking – This option will use any line from the Booking, selecting the line with the lowest price first. This rule applies to the line item on the Invoice and the sales tax amount.