Update Document type in Vendor ledger entries

(1) Share

Report

Posted on by VG-12111806-0

Hi,

We are Business central!

there was a vendor payment made and applied to an invoice. But the docuemtn type is BLANK instead of payment when i checked in the Vendor ledger entries. These payments hence are not identified and not getting reported in 1099 information.

is there a way where i can update the BANL as 'PAYMENT' .

thanks

Vijaya

Categories:

Dynamics 365 Business Central

Capture.GIF

All responses (7)

Answers (1)

Verified answer

Ramiz 344 on at

Like (0)

Report

Update Document type in Vendor ledger entries

Hi,

You can use this data editor tool to update the missing document type.

https://github.com/Drakonian/data-editor-for-bc/tree/master?tab=readme-ov-file
VG-12111806-0 24 on at

Like (0)

Report

Update Document type in Vendor ledger entries

Thank you for all your replies.

1. User has not picked the document type, thats the issue. Hence wanted a way out to populate document type -Payment on those postd entries.

2. Not all wil have access or capacity to use AL. Hence wanted to check if there could be any other easier way to just update the document type as payment.

3. Thank you ZHU for your links, but it too techincally invasive for users to deploy tht solution, SHould you have any earier and front end method/ tool to update the document type, I will appreciate it.

4. I donot want to unapply, cancel and recreate a payment docu and identify doc type , reapply , reconcile and post . This method is OK for 1 or 2 docuemnts. but for multiple entries might not be possible as this can un necessarily cause extra work and re auditing n stuff.

thanks all once again!!

vijaya
Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Update Document type in Vendor ledger entries

Hi, hope the following helps as well.

Dynamics 365 Business Central: Can we insert/modify/delete posted data (Posted Documents & Posted Entries) via AL???

https://yzhums.com/54657/

Dynamics 365 Business Central: How to add directly editable fields to Vendor Ledger Entries

https://yzhums.com/57622/

Thanks.

ZHU
Suggested answer

Yi Yong 1,470 Super User 2024 Season 2 on at

Like (0)

Report

Update Document type in Vendor ledger entries

Hello,

As mentioned by Valentin, you will need to reverse and post a new payment with the correct document type or you could get the partner to patch it.
Ramesh Kumar 233 on at

Like (0)

Report

Update Document type in Vendor ledger entries

I just checked, and by default, it is set to Payment. However, you need to select the appropriate document type based on the requirement, and it will reflect correctly once posted.

If this helped you, please check the box Does this answer your question?
Suggested answer

Ahmad Subhani 101 on at

Like (2)

Report

Update Document type in Vendor ledger entries

At the time of Payment journal you have to specify the Document Type.
If you will specify then it will come

In my case, the payment type will come automatically when i open the Payment Journal.

This is what is coming in the BC
Suggested answer

Valentin Castravet 24,925 Super User 2024 Season 2 on at

Like (3)

Report

Update Document type in Vendor ledger entries

You can reverse the payment and create it again but this time select the document type as payment.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/