Quantity On Hand through Ipaas

I have a client using multi-location inventory and are attempting to pull inventory quantities through SalesForce CRM connector with the connector currently set up it only shows the quantity on hand for one of the many locations

Can anyone shed light on this

Beginner Asked on July 7, 2023 in Inventory.
Add Comment
1 Answer(s)

Hi,

You can use below query for location wise stock

 

SELECT nvl( to_char(sum(inventoryBalance.quantityonhand)), ‘null’ ) FROM inventoryBalance  WHERE  inventoryBalance.item = T17.id and location=27

Thanks

BP Sharma

Rookie Answered on December 22, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor