DTW Error when trying to Update the BP

[Former Member]

Dear All,

when i trying to Update My all BP's in a one shot through DTW ity give me an error--

Deleting Rows not supported for object FISCAL ID for BP master data Application-defined OR object-defined.....

only some field i wanna update here--

1) BP Bank whose call default bank

2) House Bank for all BP

wait for ur valuable comment.

thanks

RAJPUT

[Former Member · Accepted solution]

Rajput,

Does bank code 'hdfc26' exist in your system?

Regards,

Nat

[Former Member · Accepted solution]

Hi Natalia,

yes i already make HDFC26 in my house bank and payment method name also hdfc26

thanks

RAJPUT

[Former Member · Accepted solution]

Hi,

You said you do the two imports at the same time - can you please try to update the bank and house bank separately in two runs, so that you can identify which template causes the problem. It might be one of them is OK so it's easier to look into the other only.

Regards,

Nat

[Former Member · Accepted solution]

Hi Natalia,

yes your advice si very important for me

now the house bank template giving me an error.

Thanks,

RAJPUT

[Former Member · Accepted solution]

Hi Rajput,

The next step should be to make sure the problem is with updating the House Bank details. Please make sure that in the template you have values only in the following columns:

CardCode

HouseBank

HouseBankCountry

HouseBankAccount

So leave empty all the other columns. Try the update again, do you have the same error?

Regards,

Nat

[Former Member · Accepted solution]

Hi Natalia,

when i run this template on only 4 field it give me an error cardtype is must be cCustomer or cSupplier

when i take card type it give me an error groupcode must be numerical value

Thanks,

RAJPUT

[Former Member · Accepted solution]

Rajput,

From this error it seems that the BP doesn't exist yet. You said you are updating existing records, is this the case?

Regards,

Nat

[Former Member · Accepted solution]

Hi Natalia,

customer alredy exist ....

when first template run succsefully

error coming only in second template.

Thanks,

RAJPUT

[Former Member · Accepted solution]

Hi,

What do you mean by first template? If the BP's are already in the system you don't need any other template but this one to update existing records.

Can you confirm what type of import (add new or update existing) you are running and also what templates you are using?

Regards,

Nat

[Former Member · Accepted solution]

Hi Natalia,

I am using two templates in one time

1) OCRD

2) OCRB

and in dtw i m using UPDATE in master data.

thanks,

RAJPUT

[Former Member · Accepted solution]

Hi,

Run it with OCRD only. Any errors?

Regards,

Nat

[Former Member · Accepted solution]

Hi,

This error will happens in the following cases.

1. Trying to update BP Type (customer to Supplier and vice versa)

2. Trying to update the Account Receivable and Payables.

3. Different account mapping in GL Determination and different account in DTW Template.

[Former Member · Accepted solution]

Hi Nat,

same error. Boss....

nothing delete in the template but same error r coming..

thanks,

RAJPUT

[Former Member · Accepted solution]

Hi Jitendra........

Everything is linked with Financial Postin Period.

While running DTW for any of the template please check whether system date is within your Posting period or not.

because the GL account determination is as per the Financial Posting period if you see in GL Account Determination on the top of the window there is a dropdown box for Period......

So please check whether you have current posting period or not.....

Regards,

Rahul

[Former Member]

Hello Jitendra,

can you post one line which you want to import ?

so i will help you .

Thanks

Manvendra Singh Niranjan

[Former Member]

hi Manvendra,

for default BP bank

ParentKey LineNum AccountNo BPCode BankCode Branch City Country

CardCode LineNum AccountNo BPCode BankCode Branch City Country

e4161 0 123456 e4161 hdfc26 gk-1 delhi IN

CardCode CardName CardType GroupCode PayTermsGrpCode PeymentMethodCode HouseBank HouseBankCountry HouseBankAccount

CardCode CardName CardType GroupCode GroupNum PymCode HouseBank HousBnkCry HousBnkAct

e4161 Jitendr kumar cSupplier 102 -1 hdfc26 hdfc26 IN 3.31E+11

thnks,

RAJPUT

[Former Member]

HI

I think you are using 'Brazil' Localisation....

If so,Have you specified any fiscal id in that template and make sure it wasnt linked to any other documents....

[Former Member]

hi Kambadsan,

I localization is india and i not found any FD add-on here in my cmpny. any one provide me this FD add-on.

thanks,

RAJPUT

[Former Member]

HI Rajput,

The fiscal id (Only For Brazil Localisation) is present in BP master data->Accounting->Tax...

but i wondering why its asking for indian localisation