Insert data from Excel to Sage 200
We find that the way Sage 200 sets unit cost in sales order line items is lacking and limited to:
1. Standard costing - one standard cost for the unit cost of the product selected
2. FIFO costing - average buying price for the unit cost of the product selected
The above two do not allow for an accurate calculation of profit on a sales order.
In order to remedy this, we need to set the Product Unit Cost (itemcost) for every new line item (in SOPOrderReturnLine) based on the Product Item Code and Warehouse.
We will have the prices for the stock items in an excel. All we need to do is to get the <itemcode> and the warehouse from the line item (a row in SOPOrderReturnLine) and access an excel to get the price and overwrite <itemcost> with that data in the particular row in SOPOrderReturnLine.
The only problem is I don't see how warehouse is related to the SOPOrderReturnLine table.
There is no <warehouseid> in SOPOrderReturnLine.
Can anyone help with this? Thank you in advance.