Rounding Issue Excise Invoice and Accounting document

[Former Member]

Hi

I have made and Excise Invoice with following values

Base Price 4110

BED 10% 411

CESS 2% on BED 8

HEC 1% on BED 4

In the Excise Table J_1IEXCDTL also values for BED is updated as 411, CESS as 8 and HEC as 4

But in Accounting Documetn following values gets updated

Base Price 4110

BED 10% 411

CESS 2% on BED 8.22

HEC 1% on BED 4.11

So at times there is a difference in both Excise Invoice and accounting Document. We want same values should appear in Excise Invoice and Accounting Document. Since EXCISE does not accept value in paise, we need to round off the value to the nearest rupee and accordingly update the accounting document.

My Pricing procedure mentions Cal Type as 17 Rounder off as per T001 R for BED / CESS /HEC...

Please guide...

Regards

Sanjeev

[Former Member]

Resolved myself with help from earlier threads in the forum.

Although i had maintained Routine 17 in Cal Type against my Excise duties, i had not defined my Rounding Rule for currencies for my company code and currency in OB90

Thanks again

Regards

Sanjeev

[Former Member]

Request you to pls tell,what/how is to be maintained in the 'rounding unit' field in OB90?

Rgds

Sumanth.G

[Former Member]

For your company code + currency maintain rounding unit as 100

for ex if your co code is 1000 maintain

1000 inr 100

Pls assign points if helpful

[former_member209761]

Dear Sanjeev,

Check whether there is a Condition type DIFF in the pricing procedure, and also in the invoice (conditions)

Check whether there is any account key assigned to it, in the pricing procedure.

Thanks & Regards,

Hegal K Charles

[Former Member]

No there is no Cond Type Diff in the Pricing Proceudre....

[Former Member]

Hi,

Try alternatively maintain Rounding rule in your excise condition type detail by V/06

Kapil

[Former Member]

Roundigng Rule is maintained as commercial only in condition types.

i want the values in Accouting Documetn to flow similar to Excise Table i.e ECESS as 8 and HEC as 4 ...

[Former Member]

Hi Sanjeev,

Just check what calculation type you maintained in VK12 for respective condition type. it Should be 'A' - Percentage.

Check and revert.

Regards

Ashwini

[Former Member]

Yes it is maintained as A only