web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Project ID not superseding Project Financial Dimension when posting to projects or GL

(0) ShareShare
ReportReport
Posted on by 205

Hi guys,

When selecting a project ID the Financial dimension needs to be superseded by the ID so the project matches the GL. Basically, The three posting types that are affected are Sales tax, project-cost and general ledger. Therefore, There is a mismatch between the Projects financial dimension and the Projects ID.

Any idea, how we can get this fixed?

Please see the spreadsheet showing actual transactions, attached to the forum. It will show:

* This issue occurred back to July of 2021
* The three posting types that are affected are Sales tax, project-cost and general ledger.
* There is a mismatch between the Projects financial dimension and the Projects ID.

Project Dimensions vs Project ID mismatches (1).xlsx

Thanks all! Any input would be valuable here.

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,146 Super User 2025 Season 2 on at

    Hi ASidd,

    Can you provide some more information? Can you tell how these transactions are created? Are these the full vouchers or does it show only the lines with differences? What main account is used for what purpose? Do all the main accounts do have the same account structure? Could someone have changed the dimension values before posting? Are there also vouchers which are posted correctly?

  • ASidd Profile Picture
    205 on at

    Hi Andre,

    See below.

    1. Can you tell how these transactions are created? Using journals, imports and sales or use tax on A/P module invoices

    2. Are these the full vouchers or does it show only the lines with differences? Only the discrepancies are showing

    3. What main account is used for what purpose? I don’t understand this question and I am not sure how it plays any part in the problem with the projects. Any Main account can be used in the projects module as long as a category is associated with it.

    4. Do all the main accounts do have the same account structure? Again not sure what the main account has to do with the projects issue but to answer the question, no the dimension structure is based on the main account type. Balance sheet accounts have a different structure from Expense account and Rev accounts. For the purposes of the projects module we are only dealing with Revenue accounts and Expense accounts.

    5. Could someone have changed the dimension values before posting? If you look at the spreadsheet attached to the incident report, this issue goes back to day one, it occurs from multiple entry types and multiple users.

    6. Are there also vouchers which are posted correctly? Yes

    Our understanding is that

    1. When an A/P or A/R entry is attached to the ‘Projects module’ the project dimension defaults to whatever is set as financial dimensions for that Project ID

    2. For a journal entry, the only way for an entry to get a project ID is by choosing account type ‘Project’ and choosing the Project ID

    3. In general, the Project ID overrides the project financial dimension.

    The question we need you to answer is why for over 700 entries the stated rules did not apply causing project id vs project dimension mismatches.

  • ASidd Profile Picture
    205 on at

    Hey @André Arnaud de Calavon,

    Any advise here, i answered your questions below.

  • André Arnaud de Calavon Profile Picture
    301,146 Super User 2025 Season 2 on at

    Hi ASidd,

    I tried to understand how the data was entered on a journal. Due to incomplete vouchers in the Excel and missing details how the journal lines were entered, I was not able to get clarity for myself.

    Can you share a screenshot of a journal entry including the dimensions entered and a full voucher including the correct lines? When I e.g. filtered on voucher JVLC000047, I don't see all the transactions, so don't know if the voucher contains cost transactions for multiple projects.

  • ASidd Profile Picture
    205 on at

    Hi Andre,

    See below the file you request, please let me know if you need anything else.

    General-journal-entry_5F00_637884779655316906-_2800_1_2900_.xlsx

  • André Arnaud de Calavon Profile Picture
    301,146 Super User 2025 Season 2 on at

    Hi ASidd,

    Did you share posted ledger transactions (accounting entries) or did you share the details of the journal lines?

  • ASidd Profile Picture
    205 on at

    I am not sure if I replied to this question. Per my email below the transaction detail came from Accounting Source Explorer, and therefore is the posted ledger transactions filtered to show only the journal number you referred to in your request for more information.

  • ASidd Profile Picture
    205 on at

    any idea Andre or anyone else?

  • André Arnaud de Calavon Profile Picture
    301,146 Super User 2025 Season 2 on at

    Hi Jamal,

    Can you share the details of the journal which got posted? You shared only the posted result, not the data entry in the GL journal itself.

  • ASidd Profile Picture
    205 on at

    Hi ,

    For data entry, when we use MS dynamics to import a journal we do not save the import files. If this was entered manually there would be nothing to send. For the entries that are sales tax related, they are entered when we enter an invoice.

    I am not sure what you are asking for since the posted result is a result of the data entry. Please give me instructions on how you need me to pull the data you are looking for.

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 456 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans