How to Export and Import Inventory Master Information
[Pages:5]How to Export and Import Inventory Master Information
Sage Pastel Accounting Newsflash ? Support Self-Help Documentation ? December 2015
You may find that you need to export and import your inventory Masterfile information for the
following reasons:
1.
You need to change the information on multiple items
2.
You would like to import this information into another company
Please note that only the inventory details from the inventory master file can be exported from Pastel. Transactions history cannot be exported or imported.
You can export inventory items as per the below instructions: ? Click on File | Export / Import ? Select Export Inventory items from the dropdown list as shown below:
? Click on the magnifying glass and browse the location where you would like to save the exported file on you PC i.e. Desktop
? Give the file a name with the extension .csv i.e. inventory.csv ? Click Process to open the screen below:
NOTE: The stores option will only show in Sage Pastel Partner and only if you have the Multi-Store module activated. Select your filters and click OK. If you need to make changes to the Inventory items information open the csv from the location you saved the file to and make the necessary changes. Remember to save the file before you import the file again however do not close the file as you will need to format some of the cells which will be explained below. If you just wish to import the information into another company without making changes you do not need to open the file you saved. You can import inventory items as per the below instructions:
Sage Pastel Accounting Newsflash ? Support Self-Help Documentation ? December 2015
Sage Pastel Partner after editing the file:
? Make the changes necessary and keep the file open ? Highlight column AB ? Right click on the colum and select the option to format cells as shown below:
? On the number tab click on custom as shown below:
? On the right where you see General delete this and type in 000 as shown below:
Sage Pastel Accounting Newsflash ? Support Self-Help Documentation ? December 2015
? Follow the same process to customize column AJ ? Save the file but leave it open
For Sage Pastel Xpress:
? Make the changes necessary and keep the file open ? Highlight column U ? Right click on the column and select the option to format cells as shown below:
? On the number tab click on custom as shown below:
? On the right where you see General delete this and type in 000 as shown below:
Sage Pastel Accounting Newsflash ? Support Self-Help Documentation ? December 2015
? Follow the same process to customize column AC ? Save the file but leave it open To import the Inventory Item in Sage Pastel Accounting ? Open the company in Sage Pastel accounting ? Select Import Inventory Items from the dropdown list as shown below:
? Click on the magnifying glass and browse to the location where you saved the exported file(s) i.e. Desktop
? De-select the option to Map Fields as shown below:
? Then click on Process.
Sage Pastel Accounting Newsflash ? Support Self-Help Documentation ? December 2015
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- quick guide to bloomberg university of leicester
- morningstar excel add in
- morningstar excel add in reference guide
- how to export and import inventory master information
- how to download bloomberg data into excel
- download ing data using the bloomberg excel addin
- excel add ins quick start guide university of toronto
- getting started on bloomberg launchpad
- microsoft excel 2019 business modeling
- stock management guide epos now
Related searches
- how to export pdf to excel
- how to export excel to pdf
- how to export dataset from r
- how to export excel to word
- how to export excel file
- how to export active directory
- how to export contacts from outlook online
- how to export word to excel
- how to export data from excel spreadsheet
- how to export a file to excel
- how to export on excel
- how to export notepad to excel