Extend summarize of general account entries after posting of sales invoice

(0) Share

Report

Posted on by Community Member

Hi all,

I am currently investigating to expand the split up of general journal entries after posting a sales invoice.

Standard AX currently summarizes on these fields : same dates, posting types, currency, and ledger accounts. But I want to add an extra field to this to expand the summarize. Is this possible in any way?

This extra custom field must be available for purchase invoicing and sales invoicing?

System : D365FO 10.0.10

I have the same question (0)

All responses (8)

Answers (1)

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Guillaume,

Can you elaborate on the details of the new field? What information is missing that needs to be added to the journal entries and for what reason?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre,

This is an extra custom information field that we need for reporting. The field is available on the sales order line and purchase order line.

The sales/purch order lines can have the same financial dimensions but the content of this information field is different. We need to expand the summarize also based on this field.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am already able to push the data towards the general journal account entry but in the class LedgerPostingGeneralJournalController where the grouping is applied the lines are concatenated. Some of my custom sales line information I pushed is not available anymore because it always takes the information from the first created general journal account entry.

That why I need to be able to split the general journal account entries based on this custom field as an extra condition

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello GuillaumeDB,

Can't you simply create another financial dimension that holds the information that you want to track in addition?

About the summary of the SO/PO lines:

I would recommend not trying to make a modification there because it can mess up things in your system. Especially think about things such as corrections, sales returns, inventory recalculations, etc. that might all be affected by the modification that you mentioned.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

That would be the easy way to just add an extra financial dimension. But that's not really the answer that I have in mind. If you add extra parm methods for the ledgervouchertransobject and push the custom fields to the general journal entry. After that expand the LedgerPostingGeneralJournalController - method initLineValuesContainer you will be able to add extra conditions. I think this is more suitable with the right validations based on posting type.

I will not change any amounts or ledger accounts or anything else. Will this still give risks in your opinion?

Thank you for your insights already!

Kind regards,

Guillaume De Bue

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Guillaume,

It is far from recommended to interact with the current posting logic. It is easy to break something else and then you might have a broken system. Would it still be compatible with future updates of Dynamics 365? I think it is a risk to hook in on the standard posting classes. I do agree with Ludwig that a dimension might be a safe alternative.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Guillaume,

I am in line with Andre.

What you try to create is risky and would not do that.

Personally, I would try using a findim even if this is not the best solution for you.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Andre and Ludwig,

Thank you for the advice and answer. I verified your answer.

Kind regards,

Guillaume

Was this reply helpful? Yes No