You’re offline. This is a read only version of the page.
3,205
hi there,
i like to know, what tables will be involved, when i do:
1. make sales order until print invoice
2. do inventory transaction (adjustment, transfer, receipt)
ahyone can describe me? or, if i want to know the process diagram, can i find on help menu?
thanks
*This post is locked for comments
Hi Rodi,
There are many tables that could be involved depending on your setup and your inventory valuation methods, etc. The best way to find what tables are involved is to run a trace in SQL Profiler and look for the Insert statements. I don't know what version of SQL Server you are using, but instructions and a template are attached to KB's 967955 for SQL 2008, 925033 for SQL 2005, and 936578 for SQL 2000.
You can also look at the schema which is in the help files. Let me know if you have any questions.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (