Notifications
Announcements
No record found.
Hi Guys,
Requirement-
I need to get the posted date in the remittance advice report.
I need to get that posted date in the Payment date column.
Please help me to solve this requirement.
Hi jenifer,
Please try it:
select PostedDateTime from LedgerJournalTable where JournalNum = '00282';
regards
Isn't the remittance advice created at the time you generate the payment in the vendor invoice journal?
The journal can be posted later and; maybe a day or two later.
How is this handled in your company?
Best regards,
Ludwig
Journal can be posted two days later.
Sorry not two days, it can be posted later at any days
I see.
If this is the case then you cannot get the posting date included in the remittance advice as the remittance advice is created before the journal is posted.
Can you revert back to your colleagues and clarify again why and how they want to have that date value included in the report?
Thank you for the reply,
After the journal is posted, that posted date they need to display it in the remittance report
I solved the requirement by adding this code in the class extension.
select PostedDateTime from LedgerJournalTable where LedgerJournalTable.JournalNum == ledgerJournalTrans.JournalNum; tmpTable.PostedOn = LedgerJournalTable.PostedDateTime;
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
