Issue

In Sage Pro ERP a sales order is created for a non-stock item in a single location company. Once the item is selected in the Line Item Details tab, its price appears. Below the price a cost of zero dollars appears. In the Item Master Maintenance screen, under the Cost/Usage tab, the average cost of the non-stock item shows a value greater than zero. This article explains where the cost of a non-stock item is being referenced from, during the sales order entry process in a single location company.

Solution or Workaround

During sales order entry, the cost of a non-stock item is referenced from the average cost sell factor field. This field exists in two places: the ICITEM and ICILOC tables. In a single location company, the cost is obtained from the ICITEM.Savgcst field while in a multi-location company, this cost is obtained from the ICILOC.Slagcst field.

The average cost in the Cost/Usage tab of the Item Master Maintenance screen may not be the same as the values in the ICITEM.Savgcst or ICILOC.Slagcst fields. Therefore when a non-stock item is added during sales order entry, a different cost could appear if the ICITEM.Savgcst or ICILOC.Slagcst fields have values that differ from the average cost value in the Item Master Maintenance screen.

Note: The average cost value in the Item Master Maintenance screen, in the Cost/Usage tab, is obtained from the ICITEM.Avgcost field. The average cost in the Item at Location screen, in the Cost/Usage tab, is obtained from the ICILOC.Lavgcst field.

Follow the steps below to correct this discrepancy in a single location company:

Create a Sales Order

1. Open Order Entry.
2. Under the Transaction menu, point to Enter Orders and click  Orders.
3. Select a customer.
4. Click Line Item Details.
5. Select a non-stock item and press ENTER.
6. In the second Price/Cost field (below the item price), type the desired cost.
7. Click Save Line.
8. Click Save to save the order.
9. Click Continue.

Ship the Sales Order

1. Under the Transaction menu, click Enter Shipments.
2. Click No when prompted to edit the price.
3. In the Enter Shipments screen, select the sales order.
4. Click Ship.
5. Click OK to confirm the shipment date.
6. Click Complete to ship the order complete.
7. Click Save to process the shipment.
8. If deferred invoicing is activated, click YES to invoice the shipment.
9. Click NO  when asked enter payment details.
10. Select any destination for the shipment log.

The average cost in the Cost/Usage tab of the Item Master Maintenance screen should now reflect the cost that was entered on the sales order that was just shipped.

Note: In a single location company the following fields are updated with the cost of the non-stock item at the time of shipment when a non-stock item is shipped: ICITEM.Avgcost, Savgcst and Pavgcst.

© Copyright Sage Software