Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 measureOf Measure: The conversion units are entered here.

Actions performed on successful import:
On Successful import of the purchase order the process is initiated and gives out a Purchase order number.The user has to go to the CAS and search for the number in the Purchase order screen and Send it for approval, then when its approved the user can send it to the vendor.