Finance (Receivables)


Overview - Receivables

RECEIVABLE MODULE

This module contains the Accounts Receivable (AR) entry options for various receivables transactions such as receipts and real-time GL posting.

______________________________________________________________________________________________________________________________________

MENU NAVIGATION

Sub-menu items of RECEIVABLE MODULE are listed below:

image.png

The RECEIVABLE MODULE has 3 tabs, as shown above, namely, Operations, Report Queries, and Settings. 

AR OPERATIONS is where transactions are entered, like receivable transactions and opening balances. 

REPORT QUERIES contains all the account receivable reports. 

SETTINGS is where the master records are created. 

AR - Operations

CREDIT NOTE

CREDIT NOTE

A credit note usually issued when clients return goods or services. To record a receivable credit note in Uniq365, you have to go in receivables module and look for credit note tab. Attached photo in reference where you can find it. 

______________________________________________________________________________________________________________________________________

image.png

Steps on how to enter new transaction in Credit Note:
  1. Click on Receivables – AR Operations – Credit Note (RC) and the following screen will appear.

    image.png

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

    image.png

image.png

______________________________________________________________________________________________________________________________________

ADDITIONAL INFORMATION: 

2.1 Batch Allocation
If user has a lot of transactions needed to allocate, they may use the batch allocation button to allocate more transactions in convenient way. Refer to attached photo on how batch allocation works. 

image.png

2.2 Clone
If user wanted to create new RC transaction with same details from previous transaction, user can click the button of "clone" in order to create new RC transaction with same details from previous transaction. In this way, no need to key-in manually all the details, hence will  just choose which customer should it be clone. 

image.png

Attached photo is an example of transaction newly created from clone button. 

image.png

2.3 Exchange Rate
It will redirect you to Finance Tab. Attached link for further information. MASTERS GL | Support Doc

image.png

 2.4 Attachment
This function use to upload supporting documents related to your transaction. Kindly also note that system only allow this format (gif, jpg, jpeg, png, pdf, doc, docx, xls, xlsx, csv, msg, html and htm) file type and with max file size 25 mb. 

image.png

3. Report and Queries
   For the double entries of the said RC transaction above, it can verify to check under AR transaction listing. 

image.png

DEBIT NOTE
DEBIT NOTE

Debit note is the form issued for any additional amount of goods or services rendered to customers wherein no product code and  quantity involved. Shortly known as Receivable debit note or RD. In UNIQ365, the receivable debit note can be found receivable module under operations. Please refer attached photo for reference where could it be found. 
______________________________________________________________________________________________________________________________________

image.png

Steps on how to enter new transaction in Credit Note:
  1. Click on Receivables – AR Operations – Debit Note (RD) and the following screen will appear.

image.png

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

image.png

3. Attached photo is a sample transaction of Debit Note (RD). 

image.png

______________________________________________________________________________________________________________________________________

ADDITIONAL INFORMATION: 

2.1 Batch Allocation
If user has a lot of transactions needed to allocate, they may use the batch allocation button to allocate more transactions in convenient way. Refer to attached photo on how batch allocation works. 

image.png

2.2 Clone
If user wanted to create new RD transaction with same details from previous transaction, user can click the button of "clone" in order to create new RD transaction with same details from previous transaction. In this way, no need to key-in manually all the details, hence will  just choose which customer should it be clone. 

image.png

Attached photo is an example of transaction newly created from clone button.

image.png

2.3 Exchange Rate
It will redirect you to Finance Tab. Attached link for further information. MASTERS GL | Support Doc

image.png

 2.4 Attachment
This function use to upload supporting documents related to your transaction. Kindly also note that system only allow this format (gif, jpg, jpeg, png, pdf, doc, docx, xls, xlsx, csv, msg, html and htm) file type and with max file size 25 mb. 

image.png

3. Report and Queries
   For the double entries of the said RD transaction above, it can verify to check under  AR transaction listing. 

