# Finance (Payables)

# Overview - Payables

## **PAYABLES MODULE** 

##### <span style="mso-ignore: vglayout; position: absolute; z-index: -1; left: 0px; margin-left: 198px; margin-top: 73px; width: 186px; height: 167px;">![](file:///C:\Users\a21ma\AppData\Local\Temp\msohtmlclip1\01\clip_image002.jpg)</span><span style="font-size: 10pt; line-height: 100%; color: rgb(0, 0, 0);">This module contains the Accounts Payable (AP) entry options for the various payable transactions, payments and real-time GL posting. The flow chart of AP module is as follow: </span>

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

##### **<span style="font-size: 10pt; line-height: 100%; color: rgb(0, 0, 0);">MENU NAVIGATION </span>**

<span style="font-size: 10pt; line-height: 100%; color: rgb(0, 0, 0);">Sub-menu items of Payables Module are listed below:</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-03/scaled-1680-/e0mimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-03/e0mimage.png)

The PAYABLES Module has 4 tabs, as shown above, which are Operations, Reports Queries and Maintenance, Document Printing and Settings.

- **AP Operations** is where transactions are entered, such as Payable Transactions and Opening Balances.
- **Reports Queries** contains all the Payable reports such as Supplier Ledger and others.
- **Document Printing** enables user to preview and print a range of AP Transactions.
- **Settings** is where master records are created.

# AP- OPERATIONS

<details id="bkmrk-ap-operations-payabl"><summary>AP OPERATIONS</summary>

## <span style="color: rgb(0, 0, 0);">**Payable Transaction** </span>

##### Transactions for **Supplier Invoice (PI),** **Credit Note (PC)**, **Debit Note (PD)** and **Payment transaction (PV)** can be done at this option. Allocation of outstanding invoices can be made via PI, PC, PD and PV transactions.

##### This option posts on-line to Supplier/Creditors account and GST account if applicable. Upon allocation of foreign currency transactions, realized exchange gain/loss will be captured and its amount posted to the account concerned. 

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/cBPimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/cBPimage.png)

</details><details id="bkmrk-credit-note-%28ap%29-%C2%A0"><summary>Credit Note (AP)</summary>

## **How to enter Credit Note (PC)?**

##### A credit note is a document issued by a seller to a buyer, acknowledging that a certain amount of money is being credited to the buyer's account. It typically occurs when there has been a return of goods, overpayment, or an error in the original invoice. The credit note can be used by the buyer as a credit for future purchases or to request a refund.

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

**Steps to enter PC are as follow:**

1\. Click on **Payables – AP Operations – Credit Note (AP)** and the following screen will appear.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/xXfimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/xXfimage.png)

2\. Click on **Add** button to create a new transaction.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/Dmoimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/Dmoimage.png)

- Fill up the fields in the header section such as **Date, Supplier, Contact Person, Currency and Exchange Rate**.
- Then select the account concerned at the detail section.
- Click for **Additional Info** for necessary details to add

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/FHkimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/FHkimage.png)

- Click on **save** button to complete the entry.

3\. Below is a sample PC transaction screen.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/CJBimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/CJBimage.png)

 **Additional Information:**

- **Add Allocation** This is where you can manually add allocation.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/8c2image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/8c2image.png)

- **Ex Rate** It will redirect you to Finance Tab. Attached link for further information. [MASTERS GL | Support Doc](https://doc.uniq365.com/books/online-user-guide-10-1224/page/masters-gl)

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/gBTimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/gBTimage.png)

- <span style="color: rgb(0, 0, 0);">**Batch Allocation** If you have a lot of transactions needed to allocate, you may use the batch allocation button to allocate transactions in a convenient way. Sample below.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/Ppbimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/Ppbimage.png)

- <span style="color: rgb(0, 0, 0);"><span style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">**CLONE**</span></span> It will allow you to copy the exact transaction created; where it will be creating another transaction copying the transaction you have clone.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/JNQimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/JNQimage.png)

4\. For the double entries of the PC transaction created, it can be verify under **AP Transaction Listing.**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/4v1image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/4v1image.png)

<p class="callout warning"><span style="color: rgb(186, 55, 42);">**Note: The steps to enter Credit Note (PC) &amp; Debit Note (PD) are identical to PI. User will need to select transaction type PC or PD respectively to enter the record.** </span></p>

</details><details id="bkmrk-debit-note-%28ap%29-%C2%A0"><summary>Debit Note (AP)</summary>

