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
Thank u guys for your help... Will try the solutions in test db
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.
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.
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.
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
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.
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.
What kind of solution are you expecting ? the way to create vendor ledger entries for the posted purchase invoice ?
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
