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 Feb 07, 2020 02:43 PM
    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
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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

    Posted Feb 10, 2020 12:22 PM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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

    Posted Feb 10, 2020 01:23 PM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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

    Posted Feb 10, 2020 02:26 PM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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

    Posted Feb 10, 2020 04:23 PM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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

    Posted Feb 11, 2020 08:26 AM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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

    Posted Feb 11, 2020 10:39 AM
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


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