## **How to enter Debit Note (PD)?**

##### A debit note is a document issued by a buyer to a seller, indicating that the seller owes a credit for goods or services that were returned, damaged, or invoiced incorrectly. It serves as a formal request for an adjustment in the payment, reducing the amount owed to the seller. Debit notes are commonly used in transactions to correct billing errors or return goods after delivery.

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

**Steps to enter PD are as follow:**

1\. Click on **Payables – AP Operations – Debit Note (AP)** and the following screen will appear.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/zOKimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/zOKimage.png)

2\. Click on **Add** button to create a new transaction.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/OSHimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/OSHimage.png)

- Fill up the fields in the header section such as **Date, Supplier, Contact Person, Currency and Exchange Rate.**
- Then select the account concerned at the detail section.
- Click for **Additional Info** for necessary details to add.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/o3zimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/o3zimage.png)

- Click on **save** button to complete the entry.

3\. Below is a sample PD transaction screen.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/yUQimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/yUQimage.png)

**<span style="color: rgb(0, 0, 0);">Additional Information: </span>**

- **<span style="color: rgb(0, 0, 0);">Add Allocation </span>**<span style="color: rgb(0, 0, 0);">This is where you can manually add the transaction. </span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/Iguimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/Iguimage.png)

- <span style="color: rgb(0, 0, 0);">**Ex Rate** It</span> will redirect you to Finance Tab. Attached link for further information. [MASTERS GL | Support Doc ](https://doc.uniq365.com/books/online-user-guide-10-1224/page/masters-gl)

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/gBTimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/gBTimage.png)

- <span style="color: rgb(0, 0, 0);">**Batch Allocation** </span><span style="color: rgb(0, 0, 0);">If you have a lot of transactions needed to allocate, you may use the batch allocation button to allocate transactions in a convenient way. Sample below.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/wA3image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/wA3image.png)

- <span style="color: rgb(0, 0, 0);">**Clone** It will allow you to copy the exact transaction created; where it will be creating another transaction copying the transaction you have clone.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/CVoimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/CVoimage.png)

4\. For the double entries of the PD transaction created, it can be verified under **AP Transaction Listing.**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/xvfimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/xvfimage.png)

> <span style="color: rgb(224, 62, 45);">**Note: The steps to enter Credit Note (PC) &amp; Debit Note (PD) are identical to PI. User will need to select transaction type PC or PD respectively to enter the record.** </span>

</details><details id="bkmrk-supplier-invoice-%28ap"><summary>Supplier Invoice (AP)</summary>

## **How to enter Supplier Invoice (PI)?**

##### A supplier invoice is a document issued by a supplier to a buyer requesting payment for goods or services provided. It typically includes details such as the quantity, price, and description of the items, along with payment terms and due dates. The invoice serves as a formal record of the transaction and is used for accounting and financial purposes.

##### There may be times where there is a purchase of non-stock item. User may use PI transaction to affect such transaction. 

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

**Steps to enter PI are as follow:**

1. Click on **Payables – AP Operations – Supplier Invoice (AP)** and the following screen will appear. [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/V7Wimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/V7Wimage.png)
2. Click on **Add** button to create a new transaction   
    [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/NzHimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/NzHimage.png)

- Fill up the fields in the header section such as **Ref No, Date, Supplier, Contact Person, Currency and Exchange Rate**.
- Then select the account concerned at the detail section.
- Click for **Additional Info** for necessary details to add.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/s1Pimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/s1Pimage.png)

- Click on **save** button to complete the entry.

3\. Below is a sample PI transaction screen.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/udaimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/udaimage.png)

**<span style="color: rgb(0, 0, 0);">Additional Information:</span>**

- <span style="color: rgb(0, 0, 0);">**Ex Rate** It</span> will redirect you to Finance Tab. Attached link for further information. [MASTERS GL | Support Doc](https://doc.uniq365.com/books/online-user-guide-10-1224/page/masters-gl)

<span style="color: rgb(0, 0, 0);"><span style="color: rgb(224, 62, 45);"><span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/gBTimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/gBTimage.png)</span></span></span>

<span style="color: rgb(0, 0, 0);">3. For the entries of the PI transaction created, it can be verify under **AP Transaction Listing.**</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/6Ntimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/6Ntimage.png)

> <span style="color: rgb(224, 62, 45);">**Note: The steps to enter Credit Note (PC) &amp; Debit Note (PD) are identical to PI. User will nee**</span><span style="color: rgb(224, 62, 45);">**d to select transaction type PC or PD respectively to enter the record.** </span>

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

