The import of Purchase Inventory Record documents can be done in 2 methods:
Method 1 : Import Purchase Inventory Record using the 'Create Many Document' feature within the PEAK program.
Method 2 : Import Purchase Inventory Record using an Excel file.
Method 1 : Import Purchase Inventory Record 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 Inventory'. Once selected, click on 'Create Document'.
Step 1.4: Specify the 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.
Expense/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.
Paid via: Specify the payment method that you used to pay the vendor.
Payment Amount: Specify the amount paid. If no payment has been made, enter zero (0), and the system will create a payable record.
Total WHT Amount: PEAK Program will calculate automatically.
Withholding Tax Certificate (PND): If withholding tax is specified, indicate which type of withholding tax certificate is required.
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
I: Products/Service
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 Inventory document, you can click '+ Add document' button.
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 Inventory Record 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 Inventory' and click the 'Download this form (.xlsx)' button.
Example Excel form:
It is recommended to read the additional details in the 'Description' sheet before entering the information.
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.
