Calculating Extension Amounts

 

The Open Purchase Order Report, Open Orders by Item Report, and Open Orders by Job Report show the ordered quantity that has not yet been received. The extension amount on these reports is calculated according to a variety of factors.

For all inventory, special, and miscellaneous items, the back order quantity is used to calculate the open order extension amount using the following equation:

Back Order Quantity x Unit Cost = Extension

If the back order quantity is zero and the received quantity is zero because the item has not yet been received, the ordered quantity is used to calculate the open order extension amount using the following equation:

Ordered Quantity x Unit Cost = Extension

For miscellaneous charges, the invoiced quantity is subtracted from the ordered quantity to derive the open order extension amount using the following equation:

Ordered Quantity - Invoiced Quantity = Extension

For more information, see:

Defining the Hierarchy of Costs

Open Purchase Order Report

Open Orders by Item Report

Open Orders by Job Report

 

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks