Default Cost for a Line Item is Always the Last Cost Received

Issue

This article clarifies what determines the default cost for an item on a PO.

Solution or Workaround

Cost level functionality was added to Sage Pro ERP 7.3. It allows increased flexibility on assigned costs to items based on quantity ranges, date ranges and vendor part numbers.

When entering a line item on a purchase order, the default cost for a line item is always the last cost received, for that particular vendor at that location. This value is obtained from the Lastcst field in the ICSUPL table. If this field does not contain a value, the Unit Cost field on the purchase order entry screen defaults to “0.” This field is editable; however, the last cost cannot be edited through the front end of the product. It can only be changed when entering a new supplier for an item at a location.

© Copyright Sage Software

Leave A Comment?