##### **How to allocate Foreign Currency Invoice with Base Currency Payment?**

<span style="color: rgb(0, 0, 0);">Let's use the following example to do this type of allocation:</span>

<span style="color: rgb(0, 0, 0);">1. Create a foreign currency invoice as follow: </span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/Gtsimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/Gtsimage.png)</span>

<span style="color: rgb(0, 0, 0);">2. Payment is made in base currency and in this example, it is SGD. The payment voucher should be entered as follow:</span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/k30image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/k30image.png)</span>

- <span style="color: rgb(0, 0, 0);">Click on **Batch Allocation** button for the screen below: </span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/89Cimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/89Cimage.png)</span>

- <span style="color: rgb(0, 0, 0);">For PI00002, click on **Auto-Allocate Amt** button, you will notice that the full amount of the invoice will be populated at </span>  
    <span style="color: rgb(0, 0, 0);">the 1st line. </span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/jj9image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/jj9image.png)

- <span style="color: rgb(0, 0, 0);">You should manually type in the base currency amount in SGD field as shown below. Click on **Update Allocation** to complete the allocation and **save** the PV transaction. </span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/3zTimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/3zTimage.png)</span>

<span style="color: rgb(0, 0, 0);">3. The completed payment transaction is as follow: </span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/ZCoimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/ZCoimage.png)</span>

<span style="color: rgb(0, 0, 0);">4. UNIQ365 will capture the Realized Exchange Gain/Loss </span><span style="color: rgb(0, 0, 0);">automatically upon allocation. The double entry of the above </span>  
<span style="color: rgb(0, 0, 0);">transaction is shown below: </span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/YYSimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/YYSimage.png)


</details><details id="bkmrk-payment-transaction-"><summary>Payment Transaction (AP)</summary>

## **How to enter Payment Transaction (PV)?**

##### A payment transaction is the process where funds are transferred from one party to another in exchange for goods, services, or obligations. It typically involves the payer providing payment information, which is then processed by a payment system or intermediary. Once the transaction is authorized, the funds are transferred to the payee, completing the exchange.

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

**Steps to enter PV are as follow:**

1. Click on **Payables** – **AP Operations** – **Payment Transaction** (AP) and the following screen will appear.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/NUHimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/NUHimage.png)

2\. Click on **Add** button to create a new transaction.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/exZimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/exZimage.png)

- Fill up the fields in the header section such as **Date, Supplier, Contact Person, Currency, Exchange Rate, Cash Bank and Bank Ref No.**
- Then select the account concerned at the detail section.
- Click for **Additional Info** for necessary details to add.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/rNpimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/rNpimage.png)

- Click on **save** button to complete the entry.

3\. Below is a sample PV transaction screen.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/9gXimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/9gXimage.png)

**<span style="color: rgb(0, 0, 0);">Additional Information: </span>**

- <span style="color: rgb(0, 0, 0);">**Ex Rate** It</span> will redirect you to Finance Tab. Attached link for further information. [MASTERS GL | Support Doc ](https://doc.uniq365.com/books/online-user-guide-10-1224/page/masters-gl)

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/gBTimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/gBTimage.png)

- <span style="color: rgb(0, 0, 0);">**Batch Allocation** </span><span style="color: rgb(0, 0, 0);">If you have a lot of transactions needed to allocate, you may use the batch allocation button to allocate transactions in a convenient way. Sample below.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/crNimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/crNimage.png)

4\. For the double entries of the PV transaction created, it can be verify under **AP Transaction Listing.**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/19nimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/19nimage.png)

</details><details id="bkmrk-opening-balance-%C2%A0"><summary>Opening Balance</summary>

##### To start on a new database, AP Opening Balances must be updated in order for user to trace all the outstanding supplier invoices at the start of the 1st financial year.

> **<span style="color: rgb(224, 62, 45);">Important: The total amount entered under AP Open Item must tie with the opening amount in the General Ledger Opening for Trade Creditor Control Account/(s) if the Posting Type selected in Payable Control Account is Supplier. </span>**

<span style="color: rgb(0, 0, 0);">You may use the report under **Payables – Reports &amp; Queries – AP Open Item Listings** to tie the figures. </span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/oe7image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/oe7image.png)

##### <span style="color: rgb(0, 0, 0);">Below is the Account Payable – Opening Items screen. There is **NO** double entry posting for this option. The records entered will be retained for current year usage like allocations, verification of outstanding invoices etc. </span>

