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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,912 Super User 2024 Season 2
Martin Dráb 229,355 Most Valuable Professional
nmaenpaa 101,156