web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Change posting date in...
Microsoft Dynamics NAV (Archived)

Change posting date in a posted Purchase invoice.

(0) ShareShare
ReportReport
Posted on by Ghetz 3,029

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

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans