Import BP Master(ERROR)

[Former Member]

hi

While importing the data from csv files of obusiness partners,

i observe the error (invalid accounts receivable/payable[OCRD.DebPayAcct],

how to solve it though ive used new numeric no and also existing ledger account.

[Former Member · Accepted solution]

Hi

Are you using Segmented Chart of Accounts? If Yes, then you have key in the Account Code like _SYS0000.....

Otherwise, please check the account which you are mapping in template is marked as a Control Account in COA.

Thanks

Anjan Bhowmick

[former_member708266]

Dear,

If you are using segmentation accounts, please try below:

Please open your B1 and run the following query:

SELECT T0.AcctCode FROM OACT T0 WHERE T0.AcctName ='ABC'

Note: 'ABC' should be the account name, for example 100200-000-000 in your system,

you can find it in chart of account.

You will get an account code started with '_SYS'.

Please input the account code '_SYS*******' in the DTW template instead of 100200-000-000.

Hope the information above could solve your issue.

Regards

Apple

[Former Member]

Hi Neeta,

This field is not mandatory, and will default as the account set in the General settings. Unless you need to upload different accounts for different Business Partners, I suggest you leave the column blank?

[former_member186095]

Hi,

based on SDK help file:

Debitor account is:
Sets or returns the business partner's accounts receivable/payable number (as defined in chart of accounts).

debitor account is a column to store debpayacct field of OCRD in DTW template business partner.

if you use segmented account, you fill in the column for example, _SYS00000000010.

Check if the account is ticked as control account in the COA.

Rgds,

[former_member583013]

I completely agree with Anjan's reply.

When you use an Account for AR or AP they have to be marked as Control account in the CoA window.

Please make sure this is done.

Then find AcctCode for the GL Account and use the same in your template.

Run the following SQL within SAP B1 and select your Account and you should see the relevant AcctCode

SELECT T0.AcctCode, T0.AcctName FROM [dbo].[OACT] T0 WHERE T0.AcctName = '[%0]'

[Former Member]

Neetu,

You can check you actual account codes by a simple query:

SELECT T1.AcctCode, T1.AcctName, T0.CardCode, T0.CardName FROM OCRD T0

Inner Join OACT T1 ON T1.AcctCode = T0.DebPayAcct

All of the current BP actual account codes will be displayed. You can figure out which is the code you need easily.

Thanks,

Gordon