Overview
To import purchase order into the database.
Mandatory fields:
- Item id: The item ID of all the items thats in the purchase order is entered (this can be obtained from the Listing Reports (Inventory ID - select item).
- Quantity: The quantity of the items in the purchase order is entered here.
- Vendor id: The vendor to whom the purchase order is sent is entered here. Each purchase order should have the vendor, Venue and level and level ID same since the each vendor corresponds to one particular PO. On this import the VendorID is entered (this can be obtained from the Listing Reports (Inventory ID - select vendor)
- Venue id: The venue of the PO thats to be delivered is entered. Enter the Venue ID obtained from the Listing Reports (Hierarchy ID - select venue)
- Level: If the items are going to store, S is entered.If its warehouse W is entered.
- Level id: The ID of the warehouse or store is entered (this can be obtained from the Listing Reports (Hierarchy ID - select store or warehouse).
Not Mandatory fields:
Unit Cost: The unit cost of the item is entered, if blank it takes the unit cost in the database.
Retail Price: The retail price of the item is entered, if blank it takes the retail price from the database.
Discount: Discount ID thats to be processed on the items is entered here.
Tax: Tax ID thats to be processed on the items is entered here.
Unit Of Measure: The conversion units are entered here.
...