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.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

tanya07 1,638 on at

Like (0)

Report

RE: How to extract applies doc in payment journal to a 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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

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

Have you looked at the Journal Pre-Payment Report?

Was this reply helpful? Yes No
Collin0426 5 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
FMidi611 5 on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No