MR Report - Gross Profit report - Which Business Unit will appear to MR report

(0) Share

Report

Posted on by Ett

489

Hi guys,

We have a default Financial Dimension - Business Unit on Customer master - B01

If we have a Sales order for this customer (Default B01), we change Business Unit on this order to - B02 for promotion purpose.

Now, we want to manage sales by Business Unit on GP report. The question are:

1. which BU will Sales amount from the above order come in? B01 or B02???

2. If users work in this way, are there any impact on BU in term of accouting/ledge??

Sales	B01	B02
	$$$$$

Sales	B01	B02
		$$$$$

Many thanks

Ett

All responses (4)

Answers (2)

Ett 489 on at

Like (0)

Report

RE: MR Report - Gross Profit report - Which Business Unit will appear to MR report

Hi Ludwig,

Many thanks for making me clear.

Ett
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: MR Report - Gross Profit report - Which Business Unit will appear to MR report

Hi Ett,

Your parameter setting means that you findim for the summary account is taken from the invoice header irrespective of what findims are selected in the lines.

Note: This applies only to the summary account, which is usually a balance sheet account. You lines that are recorded with P&L accounts use the findims that you see at the line level.

The summary account can be found in the AR posting profiles. Simply check your customer and the customer group it is associated to. For this group there should be a setup in the AR posting profiles where you can find the summary account used when you post an invoice for this customer.

You sales by business unit analysis can either be done based on the summary account, which represents the customer or based on the revenue accounts that you use in the sales order lines. Ideally they should result in the same outcome. However, your 'source document' parameter might be problematic here if you record sales order lines that are associated to different business units.

Tip: Do some tests in a demo/test environment and play around with the findims at the header and line level to see what difference the source document parameter in GL makes.

Best regards,

Ludwig
Ett 489 on at

Like (0)

Report

RE: MR Report - Gross Profit report - Which Business Unit will appear to MR report

Hi Ludwig,

Thanks for your advise

I checked GL parameter settings form > 'financial dimensions > values used for summary account: Source Document ==> what does it mean?

You mentioned AR Account Summary, can guide me how can I check this one?

If I check the sales by Business Unit on AX, the AR Account Summary can be?

Sorry for number of questions and hope to receive our feedback.

Many thanks

Ett
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: MR Report - Gross Profit report - Which Business Unit will appear to MR report

Hi Ett,

For question 1:

If your users change the BU at the header level to B02 then this BU shall be used for the posting on the AR summary account.

Note:

Whether this answer is true or not depends on a parameter setting.

Can you open the GL parameter settings form and look out for the 'financial dimensions-values used for summary account' parameter? Depending on what is selected there the BU findim is either used from the one specified in the header - what you asked for - or the ones specified in the lines. Note: If you select the latter option you might get multiple posting lines on the AR summary account broken down by BU.

For question 2:

Also here it depends on the GL parameter setting.

I would suggest that you do some quick tests in a demo/test environment where you post a SO with the first parameter option selected and then switch the parameter and post a second identical SO to see what difference this parameter makes when it comes to the voucher creation.

Best regards,

Ludwig