FTXP

[Former Member]

Hi Experts,

Previously, VAT Tax code was created with 9%. Now I changed to 0% due to legal requirement.

I have changed VAT/Output Tax rate from 9% to 0% in FTXP. I have not change anything anywhere. System is calculating only with 9% but not with 0%.

My requirement is: System should calculated 0% VAT instead of 9%. Kindly throw me some idea on it.

-----

can anyone tell me what is relation between FTXP and VK11 (VK13) condition type. Which one has priority?

eg: i have changed VAT rate from 9% to 0% and posted one document. VAT was posted with 9% not with 0%.....this is happend when I changed in FTXP

I have changed VAT rate from 9% to 0% and posted one document. VAT was posted with 0% not with 9%.....this is happend when I changed VK11.

Is this the way to change the rates or any other way is there? any material effect would be there rest of the places except VAT calculation.

thanks in advance.

Thanks,

Muneendra

[Former Member]

Hi All,

Thanks for the replies.

Issue got resolved.........

[yogesh_kshatriya2]

Hi  Muneendra,

First find out which condition have been assigned to your tax code. Then change the tax rate to zero in that condition for respective tax code. You can find conditions which are assigned to  your tax code in KONP table.

--Yogesh

[Former Member]

Hi

Can you try to post the FI entry with tax code % = 0 and verify the postings.

Whether it is calculated for ZERO or 9 % ?

Thanks

Ramu

[Former Member]

You can post FI entry with tax code % 0 example ...Tax code V0/A0 (tax code for tax exempt transactions) which is mandatory to define.

[Former Member]

It can surely be because you do not have condition type MWST in you FTXP tax code.

Try editing your tax procedure.

Put MWST condtion type in place of MWAS in you procedure.

[Former Member]

Hi Yaduveer,

In FTXP, I have created tax code D1 with condition type MWAS.

I have created condition record with MWST and D1 tax code combination.

Now, sale order will pick up D1 tax code?

if no tax code is created with MWST combination in FTXP, the same tax code can not be used in condition record creation in VK11?

Please clarify...

[Former Member]

See Tax % is determined by FTXP condition type and VK11 condition type.

For MWST you have % in vk11 but no tax rate is there in FTXP D1 tax code.

This is standard practice. An I can just suggest go as per standard define % in FTXP against same condition type as you use in vk11 and sales order, or there will be sure inconsistency when billing is done in SD (vk11) and for same FI Doc. is created in FI (FTXP).

[Former Member]

Hi,

Please check if the account key MWS has been assigned to condition type MWST in the pricing procedure. 

To get to the pricing condition, proceed as follows:

IMG --> Sales & Distribution --> Basic Functions --> Pricing --> Pricing Condition --> Define and Assign Pricing Procedures --> Maintain Pricing Procedures

Locate the pricing procedure being used and double click on Control Data on the left pane of the screen.  Look for the condition type MWST to make sure it has account key MWS maintained.  Maybe this could be the issue.  If another account key has been maintained for MWST, then you might want to check that in FTXP and make that 0% instead.

Best of Luck.

Elias

[Former Member]

Hi..

This will change tax calculation for open Sales orders.

for e.g. tax in sales order was 9% when you made it, it will be 0% now.

But all this depends on the condition type and access sequence you are using for that condition type, whether it has validity field or not.

[Former Member]

Issue is still open.

Can someone help me in this as it is high priority for my client.

[narasimhulu_konnipati]

Dear,

Usually the Condition type is MWST.

You would have created a new tax code and assigned in FV11 and in FTXP

Just check what is the rate showing in FV13

Else wait for experts views

Thanks

[Former Member]

I will still ask what is the access sequence assigned to your VAT condition type.

Check if in VK11 what combinations you get while defining tax rate.

As your VAT is picked from condition type in Sales order the rates are picked from VK11 with priority over FTXP.

[Former Member]

Hi,

as i said,  there was 9% for for one output tax code. I changed to ZERO.

I changed in two places.....FTXP and VK12....I made that tax code, lets say I1 to ZERO. I can see this in FTXP and VK12.

Why the system is not considering ZERO. Its an urgent. someone can help me.

Will give full points for this.

[Former Member]

Please give a screen shot of you tax code in VK13.

[Former Member]

Hi,

I have attached screen shots.

1. Sale order

2. VK13

3. FTXP

waiting for your reply.

[Former Member]

1. If you carefully check FTXP you will see that 0% you have defined is for condition type MWAS and not MWST which you are using in VK13.

You do not have MWST in your Tax procedure.

You can insert condition type MWST instead of MWAS in tax procedure and I am sure it will give you 0 % rate.

2. Give one more screen shot. i.e. select MWST and sales order and click on Magnifying glass icon below "choose" it will open one screen give me its screen shot.

[Former Member]

Hi Yaduveer,

MWAS and MSKA these are FV11 condition types and these are not available in VK13.

Now, I have one question here, the condition types that are mentioned above are maintained in FV11. If I change tax rate in FTXP then it should not effect VK11 condition types. What i assume is,

VK11 conditions types are playing role in sale order. I can see MWST in pricing procedure.

can you explain the FV11 and VK11 relationship in sale order?

suppose, In country DK, i have created 3 output taxes with different rates. D1, D2, D3 and rates are 5% 6% and 9%. how the system pick the 9% or 6% or 5%, on what basis.

