My Products

Expose total quantity in orderline via the API

by Nichlas Søgård Nielsen
Status: New


I would like to be able to get the total quantity of items on a orderline through the API. The total quantity is available through the UI, but not the API.

An example would be, if I was purchasing 2 boxes containing 16 items each, then I would like to be able to retrieve a total quantity of 32 items.

We have a costumer who has a need for this functionality in the API. Specifically, it’s about the column “Base Order Qty” in the ‘Sales Orders window (ScreenId=SO301000) and other tables where this column is available inside the web interface.

Since the customer uses a WMS-system that only allows for singular units, the customer won't be able to use measurements, such as, Kolli and Boxes, with the current information that we can pull from the API.

Therefore, it would make good sense to expand the API with this extra information.

The column has the following element properties:

Control Type: Grid Column

Data Class: SOLine

Data Field: BaseOrderQty

View Name: Transactions

Business Logic: SOOrderEntry

Attached is a screenshot of where this column is located on the orderlines.