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

[Tarun Godhwani]

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
——————————

[Esther Paradoski]

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
——————————
——————————————-

[Tarun Godhwani]

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
——————————
——————————————-

[Esther Paradoski]

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
——————————
——————————————-

[Gary Gong]

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
——————————
——————————————-

[Dinabandhu Mohapatra]

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
——————————
——————————————-

[Tarun Godhwani]

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
——————————
——————————————-