2,845
Anyone knows, which table is keeping the "Sales document detail inquiry zoom" records. I am facing one issue. The sales document detail inquiry zoom window displays two invoices for a particular quote. Thank in advance.
*This post is locked for comments
Hi Leslie,
The beauty is invoices having different customer ID. both are valid invoices. One comes from Service module and another one from Sales module.
Hi Mani,
If it shows 'two invoices for a particular quote' check it out to make sure none of the documents have been voided. If not, what do you get when you drill back on each of the invoices?
Kind regards,
Leslie
I have queried all this table and I did not see anywhere the same Quote as originating number. I could not finalize what could be the issue. Now, I am suspecting the displaying value in this window is should be filled by dexterity code.
Because, the attached table to that scroll window is temp table, but it has only 4 columns. So in the scroll window the line script should querying the value from some other table.
Thanks for all your reply. I will check in the GP source code.
Matt is definitely right on this one, depending on the status of the document, it could either retrieve from SOP10100 or SOP30200. Although, I would like to add up additional essential point as related to how you may have an answer for any similar inquiry; GP Power tools is the answer, security profiler catches the associated tables for each screen in a neat and simple way, this will help you track down such issues when needed.
Here are the "associated tables" for the Sales Document Detail Inquiry zoom window:
Check it out on Dynamics GP Power tools Portal
Your feedback is highly appreciated,
I believe it would be querying the SOP10100 (Unposted) or SOP30200 (History) based on the Master Number
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (