B1If: how to delete the item warehouse by call B1 Object

[Former Member]

Hi,

I wants to delete the item warehouse. try to using the 'Object Identifier' 4 - Items, but it doesn't work.

Could you please give any ideas?

Thank you.

[szymon_lipnicki3]

Hi,

Simple update will not work. You need to set updateWithSubDeletion as a method in call B1 Object atom configuration.

Kind Regards,

Szymon

[former_member192773]

Hi Simon,

You're correct my mistake. use: updateWithSubDeletion

Kind Regards Teun

[Former Member]

Hi Teun,

Still got the same error message:

After read the documentation, found

Can this method remove the row of item warehouse info?

Xiexie

[szymon_lipnicki3]

Hi,

B1 Call atom setting must looks like on Teun's screenshot.

KeyName - ItemCode

KeyValue - if you use variables then try $string(ItemCode)

Kind Regards,

Szymon

[Former Member]

Hello Szymon,

Yes, as per Teun's advices,  On the B1If Processing Diagram, I created two Cal B1 Object atoms,

First is 'Retrieval', same as Teun's scrrenshot, and this atoms can sucessful return ITEM's result.

Second is 'updateWithSubDeletion', for the 'KeyName' and 'KeyValue', I have already tried to set ItemCode and $ItemCode / Warehouse and $WarehouseCode.

Please see my attached images,

Thanks for your reply.

Cheers

Simon

[former_member192773]

Hello Simon,

In the atom between the retrieval and updatewithSubDeletion (or add an extra atom), you must delete the (specific) warehouses.

Best regards Teun

[Former Member]

Hello Teun,

Does need to add a atom for 'Call SQL' or 'Call B1 Object' to between the Retrieval and 'updateWithSubDeletion'?

Xiexie

[former_member192773]

Hello Simon,

Use XSL Transformation, in this atom you can use xslt for remove the specific warehouse tags.
You must use the result of the retrieve for input. Copy everything but not the specific warehouse. and use new generated output for input DeleteWithsubdeletion.

Regards Teun

[Former Member]

Hi Teun,

Although stll cannot delete, prompt same error, but I feel seems to be approaching the end.

This is my processing diagram

please help to have a look why still give same error information same with the above picture,  thank you very much.

[former_member192773]

Hi Simon,

I assume object 4 (Item) is the correct one.

You should test it.

First flow: t get the item (import/export mode)

- edit the xml manually (remove one warehouse) and put it into the second flows

second flow: update the item (you should set the Key Name and value correctly.

This is the easiest why for checking this by yourself.

Kind Regards Teun

[Former Member]

Hi Teun,

Can you please post a simple B1if processing? Especially in the first flow (I'm not clear with the import/export item),   accourding to your and Szymon's tips, but still cannot implemented, thank you very much.

[former_member192773]

Hello Simon,

See example and check SDK/ DI-API help.

HTH

Regards Teun

[Former Member]

Hello Simon,

In my opinion you can't delete the warehouse by the object 4. you must call the object 64.

Best Regards

Ronny