Consolidation - Trading partner field not available for COGS

[Former Member]

I am working on BPC 10.1 Consolidation. Client ECC system, classic GL exists. Please find below example

Entry in company A       

Account                                    Amount    trading partner

Accounts Receivables – B        1000 USD        100

Sales Intco – B                          1000 USD        100

Entry in company B

Inventory                                    1000 USD        200

Accounts Payables – A              1000 USD       200

I will eliminate AR with AP Sales Account in company A, need to be eliminated with COGS in Company B But COGS entry does not have trading partner field. Please suggest how to handle this ?

[Former Member]

Hi,

I would use an Eliminations and Adjustments business rule that eliminates the amount reported as Sales by company A both from the Sales account and also the COGS account.

BR,

Arnold

[Former Member]

Thanks Arnold,

I need to Eliminate sales account in company A with COGS account tin company B.

Is this possible using Eliminations and Adjustments business rule?

Regards,

Suresh

[Former Member]

Hi Suresh,

yes, as long as the sales amount is reported with trading partner you can get the rule post an elimination on that trading partner. There is an option called "swap entity and intco" (or similar) that will swap the entitiy and trading partner code for the elimination (based on the intco property in the entity dimension and the entity property in the intco dimension).

You would then need to use an offset account so that the elimination posting balances for each of the two entities.

BR,
Arnold

[Former Member]

Thanks Arnold,

Will test same.