Open Forum

Like what you see? Discover the benefits of the D365UG/AXUG Community. Learn More

1.  MR and Period 13

Posted 11 days ago
​We are running Dynamics AX 2012 R3.  We completed the process to roll a number of purchase orders from the FY2017 fiscal year to the current FY2018 fiscal year.  When this role occurred, this resulted in entries in Period 13 for FY2017 which effectively offset the existing encumbrances bringing them to zero which is incorrect.  Everything appears correctly in AX but the issue is with Management Reporter.  The Encumbrance column on my MR reports net the encumbrance with the period 13 entry which rolled the PO resulting in a zero encumbrance.

I tried using the Column Restriction as shown below but that had no effect at all.


Has anyone else in the governmental sector encountered this issue and if so, how did you solve the problem?  Thanks ahead of time.

------------------------------
Ranny Grubb
Dynamics AX Project Manager
County of Roanoke
Roanoke VA
rgrubb@roanokecountyva.gov
540-283-8131
------------------------------


2.  RE: MR and Period 13

Posted 9 days ago
​Hello Ranny,
MR does not have a specific closing period 13/14/... filter
Can you separate and identify the transactions you need to separate based on a specific voucher number series or posting date?
Best regards,
Ludwig

------------------------------
Ludwig Reinhard
SYCOR GmbH
Goettingen
------------------------------



3.  RE: MR and Period 13

Posted 8 days ago
​Hi, few options which could come into play on this and similar reports:
  • First note, usually I see the XAD meeting most setup needs on their reports
  • Look to PERIOD filters
    • like BASE period or
    • 1:12 for range on Periodic monthly columns
    • 12 for YTD ending
  • Start and End DATE filters at bottom of any FD Fin Dim column type
  • Look to the BOOK CODE filters as some ERP setups may have multiple like actual, budget, quantity, encumbrance
  • ATTRIBUTE filters for any FD Fin Dim column type
  • Run report for Transaction level to deduce and reconcile discrepancies
  • Last but pretty fast resort is rebuild the MR data mart


------------------------------
Derek Krebs
derek.krebs@msxgroup.com
Sr Consultant
MSX Group
Carlsbad CA
------------------------------



4.  RE: MR and Period 13

Posted 8 days ago
​Thanks for the ideas.

So I interrogated all of the available ATTRIBUTE filters and there does not appear to be a way to identify the transactions where the PO's were rolled.  My next thought was to add a column for Period 13 which would allow me to see these transactions.  However, when I do that and try to run the report, I get the following error.


I verified Period 13 for FY2017 is OPEN.  Anyone seen this error before?

------------------------------
Ranny Grubb
Dynamics AX Project Manager
County of Roanoke
Roanoke VA
rgrubb@roanokecountyva.gov
540-283-8131
------------------------------



'