News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Change posting date in...

Microsoft Dynamics NAV (Archived)

Change posting date in a posted Purchase invoice.

(0) Share

Report

Report

Posted on by Ghetz

2,983

OK, I'm not asking for anyone to tell me that this cannot be done... must not be done.. etc.. I alrady know that. The reality is that customer pays the bills, so we just need to do what asked for if we're left with no choice. (Yes my dear friends.. sorry for been so rude, but I'm really pissed with this customer, hope I could just fire them!! ;))

We have this customer that has posted Purchase invoices with a wrong posting date, and he wants us to modify it from SQL Server. Any idea on what tables we need to modify? So far I've detected:

- Purchase Invoice Header

- vendor entry

- Value Entry

- VAT Entry

- Item ledger entry

- GL entry

Any other tables we need to take into consideration?

Any script that could help us automate the process?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

RE: Change posting date in a posted Purchase invoice.

If you really want to build this, make them fully aware that they are going to break the system and some calculations may go wrong (costing, etc) because of it.

Also I would suggest to make a couple of restrictions on it, such as you can't back date to previous month, etc.

Purch. Inv. Line

Detailed Vendor Ledg. Entry

Analysis View if they are using it

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans