cancel
Showing results for 
Search instead for 
Did you mean: 

Tax Account is missing While doing AP Credit Memo

Former Member
0 Kudos

Dear Experts,

I want to do AP Credit Memo Base on AP Invoice.

but here below error is coming,

"Tax Account is missing"

I have Attached Following Account ,

In GL Account Determination ,ItemGroups-Setup & Warehouse-Setup ->

Purchase Credit Account (System Account Name)->Purchase Reversal (My Account Name)

Please help me to understand GL Account Determination..

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Have you checked my first reply? Please advise your SAP version and PL.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

@ Nagarajan: Yes sir i am using that book..

My SAP Version is SAP B1 8.8 PL 10 ..

@Ardie:Posing Period 2012-13 i have created but how can set it as default to system.?

One thing i have to mention here is I have not set even one Account of Sale..

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please make sure you already defined tax account under Tax Group--Setup for above tax code.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Sir can u Please Elaborate....???

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

For example, you have created new tax code under tax code setup window without tax account, then above error message will appear.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Sir i am using SAP Version 8.8 PL 10 Tax Group option is not display in my

system i seen

Administrator->setup->finance->tax

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Are you super user?

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hello sir,

Yes sir i am  Login with Manager user id

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Do you have team viewer?

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

yes sir i have..

can you access my PC Form team Viewer is it possible???

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please send your ID.

Former Member
0 Kudos

Thank you sir,

My User Id is

825 237 900

Password is

4612

i have TeamViewer Version 8

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Is this test DB or live DB?

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Connection disconnected. Don't worry will check it by tonight in my test DB. If not tomorrow we will check again.

In short, if you select tax liable --->No then there is no problem. But when yes, we need to set tax account.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Sorry sir My net was down..

ok. but till here i am on right way??

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Yes.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hello Sir.

have u checked it my Problem??

it is still not solve today also..

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

I need to access your system again.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hello Sir.

r u their???

when u will get time please inform me or tell me a time when want to access my PC..

or can you please share your email with me i will ping you..

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Can i check now?

Former Member
0 Kudos

Hi Sir Problem is Solve..

I reset all Accounts In New Data Base & Did new entry it works!!

I Checked,

ItemGroup Account,Warehouse Account,GL Accounts->Purchse Tab.

& for Tax i Check very carefully

Administration->Setup->Financials->Tax->Tax Type.

but it is because of you only i got a way

Thanks a lot!!

But My Request is U Take My PC Access & Check it once Please..

Thank you!!

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

That is great. Your problem solved. Still i need to check? I think no need to check....carry on all test in test DB.

All the best.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Yes sir Thak you very much for taking effort for me!!

Thanks a lot..

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi santosh,

Try this

Please Enable GL account in form settings for CreditMemo.If no GL account appears.Pls assign Gl  account and Post the document.

Hope helpful.

Former Member
0 Kudos

Hello Devraj,

I have click GL Account in Form setting of AP Credit Memo,

But still not solve. Please tell m doing in correct way..

Former Member
0 Kudos

Hi Santosh,

In Credit Memo Row level you will find the GL account.Please assign GL account and Try to add document.

Former Member
0 Kudos

it is already Link Devraj..

i link it in Asset Account..

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

To understand GL account determination, please refer below guide,

http://www.pioneerb1.com/wp-content/uploads/2012/03/Understanding-GL-Determinations-in-SAP-Business-...

Hope helpful.

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hello Experts,

Thank you for Replays..

@ Raviraj : I have already set Purchase Credit Account.

@ Ardie : I set Rounding Account also..

I have set "Set GL Account By" in Inventory Data tab in Item Master Data to Warehouse..

Please help me to find what i am missing here???

Former Member
0 Kudos

Go to admin>setup>inventory>warehouse>find the warehouse>accounting tab>set GL for Purchase Credit Account and purchase credit account foreign.

Former Member
0 Kudos

Hello ARDIE,

Thank you for helping me..

i have set Purchase Credit Acc But  2nd Purchase Credit Acc Foreign is not displaying here..

menace that account not present list..

I am using SAP B1 8.8 PL 10..

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Please let us know the exact error. May be error screenshot.

Also, can you check the freight setup if freight is involved in the document. The Tax code applicable to freight can be checked.

Kind Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

Hello Sir,

I am posting Screen shot of AP/Invoice & AP/Credit Memo,

I have not include any Freight in Document..

I have added screen shot of Tax Code Setup also in that Purchasing Account are added.

if u want more clarification please let me know.

Former Member
0 Kudos

Hello Jitin sir,

I am posting Item Master Data,Item Group & Warehouse Account Setting which i have done in sample database.Please tell me where i am wrong??

i am sending this for Clarification of my problem.

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Make a copy of the database in test enviornment and check whether by assigning accounts to Freight (although not involved in affected documents) helps.

If not, check by accounts defined for the Tax Code, whether everything is fine. Check for Add-ons (stopping the add-on) and also commenting any additional code in Sp_transactionNotification.

Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

can you post also you gl account determination under general tab

Former Member
0 Kudos

Hello Ardie,

I am posting screen shot of GL account Please Check it..

still i am not getting Problem what i am missing here..

Please do need full..

Thank you for Helping me..

Former Member
0 Kudos

Can you check also the 2012-13 period selection?

Former Member
0 Kudos

Hi

Check following G/L

Incoming CENVAT Clearing Acct in warehouse

Acct map in Tax code used in AP Invoice

Acct map in Tax code for freight code used in AP Invoice

Purchase Credit Account  (for respective Financial period in G/l Determination)

Capital Goods On Hold Account (for respective Financial period in G/l Determination)

regards,

Raviraj

Former Member
0 Kudos

Hello Raviraj,

Thank you for replay.

Can you please check above posted Screen shots.i have putted All Screen Shots above.

i.e Warehouse Acc,Item Group Acc,GL Acc Determination & Tax Code Account also..

Former Member
0 Kudos

Try to isolate the issue by restoring a backup database then try to add stand alone credit memo. This is to check if you have the same issue for APCM. You may try to add another AP then repeat the procedure. Also check if you have stored procedure that has an update function.

Former Member
0 Kudos

Hi Check whether you have mapped 'Purchase Credit Account' in

Administration---Setup---Financials---G/L Account Determination----Purchasing tab---General tab---'Purchase Credit Account'

regards,

Raviraj

Former Member
0 Kudos

If you are really sure that your tax account for VAT has a GL account assigned, then try to put GL account to your rounding account under general tab of GL account determination. Sometimes, DTW throws misleading error message.

Former Member
0 Kudos

Hi Santosh,

Please check the account setting of tax which you used in transaction.If you used tax code for an item, check the purchase account is set or not. It is must for account entry.

Regards

Manoj

Former Member
0 Kudos

Hello sir,

I have checked it sir,

for conformation i click on goldon arrow on taxcode in row level,

their Purchasing Tax Account is set for all tax codes i have used still geting error.

help me for this.