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

[Wes Mangum]

I am trying to come up with a report that will show Invoice Totals against the PO Totals in order to report on the variance between the two (2).
I can get this data by pulling from Accounting Source Explorer and exporting the All Purchase Orders list to Excel and matching up from there – with a lot of manual manipulation.  

Hoping to find a more efficient way to pull this off.  We are on AX12 r3.  Any suggestions would be much appreciated.

thanks- Wes

——————————
Wes Mangum
National Cable Satellite Corporation d/b/a C-SPAN
Washington DC
——————————

[Duane Jenkin]

Greetings,

I have always been a fan of using a slightly non-conventional approach by using the Inventory Transactions Inquiry.?
By Comparing the Physical (Delivery note) to the Financial value (Invoice) you get the variance per product.
This works for me but won’t so well if you are allocating Misc. Charges to the product or using Standard costing.
I have not tried this in 2012 but it does work in AX2009 and D365 (although a bit trickier in the later version).

Good luck.

——————————
Duane Jenkin
Business Analyst
Tourism Holdings Limited
Hamilton, New Zealand
——————————
——————————————-

[Boris So]

Hi Wes

We were able to do this using Atlas. 
Short of that, an SSRS report could work but it’s not something we have tried.

——————————
Boris So
Boris So
——————————
——————————————-

[Mark Bailey]

Hi Wes,

No standard report for this in any version of the system. A bit of a failing by Microsoft if you ask me. Who doesn’t want to know the variance between ordered & invoiced at any level (total, PO line etc).

The tables you are interested in are PurchLine (aggregate by PO numbers) V VendInvoiceInfoLine (agrregate by PO number).  As Boris said if you have Atlas this is easy enough otherwise you will need to contact you partner to do a development for an SSRS report.
Alternatively if you have readonly access to your SQL database you can also use powerquery in Excel to ETL the data into an excel report.

——————————
Mark Bailey
Application Consultant
Annata
Portsmouth
——————————
——————————————-

[Chantal Golding]

Hi Wes,

Our Developer built an SSRS report for this which includes other interesting features as well. If ou are interested let me know I could send you a sample of the columns and parameters to run the report.

Thanks?

——————————
Chantal Golding
PSP Investments
Montreal QC
——————————
——————————————-