Need seperate GL for Export Pricing procedure in commercial billing

[former_member731201]

Dear Expert,

Client wants to enable excise for export, and also at the time of commercial invoice.

All credited tax values (i.e., BED, AED, ECS , S&H) has to flow seperate G/L to debit this value.

Should not add in Customer Recon account.

eg.,

Customer Acc Dr : 1000

Sales Acc       Cr:  1000

Tax acc          Dr :    123

BED               Cr:     120 (12% from base value)

ECS               Cr:        2 (2% from BED)

S&H               Cr:         1 (1% from BED)

but right now

Customer Acc Dr : 1123

Sales Acc       Cr:  1000

BED               Cr:     120 (12% from base value)

ECS               Cr:        2 (2% from BED)

S&H               Cr:         1 (1% from BED)

Kindly give suggestion how to add new condition type for this tax debit gl in pricing procedure.

[jpfriends079 · Accepted solution]

Can you provide me condition detail of your condition type used/suggested for tax adjustment in yiur sales doc? Please refer following screenshot for the same

[former_member731201 · Accepted solution]

Dear Jyothi Prakash,

As you asked,

[jpfriends079 · Accepted solution]

Following is my observation:

1. I don't know, why are you using Alt.calc.type 352 for this condition. Can you briefly guide us on that?

2. If your this condition type is discount, the it should be similar to following:

Once you get condition value in negative, you will be able to achieve your requirement.

Thanks, JP

[former_member731201 · Accepted solution]

Dear Jyoti Prakash,

Thanks a lot for all your suggestion.

Its working fine now, my mistake using cal type 352, now i am using 353.

Here having one more problem, account posting system rounding off the percentages

Basic price : 1000

If the BED 12% = 120 no problem

