Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[James Woodin]

I do not ‘get’ it…

we have a GP company that we were not doing sales out of till last fall – at that point all went in and MOST things look fine which makes me bet that one table setting must be turned off

the ‘Period Sales Analysis Report – Detail’ in Receivables management is perfect
the ‘Sales Document Analysis report’ – Sales Order Processing – again perfect
both are run for 2016 for one customer

same customer and same date range – running the ‘sales analysis detail report’ (which says ‘invoicing’ as part of the title) turns up with no records.

everything posted to the SOP302/303 tables fine as well as posted to the GL just fine – so why the one report is not behaving has me baffled.

any thoughts about which GP table (not the SOP302/303 unless it is one field that makes no sense) this report is pulling from?

——————————
James Woodin
Application and Database Developer
Diamond V
Cedar Rapids IA
——————————

[Steve Erbach]

James,

I don’t have an answer for you — someone else may. The same thing happens in our Sales Invoicing Analysis report. What I can tell you is that there are two tables that make up that report: the Item Master (IV00101) and a temporary table called IVC_Customer_Sales_TEMP. That only exists for as long as it takes to build the report.

Regards,

——————————
“Sparkly” Steve Erbach – Business Analyst & MS Dynamics Platform Administrator
WOW Logistics Company – Appleton, WI
VP for Communication, GPUG WI (Milwaukee) Chapter
Co-Chair, GPUG WI (Green Bay) Chapter
GP 2016 (16.00.0439) / MR 2012 CU15
Blog: https://www.gpug.com/blogs/steve-erbach
Twitter: @serbach
——————————
Welcome to Dynamics!
You do not have permission.
Call Steve. (hat tip: Lou Spevack)
——————————
——————————————-

[Russ Worth]

Invoicing is a separate module from SOP, so anything with that in the title will not return any records.

——————————
Russ Worth
GP Business Analyst
Grand Isle Shipyard
Galliano LA
——————————
——————————————-

[Glenda Homan]

James,

Invoicing and Sales Order Processing do not use the same tables.  That is why you get the warning message of “Sales Order Processing and Invoicing modules are both installed. They do not share information. Transactions should be entered in one module only.” unless it’s turned off.

The reports that reference “Invoicing” use the Invoicing tables ONLY.  The Receivable reports would include data from either group of tables.

Glenda

——————————
Glenda Homan
Dolese Bros. Co.
OKlahoma City OK
——————————
——————————————-

[Paula Camara]

It appears that you are using the Sales Order Processing to enter sales transactions.

The report you are referencing as printing no data is the Sales Invoice entry.

These are two different functions with Dynamics GP and typically you use on or the other.

 

 

Sent from Mail for Windows 10

 

——Original Message——

I do not ‘get’ it…

we have a GP company that we were not doing sales out of till last fall – at that point all went in and MOST things look fine which makes me bet that one table setting must be turned off

the ‘Period Sales Analysis Report – Detail’ in Receivables management is perfect
the ‘Sales Document Analysis report’ – Sales Order Processing – again perfect
both are run for 2016 for one customer

same customer and same date range – running the ‘sales analysis detail report’ (which says ‘invoicing’ as part of the title) turns up with no records.

everything posted to the SOP302/303 tables fine as well as posted to the GL just fine – so why the one report is not behaving has me baffled.

any thoughts about which GP table (not the SOP302/303 unless it is one field that makes no sense) this report is pulling from?

——————————
James Woodin
Application and Database Developer
Diamond V
Cedar Rapids IA
——————————