Incorrect Tax Base Amount

Rukshana Sameem

Mar 5, 2012 9:38 AM

Currently Being Moderated

Hi All

I am stuck on a issue with the tax posting, everytime we do an FB60, the tax amoiunts gets calculated from the Line item expense amount instead of the header vendor amount, therefore making the tax calculated amount as incorrrect.

I checked the co code setting to see if the 'net tax indicator' is set there - no it is not.

I checked the OBCN and OBYZ settings and OB69 settings - all are correct and have no reference to specific tax calculations

I checked F000 - there is no specific user setting there either on taxes

I checked the Doc type - nothing there either.

Can someone please help me with this since I dont knw where else to check.

Thank you very much

Re: Incorrect Tax Base Amount

Narasimhulu Konnipati Mar 5, 2012 9:59 AM (in response to Rukshana Sameem)

Currently Being Moderated

Hi,

If it takes from Header data or Line item data, the TDS will be calculated on the total amount.

Refer to the below entry

Itm PK Account    Account short text   Assignment         Tx           Amount

1... 31 3012263    Volkswagen     .....                                   6,300.00-
2... 40 10000000   Cash                    .........                          5,000.00
3... 40 63502000   Testing material            ........                      2,000.00
4... 50 21611000   TDS Deduct                          .........              700.00-

Thanks
Report Abuse

Like (0)
- Re: Incorrect Tax Base Amount
  
  Rukshana Sameem Mar 5, 2012 10:16 AM (in response to Narasimhulu Konnipati)
  
  Currently Being Moderated
  
  Hello
  Thanks for the response
  My concern is
  I have the below posting: where tax is at a 19%
  31 - vendor - 3388,37
  40 - Expense - 2847,37
  40 - tax - 541 (19/100*2847,37)
  
  whereas I want the tax amount to be - 19/100* 3388,37 = 643,79
  
  I have not changed anything on the way I usually define the tax codes, but somehow the client is requesting this - and I dont know how to go about to get it to work since I have checked all the relevant settings. What am i missing?
  
  Thanks again
  R
  
  Report Abuse
  
  Like (0)
  - Re: Incorrect Tax Base Amount
    
    Narasimhulu Konnipati Mar 5, 2012 10:26 AM (in response to Rukshana Sameem)
    
    Currently Being Moderated
    
    This is strange my dear....
    
    Let me check for the possible reason
    
    SPRO - FA New
    
    Under calculation -> Withholding Tax Type ->Define Withholding Tax Type for Invoice Posting
    
    WHT Type - Double click on any code
    
    Base amount should be "GROSS Amount"
    
    Check these settings what you have
    
    Thanks
    
    Report Abuse
    
    Like (0)
Re: Incorrect Tax Base Amount

Vivek Srivastava Mar 5, 2012 11:05 AM (in response to Rukshana Sameem)

Currently Being Moderated

Hi,

In FB00 please un tick "Calculate Tax on net amount".

Regards,
Vivek
Report Abuse

Like (0)
- Re: Incorrect Tax Base Amount
  
  Rukshana Sameem Mar 5, 2012 11:10 AM (in response to Vivek Srivastava)
  
  Currently Being Moderated
  
  Hello again
  this tax code is not defined as a withholding tax key.
  
  And Hello vivek,
  i tried that too but it doesnt work either.
  
  Thanks again
  R
  
  Report Abuse
  
  Like (0)
  - Re: Incorrect Tax Base Amount
    
    Narasimhulu Konnipati Mar 5, 2012 11:21 AM (in response to Rukshana Sameem)
    
    Currently Being Moderated
    
    Dear,
    
    try to provide us more details instead of giving a line answer
    
    What do you see in Tax type - Invoice level
    
    GROSS AMOUNT or NET AMOUNT?
    
    Gross amount should be ticked,
    
    This is important to solve the error
    
    Double click on any tax type and see the details
    
    Thanks
    
    Report Abuse
    
    Like (0)
    - Re: Incorrect Tax Base Amount
      
      Rukshana Sameem Mar 5, 2012 11:41 AM (in response to Narasimhulu Konnipati)
      
      Currently Being Moderated
      
      Hello
      there are no tax Codes defined on the customizing node: Tax Type at Invoice Level.
      
      The particular tax code I m referring to is not defined as a withholding tax type. However, I just defined it with Gross amount as the base - but even then, I am not generating the value that I need.
      
      Under my tax code setting in FTXP, there is no place where I can specify the base amount.
      
      THank you
      R
      
      Report Abuse
      
      Like (0)
    - Re: Incorrect Tax Base Amount
      
      Rukshana Sameem Mar 13, 2012 3:55 AM (in response to Narasimhulu Konnipati)
      
      Currently Being Moderated
      
      Hello again
      can anyone shed me some light on this issue -
      how can i calculate taxes on the gross amount of the invoice. Does that mean that i would have to define that as a Withholding tax
      
      thanks much
      R
      
      Report Abuse
      
      Like (0)
      - Re: Incorrect Tax Base Amount
        
        Narasimhulu Konnipati Mar 13, 2012 4:35 AM (in response to Rukshana Sameem)
        
        Currently Being Moderated
        
        Dear,
        
        Go to OB69 and check if your company code has been selected for Net base amount.
        If yes, check what could be the reason whether any legal purpose was driver to opt for it or not.
        Otherwise remove the tick and check the entry.
        If you still see, at transaction level, there is an option "Editing options" click on it
        See if the option "Calculate taxes on net amount ticked", if yes remove it
        
        Thanks
        
        Report Abuse
        
        Like (0)
        
        Re: Incorrect Tax Base Amount
        
        Rukshana Sameem Mar 13, 2012 8:01 AM (in response to Narasimhulu Konnipati)
        
        Currently Being Moderated
        
        Hello
        Thanks much for the response
        in answer to your first Qs - there is no check maintained in OB69.
        In answer to your 2nd Qs - under 'Editing options' - there is no check either.
        I want the tax to calculate on the gross amount -
        eg -
        31 - Vendor 100
        40 - Expense 81
        40 - Tax Acct - 19 (19% from 100)
        How can i set that up - can you please advise
        Thanks much
        RS
        
        Report Abuse
        
        Like (0)
        
        Re: Incorrect Tax Base Amount
        
        Narasimhulu Konnipati Mar 13, 2012 8:17 AM (in response to Rukshana Sameem)
        
        Currently Being Moderated
        
        What you are talking about is Tax on Net amount.
        FB00 - Check the box "Calculate taxes on net amount ticked"
        Simulate a scenario in FB60, or FB70
        Now see the entry,
        
        Let me know if you still isuee
        
        Report Abuse
        
        Like (0)

Go to original post