Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Import Product O/B's

Sage 50 general help forum - Free help and support for all general issues
Post Reply
Sonaso
User
User
Posts: 7
Joined: 15 Jun 2011, 10:19
Sage Version: v2008 14 UK/Europe/Africa

Import Product O/B's

Post by Sonaso » 08 Aug 2011, 16:53

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.
Top
leyburnsolutions
User
User
Posts: 132
Joined: 14 Apr 2011, 18:02
Sage Version: v2014 20 UK/Europe/Africa

Re: Import Product O/B's

Post by leyburnsolutions » 08 Aug 2011, 17:33

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
Top
Sonaso
User
User
Posts: 7
Joined: 15 Jun 2011, 10:19
Sage Version: v2008 14 UK/Europe/Africa

Re: Import Product O/B's

Post by Sonaso » 09 Aug 2011, 11:29

Thank you again John.
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: Import Product O/B's

Post by brucedenney » 10 Aug 2011, 12:55

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

http://import.makingithappen.co.uk/csv_prodrec.htm
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: Amazon [Bot] and 2 guests