Updating Purchase Order Costs

QAD 2017 Enterprise Edition > User Guides > Purchasing > Purchasing > Updating Purchase Order Costs

Use Purchase Order Cost Update (5.19) to update the unit cost of items. This program uses the same logic as Purchase Order Maintenance (5.7) to recalculate the price of eligible lines on the selected purchase orders.

Enter Yes in the Fixed Price field on the PO line to exclude individual order lines from automatic cost recalculation or No to include them. Lines that are closed, canceled, or returned are automatically excluded from the update. Set the default value for each supplier in Supplier Data Maintenance (2.3.1). The header value defaults to each of the line items.

Note: Scheduled orders can have prices fixed; however, scheduled orders typically do not have an order quantity to determine a price, so even though scheduled orders are not explicitly excluded in the update, PO costs on scheduled orders are not affected.

Orders are selected for update based on selection criteria you specify. Leave selection criteria blank to have all orders selected for processing. If Fixed Price for a line item is No, all available pricing information is used to determine the item’s new cost, including item master cost, and the price list specified in the purchase order if applicable.

Example: Enter a price list of type list. All purchase orders specifying that price list in the header are selected. Line items eligible for cost recalculation have their new costs calculated.

The update report shows both old and new costs and the discount for all lines changed. Net cost after discount is determined by the quantity ordered, but the open quantity is printed on the report.

If Keep Booking History is Yes in Purchasing Control (5.24), Purchase Order Cost Update creates transaction history records for all lines changed.