Matching Advance Payments with the Sales Invoice
To match advance payments with the sales invoice:
From the GST Module, click GST Daily Processing (G75IGST3H), and then GST Matching Advance Payment With Sales Invoice.
On the Work With GST Advance Payment Receipts form, enter values in the following required fields to search for advance payment receipts:
Document Company
Payor Number
This is the address number of the entity who pays the supplier.
GST Unit
GST Rate Type
You must enter values in the above fields to select records and to proceed to the next form. Optionally, you can also enter values in the Receipt Date From and Date Thru fields to narrow your search.
Review the advance payment receipts that the system populates based on your search values.
The system displays only the receipts with open amounts (for CGST, SGST, IGST, and Cess) greater than zero (0) in the F75I827 table.
Select the receipts that you want to match with the invoice, and then click Select.
The system displays the Work With GST Sales Invoice form with prepopulated data in the header fields.
To retrieve sales order lines for the selected receipts, enter values in the Invoice Date From and Date Thru fields in the header.
When you enter the dates in these fields, the system populates the first grid in the form with the sales order lines that are eligible to be matched with the advance payment receipts that you have selected. The system retrieves only those sales order lines that are not void, not mapped, and for which you have generated the tax invoice and completed the sales update.
The system automatically computes and selects the sales order lines that can be offset by the open receipt amount displayed in the header. The selected sales order lines are displayed by a green tick mark. Standard check boxes are available for each record that you can use to select the records.
To deselect records, click Reset Selection. To select a record, click Select Invoice.
Click Confirm Selection to match and offset the selected sales order lines with the advance payment receipts.
The system populates the details of the sales order lines that are offset against the associated advance payment receipts in the Offset Advance Payment Receipts With Sales Invoice Details grid.
Click Confirm and Update Ledgers to process the records.
The system updates the ledgers after confirmation and displays the batch number for the transaction.
The system updates the ledgers and creates journal entries. If there are errors while updating the ledger and creating the journal entries, the system does not save the transaction and reports the errors.