<span style="color: rgb(0, 0, 0);">1. Click on **Payables – AP Operations – Opening Balance** and the following screen will appear.</span>

![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/MEmimage.png)

2\. Click on **Add** button for new transaction

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/ri5image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/ri5image.png)

- Fill up the fields such as **Ref No, Date, Dock Date, Due Date, Supplier, Buyer, PDSU, Currency, Exchange Rate, Narration, and amount.**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/yMQimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/yMQimage.png)

> **<span style="color: rgb(224, 62, 45);">Note: The date must be the actual date of invoices concerned in order for the system to capture the correct supplier aging. If supplier invoice the amount is credit side and if is a supplier credit note is a debit side. </span>**

<span style="color: rgb(0, 0, 0);">**Additional Information:** </span>

- <span style="color: rgb(0, 0, 0);">**Ex Rate** It</span> will redirect you to Finance Tab. Attached link for further information. [MASTERS GL | Support Doc ](https://doc.uniq365.com/books/online-user-guide-10-1224/page/masters-gl)

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/gBTimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/gBTimage.png)

- **Download Template** Once you click for the Download Template, it will auto download the Excel File.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/jFZimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/jFZimage.png)

Ensure the Excel file you plan to upload is formatted correctly. It should contain all these fields:

- Supplier Code
- Inv Date
- Inv Number
- Doc Date
- Due Date
- Buyer
- Narration
- Project
- Department
- Section
- Unit
- Currency
- Exchange Rate
- Debit Amount
- Credit Amount

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/OQpimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/OQpimage.png)

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

##### **How to Import Items?** 

1\. Click Import Items, this opens a file browser or prompt you to select the Excel file you want to upload.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/9wkimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/9wkimage.png)

- Sample excel file below generated from the system,

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/uocimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/uocimage.png)

2\. After successfully import of the excel file above, you may verify the entry in **AP Open Item Listing,**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/vrCimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/vrCimage.png)

</details><details id="bkmrk-blacklist-supplier-%C2%A0"><summary>Blacklist Supplier</summary>

##### <span style="color: rgb(0, 0, 0);">This option enables user to blacklist customers and suppliers. Once a supplier is black-listed, user will be blocked from entering any purchase transactions for the supplier concerned.</span>

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

#### <span style="color: rgb(0, 0, 0);">**How to enter Blacklist Supplier?** </span>

<span style="color: rgb(0, 0, 0);">Steps to enter Blacklist Supplier are as follow:</span>

<span style="color: rgb(0, 0, 0);"> 1. Click on **Payables – AP Operations – Blacklist** Supplier for the entry screen.</span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/lZRimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/lZRimage.png)</span>

<span style="color: rgb(0, 0, 0);"> 2. Click on **Add button**. Select the supplier from the drop-down list, enter the Blacklist date, key in the Remarks and select the A2000ERP user who performed the entry.</span>

<span style="color: rgb(0, 0, 0);">Screen below is an example of the entry,</span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/1Osimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/1Osimage.png)</span>

- <span style="color: rgb(0, 0, 0);">To delete a supplier from the blacklist record, user must click on Edit button, select the supplier concerned, and then click </span><span style="color: rgb(0, 0, 0);">on **Delete button** to clear the record. </span>

</details>

# Report Queries

<details id="bkmrk-report-queries-the-r"><summary>Report Queries</summary>

##### <span style="color: rgb(0, 0, 0);">The reports &amp; query screen shown here opens the options for the users to print important reports related to the payables/purchase modules. </span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/QYvimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/QYvimage.png)</span>

<span style="color: rgb(0, 0, 0);">The main documents are the Statement of Account, Outstanding Statement and the Aging Analysis. These reports will enable the users </span><span style="color: rgb(0, 0, 0);">to see the outstanding amount due to the suppliers, the transactions made as well as the aging report of outstanding transactions. </span>

</details><details id="bkmrk-gl-%26-ap-diagnostic-%C2%A0"><summary>GL &amp; AP Diagnostic</summary>

##### This screen will help you identify transactions that causes unbalanced of your GL Code and AP Accounts. 

- Click on **Payables – AP Operations – Report Queries - GL &amp; AP Diagnostic** and the following screen will appear.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/iZ2image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/iZ2image.png)

- Must filter the **From To** Date accordingly when was the unbalanced started and click **filter** so system will show you transactions that causes your unbalance if any.

