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

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.

[Getting different errors when trying to create a new order (Sage 50 Accounting)]

I just realized that I used the name of a Customer rather than a Vendor, which is why I was getting these errors. No need to reply.

[Getting different errors when trying to create a new order (Sage 50 Accounting)]

Hi everybody,

I am new to Sage. I am a C# developer trying to build a software for my boss. I am using Sage 50 Pro Accounting (Canadian) 2022, and I am currently on the trial version.

I followed the example that comes with the SDK for creating a new order:

 

When I get to the part where I need to set the OrderQuoteNum property, I get the error message: "The order/quote number field is disabled or it is hidden because the company data does not have order/quote feature turned on." I searched in the different settings, and from what I could find (see below image), every feature seems to be turned on:

 

 

I tried commenting out this line in my code, to see if I could create an order without it, but I get another error when I get to the purJournal.SetOrdered(50, 1) line. The error is: "The field you are trying to change or function you are calling is not accessible under current circumstance."

Finally, when I comment out that line in the code too, I make it to purJourn.Post() line, but I then get the following error message: "The Invoice number is undefined.  Enter the Invoice number." I don't understand why I am getting this error, since I am not creating an Invoice but a PurchaseOrder.

I couldn't really find help online for these different errors. I would appreciate any help I can get.

Thanks :)