Microsoft Dynamics NAV (Archived)

Vendor Ledger Entry Missing - after posting Purchase Invoice

(0) Share

Report

Posted on by Community Member

Hello Experts,

I am using Dynamics NAV 0.6 W1 version

After posting purchase invoices Vendor ledger entries are missing.

This caused due to some code changes in Codeunit 12, we have got the reason due to which it happened :(

But can anyone suggest a solution to rectify this.

Waiting for reply, thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Suggested answer

Suresh Kulla 50,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What kind of solution are you expecting ? the way to create vendor ledger entries for the posted purchase invoice ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Yes, means vendor ledger entry, detail vendor ledger entry etc... How can I correct it? I have checked financial part g/l entries posted properly.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Aditi,

You need to reverse the G/L Entries manually via General Journal and further post the relevant Invoice via "Purchase Journals" or "General Journal". Or May be create new Purchase Invoice all together to have the actual effect in all the relevant tables.

It is not recommend to create the entries via back end Tables due to Data Integrity.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Vishal,

Thanks for your reply, but just a query posting General journal will revert financial part but what about warehouse and item ledger entries. Please correct me if I am wrong

- Aditi

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Option 1)

Step 1)

As I mentioned, you can reverse the G/L Entries with General Journal.

Step 2)

Pass the Invoice Journal via "Purchase Journals" or "General Journal" options in Financial Management. This will pass the relevant G/L & Vendor Ledger Entries (Including Detailed Vendor Ledger Entry) in the system.

You already have the Item Ledger Entries available and hence no need to pass the same again.

Option 2)

Reverse G/L Entries via General Journal.

Reverse Item Ledger Entries & Warehouse Entries via Item Journal

Create fresh Purchase Invoice and post the same, which will create the normal entries as needed.

Hope this clarifies your doubts.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

As Vishal mentioned it is not recommended to create ledger entries, as suggested use Gen. Journal to reverse finacial entry and item journal to reverse the item ledger entries and create a new purchase invoice.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report
Copy link

Link copied!

I fully agree with the other community members - adding new lines manually into the tables has a strong risk of loosing data integrity.

If you really want to do so (which is strongly not recommended), I advice to make a correct posting on a database copy, and then manually transfer the lines into Vendor Ledger Entry and Detailed Vendor Ledger Entry (perhaps also VAT ledger Entry?), changing the reference to correct G/L entries numbers in your database and modifying transaction number of those lines to your initial one.

Another (a bit more safe) option would be to delete the transaction in all needed tables (however not all tables are shown in the Navigator, e.g. Item Application Entry table).

But, the best option is indeed as Vishal proposed - reverse the transactions by standard NAV methods and post a correct one.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank u guys for your help... Will try the solutions in test db

Was this reply helpful? Yes No