</details><details id="bkmrk-ap-invoice-status-qu"><summary>AP Invoice Status Query</summary>

This screen will show AP Invoices such as how many were **invoiced**, **paid** and its remaining **balance.**

- Click on **Payables – AP Operations – Report Queries - AP Invoice Status Query** and the following screen will appear.

 [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/Sw6image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/Sw6image.png)

- Filter accordingly the necessaries such as **Type of transaction,** tick **show only outstanding invoices** if you want to, **Supplier, PDSU if any, Type Date and Filter.**

Below photo as a sample,

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/MrVHcFimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/MrVHcFimage.png)

- You may click **ZOOM IN** and it will redirect you to the transaction itself.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/HWQimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/HWQimage.png)

- Meanwhile, when **Payment Voucher** is click, following screen will appear.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/obfimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/obfimage.png)

</details>

# Document Printing

#####    
<span style="color: rgb(0, 0, 0);">The Document Printing screen shown below enables user to preview and print a range of AP Transactions. </span>

<span style="color: rgb(0, 0, 0);">User must select the transaction type concerned as per example in screen below. If a specific range of transaction numbers needs to be printed, user must indicate the range in **Trn No From and To fields.** </span>

<span style="color: rgb(0, 0, 0);"> Please note that the Trn No range selected must be **within the date range.** </span>

<span style="color: rgb(0, 0, 0);">[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/PDaimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/PDaimage.png)</span>

# Settings

<details id="bkmrk-supplier-maintenance"><summary>Supplier Maintenance</summary>

##### The Supplier Maintenance is used to enter master records of suppliers. The information regarding a supplier such as Supplier Code, Name, billing address, credit limit, pricing information, shipping addresses and the account posting details are entered here.

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

<span style="color: rgb(0, 0, 0);">**How to create Supplier records?** </span>

**<span style="color: rgb(0, 0, 0);">Details:</span>**<span style="text-decoration: underline;"><span style="color: rgb(0, 0, 0); text-decoration: underline;">  
</span></span><span style="color: rgb(0, 0, 0);">Click on **Finance - Payables – Settings – Supplier** </span><span style="color: rgb(0, 0, 0);">**Maintenance** for the following screen.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/X89image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/X89image.png)

- **Supplier (mandatory)** <span style="color: rgb(0, 0, 0);">Enter the code for new supplier. This is a 10-character alphanumeric field. </span>
- <span style="color: rgb(0, 0, 0);"> **Type** Select S for Supplier or B for Both Customer &amp; Supplier. </span>
- <span style="color: rgb(0, 0, 0);">**Name (mandatory)** Enter the name of the supplier.</span>
- <span style="color: rgb(0, 0, 0);">**Address (mandatory)** Enter the billing address of this supplier. </span>
- <span style="color: rgb(0, 0, 0);">**Postal Code** Enter the postal code of the supplier's address.</span>
- <span style="color: rgb(0, 0, 0);">**Contact** Enter the contact person's name.</span>
- <span style="color: rgb(0, 0, 0);">**Account Group (mandatory)** If the Account Posting Setting is set based on Supplier‟ Posting Type, then click to select the relevant Account Group that is defined under Payables - Maintenance. </span>
- <span style="color: rgb(0, 0, 0);">**Group** Click to select the reporting group.</span>
- <span style="color: rgb(0, 0, 0);">**Delivery Term** Click to select the Delivery Term. </span>
- <span style="color: rgb(0, 0, 0);">**Delivery Mode** Click to select the Delivery Mode. </span>
- <span style="color: rgb(0, 0, 0);">**Payment Term** Click to select the Payment Term.</span>
- <span style="color: rgb(0, 0, 0);">**Payment Mode** Click to select the Payment Mode.</span>
- <span style="color: rgb(0, 0, 0);">**Sales Tax Type** Select the Sales Tax type that will apply for this supplier. For example, if this is an Export supplier in USA, then the GST for this purchase will normally be zero-rated. Once Zero-GST is selected here, the next time this supplier's invoice is entered, the GST type will be captured automatically.</span>
- <span style="color: rgb(0, 0, 0);">**Default Currency** Select the currency that this supplier normally transacts in. For a USA based supplier, the default currency is in US Dollars. In the case of Japanese suppliers, it will be Yen. </span>
- **Price Type** Please refer to procurement module for further information with Price Type
- <span style="color: rgb(0, 0, 0);">**Discount** </span><span style="color: rgb(0, 0, 0);">Enter the discount in percentage given by this supplier. For example, a particular supplier normally gives 10% off List Price for all the items supplied. User could then enter 10% in this field. The system will capture the discount   
    every time an invoice is raised for this supplier. Hence, you need not remember each and every of your supplier's discount rate. </span>
