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 the Remittance Using the Due Date to Post the Journal and not the Accounting Date

How to resolve the Remittance

How to Resolve the Remittance Using the Due Date to Post the Journal and not the Accounting Date

Manual remittance is used to group payments linked to the same bank in one remittance. How to perform a manual remittance will be discussed later. Some Sage X3 users decide to create payments (GESPAY) which can only be posted through the Remittance (GESFRM) function.
In this case, the accounting journal is generated and this affects the financials. The payment status in the GESPAY function changes from entered to in the bank after the remittance.

Before Manual remittance

How to resolve the Remittance using the Due date image-1
After Manual remittance
How to resolve the Remittance using the Due date image-2
When posting the Manual remittance, it is expected that the journal will be posted based on the accounting date. However, in some circumstances, you may experience a challenge where the remittance uses the invoice due date when posting the journal, not the accounting date.
This may overstate or understate the book balance for that particular period.
This will also affect the transactions appearing on the bank reconciliation screen.
To resolve this, follow the steps highlighted below.

Setup > A/P-AR Accounting > Payment entry Transactions

How to resolve the Remittance using the Due date image-3
  • Select the payment method. In our case, this is Payment through Wire Transfer (PAYWT).
  • Ensure the due date management option under the (header) General is unticked (refer to the screenshot below)
  • Validate the screen then log out and log back in.
How to resolve the Remittance using the Due date image-4

Note: This transaction will only apply to manual remittances done after the change. For older transactions, you may need to do an accounting cancellation and then do a manual remittance again. This accounting date in the payment entry screen will be picked in this case.

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
White Logo

+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

Sage X3
Integrations

Other Integrations

Sage Intacct
Integrations

Sage 300
Integrations

Sage X3
Add-ons

Sage Intacct
Add-ons

Sage 300
Add-ons

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

Industries We Serve

Subscribe Our Newsletter

Follow Us

© 2023. 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.