Control account Issue - BP

[Former Member]

Hi Friends,

The client has two control accounts for Accounts Payable

1- 2101 - Accounts Payable USD

2- 2102 - Accounts Payable Trade Foreign ( Multi Currency)

One of the BP has control account for Accounts Payable set to 2102

Whenever a posting is made its going to 2101 instead ( Currency is in USD)

Question:

- What could be the reason for above?

-How to clear the balance in 2101 ?

Thanks

[Former Member]

Hello,

First of all you cannot have two control accounts for one BP in any version of SAP B1 prior to 8.8 which allows you to change the control account at entry level.

In G/L determination window under purchasing tab you should see two control accounts one for domestic and one for foreign. The system will default the domestic control account for all suppliers who have the same country as your defined in your company set up. If your supplier's country is a different one in the business partner master data than the one defined for your company then it will always default the foreign control account.

It is important to note that you cannot change this control for a specific BP for different documents. If you put in a document with a local currency and another one with another foreign currency it will always post to one control account. You need to change the country in the address tab in the BP master data to change to the foreign control account.

Hope this helped.

Regards,

Fraz

[Former Member]

Hi Faraz,

I think you are incorrect.

In my case the BP is in different country and still it was posting to the Domestic AP control account by default which i found is the same as mentioned in the Asset Account control account in BP master.

And secondly every BP can have different control accounts but for different purposes like AP Payable or Asset Account or Open debts or Bills of Exchange etc.

As far as currency is concerned, just make BP as ALL Currency and you can post in any currency irrespective of country address.

Thanks to all.

Edited by: SAPFICO on Sep 20, 2011 12:45 PM

[jitin_chawla]

Hi,

I think i know the issue. It usually happens when duplicating the document with a different BP Code.

Check the following query and see whether you get any result :

select T0.transid, T0.CardCode, T0.DocEntry, T0.DocNum, T0.DocDate,T0.CtlAccount, T1.Account, 
(select debpayacct from ocrd where ocrd.cardcode = T0.CardCode) as 'BP Control Account', 
case when (select count('A') from acrd where acrd.cardcode = T0.CardCode and acrd.DebPayAcct != 
T0.CtlAccount) > 0 then 'Y' else 'N' end Changed 
from oinv T0 inner join jdt1 t1 on T0.TransId = T1.TransID and T0.CtlAccount != T1.Account 
and T0.CardCode = T1.ShortName 
order by docentry asc 

Also, please check Note No. : [1463211|https://b1-support.wdf.sap.corp/sap/support/notes/1463211]

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Hi.......

Which Version and Patch Level of SAP do you have because from SAP 8.8 there is a provision where you can change the Control Account of BP manually on transaction level.......

Please check on Accounting Tab of Invoice before add the Invoice document .....

Also same you can do in Payment windows exactly at the bottom.......

Regards,

Rahul

[Former Member]

Hi,

The version is 2007 SP:01 , PL:11

My issue is not changing it manually at entry level. The concept of control account is to let it post automatically to the control account.

The issue is to find the reason why its not posting to the control account mentioned in BP master.

And also.. how to clear the balance in wrong control account. Can we pass a JV and transfer it to correct BP ( I understand its not possible since there are control accounts)

Thanks

[Former Member]

Ok.........

Please go to BP Master and check in Accounting Tab which Control Account is Mapped and also under Control Account Button you find it in BP Master data form. You have to map there nothing.

For the JV it seems impossible as you can not take Control account directly into journal transaction. But for the sake of testing try clearing complete balance of any BO and then check with Trial Balance whether it is going NIL from incorrect Control Acct or not........

Do it in Test DB first....

Regards,

Rahul

[Former Member]

Hi Rahul,

In the BP master.. Accounting tab. the Accounts payable control account is 2102... whereas upon clicking the control account button i found that 2101 is mentioned against Asset Account..

Has it got to do anything with the posting being done in 2101 instead of 2102.. if yes what is the purpose of this Asset Account and what does it do

Thanks

[Former Member]

Hi.....

Try changing it to correct control account and then check....

Do it in Test DB.....

Regards,

Rahul

[Former Member]

Hi Rahul,

I'm in Test DB.

I created a new BP and instead of copying i put all inputs manually.

I did not put anything in the Asset Account Control pop up window. Its not letting me pass any AP Invoice entry.

what is the purpose of this asset account control account ?

I would like to pass an entry and see the effect

Thanks

[Former Member]

Hi........

have you not even mapped Control Account Payable for Sundry Creditors. It is important.

And Assets account is necessary when you do transactions related to Fixed Assets........

Map this Account Payable just below the Control Account for assets.....

For more details please check this thread......

Regards,

Rahul

[Former Member]

Hi Rahul,

I got the solution.

Yes the BP in question has the setting done for Accounts Payable control account and also for Assets Account.

The fact is the item in the AP Invoice is a Fixed Asset in which case while AP Invoice posting the entry is posted to 2101 as mentioned in the Asset Account control account instead of 2102 as mentioned in Accounts Payable control field.

Thanks

[Former Member]

Great!!!!!!!!