Skip to content
+1-888-319-3663

COMMUNITY FORUM

Updating Item Site Default Bins when integrating with eConnect

Mike asked 3 years ago
Is there an eConnect node capable of integrating Item Site Default Bins into eConnect? The specific table is IV00102. The Item Sites node is very limited as to what you can update. I suspect that is Microsoft’s way of protecting against users inadvertently importing incorrect quantities into GP, but I have over 850 items that need to be updated with default bins, and it would take FAR less time to let SmartConnect do it than to have a user do it manually, one at a time.
Thanks!
Mike replied 3 years ago

Can anyone assist with this?

I’m trying, through SmartConnect, to update default bins for specific items.

I need to simulate the process of updating them manually by opening Cards –> Quantities/Sites and then clicking the Bin button to open the Item Sites Default Bins screen and entering bin numbers in the Purchase Receipts, Purchase Returns, Sales Order Fulfillment, etc. fields

I’m not wanting to assign items to sites or bins, just wanting to set the default bins for a specific site item.

Please and thank you.

Answers
Patrick Roth Staff answered 3 years ago
For clarification “sites” and “bins” are different things in GP. The IV00102 contains “sites” (Location Code) and is stored Location/Site Master table.  To assign an inventory item to a location/site – then use the “assign item to site”.  This will create the IV00102 record.
For QTY’s you want to create an inventory increase adjustment – the same way you would in GP – for the beginning qtys.  THis is the Inventory Transactoins node in smartconnect/econnect.
Mike replied 3 years ago

Thanks for your reply, Patrick. To be more clear, I’m not actually trying to adjust any of the Item Quantity counts. I’m trying to adjust the default bins assigned to an item for a specific site.

If I were updating them manually, it would be through Cards –> Quantities/Sites. I would then select a specific site, click the Bin button to open the Item Sites Default Bins screen and enter bin numbers in the Purchase Receipts, Purchase Returns, Sales Order Fulfillment, etc. fields.

Patrick Roth Staff replied 3 years ago

ok, I see. You weren’t thinking of updating the QTYs themselves, just the default sites per item/location code.

No, I don’t see that there is an econnect destination for this:
https://www.eonesolutions.com/tech-tuesday-what-data-can-smartconnect-integrate-in-dynamics-gp/

The only workaround that I see is that you could go direct to table to the IV00102 – but make sure that you don’t import invalid data into those fields.

Mike replied 3 years ago

Gotcha. I will try a SQL Table destination in our test company first. If that works as expected, I’ll run the same map to import into our live company.

Mike replied 3 years ago

Thanks for your response and suggestions!


If you would like to submit an answer or comment, please sign in to the eOne portal.