How can I open a Vendor ledger entry

(0) Share

Report

Posted on by Tobro

Hello,

I know there are already the same questions in this forum, but with no solution for my issue.

I have a Vendor ledger entry (posted credit memo) and it is marked as "not open". Now I want to use apply entries, but this is not possible to closed entries.

My question: Is it somehow possible to open this entry?

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Hi,

If this is a closed entry then it means it is already applied to some other entry. You can unapply this entry if it is applied to a wrong entry. Once you unapply the entry will be opened.

Was this reply helpful? Yes No
Tobro 10 on at

Like (0)

Report

I agree. The problem here, somehow the entry is closed but there is still remaining amount, so I am not able to unapply because it was never applied.

Best regards.

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report

AS per my knowledge it's not possible that vendor ledger entry has remaining amount and closed.

Unless somebody has done it through code.

Was this reply helpful? Yes No
NAV_with_Narang 2,294 Moderator on at

Like (1)

Report

Please share a screenshot of this scenario, as Bilal Haider has rightly mentioned - seems like something may have been done via a piece of code by a developer

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (2)

Report

Hi, I also suspect that someone directly modified the data.

Now there are a few options, none of which are recommended.
1. You can directly open the database, find this table and this row of records, and open it in the database.
2. Develop a tool and open it on the page.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Tobro 10 on at

Like (1)

Report

Hi, as Yun Zhu suggested we opened the ledger entries directly in the database.

Thank you all for your help!

Was this reply helpful? Yes No
Suggested answer

Shawnsauve 1,093 on at

Like (0)

Report

Hi there! It sounds like you're having trouble applying for entries in Dynamics GP because one of your vendor ledger entries is marked as "not open". While it's not possible to apply entries to closed entries, there are a few things you can try to open up the entry and make it available for application.

First, check to make sure that the entry is not marked as a historical transaction. If it is, you may need to remove the historical flag in order to make it available for application.

If the entry is not marked as historical, you may be able to open it up by reversing the credit memo and then re-entering it as a new transaction. This should create a new, open entry that can be applied to other transactions.

Another option is to manually adjust the vendor's account balance to reflect the credit memo, rather than applying it directly to another transaction. This can be done using a manual payment or credit note, which will create a new, open transaction that can be applied to future transactions.

Was this reply helpful? Yes No