Allocation of Sales and Expenditure Accounts only to a profit center.

[Former Member]

Hi,

I had earlier posted a question on how to allocate a BP to a Profit center:

Hi,

Is it possible to allocate a BP to one or more Profit centers when creating a BP Master in SAP;such that, on creation of a marketing document the Profit center is directly picked up instead of selecting it.

Please comment.

Regards,

The answer which solved it is :

Projects can be associated with a Business Partner in the Master data definition but not Profit Center.

Profit Center have associated distribution rules and are linked to G/L account or a transaction at the row level.

You could do this. Create a UDF in the BP Master to enter the profit Center information.

In the Sales Order Rows..in the Profit Center field create a Formatted Search to pull the Profit Center from the BP Master UDF

Example: Let us say your Profit Center User field on the BP Master is called U_PC

then your Formatted Search on the Marketing document would be

SELECT T0.U_PC FROM dbo.OCRD T0 WHERE T0.CardCode = $http://$4.0.0

Set it to Auto Refresh on Item Code ....check Display Saved Values

If you want 2 Profit Centers on the BP Master and the user would select it in the Marketing document then let us presume your UDF's are U_PC1 and U_PC2,

the FMS would be

SELECT T0.U_PC1 FROM dbo.OCRD T0 WHERE T0.CardCode = $http://$4.0.0

UNION ALL

SELECT T0.U_PC2 FROM dbo.OCRD T0 WHERE T0.CardCode = $http://$4.0.0

Suda

Now, since the BP has already been allocated to the profit center anytime a service type credit note is passed which links to a Liability or an "Other" Account type, the profit center still gets allocated.

Can I make any changes to the query such that only Sales or Expenditure account could be allocated to the BP, and any other account if tagged the entry is not tagged with a profit center.

This has become critical for users who check the profit center report, which does not give the correct figure because of the above issue.

Please advise.

[Former Member]

Hi,

I believe there is a bug in SAP at some patch levels which causes the credit notes to apply the profit centre to the asset & Liability lines.

You can upgrade to stop it happening, and you can manually drill to the journals and remove it, or use DTW to update JDT1 lines to remove it where necessary, depending on the volumes?

[Former Member]

Hi Julie,

Thanks for your reply!

We have recently upgraded to 2005B PL43.

Still it has not helped.

Secondly these report are regularly checked by our Sales manager's hence updating using DTW will be a cumbersome affair.

Is there some query which can update the fields correctly......

E.g. Can the following query be amended to get the correct result:

DECLARE @Type nvarchar(1)

SELECT @Type=T1.ActType FROM OACT T1 WHERE T1.AcctCode=$[$39.94.0]

IF @Type='I'

BEGIN

SELECT T0.U_AT_PC FROM [dbo].[OCRD] T0 WHERE T0.CardCode= $[$4.0.0]

END

ELSE

IF @Type='E'

BEGIN

SELECT T0.U_AT_PC FROM [dbo].[OCRD] T0 WHERE T0.CardCode= $[$4.0.0]

END

ELSE

BEGIN

SELECT u2018u2019

END

Need your advise.

Regards

[Former Member]

Hi Vishal,

You can certainly change the query that our formatted search is based on to consider the value in the GL Account field, and have it populate or not populate based on the account type.

My SQL is not the best, hopefully someone else can look at your query and tell you if you are on the right track?