Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Change posting date in a posted Purchase invoice.

Posted on by 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

  • Suggested answer
    TeddyH Profile Picture
    TeddyH 12,868 Super User 2024 Season 1 on at
    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

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,912 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,355 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans