Finance | Project Operations, Human Resources, ...

Post Account Receivable of Sales Order Invoice by Line dimensions

(0) Share

Report

Posted on by HarukaMatsumoto

124

Hi Experts

My client needs to post Account Receivable entries with the line-level dimensions instead of the header-level dimensions from Sales Order Invoices but it seems this is not supported by D365 FO standard (I found a parameter in General ledger parameter>Ledger> Values used for summary account but this does not work on Sales Order Invoice).

i.e.

Sales Header dimension: Cost Center = IL and ItemGroup = blank.

Sales Order Line 1 $20 with dimension: Cost Center = IL and ItemGroup = A

Sales Order Line 2 $30 with dimension: Cost Center = CA and ItemGroup = B

Then by posting an invoice for this SO, it is expected to generate 2 AR entries: $20 with AR-IL-A and $30 with AR-CA-B instead of one line as $50 with AR-IL-blank

Has anybody experienced the same requirement, can you share solutions (customization, W/A etc) with me?

Thank you in advance!

Haruka

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

OsmanIstanbul 2,818 on at

Like (1)

Report

Hi,

This behavior is just working for revenue and loss of currency revaluation of customer trans. it is irrelevant to your requirement of course. You have to separate your order and create single order for each dimension combination.

Best.

Was this reply helpful? Yes No
HarukaMatsumoto 124 on at

Like (1)

Report

Hi Osman

Thanks for your reply. It seems the only way under current design. Since one of the required dimension is Item group, it is not realistic to separate orders by dimension for my client. I will try to create an report

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

Like (1)

Report

Hi Haruka,

What is the background of having the item group dimension on a customer transaction? If it is for analysis purposes, why don't you take the data from the sales invoice lines or inventory transactions?

I had this question before only once. That was for reporting purposes, We solved it like I mentioned above.

Was this reply helpful? Yes No
HarukaMatsumoto 124 on at

Like (0)

Report

Hi Andre

Thanks for your reply. It is for analysis purpose too but based on voucher transactions. My client want a report to review AP, Inventory, AR, Revenue, COGS balance by dimensions including Item group to analyze the total amount by days since inventory is purchased (paid) until sold out (paid).

The report logic will be more simple to analyze the voucher transactions by dimensions rather than tracking back each transactions in this case. This is why I was looking for a way to post AR by line dimensions.

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

Like (1)

Report

Hi Haruka,

In this case, I would follow the suggestion from Osman. You can also check the on the Accounts receivable parameters form the summary parameters if there is a setting for the item group. If not, you can consider a customization for this. There are settings for auto summary, but also a split function.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Post Account Receivable of Sales Order Invoice by Line dimensions

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Post Account Receivable of Sales Order Invoice by Line dimensions

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates