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.