Small and medium business | Business Central, N...

How to extract applies doc in payment journal to a report?

(0) Share

Report

Posted on by Collin0426

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.

All responses (5)

Answers (0)

Sort by

Suggested answer

tanya07 1,638 on at

Like (0)

Report
Copy link

Link copied!

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
Suggested answer

Dallefeld 235 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Have you looked at the Journal Pre-Payment Report?
Collin0426 5 on at

Like (0)

Report
Copy link

Link copied!

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
Suggested answer

Govinda Kumar 2,310 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
FMidi611 5 on at

Like (0)

Report
Copy link

Link copied!

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.