Worldwide Middle East
Sage-Partner-for-header
Sage-Partner-for-header
Greytrix Africa Logo
Free Demo
Greytrix Africa Logo
Worldwide Middle East
Free Demo

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

Due_date_being_paid

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.

due date paid error in manual matching screen image-1
due date paid error in manual matching screen image-2

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:

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

Query:

due date being paid error image-3

Output:

There is no payment against the invoice.
due date being paid error image-4
  1. 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:

due date being paid error image-5

Output:

The MTC_0 field is blank, indicating that no matching is performed.
due date being paid error image-6
  1. 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:

due date being paid error image-7

Output:

There are values stored in the TMPCUR and TMPLOC fields for sales invoice LUSB24SIN00376.
due date being paid error image-8

Updating Temporary Fields:

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

Query:

due date being paid error image-9

Output:

due date being paid error image-10
After executing the update query, recheck the GACCDUDATE table to confirm that the TMPCUR and TMPLOC fields have been reset to zero.

Query:

due date being paid error image-11

Output:

Hence, the TMPCUR and TMPLOC fields have become zero.
due date being paid error image-12
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.
due date being paid error image-13
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.
due date being paid error image-14

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.

Our Partners

Previous
Next
All Greytrix Logos - Small White

+254 735 003164

sales@greytrix.com

Office No:8, 1st Floor, Western Heights, Karuna Road,
Behind Sarit Center, Westlands, Nairobi 00100, Kenya,
Africa

Company

Solutions

Other Solutions

E-invoicing Solutions

Industries We Serve

Sage X3
Integrations

Sage X3
Add-ons

Sage Intacct
Integrations

Sage Intacct
Add-ons

Checkbook.io ACH Payment
Sales Commission

Sage 300
Integrations

Sage 300
Add-ons

GreyMatrix - Apparel Solution
Document Numbering
Document Attachment
Purchase Approval System
Auto Bank Reconciliation
Bill of Lading
Three Way PO Matching

Follow Us

Subscribe Our Newsletter

© 2024. Greytrix Africa Ltd

close menu icon

Get In Touch

close menu icon

Get In Touch

Thank you for contacting us.

Be ready to explore some leading business management solutions that will help shape the future of your business!

Our team will get in touch with you shortly.

close menu icon

Get In Touch

Thank you for downloading Sage X3 Brochure

The brochure is sent successfully on your registered  Email Id.

close menu icon

Download Free Sage X3 Brochure