- <span style="color: rgb(0, 0, 0);">**Credit Period** Enter the number of days, weeks or months that this supplier gives as credit period. </span>
- <span style="color: rgb(0, 0, 0);">**Credit Limit** Enter the Credit Limit of supplier. This is a numerical field that will enable the system to check and block   
    payable/purchase entries once the figure reaches the limit, provided the required setting is done in System Manager – System Utilities – System Settings.</span>
- <span style="color: rgb(0, 0, 0);">**Credit Used** This is a non-editable field. It is updated automatically by the system every time the credit is used up. </span>
- <span style="color: rgb(0, 0, 0);">**SP/Buyer** Click to select the Buyer assigned to this supplier. </span>

> **<span style="color: rgb(224, 62, 45);">Note: Tab sheets for Prices &amp; Location, Discount Group and Supplier Product Code are applicable for Purchase Module only</span>**

</details><details id="bkmrk-supplier-account-gro"><summary>Supplier Account Group</summary>

##### <span style="color: rgb(0, 0, 0);">If the Posting Type for Creditor Account is set to Supplier in Payable Control Accounts, the system will locate the creditor account code from Supplier Account Group maintenance screen as shown below:</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/MSKimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/MSKimage.png)<span style="color: rgb(0, 0, 0);">With reference to setting done as per screen above, if supplier TC is being mapped to TC Account Group in Supplier Maintenance, and user enter a Supplier Invoice (PI) transaction in AP module, the system will automatically credit the amount of transaction concerned to account name Other Creditors &amp; Accrual.</span>

<span style="color: rgb(0, 0, 0);">Likewise, these creditor accounts will be automatically posted during creation of Invoices, Credit Notes and Debit Notes in Purchase Module and any AP Transaction in AP Module. </span>

##### **\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_**

##### <span style="color: rgb(0, 0, 0);">**How to create Supplier Account Group?**</span>

1. <span style="color: rgb(0, 0, 0);">Click on **Finance - Payables – Setting – Supplier Account** icon for following screen.</span><span style="color: rgb(0, 0, 0);"> </span>[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/VVhimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/VVhimage.png)
2. <span style="color: rgb(0, 0, 0);"> At the new line, enter the Supplier Account Group code under the Group column. This field can cater up to 4 alpha-numeric characters. </span>
3. <span style="color: rgb(0, 0, 0);">Key in the account code description at the Description field. This field can cater up to 50 alpha-numeric characters.</span>
4. <span style="color: rgb(0, 0, 0);">Select the Creditor A/c via the drop-down list. </span>

</details><details id="bkmrk-payment-mode-%C2%A0"><summary>Payable Control Account</summary>

##### <span style="color: rgb(0, 0, 0);">UNIQ365 will automatically post Invoices, Credit Notes and Debit </span><span style="color: rgb(0, 0, 0);">Notes in Purchase Module and AP Transactions in AP Module </span><span style="color: rgb(0, 0, 0);">according to the setting done at Payable Control Accounts option. </span>

<span style="color: rgb(0, 0, 0);">Click on **Payables – Settings – Payable Control Accounts** icon for following screen. </span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-01/scaled-1680-/zvVimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-01/zvVimage.png)

<span style="color: rgb(0, 0, 0);">The Posting Types available are:</span>

**Fixed**   
<span style="color: rgb(0, 0, 0);">If this option is selected, user must select the Creditor control account from the account code drop-down list at Fixed Account section. </span>

<span style="color: rgb(0, 0, 0);">For example, when a payment transaction is done at Payable module, assuming DBS Bank Account is used to make payment, the double entry under this setting will be as follow: </span>  
<span style="color: rgb(0, 0, 0);"> Dr Cr </span>  
<span style="color: rgb(0, 0, 0);">Trade Creditor A/C XXX </span>  
<span style="color: rgb(0, 0, 0);">DBS Bank A/C XXX</span>

**Supplier**   
<span style="color: rgb(0, 0, 0);">User must ensure that the setting for Supplier Account Group is done. UNIQ365 will post to the Creditor Control Accounts accordingly for transactions done in Purchase and Payables modules. </span>

</details>