Finance | Project Operations, Human Resources, ...

Payment Journal Posting Date

(4) Share

Report

Posted on by ahmed.kimo

546

Hi,

One of my customers using payment journal to record a transaction on particular date lets say 27th of Jan then it is sent for approval and takes around from 4 to 6 (or more) days to get it approved and submitted to the bank and can be on 2nd of Feb.

The question , How we can record the exact transaction date in our books (vendor & bank) which is in my case 2nd of Feb, in order to perform the bank reconciliation and verify the statement while reconciling with the vendor.

Hint : in case of considering the transaction date there will be a gab which make difference while performing the bank reconciliation also we can not verify our books with the vendor since our dates different than the dates recorded in his books since this will be recorded based on actual transaction recorded in his bank account.

i tried to use bridging accounting but this will resolve the bank statement issue but the vendor statement will remain the same.

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Giorgio Bonacorsi 2,071 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Good question. You should delay posting the journal until you know the exact transaction date (when the transaction appears on the bank statement).

You can proceed with creation and approval earlier, but the actual posting should be done only at that confirmation point.

For added security, consider:

- Setting the journal as private (limits visibility/editing): https://dax365fo.org/2024/06/01/blocking-journal/
- Restricting posting rights to specific users: https://dax365fo.org/2024/05/28/posting-restriction/

Thank you,
Giorgio

Was this reply helpful? Yes No
ahmed.kimo 546 on at

Like (0)

Report
Copy link

Link copied!

Thanks @Giorgio Bonacorsi for your kind reply ,

I totally agree and we are doing the same , but still original transaction data (recorded in the journal lines) is the financial date appearing in your books even if you posted the journal after the whole approval cycle , our aim is to update the transaction date not the posting date.

Was this reply helpful? Yes No
Suggested answer

Ali Alkhateeb 97 on at

Like (0)

Report
Copy link

Link copied!

I had same requirements however, similar standard feature is availbile only for invoice journal (Account payable parameter > Ledger and sales tax > Posting > Adjust invoice posting date automatically)

Unfortunately not available for payment it has to be customized.

Was this reply helpful? Yes No
Suggested answer

Santosh Dhavan 2 on at

Like (0)

Report
Copy link

Link copied!

Try using payment transfer. Delay posting and then update the final date as per the bank transaction and then post

Was this reply helpful? Yes No