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

Importing Stock Quantitys through .CSV file

Sage 50 general help forum - Free help and support for all general issues
Post Reply
jerrygallow

Importing Stock Quantitys through .CSV file

Post by jerrygallow » 16 Apr 2007, 12:20

I am importing stock records via .CSV files and would like to know if poss to also add stock quantitys with this file, I cant work out where the stock quantity goes in the .cvs file (example below)

Code: Select all

"TEST","TEST","T7",20.00,8.85,"","","4001",2,2,"ROHDESHO","",0.00,0,"2100000125081",0.00,"",0.00,0.00
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 17 Apr 2007, 07:28

You need to do a separate stock transaction imports to put into stock the quantities you want at the appropriate cost prices.
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
jerrygallow

Post by jerrygallow » 17 Apr 2007, 08:30

Thanks, how would this look like on a .csv file like the example above
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Post by brucedenney » 18 Apr 2007, 10:13

They have swapped some of the fields around in different versions.

Check the help file for your version index>import>file details>product transaction.
or
run / edit the Product Report >Product Details>Product Transaction CSV
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: No registered users and 0 guests