View Categories

Batch Purchase Order

If you have an existing data of purchase order and you want entry to the Localizebook system you can use the Batch Purchase Order function.

Go to Batch Purchase Order transaction into system:

  1. Go to the Accounting menu.
  2. Click on Batch Transaction.
  3. Choose Transaction Type “Purchase Order”
  4. Click on the Click this link to download the working template.
  1. Fill in the information for each function and save your excel file:
  2. TRAN TYPE (required): Please input type of transaction as ‘’PURCHASE_ORDER’’
  3. CLASS: Enter the class name of your purchase order. This class is the overall of your transaction.
  4. STATUS: If blank it will select ISSUED automatically.
  5. LOCATION: Enter the warehouse of your purchase, If blank it will select the default location automatically.
  6. DATE: Enter your transaction date (required).
  7. NUM: The reference of your purchase order.
  8. VENDOR: Enter your vendor name (required).
  9. MEMO: Describe your transaction. If you don’t have one, keep it blank.
  10. TEM CODE: The unique code of each item. If you don’t have one, keep it blank.
  11. ITEM NAME: Please input the item name that you set on the system (required).
  12. UNIT NAME: Please input the unit name of the item that you set on the system. If you don’t have the name of your product unit, please put N/A.
  13. QTY: The quantity of each item (required).
  14. COST: Is the purchase price per base unit (required).
  15. AMOUNT: The total amount of your purchase (required).
  16. VAT: If item has vat please input sales tax name on this column. If you don’t have the item code, keep it blank.
  17. DISCOUNT AMOUNT: The total amount of your discount. If the blank discount amount is equal to zero (0).
  18. CLASS DETAIL: Enter your class name. This class is detailed by transaction. If you don’t have one, keep it blank.
  1. After filling all the information please back to the system:
  2. Click on Browse File and select the template with purchase order data. If data is loaded, you are ready to import. But if there is any error, messages will be shown.
  3. Click on Import to take all your purchase order data into Localize.
Scroll to Top