Multiplying Quantity Invoiced by Unit Price

Use this procedure to multiply the quantity invoiced for each line item by the unit price to obtain the extended price for an outbound ANSI X12 invoice.

  1. Double-click the IT102 element (in the IT1 segment in the IT1 group). This is the element that you typically use to count the quantity invoiced.

    The system displays the Element Properties dialog box.

  2. Select the Standard Rule tab.
  3. From the standard rule list, select Use Accumulator.
  4. Click New.

    The system displays the Edit Accumulator Entry dialog box to create a new calculation for this element.

  5. From the Primary Accumulator list, select 2.
  6. In the Name box, type Extended Price.
  7. From the First list, select Load primary. This operation specifies that the system loads the contents of the element into the Primary Accumulator for each iteration of the IT1 group.
  8. Click OK to add the accumulator.
  9. Click OK on the Element Properties dialog box to add the standard rule to the IT102 element.
  10. Double-click the IT104 element (in the IT1 segment in the IT1 group). This is the element that contains the unit price for each line item.

    The system displays the Element Properties dialog box.

  11. Select the Standard Rule tab.
  12. From the standard rule list, select Use Accumulator.
  13. Click New.

    The system displays the Edit Accumulator Entry dialog box to create a new calculation for this element.

  14. From the Primary Accumulator list, select primary accumulator 2.
  15. From the First list, select Multiply with primary. This operation specifies that the system multiplies the value of the IT104 (Unit Price) element with the contents of the primary accumulator, and store the result in the primary accumulator for each iteration of the IT1 group.
  16. Click OK to add the accumulator.
  17. Click OK on the Element Properties dialog box to add the standard rule to the IT104 element.
    Tip: If there is an extended price element in your EDI file, you could load the total from the extended price calculation into that element. To do this, you need to use an accumulator on that extended price element that specifies Use primary for accumulator 2.