HowToHeader

Ensuring Accurate Journal Posting in Sage X3

Manual remittance is used to group payments linked to the same bank in one remittance. 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 Payments (GESPAY) function changes from entered, to in the bank after the remittance.

Before Manual remittance

After Manual remittance

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

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.

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.

 

Transforming businesses since 2009

For over a decade, Panni has helped companies transform their businesses to lead, innovate and be profitable. With the right combination of technology and experienced developers and consultants, we help companies with Change Management to achieve the organizational objectives. We believe in long-term relationships with our clients and provide top-notch support with fast turnaround times.

Looking for ERP advice?