Update Branch Assignment in Business Partner Master Data through DTW

[Former Member]

Hi Expert,

I tried to update CRD8 (BP branch assignment) table through DTW.

Currently all branches are assigned and I would like to unassigned certain branches.

OCRD

CardCode

CardCode

JB3100/A02

CRD8

ParentKey	LineNum	BPCode	BPLID
CardCode	LineNum	CardCode	BPLId
JB3100/A02	0	JB3100/A02	4

However, I have the error : This Entry Already Exist.

Is anyone has an example on how to "uncheck" certain branch through DTW ?

Thank you !

Regards,

Clara

[ANKIT_CHAUHAN]

Hi,

For importing BP Branch Assignment via DTW, please find below the key points:

1. "CRD8 -BPBranchAssignment" template can be created via DTW. Go to Templates → Customize Template → Select BusinessPartners object → right click on BPBranchAssignment → Create Template for the Structure.
2. If you are adding a new Business Partner without CRD8 template, then all active branches will be assigned to the Business Partner.
3. When updating BPBranchAssignment, LineNum is necessary. The value should be an integer which begins with 0.
4. It is not possible to delete records using DTW, only importing new records or updating existing ones are supported. It means, if the BP already exists in database and all branches are checked, then it is not possible to delete(uncheck) branch by updating BP via DTW.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[narayanis]

Hi,

If all branches are checked then it is not possible to unassign the branches for a BP through DTW. This can the nbe achieved only by SDK.

Regards

[Former Member]

Hi Clara,

Did you find a solution to your question?

Regards,

Kiran

[Former Member]

Hi Kiran,

I haven't get any solution on DTW.

I have manually unassigned the branch in BP Master Data.

Do share your view if you have found the solution.

Thanks !

Regards,

Clara