Posting to multiple COCG accounts

95 Views

Guys,

Would appreciate if anyone like to share some knowledge on this point. the case and requirement is as follow:

*1ST PART OF THIS REQUIREMENT*

Multiple Cost of Sales accounts

When goods issue is posted for a Sales Order delivery, the COGS account

is determined from the valuation class and only 1 COGS account can be

specified.

My client requires the posting to be made to multiple cost of sales accounts

based on the customer account assignment group.

The Logic for the change is as follows and needs to be inserted in the

process when the goods issue is posted for a delivery.

Logic: Determine Sold to party from delivery header, then determine the

COGS account from Customer Master field Account Assignment Group (KTGRD)

.

Accounts to be substituted are listed below.

Note: If a delivery has no sold to the no substitution needs to occur as

the delivery will be an intra company STO.

Customer Acct Grp G/L Account

01 Domestic Revenues 450000

02 Export Revenues 460000

03 A Group 470000

04 B Group 470100

05 C Group 470200

*2ND PART OF THIS REQUIREMENT*

Profit center for inter company STO spares sales

The profit center is determined via the account determination for the

materials valuation class. This determination results in an inventory

posting to account 470000. The account is then linked to cost center

3540 via cost center determination. This cost center is then linked to

profit center 35100 in the cost center master record.

The issue arises when we u201Csellu201D spare parts to Australia via STO.

We require the profit center for the spares sales to be 34150.

This code should be placed after this code for issue 1 above.

This logic needs to be inserted in the process when the goods issue is

posted for an STO delivery.

IF Delivery Type = NLCC AND Sales Org = NZ01 AND Material Group LIKE S*

THEN profit center = 34150 IF Delivery Type = NLCC AND Sales Org = AU01

AND Material Group LIKE S* THEN profit center = 14100

PLEASE DO ADVISE IF YOU THINK IT IS POSSIBLE, IN THAT CASE WHICH LOGIC SEEMS FEASIBLE HERE.

Thanks