Hi everyone,
May I know is there any ways or method that we can extract applies doc in payment journal to a report?
Thank you.
Hi,
I actually managed to pull out the "Applies to Doc No" and "Applies to Doc Type" Fields in the vendor ledger page using page extension through AL Code just to see if there's any value.
As you can see, the "Applies to Doc Type" is filled with their respective doc type but the "Applies to Doc No" is empty for all entries even though I'm pretty sure you need to fill the field during entry which is why there won't be any output if I used in in a report. I think the main problem is that it does not automatically sync with other tables when posted in payment journal either because we missed something while posting or because it just did not automatically sync after posting.
Hi,
If I understand correctly, you want to extract 'applies doc' information from the ledger entries. I think you would need to use AL code and query the relevant tables, such as the vendor or customer ledger entries depending on the type of transaction.
I suggest you to get help from a developer if you are unfamiliar with AL code.
Regards
Hi Tanya...
I would like to pull to a new one. BUT Im not sure pull from where as I cant see the applied doc from my ledger entries. Can you give me some clues or guidance?
Regards,
Collin
Have you looked at the Journal Pre-Payment Report?
Hi,
Yes, we can, do you want to pull in any existing report or a new one ?
Regards,
Tanya Kharbanda
Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has a verified answer
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156