How to split Inventory and customs during Goods Issue

[Former Member]

Hi Friends,

We create an Intercompany PO and do a GR against it. It creates an automatic GI. The Material document posted during GI is Dr. COGS account and Cr. Inventory account. The Inventory account consists of stock value + customs duty paid during GR.  Now we want to split this inventory and customs separately while posting the GI.

For Example: Stock value = $100, Customs duty $10. Then total inventory value is $110.

Current postings

Dr. COGS      $110

Cr. Invenotry  $110

To be postings

Dr. COGS          $100

Dr. Other Costs $ 10

Cr. Inventory      $100

Cr. Customs       $ 10

Please share any inputs to achieve the required postings.

Regards

Surya

[former_member200703]

Hi

you needs is obviously violate the IFRS standard that state the custom and othervcost directly attributable to inventory is integral part of its cost .. I do belive SAP is not supporting such needs you have.. you may also check at MM area if they can helps you out  to  achive you requirements.

Regards

Mahmoud El nady

[Former Member]

Hi Mahmoud Elnady,

We are not violating the IFRS here. We just wanted to know the split. We will be grouping these 2 GLs (1 for inventory and other for customs) in the financial statements.

Regards

Surya

[sanilbhandari]

Hi Surya

Do you not want to show stock values inclusive of Customs value? If that is the case, you can have only one GL Account for both inv and customs. You may write a query or a custom report based on KONP and KONV table to get the required information based on condition type values though.

Regards

Sanil Bhandari

[former_member200703]

Hi

In our company we have the following cycle if it can gives you any idea:

inventory purchase with custom/ freight cost

Dr. Inventory                         1150

     Cr. GR-IR                         1000

     Cr. Custom for Inventory    100

     Cr. Freight for Inventory       50

While Goods issue to production :

Dr. COGS                1150

     Cr. Inventory        1150

Regards

Mahmoud El Nady

[Former Member]

Hi Sanil Bhandari,

Yes you are right. We dont want to include customs value in inventory value. We creat outbound delivery directly from PO using VL10D. After GI, the entry gets posted as Dr. COGS and Cr. Inventory.

We just wanted to split it.

Regards

Surya