AED 2% = 2 EUR(Instead of 2.4) 131.714 LC(Instad of 158.00-

SED 1% = 1 EUR(Instead of 1.2) 65.86 (Instead of 79.00-

System rounding off the amount in Foreign Currency. So that converting Local difference more.

Kindly help me on this.

Ragards,

Mani.S

[jpfriends079 · Accepted solution]

If you search properly. There are many SCN discussions are there to help you on rounding issue. This all about, importantly, how you are

- configuring rounding rule in condition type(V/06)

- setting rounding rules for currency in OB90.

Refer following links for your reference:

- Condition type: DIFF-Rounding Off

- Condition type specific rounding off

- Rounding Off of Condition Type

Thanks, JP

[former_member731201 · Accepted solution]

Dear Jyoti Prakash,

Even I check this,

But here the problem is only for this process need to be correct.

Should not disturb the CO existing process.

Regards,

Mani.s

[jpfriends079 · Accepted solution]

How the above suggestion will affect your CO process?

Thanks, JP

[former_member731201 · Accepted solution]

Dear Jyoti Prakash,

If I do changes in condition type or any other place to turn off round of percentage.

Then that will effect all the pricing procedure.

That is the reason i am asking there is any possibilities only turn particular pricing procedure.

Regards

Mani.S

[Lakshmipathi]

You would be aware normally for exports, both tax and excise is exempted and it should be statistical in pricing procedure.  Of course, while creating an excise invoice, the corresponding excise amounts would be posted in the relevant G/Ls based on the settings you set in IMG.  This being the case, how it is configured at your end.

G. Lakshmipathi

[jpfriends079]

The functionality desired by is known as deferred taxation. Please check my response in following post:

- Billing document for SEZ customers w/o TAX

Although that talks about service tax, but similar config/setup can also be achieved for Excise, ECS & S&H.

If you still have any concern, please revert back.

Cheers, JP

[former_member731201]

Dear Jyoti Prakash,

I read your link, from that i got to know need to be add new conditon type. ZTAJ (Discount ) from your discussion.

This scenario will work for my requirement.

Here I attached my pricing procedure.

Can you suggest me how to add new condition , configuration to create condition type.

Regards

Mani.S

[jpfriends079]

Before suggesting further, what you are going to do with

Tax acc          Dr :    123

Is it statistical?

Thanks JP

[former_member731201]

Dear Jyoti Prakash,

Client need tax account separete gl  for claiming rebate (Export no bond.)

Ragards

Mani.S

[jpfriends079]

That means you are paying excise upfront to export material and then claiming it back. This means it is normal sales, where you will ask for refund after showing other supporting doc related to export. Correct?

For this my previous response may not help. B'coz as soon as PGI is done for your plant, you are liable to pay excise to the Indian Govt and you have to create excise invoice. And that is not deferred tax.

This should be better handled through separate G/L account for these sort of export. And accounting doc will remain as it is:

	Dr	Cr
Customer Acc	1123
Sales Acc		1000
BED(12% from base value)		120
ECS (2% from BED)		2
S&H (1% from BED)		1

Separate can be achieved through G/L account determination based on separate tax code for export. For config refer following SCN Wiki page:

- Plant-wise Different Tax General Ledger Accounts

In above link, just refer only step 1 to 3. As you already have separate pricing for export. You don't have to do any changes in your pricing.

If in case of any further information required or concern, please revert back.

Thanks, JP

Moderator Remarks: As discussion is related to CIN(India Localisation). Discussion is moved to SCN Space - Internationalization and Unicode

[former_member731201]

Dear Jyoti Prakash,

As you replied, the process going on regular process for local sales.

In export right now there is no excise tax.

User want excise after PGI.

As per the client requirement, I made this Pricing procedure working fine.

After PGI

Pro-forma Invoice (Background acc doc)

Excise document :

BED Acc   Dr : 120

ECS Acc   Dr:       2

S&H Acc   Dr:       1

Tax acc     Cr:   123

Commercial Invoice:

Customer Acc Dr : 1123

Sales Acc       Cr:  1000

BED               Cr:     120 (12% from base value)

ECS               Cr:        2 (2% from BED)

S&H               Cr:         1 (1% from BED)

But Client need like this only at the time of commercial:

this is only place i couldn't able to make

Customer Acc Dr : 1000

Sales Acc        Cr:  1000

Tax acc          Dr :    123

BED               Cr:     120 (12% from base value)

ECS               Cr:        2 (2% from BED)

S&H               Cr:         1 (1% from BED)

Kindly do me favor , how to make this.

Regards

Mani.S

[jpfriends079]

If that is so, then add following steps once your all tax condition type is calculated. Say, as per screenshot your all tax calculation concludes at step 619. Then

Step	Condition Type	Description
630		Total Tax (This should sum up all your tax amount in pricing procedure which you like to see in DR side, including E CESS & Sec CESS)
640	ZAUJ	Tax Adjustment (This can be an item discount condition. This condition must be: - Cond. class: A - Discount or surcharge - Calculat.type: A - Percentage Assign account key for relevant G/L account determination Maintain condition record in VK11/VK12 as 100% )

Hope that helps you.

Thanks, JP

[former_member731201]

Hi,

As per your suggestion I made changes added two lines, but its not working properly.

Values crediting, but i want debit side and this tax should not add in customer recon.

I thing from & to is wrong and calculation type also.

Kindly refer my screen shot give me suggestion how to maintain.

[jpfriends079]

Check your Tax Adjustment condition type. The error is with Plus/minus. As earlier said, that is discount condition type. Refer following screenshot(make changes accordingly and try again)

-

Best Wishes, JP

[former_member731201]

Dear Jyoti Prakash,

As you replied, I tried same one time postie and one time negative.

But there is no changes in account posting.

Kindly refer my screen shot.

Kindly help me on this.

[jpfriends079]

Are you trying this with a new sales cycle or with same sales cycle? Change in condition type is config change. If you like to see the effect of the change try with a fresh sales doc cycle.

Best Wishes, JP

[former_member731201]

Dear Jyoti Prakash,

I did not get you point.

what is meant by sales doc cycle.

As per your suggestion i made changes in ZAJJ condition, but GL Acc not Debiting only crediting.

Kindly tell how to achieve this.

[jpfriends079]

Sales Cycle means your sales process, say, creation of Sales doc - Delv - Billing. For every config change, please check with fresh sales process to see the effect of config change.

Okay. I have question for you, if you give discount to your customer. Where it should debited or credited in account doc generated for sales invoice.

Thanks, JP

[former_member731201]

Dear Jyoti Prakash,

I am doing new pricing procedure,not existing one.

So that the effect only for this Export Customer only.

As per the client requirement, Ignoring collecting tax from customer(i.e.,Discount).

That they need separate GL to get report only for Rebate.

Everything is done, but system adding with tax as net value and posting into customer recon acc

and also new condition type value posting only credit but i need in debit side.

Kindly help me on this.

Regards

Mani.s