AP Invoice Payments

Description

Categories
Enginatics
Repository
GitHub
Supplier invoice payment details.
There can be multiple payments per invoice and one document/check can be used to pay different payments and invoices. To allow reconciling payment with invoices and checks, invoice and check level amounts are shown on the last payment record only and are blank for multiple/duplicate records.

When India Localization is installed, the following GST columns are also included: GST Registration No, GST PAN No, GST TAN No, CGST Amount, SGST Amount, IGST Amount, CESS Amount, Custom Amount, Unclassified Tax Amount, Taxable Value, HSN SAC Code, CGST Rate, SGST Rate, IGST Rate, CESS Rate, CGST Recoverable, CGST Non-Recoverable, SGST Recoverable, SGST Non-Recoverable, IGST Recoverable, IGST Non-Recoverable, Reverse Charge Flag, Place of Supply, Ship From State.

SQL 150 lines

Parameters 12

ParameterTypeList of values SQL
LedgerLOV
gl.name=:ledger and 
hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU')
Operating UnitLOV
hou.name=:operating_unit
Payment Date FromDate
aca.check_date>=:payment_date_from
Payment Date ToDate
aca.check_date<:payment_date_to+1
Accounting Date FromDate
aipa.accounting_date>=:gl_date_from
Accounting Date ToDate
aipa.accounting_date<:gl_date_to+1
SupplierLOV
aps.vendor_name=:vendor_name
Supplier NumberLOV
aps.segment1=:supplier_number
Supplier SiteLOV
assa.vendor_site_code=:vendor_site_code
Invoice NumberLOV
aia.invoice_num=:invoice_number
Check NumberNumber
aca.check_number=:check_number
Check StateLOV
aca.status_lookup_code=:check_state