D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Project invoicing - Project financial dimension not posted against AR Summary Account

  • 1.  Project invoicing - Project financial dimension not posted against AR Summary Account

    Posted 17 days ago
    All - I'd appreciate your inputs to the following issue.

    Backgroud:
    • Customer invoices are posted via the Project Management and Accounting module
    • Project has been set up as a Financial Dimension
    • Project Dimension has been added as a segment to the Account structure (refer to 1st screenshot below)
    Issue
    • When posting a Project Invoice, the Project dimension does not show up as a segment against the AR summary Account (within the voucher). Refer to the last screenshot.

    Question
    • Can I know what needs to be configured in order to stamp the Project dimension against the AR summary account? I'm hoping that it is a case where I have missed a setup rather than this being standard functionality.

    Any recommendations would be appreciated.

    Thanks in advance!








    ------------------------------
    Tarun Godhwani
    Solutions Architect, Dynamics CE and F&O (AX)
    Sierra Systems, an NTT DATA Company
    Vancouver BC
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Project invoicing - Project financial dimension not posted against AR Summary Account

    Posted 14 days ago
    Hi Tarun,

    Do you have financial dimensions set up in your projects? Financial dimensions are pulled from the project when not specified for a voucher line that is created automatically as in the case of an invoice.

    Esther

    ------------------------------
    Esther Paradoski
    Ducks Unlimited Canada
    Stonewall MB
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Project invoicing - Project financial dimension not posted against AR Summary Account

    Posted 14 days ago
    Hi Esther,

    Thanks for replying back! To answer your question, yes, the financial dimensions are set up as defaults against the project in question. I have attached a screenshot below.





    ------------------------------
    Tarun Godhwani
    Solutions Architect, Dynamics CE and F&O (AX)
    Sierra Systems, an NTT DATA Company
    BC
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: Project invoicing - Project financial dimension not posted against AR Summary Account

    Posted 14 days ago
    Hi Tarun,

    I looked at all of our transactions in AR from project invoices over the last couple of years and only see 8 transactions that have carried any dimensions with them from projects. I could not see why this occurred out of thousands of transactions. We don't track any dimensions with our AR account, so it is not a behaviour I have looked at. All of our projects have financial dimensions and our balance sheet accounts allow 2 of those dimensions to post against balance sheet accounts. Not sure they are all not with dimensions or all without dimensions. Likely one of those Microsoft anomolies. I will ask a co-worker who works a lot in projects and see if he has any ideas.

    Esther

    ------------------------------
    Esther Paradoski
    Ducks Unlimited Canada
    Stonewall MB
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: Project invoicing - Project financial dimension not posted against AR Summary Account

    Posted 14 days ago
    You may want to try an obscure setting on the General Ledger Parameters>>Ledger>>Accounting Rules>>Financial Dimensions-Values used for Summary Accounts. Set the setting to Accounting Distributions instead of Source Documents. Go back and test your invoices on your projects.

    ------------------------------
    Gary Gong
    Independent Solution Architect for Dynamics 365 Finance and Operations
    ORLANDO FL
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: Project invoicing - Project financial dimension not posted against AR Summary Account

    Posted 13 days ago
    Dear,
    could you defined financial Dimension on Contract ->Funding source Details for getting dimension at Summary Account.

    let us know if have any issue after this .


    ------------------------------
    Dinabandhu Mohapatra
    Functional Lead -India
    ------------------------------

    Conference-AXUG_200x200


  • 7.  RE: Project invoicing - Project financial dimension not posted against AR Summary Account

    Posted 13 days ago
    Hi Dinabandhu,

    Thanks for sending the information. Yes, setting up the default dimensions on the Funding Source resolves the issue. I am now able to see the project dimension on the project invoice vouchers.

    Many thanks!


    ------------------------------
    Tarun Godhwani
    Solutions Architect, Dynamics CE and F&O (AX)
    Sierra Systems, an NTT DATA Company
    BC
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role