image.png

CUSTOMER INVOICE
CUSTOMER INVOICE

There may be times where there is a SALES of non-stock item. User may use Customer Invoice (RI) transaction to effect such a transaction. The customer invoice or RI can be found under receivable module. Please refer to attached photo where to find the customer invoice. 

______________________________________________________________________________________________________________________________________

image.png

Steps on how to enter new transaction in Credit Note:
  1. Click on Receivables – AR Operations – Customer Invoice (RI) and the following screen will appear.

image.png

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

image.png

3. Attached photo is a sample transaction of Customer Invoice (RI). 

image.png

4. Report and Queries
   For the double entries of the said RI transaction above, it can verify to check under AR transaction listing. 

image.png

RECEIPT TRANSACTION
Receipt Transaction

A receipt transaction menu is where you can record of a payment received from a customer. In UNIQ 365, the receipt transaction can be found in receivable module. 


image.png

______________________________________________________________________________________________________________________________________

Steps on how to enter new transaction in Receipt Transaction:
  1. Click on Receivables – AR Operations – Receipt Transaction (RI) and the following screen will appear.

image.png

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

image.png

Attached is an example of new receipt transaction.

image.png

ADDITIONAL INFORMATION: 

2.1 Batch Allocation
If user has a lot of transactions needed to allocate, they may use the batch allocation button to allocate more transactions in convenient way. Refer to attached photo on how batch allocation works. 

image.png

2.3 Exchange Rate
It will redirect you to Finance Tab. Attached link for further information. MASTERS GL | Support Doc

image.png

 2.4 Attachment
This function use to upload supporting documents related to your transaction. Kindly also note that system only allow this format (gif, jpg, jpeg, png, pdf, doc, docx, xls, xlsx, csv, msg, html and htm) file type and with max file size 25 mb. 

image.png

 

3. Report and Queries
   For the double entries of the said RI transaction above, it can verify to check under AR transaction listing. 

image.png

OPENING BALANCE

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

Important: The total amount entered under AR Open Item must tie with the opening amount in the General Ledger Opening for Trade Debtor Control Account/(s) if the Posting Type selected in Receivable Control Account is customer. 

You may use the report under Receivables – Reports & Queries – AR Open Item Listings for reference to check your figures.

image.png

______________________________________________________________________________________________________________________________________

Below is the Account Receivable – 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.

1. Click on Receivables – AR Operations – Opening Balance and the following screen will appear.

image.png

 

2. Click on Add button for new transaction 

image.png

image.png

______________________________________________________________________________________________________________________________________

Additional Information:

image.png

image.png

Ensure the Excel file you plan to upload is formatted correctly. It should contain all the necessary fields required such as:

image.png

 

image.png

 

 

BLACKLIST CUSTOMER

This option enables user to blacklist customers and suppliers. Once a customer is black-listed, user will be blocked from entering any receivable transactions for the customer concerned.

______________________________________________________________________________________________________________________________________

How to enter Blacklist Customer? 

Steps to enter Blacklist Customer are as follow:

 1. Click on Receivables – AR Operations – Blacklist customer for the entry screen.

image.png

 

2. Click on Add button. Select the customer from the drop-down list, enter the Blacklist date, key in the Remarks. 

Screen below is an example of the entry. 

image.png

 

Reports & Queries

For report and queries under receivable module, there are three sub menus. First is the report and queries where you can find the reports related to receivables, second is the GL and AR diagnostics wherein if the general ledger and receivable report is not tie up, this report may help to identify which transaction causing of unbalance, and lastly, is the send statement of account wherein this can be used to send a statement of account in your specific customers. 

image.png

REPORT QUERIES

In report and queries menu you can generate a reports related to receivable transactions. Mainly use reports are AR transaction Listing, AR statement of account, AR aging analysis, customer ledger, AR outstanding and many more. The report and queries menu can be found in receivables > report and queries > report and queries. 

