The import of Purchase Order documents can be done in two ways:
Method 1 : Import Purchase Order using the 'Create Many Document' feature within the PEAK program.
Method 2 : Import Purchase Order using an Excel file.
Method 1 : Import Purchase Order using the 'Create Many Document' feature within the PEAK program. can be done following these steps:
Step 1.1: Select the Expenses menu >> Import Document.
Step 1.2: Click on 'Create Many Document'.
Step 1.3: Select 'Purchase Order'. Once selected, click on 'Create Import Data'.
Step 1.4: Specify various details:
Doc. No.: For Doc. No., the system will automatically generate a sequential document number for the non-itemized payment documents
Ref.: Fill in reference document.(if any)
Doc. Date: Specify the date of the payment record, which will be the same as the payment date.
Contact/Payee: Specify the vendor name.
Tax Invoice No.: Specify the tax invoice number received (if any).
Tax Invoice Date.: Specify the tax invoice date received (if any).
Pricing Type: Specify the price type as inclusive tax, exclusive tax, or none(none VAT). If 'none' is selected, you will not be able to specify the VAT type.
Product/Service: Specify the desired product or service.
Account: Specify the account number to enter the data.
Description: The system will display the account name or product name instead of the original description in the description field. Users can type additional information in the description field, and the system supports up to 1,000 characters.
Quantity: Specify the quantity, with support for up to 4 decimal places.
Price: Specify the price, with support for up to 4 decimal places.
Pre-tax Amount: Amount before tax calculation.
VAT: Specify the VAT rate for the item.
VAT Amount and Net Amount: PEAK Program will calculate automatically.
WHT: Specify the withholding tax rate for the item.
Remark: Specify additional notes in the document.
Classification: Classification for reporting in the PEAK Board (currently, only 1 item/document can be specified for import).
You can scroll to enter the details.
Note: Required information to be filled in:
B: Document Date
C, D, E: Contact/Payee
J: Description
When you have already entered the details of each document, there will be a checkmark icon next to the document number field.
If you want to add a Purchase Order document, you can click the button '+ Add document'.
In the case where there are multiple items in a purchase document, follow these steps:
Click '+ Add item in document' button to add a sub-item.
Select the Doc No. of the document where you want to add the sub-item.
Choose the number of sub-items you want to add.
Click '+ Add item in document' button.
For this example, adding a sub-item in Document Number: 1. Add 2 Items
The transaction will display an additional 2 rows for entering the sub-item
In case of adding more documents or sub-items than needed, you can delete the row by clicking (X) as shown in the example below.
When you have already entered all the required information, click 'Create all documents'.
Once all documents have been created, the bell icon in the top right corner will notify you about the import purchase Inventory transactions successfully.
You can view the import details by clicking on the bell icon >> 'View data'
After you click 'View data' , you can view the document details by clicking on the document number.
For the example of the Purchase Inventory documents, you can select the required tab to view.
Method 2 : Import Purchase Order using an Excel File
Step 2.1: Click the 'Import Document' button. >> Select 'Format PEAK'.
Step 2.2: Select the items to import as 'Purchase Order' and click the 'Download this form (.xlsx)' button.
Example Excel form:
It is recommended to read the additional details in the 'Description' sheet before filling in the data.
Step 2.3: When you have completed entering the data, save it on your device.
Step 2.4: To upload the saved file, drag and drop it into the system or click 'Search' to search for the file. Once you have selected the file successfully, click the 'Import' button to import it into the system.
