Accounting entry

[Former Member]

Hi All,

Someone can suggest me how to achieve below transaction while invoice is posted to accounting

Current account entry takes place

PARTY ACCOUNT 13090.00

SALE DEEMED EXPORT - 11867.50

EXCISE DUTY COLLECTION ON SALE - 1186.75

ED CESS COLLECTED ON SALE - 23.74

SEC COLLECTED ON SALE - 11.87

ROUNDED OFF - 0.14

Should be taken place

PARTY ACCOUNT 11867.50

EXCISE DUTY REBATE UNDER CENVAT 1222.11 ( It will hit a separate G/L 265014)

SALE DEEMED EXPORT -11867.50

EXCISE DUTY COLLECTION ON SALE -1186.75

ED CESS COLLECTED ON SALE - 23.74

SEC COLLECTED ON SALE -11.87

ROUNDED OFF -0.14

How can I configure the pricing procedure so that, Invoice will be posted like this into accounting.

Regards

JJ

[former_member657193]

Hi

As you have explained - You want the total of Excise charged into a seperate GL. This can can configured using the standard process in the pricing procedure.

As suggested by Jignesh, Create TWO condtion types.

1. In the first one capture the total of Excise that will hit your required GL

2. In the second one capture the -ve of the Excise or 100 % copy of the First condtion with -ve value (discount ) and then post

Thanks

RB

[jignesh_mehta3]

Hello,

This is very much possible with SAP Standard Pricing Procedure settings.

Create a new Condition Type (say ZEXR) for Excise Duty Rebate . In the Pricing Procedure insert ZEXR after the Secendary Cess Condition & mentioned required From / To columns such that ZEXR contains sum total of Excise + HE Cess + SE Cess.

Now create another Condition Type say ZEX1 (Calculation Type - percentage) & set it as Negative. Now create a new Tax Code for Excise Rebate Conditio Type. Create Condition Record for ZEX1 which would be 100% & assign the Tax Code.

In the Pricing Procedure insert ZEX1 after ZEXR & maintain required From To Columns.

Subsequently create new Account Key & assign the same to Condition Type (ZEX1) in Pricing Procedure. Also maintan GL Account Determination in OB40.

Hope this helps,

Thanks,

Jignesh Mehta