Remove data from UDFs using B1iF

[Former Member]

Hi

I have a scenario where there is a UDF called Date Left on
the BP master.  There are two databases.  One is the master and the
other subsidiary.

User creates BP master and it replicates to subsidiary
database.

When the BP leaves the business they enter the date they
left in the UDF.  This replicates to the subsidiary db.

Now sometimes the BP may come back and do more
business.  The user then deletes the value in the Date Left UDF in the master database.  The date field has no value now.

However this does not synch to the subsidiary.  The
subsidiary db still has the date in the field.

Has anyone faced this issue with B1iF?

Does anyone know how to clear values in a UDF using B1iF?

I am using SAP B1 Version 9 Patch 9 HF1.

Any help would be much appreciated.

Thank you

Regards

Ashvin

[former_member203816 · Accepted solution]

Hi Ashvin,

Means you are saying that whenever user update the BP in master database then also update the same in subsidiary database. IF you you setup teh same then have you mapped that UDF in scenario ?

Thanks,

Tushar

[Former Member · Accepted solution]

Hi Tushar

Yes both the databases have the same UDFs with the same name.  The UDF is also in the scenario package.

The issue is specific to Date Type UDFs... alpha numeric UDFs get cleared without any issues.

If you remove the date in the Date UDF, it does not do the same in the other database.

Regards

Ashvin

[bastian_schaefer · Accepted solution]

Hi Ashvin,

B1 call atom method UpdateWithSubDeletion clears values of fields - including UDF values - which are not explicitly mapped and not part of the B1 object call payload.

This could have ugly side effects, if a field has been overseen in your mapping.

If you decide to use UpdateWithSubDeletion, please test very carefully for these unexpected side-effects.

Best regards

Bastian

[Former Member · Accepted solution]

Thank you Bastian

I got it working with UpdateWithSubDeletion.

Regards

Ashvin