[Former Member]

VK11 condition type effects SD module.

FV11 does not effect Sales Order.

Give one more screen shot. i.e. select MWST and sales order and click on Magnifying glass icon below "choose" it will open one screen give me its screen shot.

For Sales order your condition type will be picked from VK11 and rate also.

As seen in your tax code MWST condition does not exist.

thus give me above screen show so that i can see the calculation for MWST done in your SO.

[Former Member]

After replicating your scenario these are findings:

1. Rate is picked from VK11 (as this effects SD)

2. FV11 and FTXP rates are ignored in SD documents.

3. In SO the tax is calculated by condition type, i.e. MWST not tax code (FTXP)

i.e. FTXP tax code (VT suppose) 1% MWAS

MWST in VK11 10%

In sales order when you will calculate tax it will check.

1. Tax code:VT (from user input)

2. Condition type: MWST (In pricing procedure)

3. Combination of Tax code and condition type (in VK11)

4. 10% (defined in VK11)

Thus picking 10%.

Now to provide some extra help if you need for your scenario:

Let me know is your legal requirement is for specific customers or for all company code.

[Former Member]

Hi,

Providing screenshot as requested.

in VK13....I can see that D1 tax code rate is ZERO. But when i see in sale order under condition types tab it showing old percentage 7%. How the system is picking 7% instead of 0%.

I can also see 0% for the same tax code in FTXP also.

waiting for you reply.

[Former Member]

Hello,

VK13

I would like to see you VK13 also.

Sorry I am being to demanding but its really important. As in Vk11 when we maintain a Condition type various data can be maintained depending on access key. In my system I can mention this % based on State/Customer Tax category/

i.e. Country IN state MH custome cat 0 (non taxable) tax code D1 rate 0%

Country IN state MH custome cat 1 (taxable) tax code D1 rate 10%.

So need all that information from you. As number of possiblities are many.

[Former Member]

Hi,

Providing VK13 screenshots.

[Former Member]

Good.

Now in sales order condition tab click on Analysis button... go to MWST and check whether the same sequence is used to pick %.

If you arent getting what is happening post screen shots. MWST--->something and ----> %.

Check condition value determination for all steps.

[Former Member]

Hi,

Providing another screenshot from sale order.

condition types - selected MWST - anlysis....

The sequence is same as in VK13. there is no difference between Sale order level and VK13 level.

[Former Member]

Hi dear,

Open the Sales order in change mode and update pricing.

I hope it will change % to 0%.

PS: Some pricing type G: redetermine tax calculation.

Check and revert back.

Also check whether no delivery or billing has taken place for this sales order.

[Former Member]

Hi,

Pricing(condition tab) is not in change mode in sale order. I should not change mannually. System hast to pick on its own. I checked but its not 0% its 7%.

Hi forum,

Kindly look into this issue. Hope many experts are there in this forum. Requesting all to respond.

[Former Member]

In change mode check on menu bar... Goto ---> Item/header---> conditions.

It will take you there. And you do not have to change any think. on condition tab click on "Update" as whenever you make changes in VK12 you need to do that else it will remain as it was carried out when the condition was 7%.

Hi dear,

[Former Member]

Hi,

But its gray mode. so, its not possible to update it.

[Former Member]

Its grey in display. in change its not grey.

I used your screen shot to show you as i dont have my SAP server available atm.

[Former Member]

Hi,

I tried again. Its in grey color only. Not able update.

[Former Member]

Will revert back tomm when my system will be available.

[Former Member]

B/w you are trying update in condition at item level, do not try at header level.

Goto--->Item--->Condition---> update select type "G" pricing remain unchanged and redetermine tax.

[Former Member]

Check this:

VA02 - give your sales order.

When it opens in menu bar goto -->item-->condition

Click on update. and choose option G.

Above tax is 10% and now after updating check this.

As it updated it has changed to 0%.

[Former Member]

Hi,

I tried as you said still its in grey color only. So, not able to update.

System has to update right, why we need to click on update button. I think its not bz of the updation and its bz of something else which I dont know.

I will wait for other views as well.

[Former Member]

System does not update pricing procedure automatically in already existing sales orders (you have manually update for which SAP has given that option). If it grey that means you have created billing document (FI doc has been created) for the same sales order and thus nothing can be updated/changed now in either of docs (billing and sales). You can check by making new sales order it will come 0%.

Thanks.

[Former Member]

Yaduveer,

Thanks for the replies. I have created new sale order and tried still its in grey color only. Keep this apart for time being.

can you tell me why the table is not been updated with 0% (konp). I can see only 7% in this table not 0%. But i can see 0% in VK13.

Please let me know why table is not updated even after changing the rate in vk12. Then how to update the table with 0%. Please suggest.

[former_member392819]

Hi Muneendra,

When you change the tax rate from one % to other %, there wont be any effect on the previous posted documents.

Regards,

Sravan

[Former Member]

adding to the above question,

I think if we change some rate for a tax code it effects rest of the places automatically. Because the same account key or condition type might be used in pricing procedure...

Please correct me and provide solution for the issue.

[Former Member]

adding to previous question:

If I change output/vat tax rate from one percentage to another percentage, previous data will get effected? I mean the documents that are posted alredy will be effected with new percentage rate?

This is only a doubt.