Heading Description
Explanations:
- Part Manufacturer Item ID:
This is the most important field. If
this matches a current manufacturer id the purchase will be adding to an exist
part in your inventory. If there is no
existing matching ID then a new part entry will be created.
If there are duplicate manufacture ids in your csv file for more than one part
they will not get imported.
- Part_Category:
Enter a category for the part
- Part_Description
Enter a part description
- Part_Name:
Enter a part name
- Part_Size
Enter a part size
- Part_#_Per
Enter the total number of parts per bag/pack/wire length etc.
- Part_Date
Enter the purchase date
- Part_Per
Enter a description for the unit of measure, ie bag/roll/pack etc.
- Part_Price
Enter the total price of the purchase
- Part_QTY_Purchased
Enter the number of bags/packs/rolls of wire etc. purchased
- Ship_Cost
Enter the shipping cost
- Tax_Inc_Flag
Enter 1 if Tax is included. Enter 0
If tax is not included
- Tax_Percent
Enter the Tax amount as a decimal.
0.1 = 10%, 0.5 = 5% etc.
- Vendor_Order_#
Enter a Vendor order number (if applicable)
Import Instructions:
a) Download a blank copy of the csv file from here and save this to your local machine.
b) Fill in the details of your purchases as per the header descriptions above and save the file with a new name so you can use the blank template again as required.
c) Select the “Import” button option and select the csv file that you have saved with your purchase information and click ok.
d)
Select the correct Tax option to use the tax
rate from the sheet or from your Admin settings.
e)
Review the information presented in the list
view and select Import if correct.
f) Review the final imported data and make changes if required.
Simply click the Export Purchases button and an excel file will be
created on your desktop containing the purchase history details.
Simply click the History button and print the list that is created on
your printer.
Related Topics
Adding Part Purchases In Vendor Screen: