How to access quantity on hand for a given product (Sage 50 Accounting) in C#?

[Alain G.]

Hi everybody,

When I try to convert a purchase order to an invoice, I get an exception if I set a quantity for an item that exceeds the available stock on hand. To avoid this, I want to retrieve the quantity on hand of a given product before I set the invoice quantity.... but I can't seem to find any property of method for retrieving the quantity on hand! I am able to retrieve a particular product (inventory item) like this:

 

However, when I look at the different properties and methods for the InventoryLedger object I am returning, I can't find anything related to quantities. Am I looking at the wrong place? I couldn't find any information online, so any help would be appreciated.

Thanks.

[Steel, Mark]

Hi Alain, thank you for your question.

I don't believe there are members of the North American team who frequent this forum. If you don't get a response here you can send an email to [email protected].

Please let us know if you don't receive a response.

Thanks

Mark