StockSettings
These settings to define how to process and manage your stock.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process all search criteria.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM StockSettings WHERE Id = 1 SELECT * FROM StockSettings WHERE UseMultipleLocations = true SELECT * FROM StockSettings WHERE ProfitPercentOfRevenue = true SELECT * FROM StockSettings WHERE DateTimeUpdated = '2018-02-28T15:23:45.543+01:00'
Columns
| Name | Type | References | Description |
| Id [KEY] | Long | Stock setting unique Id. | |
| UseMultipleLocations | Bool | When true this setting allows Sage 200 to track stock at different locations. This can be across several warehouses, or a single warehouse split into separate areas (bins). (Sage 200c Standard value is true and cannot be changed). | |
| ProfitPercentOfRevenue | Bool | Profit can be calculated as a percentage of revenue (true), or as a percentage of cost (false). | |
| DateTimeUpdated | Datetime | The date and time this entity was last updated (UTC). |