Importing stock transactions overwrites cost

[bandonsage]

Hi, When importing stock transactions from excel, Sage overwrites the cost field. I don't want the cost field to be overwritten so tried leaving the cost field blank . This has the affect of returning the product cost in Sage to zero value. The cost field has to be included when importing stock transactions. Is there any way of managing the stock transaction import to leave the cost of stock in Sage at its original value ?

Stock Code Details Quantity Type Date Reference Cost Price Sales Price
1245A Pallet 24 AI 28/10/2011 8148 100

[brucedenney]

You can put the correct cost price on the transactions when you import.

Make a sheet that contains stock codes and cost prices, I would use ODBC to link this, but you could use EIR if you have Excel

Then lookup the cost price for each product code suing a VLOOKUP in your spreadsheet (assuming you use one of the big three spreadsheets LibreOffice, MS Excel or OpenOffice)

Save the sheet with the corrected cost price information and import.

[bandonsage]

Thanks, that will work . ODBC & VLookup should do the trick. Just wanted to make sure I wasn't missing anything in Sage.