Page 1 of 1

Stock Control on Sage 50

Posted: 10 Feb 2009, 12:18
by Luke@BusinessReply
Hiya

I am looking at doing a stock count on a hand held device, is there anyway to import a stocktake into sage 50 from a csv or similar file?

Regards, Luke

Posted: 13 Feb 2009, 13:31
by brucedenney
No but yes.

You can export the stock levels of items in sage to an excel spreadsheet (using ODBC)
You can then calculate the stock adjustment you need to make in an excel spreadsheet

You can then create a csv file of stock adjustments using the product transaction format, which you can then import.

see below for the fields you need.

http://support.makingithappen.co.uk/gui ... dtrans.htm