How to resolve Due date being paid SAINV LUSB24SIN00376 (5462524 1) error in the Manual Matching screen

Issue Description:

The error occurs when attempting to match the sales invoice (SAINV) and receipt (REC01) transactions through the manual matching screen when the amounts are stored in the provisional payment fields of the open item. Specifically, the amounts are recorded in the temporary fields (TMPCUR and TMPLOC) within the GACCDUDATE table. This discrepancy leads to a mismatch between the document total and payment total.

Understanding Provisional Payments in Sage X3:

Provisional payments refer to amounts that have not yet been posted initially. Situations such as deleted or partially paid transactions can result in matching errors due to amounts stored in the temporary fields on the backend.

Definition of TMPCUR and TMPLOC Fields:

TMPCUR (Temporary Amount Paid / Provisional Payment): This field represents amounts of provisional payments that have not completed the initial posting phase, expressed in the transaction currency.

TMPLOC (Provisional Company Payment): This field represents the same amounts but expressed in bookkeeping currency.

Resolution Process

Source of Resolution: To address this issue, it is necessary to execute an update query in the SQL database for the GACCDUDATE table.

Steps to Resolve the Matching Issue:

Check the PAYMENTD Table: This table is used for payment lines. It verifies whether a payment has been made against the specified invoice.

Query:

Output:

There is no payment against the invoice.

Check the GACCENTRYD Table: This table is used for accounting entry lines. Check if matching has been performed, specifically in the MTC_0 field.

Query:

Output:

The MTC_0 field is blank, indicating that no matching is performed.

Check the GACCDUDATE Table: This table is used for open items. It verifies if there are any values stored in the TMPCUR and TMPLOC fields.

Query:

Output:

There are values stored in the TMPCUR and TMPLOC fields for sales invoice LUSB24SIN00376.

Updating Temporary Fields:

If values are found in the TMPCUR and TMPLOC fields, execute the following update query to set them to zero.

Query:

Output:

After executing the update query, recheck the GACCDUDATE table to confirm that the TMPCUR and TMPLOC fields have been reset to zero.

Query:

Output:

Hence, the TMPCUR and TMPLOC fields have become zero.

Once the TMPCUR and TMPLOC fields have been set to zero, you may proceed with the manual matching of the sales invoice (SAINV) and receipt (REC01) transactions, which will result in a successful match.

Once the transactions have been successfully matched, navigate to the sales invoice screen and open the corresponding open items screen from the right-hand side. At this point, you will observe that the provisional payment amount has been cleared, and the amount will be reflected in the Payments field. Additionally, the document total and payment total will now align.

About Us

Greytrix Africa is a leading Sage business partner and ISV Partner offering Consulting, Implementation, and development services for Sage X3, Sage 300, Sage 300 People (HRMS), Sage CRM, and Sage Intacct, which covers East Africa, West Africa, SADC, and Middle East region. We offer professional services such as Implementation and Configuration, Business Process Analysis, Project Management, Integrations and Migrations, and Technical & Functional Support, along with enhancements within Sage X3, Sage 300 People (HRMS), Sage 300, Sage CRM, and Sage Intacct across various industry verticals like Process Manufacturing (Food & Beverages, Chemical), Discrete manufacturing (Automotive, Textile & Apparel), Non-Profit, Health-care Industry and Services Industry (Financial, Software & Engineering), Distribution (Transportation & Logistics), and Agriculture.

Sage Solutions

Other Solutions

E-invoicing Solutions for

Sage Solutions

Other Solutions

Integrations

Addons

Integrations

Sage X3-Integrations

Sage Intacct Integrations

Sage 300 Integrations

addons

Sage X3 Add-ons

Sage Intacct Add-ons

Sage 300 Addons

Process Manufacturing

Distribution

Discrete Manufacturing

Service Industry

Industry Specific

Blogs

Video Gallery

Sage Solutions

Other Solutions

E-invoicing Solutions for

Sage Solutions

Other Solutions

Integrations

Addons

Integrations

Sage X3-Integrations

Sage Intacct Integrations

Sage 300 Integrations

addons

Sage X3 Add-ons

Sage Intacct Add-ons

Sage 300 Addons

Process Manufacturing

Distribution

Discrete Manufacturing

Service Industry

Industry Specific

Blogs

Video Gallery

How to resolve Due date being paid SAINV LUSB24SIN00376 (5462524 1) error in the Manual Matching screen