FB60 vendor invoice

[Former Member]

FB60 vendor invoice

Transaction : posting a vendor invoice and offsetting entry is a G/L expense account

When i enter equal amounts (invoice amount and g/l amount) i am getting an error saying balance not zero

But i varied the amount it is letting me post

ex 5300 as invoice amount and 5000 as g/l amount

Why is this so?

Points promised

Prashanth

[sridevi_p · Accepted solution]

Hi,

Check whether any tax category is maintained for the GL account in FS00.

Regards,

sridevi

• Pls. assign points, if useful

[Former Member · Accepted solution]

As i said in my earlier message i am using tax category input tax allowed for the G/L account

Prashanth

[sridevi_p · Accepted solution]

Pls. check if u have checked Calculate tax checkbox in FB60?

[Former Member · Accepted solution]

Yes checked the box calculate tax

Prashanth

[sridevi_p · Accepted solution]

Hi,

To solve ur problem,

click the 'Editing options' button in FB60

Check - Calculate taxes on net amount.

Now post the document.

I think ur issue should be solved.

Previously, if u post amount for 5000rs - and say tax is 300rs, it is taking as 5000 + 300 = 5300

After making editing option changes, it will be like 4700 + 300 = 5000

REgards,

sridevi

• Pl.s assign points if useful

[Former Member · Accepted solution]

Thanks sridevi u solved the problem

but i am not sure if you exactly meant the below

If i uncheck the calculate tax on net amount in editing options balance is zero

if i check the calcualte tax on net amount box in editing options it is not letting me post

However problem solved

Thanks

Prashanth

[Former Member]

Hello

Check the posting keys. Probably you are manually changing them or both have only debits.

Reg

*assign points if useful

[sridevi_p]

Hi,

Try simulating the document and get to know the error better.

Regards,

sridevi

• Pls. assign points if useful

[Former Member]

May be its calculating WT tax but unable to recognize and post to the tax account.Can u please let me know r u using With holding tax if so pls check the settings to WT.

Assign points if useful

[Former Member]

Thanks Ragani

Sure there is some problem with tax i guess

The tax code i am using is I1(input tax) for both vendor and g/l accounts

I checked the g/l master the tax category i assigned was input tax allowed

Can you further analyze the problem.

Prashanth

[Former Member]

I have simulated the document

and the entries are

expense (debit) 5300

vendor (credit) 5300

However i posted only 5000 to g/l account and 5300 as vendor invoice amount

[Former Member]

I m also sure its problem with WT only.

Use tax code only for vendor not for G/L account.

Hope u have made WT configuration correctly.

Reply for further clarification

Assign points if useful

[Former Member]

Ragini can you give some brief steps to go about WT configuration

Prashanth

[sridevi_p]

Hi,

WHT has 2 types – a. Accrual basis b. Payment Basis

Path: IMG – FA-Fin GS – WHT-Extended WHT

1. Basic Settings

a. Check WHT countries: Check ur country

b. Calculation

i. Withholding tax type – Define WHT type for invoice posting: Give ur country, tax type, Base Amt – Select Gross amount à Save

ii. WHT Type – Define WHT for payment posting – Similar to 1bi

iii. WHT Code - Country, WHT type, Base Amoutn: 100%, Post Indicator: 1: Std posting, Calculate: WHT Rate: Give ur tax rate. Similarly do for payment posting

c. Define formula for calculating WHT-Give basic details and enter other details by double clicking ‘Formula for calculating WHT’. Do for both Accrual and payment

d. Company code – Assign WHT to cocode – Do for both payment and accrual

e. Activate Extended WHT

2. Posting: Accoutns for WHT – Define accouts for WHT – Give chart of acct – Select WHT code and Type. Give the type and code of both accrual n opayment

3. IMG-Logistics General – Tax on Goods movement – India – basic settings – Maintain Cocd settings – Give first month and save

4. Attach the WHT to Vendor Master (FK02 – change; FKO1 –Create) – Select WHT; Tax type: Either payment/accrual; Select Liable and save

5. Try posting entry thru F-43 and enter the WHT. Document àSimulate

The above is the configuration for Extended WT

Regards,

Sridevi

<b>* Pls. assign points, if useful</b>