image.png

 

Example on how to generate a report. 
1. Select a report you wanted to generate. 
2. Fill up necessary field, in order to capture the filtering of report correctly. 
3. Click ''preview'' button to generate the report. 

image.png

4. Also, there is an option to download the report in pdf, xlsx, csv, and etc. Please refer to attached photo on how to download on it. 

image.png

GL AND AR DIAGNOSTICS

The GL and AR Diagnostic menu can be used to find transactions that are causing of unbalance from AR vs. GL. This menu can be found in receivables > report and queries > GL and AR diagnostics. 

image.png

In order to generate if there is any transactions in the diagnostics, user must fill up the fields of from date and to date correctly, and after filling it up, need to click the filter button. 

image.png

 

NOTE: If in case the transactions were not able to clear automatically, Please contact customer care support. 

SEND STATEMENT OF ACCOUNT

In Uniq365, The ''send statement of account'' menu is used to send statement of account in your specific customers. This menu can be found in receivables > report and queries > send statement of account. 
image.png

STEPS ON HOW TO SEND A STATEMENT OF ACCOUNT:

Note: Before you can able to send a SOA to a customer, the user must set up first email setting. Email setting can be found in system admin - company - email setting. The email set up usually done during implementation. 


image.png



  1. Filter first the date you wanted to generate first.
  2. Click ''edit'' to select customer, after that, tick which customer you will send the SOA and clicked for the ''insert button''

    image.png

  3. After clicked ''insert'' button, all the customers you have ticked will show in the list, if already confirmed. User may clicked the ''sendemail'' to send the SOA into the following customers. 

    image.png


    Attached photo is an example of E-SOA. 

    image.png

    image.png

 

Document Printing

The Document Printing screen shown below enables user to preview and print a range of AR Transactions. 

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. 

 Please note that the Trn No range selected must be within the date range. 

image.png

Settings

Customer Maintenance
The Customer Maintenance is used to enter master records of customers. The information and properties of a customer such as customer code, customer name, billing address, credit limit, pricing information, shipping address, the account posting details etc are entered here. 

image.png

image.png


This is the place where you add new Customer or edit  existing Customer. Some of the fields are mandatory, such 
as the following :

Location - Create different delivery locations for this Customer
Price - Records the history of selling prices for this Customer if the price type (price table) is selected

 

Important: Our system does not allow duplicate customer codes in Customer Maintenance, so before creating the coding for Customer Maintenance, please double check and make sure that there are no duplicates. As guidance for creating Customer codes, one example is “CA0001” for A2000 Pte Ltd.; “C” stands for Customer and “A” is the starting alphabet for the Customer name.

Customer Groups
This option lets you indicate the Customer Group if you intend to use reports that sort or filter by Customer Group (Optional).
How to Setup Customer Type Group?

image.png

Note: If you did not use this grouping method for reporting, please ignore the options.

 

Customer Account Groups
The Customer Account Group is used for auto posting function when the user creates Sales Transaction. Unlike other systems that are hard-coded, A2000 WEB ERP allows the accounts posting to be organized according to the users’ requirements through their own Customer Account Groups. 

You can create different groups and set the account posting to be by 
Customer Group” if you need:

Exp: Trade Debtor A/C by Customer
        Sales A/C by Customer
        Discount A/C by Customer
        Cost of Sales A/C by Customer

image.png

How to Setup Customer A/C Group?

image.png

Note: If you did not use for this posting method, please ignore the options.

Payment Terms

This is where you indicate the Customer Payment Terms for Customers and Suppliers. The payment terms set for individual customers and suppliers are for the buckets in the Statement of Account & Aging reports.

How to add Payment Terms?

image.png

         Exp: Add 7 Days, 45 days or 120 days…etc.

Note: If you did not set the payment terms, you can not select the terms for individual customers and the system 
will be unable to generate accurate Statement of Account & Aging reports.