11-Document Report - Receipt and add new fields in customer,  journal and S&R setup

Setup

ModuleDescription
Customer

Check box [Request Receipt] added in customer card.  Tick the check box if the customer receipt is requested for the customer.

Sales & Receivable Setup

Receipt No. can be auto generate by system.  Please follow the steps below for setup the no. series.

1) Go to No. Series and create the No. Series Code and the No. Series Lines (for example, No. Series Code CUST-RCT)

2) Go to Sales & Receivable, select the no. series for Receipt No. Series Code.

Cash Receipt Journal Process and print Receipt

New Field/FunctionDescription

Cash Receipt Journals

Define Receipt No. Method by Batch

New field 'Receipt No. Method' added in Cash Receipt Journals page.  User can define the generate receipt no, method by batch.

Options including:

  • Document No - System will assign Receipt Number according to Document No.
  • Document No. & Customer No. - System will assign Receipt Number according to the combination of Document No. & Customer No.
  • Customer No. & Ext. Doc. No - System will assign Receipt Number according to the combination of Customer No. & External Document No.

Cash Receipt Journal Line

Payment Amount

New field Payment Amount added in Cash Receipt Journal.  The Payment amount to be print on Customer Receipt.

When user selected Applied Entries, the amount to be populated to both Amount LCY and Payment Amount accordingly.

Receipt No.

Generate Receipt No.

New field Receipt No. added in Cash Receipt Journal.  When the batch is completed, user can click on the new action button Generate Receipt No for assign the Receipt no. to the journal line. 

  • System will assign Receipt No. if the journal is matched all of following criteria.
    1. Request Receipt is checked in the Customer Card and
    2. External Document No and Payment Amount is entered
    3. Receipt No. to be assign to the Journal Line
      1. if by Document No. and Customer No. - assign receipt no. for the combination of Document No. and Customer No., if Customer Request Receipt = yes and Payment Amount is >0
      2. if by Customer No. and Ext. Doc. No. - assign receipt no. for the combination of External Document No and Customer No, if Customer Request Receipt = yes and Payment Amount is >0
      3. if by Document No - assign receipt no. for the document no. if Customer Request Receipt = yes and Payment Amount is >0

NOTE: Field name Cheque Amount have been changed to Payment Amount at July 28, 2022

System Checking

Validation - check when Preview Posting or Post

1) Payment amount must enter for the customer No. is DEPOSIT-AR,  TEMPORARY-AR,

Warring Message - check when close the batch

Missing generate Receipt No. will check when close the batch.- "Receipt No. is missing" shows if Receipt No is empty but customer is Request Receipt and Payment Amount >0

Customer Ledger Entries

General Ledger Entries

After the payment journal is posted, the Payment Amount and Receipt No to be shows in both General Ledger Entry and Customer Ledger Entry

Print Receipt for General Customer

In Customer Ledger Entries page, action button 'Print Receipt for General Clients' is added

User can enter Cash Receipt Document No or Customer No to print the receipt 

*NOTE: per information from user during requirement stage, General Clients means Type 2 customer.  The customer no prefix is not OAH, OH* or RC*.

System Print the Receipt 

Document for Customer Receipt to be printing.

If the invoice is not fully pay, system will prompt the message "Send receipt later for Receipt No. xxxxxxx'

No. of Prints

System will count the no. of Print and show in Customer Ledger Entry

Case Handling

  1. If same document no. for different customer and the journal is no external document no.  User may need to use another reference no to identify the external document (e.g. Customer No.) for generate the receipt.      

User Requirement Notes

Receipt – new format for receipt

  • Type 1: current format – no change, for OAH, OH* or RC*.
  • Type 2: new format – for general clients.
  • New box in the customer master - Request Receipt
  • New column in Cash receipt journal – Cheque Amount
  • Receipt no.- assign by every single cheque. (Warning: if input same cheque no.)
  • Exceed payment (DEPOSIT) – display in the receipt
  • Warning: not paid in full amt (send receipt later)
  • Warning: if involve sub a/cs (Deposit-AR or Temp-AR) but no data input in the cheque amount column.

Expected Process flow after new receipt is developed.

1) Print receipt for Type 1 – no change
2) Print receipt for Type 2 – new button for Print Receipt

  • No labels