GL Allocations in AX/D365 - Posting Detail Level

(0) Share

Report

Posted on by G-Squared

244

Hello community. What ideas does the community have about reducing the Posting Detail Level for General Ledger Allocations?

My testing shows that the process generates a full set of allocation distribution lines for each source balance line (Note: The source balance line may include multiple entries in the balance).

In the Journal Name setup for Journal type: Allocation, the Posting Detail Level is forced to a value of Details and the detail level of Summary is unavailable. See screenshot.

Allocation-Posting-Detail-_2D00_-Journal-Name-Setup-_2D00_-1800104.png

In this example, the allocation distribution lines could be summarized if there was a way to summarize. See screenshot.

Screenshot of Ledger Allocation Rule looks like this:

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

I tried to replicate your issue and noticed that AX is actually summarizing the lines. Here is an example:

I posted three vouchers

The first two lines are absolutely identical except for the posting date

The third line is posted with a different business unit.

When I run the allocation, the first two lines are summarized.

As you can see from my screenprint, AX always refers to the original mainaccount-voucher combination to decide whether transactions are summarized or not.

Are too many allocation vouchers a problem for you?

Best regards,

Ludwig

Was this reply helpful? Yes No
G-Squared 244 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig. I see that D365 is allocating from a GL Balance line and not from individual transactions. Individual transactions are summarized into the GL Balance Line. This is good.

Yes, it would be great and acceptable to have fewer voucher numbers and a higher level of summarization.

However, in the Journal name for Journal type: Allocations, I see that when I pick a value of "Allocation", then it forces a value for New voucher of "In connection with balance".

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi G-Squared,

You are right and there is actually nothing you can do about it except ... you could possibly make use of the new cost accounting module for making your allocations. You can find some information on this module here

docs.microsoft.com/.../cost-accounting-home-page

The allocations that are made there won't be visible in GL. Maybe that is interesting for you.

Best regards,

Ludwig

Was this reply helpful? Yes No