Power BI Connector for Sage 200

Build 24.0.9062

SalesOrders

Sales orders are used to represent the sale of goods or services to a customer. They are central to a business and define the terms (price, quantity and times) by which the products or services will be delivered. Note: Adding traceable items to sales orders. If you're using traceable stock items and an item is set to be sold from a single batch, then the order quantity must be less than or equal to quantity in the batch. If you try to order more than the quantity in the batch, the order cannot be posted via the API.

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 SalesOrders WHERE Id = 42101
SELECT * FROM SalesOrders WHERE DocumentNo = '0000000001'
SELECT * FROM SalesOrders WHERE CustomerDocumentNo = 'Sample'

Columns

Name Type References Description
Id [KEY] Long Sales order record Id.
DocumentNo String Sales order document number. Note: If the SOP setting in Sage 200c Professional or Sage 200 Extra Online is to NOT automatically generate numbers, then this property MUST be set. If the SOP setting in Sage 200 Extra is to automatically generate numbers, or you are using Sage 200c Standard (which doesn't allow you to set this option), then setting this on POST will be ignored.
DocumentDate Date Sales order document date.
DocumentStatus String Document status. See sop_document_status_types
CustomerId Long

Customers.Id

Customer record Id. See customers
ExchangeRate Decimal Exchange rate.
SubtotalGoodsValue Decimal Goods value (sum of stock items and free text).
SubtotalChargeNetValue Decimal Charge net value.
SubtotalChargeTaxValue Decimal Charge tax value.
SubtotalDiscountValue Decimal Discount value
TotalNetValue Decimal Net value (sum of all line types).
TotalTaxValue Decimal Tax value.
TotalGrossValue Decimal Gross value.
CustomerDocumentNo String Customer document number.
UseInvoiceAddress Bool True if this order uses the customer invoice address, else False.
SettlementDiscountDays Short Settlement discount days.
SettlementDiscountPercent Decimal Settlement discount percent.
DocumentDiscountPercent Decimal Document discount percent value, between -99.99 and 99.99. A negative value is treated as a surcharge (e.g. -10 is a 10% surcharge), and a positive value is treated as a discount.
DocumentCreatedBy String The person who created the SOP Order
RequestedDeliveryDate Date Requested delivery date.
PromisedDeliveryDate Date Promised delivery date.
AnalysisCode1 String Analysis code 1.
AnalysisCode2 String Analysis code 2.
AnalysisCode3 String Analysis code 3.
AnalysisCode4 String Analysis code 4.
AnalysisCode5 String Analysis code 5.
Lines String The sales order lines collection. See sop_order_lines
DeliveryAddressId Long The delivery address contact.
DeliveryAddress_1 String The delivery address line 1.
DeliveryAddress_2 String The delivery address line 2.
DeliveryAddress_3 String The delivery address line 3.
DeliveryAddress_4 String The delivery address line 4.
DeliveryAddressCity String The delivery address city.
DeliveryAddressCounty String The delivery address county.
DeliveryAddressPostcode String The delivery address postcode.
DateTimeUpdated Datetime The date and time this entity was last updated (UTC).

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062