SageForum for UK versions of Sage 50- Help and support.

We are using Sage 17 on XP

We have 2000+ product items (already entered on Sage) including some with BOM's and are hoping to import the opening balances from an excel CSV file/spreadsheet. Can anyone help with the column headings necessary to import correctly.

Open the Sage 50 Help File and do a search for 'import data'. Click on the first result and scroll down to the bottom where you'll see a link for Import File Details. Click on the link and, on the new page, scroll to the bottom and select Stock Transactions - the document that appears has all the information you need.

John

Thank you again John.

If you need them in future, I keep a list of them on the web

http://import.makingithappen.co.uk/csv_prodrec.htm