SORQRY: SO Sales Order Query
The SO Sales Order Query business object lets you query a sales order number or a specific sales order / invoice number combination and returns sales order header and detail line information. Archived sales orders can't be queried.
Properties
| Syspro Module | Sales Orders |
| Class | Query |
| Methods | Query |
| Functional Area | Sales Orders Primary Query |
| Initial version released | Syspro 6.1 |
Input XML
The .XML and .XSD input files indicate the parameters schema and an instance of an XML document for this business object.
SORQRY.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2023 SYSPRO Ltd.-->
<!--
This is an example XML instance to demonstrate
use of the Sales Order Query Business Object
-->
<Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="SORQRY.XSD">
<Key>
<SalesOrder>000812</SalesOrder>
<Invoice></Invoice>
</Key>
<Option>
<IncludeStockedLines>Y</IncludeStockedLines>
<IncludeNonStockedLines>Y</IncludeNonStockedLines>
<IncludeFreightLines>Y</IncludeFreightLines>
<IncludeMiscLines>Y</IncludeMiscLines>
<IncludeCommentLines>Y</IncludeCommentLines>
<IncludeCompletedLines>Y</IncludeCompletedLines>
<IncludeSerials>N</IncludeSerials>
<IncludeLots>Y</IncludeLots>
<IncludeBins>Y</IncludeBins>
<IncludeAttachedItems>N</IncludeAttachedItems>
<IncludeCustomForms>Y</IncludeCustomForms>
<IncludeDetailLineCustomForms>Y</IncludeDetailLineCustomForms>
<IncludeValues>N</IncludeValues>
<ReturnLineShipDate>N</ReturnLineShipDate>
<IncludeKitComponents>Y</IncludeKitComponents>
<IncludeNotes>Y</IncludeNotes>
<IncludePickingDetails>N</IncludePickingDetails>
<ReturnNotesinBlock>N</ReturnNotesinBlock>
<XslStylesheet/>
</Option>
</Query>Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2023 SYSPRO Ltd.-->
<!--
Schema for the Sales Order Query Business Object
-->
<xsd:schema elementFormDefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="IncludeBins" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include multiple bin lines (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeCommentLines" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include comment lines (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeCompletedLines" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include completed lines (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeFreightLines" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include freight lines (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeLots" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include lots (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeMiscLines" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include miscellaneous charge lines (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeNonStockedLines" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include lines containing non-stocked items (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeStockedLines" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include lines containing stocked items (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeAttachedItems" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to return attached items (Y - Yes, N - No). Default = N. If Yes, this will return the Job, Purchase order,Supply chain transfer or Requisition that has been created against the line. </xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeSerials" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include serial numbers (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Key">
<xsd:annotation>
<xsd:documentation>The key to use for this query.</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:all>
<xsd:element ref="SalesOrder"/>
<xsd:element ref="Invoice"/>
</xsd:all>
</xsd:complexType>
</xsd:element>
<xsd:element name="Option">
<xsd:annotation>
<xsd:documentation>The list of options.</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:all>
<xsd:element ref="IncludeStockedLines" minOccurs="0"/>
<xsd:element ref="IncludeNonStockedLines" minOccurs="0"/>
<xsd:element ref="IncludeFreightLines" minOccurs="0"/>
<xsd:element ref="IncludeMiscLines" minOccurs="0"/>
<xsd:element ref="IncludeCommentLines" minOccurs="0"/>
<xsd:element ref="IncludeCompletedLines" minOccurs="0"/>
<xsd:element ref="IncludeSerials" minOccurs="0"/>
<xsd:element ref="IncludeLots" minOccurs="0"/>
<xsd:element ref="IncludeBins" minOccurs="0"/>
<xsd:element ref="IncludeAttachedItems" minOccurs="0"/>
<xsd:element ref="IncludeCustomForms" minOccurs="0"/>
<xsd:element ref="ReturnLineShipDate" minOccurs="0"/>
<xsd:element ref="XslStylesheet" minOccurs="0"/>
<xsd:element ref="IncludeDetailLineCustomForms" minOccurs="0"/>
<xsd:element ref="IncludeValues" minOccurs="0"/>
<xsd:element ref="IncludeKitComponents" minOccurs="0"/>
<xsd:element ref="IncludePickingDetails" minOccurs="0"/>
<xsd:element name="IncludeNotes" default="Y" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Indicates whether notes should be returned. (N - No and Y - Yes). If no value is supplied then a default value of 'Y' will be used. </xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ReturnNotesinBlock" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Indicates whether notes should be returned combined in a block. (N - No and Y - Yes). If no value is supplied then a default value of 'N' will be used. </xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:all>
</xsd:complexType>
</xsd:element>
<xsd:element name="Query">
<xsd:annotation>
<xsd:documentation>The root element.</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="Key"/>
<xsd:element ref="Option" minOccurs="0"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="ReturnLineShipDate" default="Y">
<xsd:annotation>
<xsd:documentation>Option to return Line Ship Date regardless of Order Type. (Y - Yes, N - No)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SalesOrder">
<xsd:annotation>
<xsd:documentation>Enter the sales order number to be queried</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="XslStylesheet">
<xsd:annotation>
<xsd:documentation>Enter the name of the XSL Stylesheet to use</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Invoice">
<xsd:annotation>
<xsd:documentation>Enter the A/R invoice number, if the sales order to be queried has already been invoiced.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeCustomForms" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include custom forms (Y - Yes, N - No). Default = N. If Y - Yes, custom form fields and values defined against the sales order are returned. </xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeDetailLineCustomForms" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include custom forms for detail lines (Y - Yes, N - No). Default = N. If Y - Yes, custom form fields and values defined against the sales order detail line are returned. </xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N"/>
<xsd:enumeration value="Y"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeValues">
<xsd:annotation>
<xsd:documentation>This element indicates whether or not you want all order and line values to be returned. Valid values are 'N' (default) and 'Y'.
Please note that values will only be returned if querying the primary order. MDN and reprint files are not catered for.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="IncludeKitComponents">
<xsd:annotation>
<xsd:documentation>Do you wish to return kit component lines (Y - Yes, N - No). Default = Y.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludePickingDetails" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to display picking details for lines released to picking (Y - Yes, N - No). Default = N</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Y"/>
<xsd:enumeration value="N"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:schema>
-
If the operator is denied access to the branch against the sales order and the option to filter reports and browses is selected (Setup | Security | Operators | Security | A/R Branches), the query cannot be performed.
-
If a salesperson code (with access control applied) has been defined against the operator and the option to filter reports and browses is selected (Setup | Security | Operators | Security | Salesperson), the query cannot be performed if the salesperson defined against the operator does not match the salesperson defined against the sales order.
-
The query cannot be performed if the customer against the sales order is not on the list of customers that may be accessed by the operator or the salesperson attached to the sales order is not the specific salesperson to which the operator is allowed access (Setup | Security | Operators | e.net | Customers).
-
Serial allocations cannot be returned if the serial tracking system is not required (Setup | Distribution Setup | Inventory | Options tab).
-
Bin allocations cannot be returned if multiple bins are not installed (Setup | Distribution Setup | Inventory | General tab).
-
An error will be returned if the sales order information cannot be returned for the entered invoice because it has been purged from the invoice reprint file/table.
-
Refer to SORQRY.XSD and SORQRY.XML for the schema and an instance of an XML document for this business object.
Output XML
The OUT.XML indicates a sample of the XML returned by this business object.
SORQRYOUT.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2023 SYSPRO Ltd.-->
<!--
This is an example XMLOut instance to demonstrate
use of the Sales Query Business Object
-->
<SorDetail xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="SORQRYout.XSD">
<SystemInformation>
<CssStyle/>
<Language>EN</Language>
<DecFormat>1</DecFormat>
<DateFormat>01</DateFormat>
<Role>01</Role>
<Version>7.0.034</Version>
<CompanyId>2</CompanyId>
<CompanyName>Demo for Mohammed</CompanyName>
<OperatorCode>MM</OperatorCode>
<OperatorName>MEspresso</OperatorName>
<OperatorGroup>ADMIN</OperatorGroup>
<OperatorEmailAddress/>
<OperatorLocation/>
<LocalCurrency>$</LocalCurrency>
<LocalCurrencyDesc>Local Currency</LocalCurrencyDesc>
<GlPrdPerYear>12</GlPrdPerYear>
<ReportDate>19/06/2014 12:05</ReportDate>
<UseSeparatorOnReports>N</UseSeparatorOnReports>
<SeparatorToUse>,</SeparatorToUse>
<OperatorPrimaryRole/>
</SystemInformation>
<SalesOrder>000812</SalesOrder>
<DocumentType>B</DocumentType>
<DocumentTypeDesc>Billing</DocumentTypeDesc>
<InterBranchTransfer/>
<InterWhSale/>
<SourceWarehouse/>
<TargetWarehouse/>
<GtrReference/>
<Customer>0000011</Customer>
<CustomerName>Maniac Sports - South</CustomerName>
<TaxStatusCode>E</TaxStatusCode>
<TaxStatus>Exempt from tax</TaxStatus>
<GSTTaxStatusCode>E</GSTTaxStatusCode>
<GSTTaxStatus>Exempt from tax</GSTTaxStatus>
<EUFlag>N</EUFlag>
<EUFlagDesc>EU</EUFlagDesc>
<SoldToName>Maniac Sports - South</SoldToName>
<SoldAddr1>P O Box 666</SoldAddr1>
<SoldAddr2>Southville</SoldAddr2>
<SoldAddr3>Montgomery</SoldAddr3>
<SoldAddr3Locality/>
<SoldAddr4>AL</SoldAddr4>
<SoldAddr5>USA</SoldAddr5>
<SoldPostalCode>36101</SoldPostalCode>
<SoldGpsLat>0.000000</SoldGpsLat>
<SoldGpsLong>0.000000</SoldGpsLong>
<DiscPct1>0.00</DiscPct1>
<DiscPct2>0.00</DiscPct2>
<DiscPct3>0.00</DiscPct3>
<Salesperson>201</Salesperson>
<ScheduledOrdFlag/>
<Commissions>
<Salesperson>201</Salesperson>
<CommissionSales1>0.00</CommissionSales1>
<Salesperson2/>
<CommissionSales2>0.00</CommissionSales2>
<Salesperson3/>
<CommissionSales3>0.00</CommissionSales3>
<Salesperson4/>
<CommissionSales4>0.00</CommissionSales4>
</Commissions>
<SALSLS_Name>Victor Patterson</SALSLS_Name>
<OrderStatus>9</OrderStatus>
<OrderStatusDesc>Complete</OrderStatusDesc>
<CustomerPoNumber>South 241</CustomerPoNumber>
<OrderDate>17/03/2008</OrderDate>
<GITReference/>
<ReqShipDate>17/03/2008</ReqShipDate>
<ShippingInstrs>Louise.Bright@maniacsports.com</ShippingInstrs>
<SpecialInstrs/>
<InvTermsOverride>1</InvTermsOverride>
<DeliveryNote/>
<LastDelNote/>
<TimeDelPrtedHh>00</TimeDelPrtedHh>
<TimeDelPrtedMm>00</TimeDelPrtedMm>
<LastInvoice>100482</LastInvoice>
<DateLastInvPrt>17/03/2008</DateLastInvPrt>
<TimeInvPrtedHh>16</TimeInvPrtedHh>
<TimeInvPrtedMm>56</TimeInvPrtedMm>
<TBLART_Description>30 Days - 2.5%</TBLART_Description>
<Branch>20</Branch>
<SALBRN_Description>Receivables - South</SALBRN_Description>
<EntInvoice>000000</EntInvoice>
<OrderType>T</OrderType>
<Area>S</Area>
<SALARE_Description>Southen Region</SALARE_Description>
<TaxExemptNumber/>
<GstExemptNum/>
<Currency>$</Currency>
<TBLCUR_Description>Local Currency</TBLCUR_Description>
<ShipAddress1>85a Third Street</ShipAddress1>
<ShipAddress2>Southville</ShipAddress2>
<ShipAddress3>Montgomery</ShipAddress3>
<ShipAddress3Locality/>
<ShipAddress4>AL</ShipAddress4>
<ShipAddress5>USA</ShipAddress5>
<ShipPostalCode>36104</ShipPostalCode>
<ShipGpsLat>0.000000</ShipGpsLat>
<ShipGpsLong>0.000000</ShipGpsLong>
<ShipComplete>N</ShipComplete>
<DispatchWholeOrderOnly>N</DispatchWholeOrderOnly>
<Email/>
<FixExchangeRate>N</FixExchangeRate>
<ExchangeRate>1.000000</ExchangeRate>
<MulDiv>M</MulDiv>
<ConsolidatedOrder/>
<GstDeduction>I</GstDeduction>
<CreditedInvDate/>
<Job/>
<SerialisedFlag>Y</SerialisedFlag>
<CounterSalesFlag/>
<Nationality/>
<DeliveryTerms/>
<ShippingLocation/>
<TransactionNature>000</TransactionNature>
<TransportMode>00</TransportMode>
<ProcessFlag>0</ProcessFlag>
<RegimeCode></RegimeCode>
<PortDispatch></PortDispatch>
<JobsExistFlag/>
<AlternateKey/>
<HierarchyFlag/>
<DepositFlag/>
<EdiSource/>
<DeliveryNote/>
<MultShipCode/>
<AlternateKey/>
<CompanyTaxNo/>
<LastOperator>DEMO</LastOperator>
<Operator/>
<State/>
<CountyZip/>
<ExtendedTaxCode/>
<WebCreated/>
<Quote/>
<DispatchesMade/>
<LiveDispExist/>
<NumDispatches>0</NumDispatches>
<IncludeInMrp>N</IncludeInMrp>
<PriceGroup>BPG</PriceGroup>
<PriceGroupDesc>Price Group for best price</PriceGroupDesc>
<SalesOrderDetStat>C</SalesOrderDetStat>
<SalesOrderDetStatDesc>Mark as complete</SalesOrderDetStatDesc>
<HeaderText/>
<CustomForm/>
<SalesOrderLine>
<Merchandise>
<SalesOrderLine>1</SalesOrderLine>
<SalesOrderInitLine>0001</SalesOrderInitLine>
<MStockCode>A100</MStockCode>
<MStockDes>15 Speed Mountain Bike Boys</MStockDes>
<LongDesc>Distribution</LongDesc>
<MProductClass>MB</MProductClass>
<Description>Mountain Bicycles</Description>
<MWarehouse>S</MWarehouse>
<MWarehouseDesc/>
<MBin/>
<MCusSupStkCode/>
<MOrderQty>100.000</MOrderQty>
<MOrderQtyInStockingUm>100.000</MOrderQtyInStockingUm>
<MShipQty>0.000</MShipQty>
<MStockQtyToShp>0.000</MStockQtyToShp>
<QtyReserved>0.000</QtyReserved>
<QtyReservedShip>0.000</QtyReservedShip>
<MBackOrderQty>0.000</MBackOrderQty>
<MBackOrderQtyInStockingUm>0.000</MBackOrderQtyInStockingUm>
<MQtyDispatched>0.000</MQtyDispatched>
<MMulDivQtyFct>M</MMulDivQtyFct>
<MConvFactAlloc>1.000000</MConvFactAlloc>
<MOrderUom>EA</MOrderUom>
<MStockingUom>EA</MStockingUom>
<MStockUnitMass>1.000000</MStockUnitMass>
<MStockUnitVol>0.000000</MStockUnitVol>
<MPrice>560.00000</MPrice>
<MUnitCost>0.00000</MUnitCost>
<MPriceUom>EA</MPriceUom>
<MMulDivPrcFct>M</MMulDivPrcFct>
<MConvFactOrdUm>1.000000</MConvFactOrdUm>
<MPriceCode>A</MPriceCode>
<MContract/>
<MBuyingGroup/>
<MTaxCode>A</MTaxCode>
<CreditReason/>
<MDiscValFlag/>
<MDiscPct1>0.00</MDiscPct1>
<MDiscPct2>0.00</MDiscPct2>
<MDiscPct3>0.00</MDiscPct3>
<OrderLineValue>56000.00</OrderLineValue>
<MLineShipDate>17/03/2008</MLineShipDate>
<MCustRequestDat>17/03/2008</MCustRequestDat>
<MBomType/>
<MParentKitType>N</MParentKitType>
<MQtyPer>0.000000</MQtyPer>
<MScrapPercentage>0.00</MScrapPercentage>
<MQtyChangesFlag/>
<MUserDef/>
<MTariff/>
<Decimals>3</Decimals>
<IncludeInMrp>N</IncludeInMrp>
<SalesOrderDetStat>C</SalesOrderDetStat>
<SalesOrderDetStatDesc>Mark as complete</SalesOrderDetStatDesc>
<TpmUsageFlag/>
<TpmParentLine>0</TpmParentLine>
<PromotionCode/>
<TpmSequence>0</TpmSequence>
<StockAndAltUm>N</StockAndAltUm>
<PriceGroupRule>1</PriceGroupRule>
<PriceList>PrLstA</PriceList>
</Merchandise>
</SalesOrderLine>
<SalesOrderLine>
<Merchandise>
<SalesOrderLine>2</SalesOrderLine>
<SalesOrderInitLine>0002</SalesOrderInitLine>
<MStockCode>A101</MStockCode>
<MStockDes>15 Speed Mountain Bike Girls</MStockDes>
<LongDesc>Distribution/Foreign Price Eur</LongDesc>
<MProductClass>MB</MProductClass>
<Description>Mountain Bicycles</Description>
<MWarehouse>S</MWarehouse>
<MWarehouseDesc/>
<MBin/>
<MCusSupStkCode/>
<MOrderQty>100.000</MOrderQty>
<MOrderQtyInStockingUm>100.000</MOrderQtyInStockingUm>
<MShipQty>0.000</MShipQty>
<MStockQtyToShp>0.000</MStockQtyToShp>
<QtyReserved>0.000</QtyReserved>
<QtyReservedShip>0.000</QtyReservedShip>
<MBackOrderQty>0.000</MBackOrderQty>
<MBackOrderQtyInStockingUm>0.000</MBackOrderQtyInStockingUm>
<MQtyDispatched>0.000</MQtyDispatched>
<MMulDivQtyFct>M</MMulDivQtyFct>
<MConvFactAlloc>1.000000</MConvFactAlloc>
<MOrderUom>EA</MOrderUom>
<MStockingUom>EA</MStockingUom>
<MStockUnitMass>1.000000</MStockUnitMass>
<MStockUnitVol>0.000000</MStockUnitVol>
<MPrice>560.00000</MPrice>
<MUnitCost>0.00000</MUnitCost>
<MPriceUom>EA</MPriceUom>
<MMulDivPrcFct>M</MMulDivPrcFct>
<MConvFactOrdUm>1.000000</MConvFactOrdUm>
<MPriceCode>A</MPriceCode>
<MContract/>
<MBuyingGroup/>
<MTaxCode>A</MTaxCode>
<CreditReason/>
<MDiscValFlag/>
<MDiscPct1>0.00</MDiscPct1>
<MDiscPct2>0.00</MDiscPct2>
<MDiscPct3>0.00</MDiscPct3>
<OrderLineValue>56000.00</OrderLineValue>
<MLineShipDate>17/03/2008</MLineShipDate>
<MCustRequestDat>17/03/2008</MCustRequestDat>
<MBomType/>
<MParentKitType>N</MParentKitType>
<MQtyPer>0.000000</MQtyPer>
<MScrapPercentage>0.00</MScrapPercentage>
<MQtyChangesFlag/>
<MUserDef/>
<MTariff/>
<Decimals>3</Decimals>
<IncludeInMrp>N</IncludeInMrp>
<SalesOrderDetStat>C</SalesOrderDetStat>
<SalesOrderDetStatDesc>Mark as complete</SalesOrderDetStatDesc>
<TpmUsageFlag/>
<TpmParentLine>0</TpmParentLine>
<PromotionCode/>
<TpmSequence>0</TpmSequence>
<StockAndAltUm>N</StockAndAltUm>
</Merchandise>
</SalesOrderLine>
<SalesOrderLine>
<Merchandise>
<SalesOrderLine>3</SalesOrderLine>
<SalesOrderInitLine>0003</SalesOrderInitLine>
<MStockCode>A200</MStockCode>
<MStockDes>Bicycle Pump</MStockDes>
<LongDesc>Distrib./Alt. Unit Meas/Alt Su</LongDesc>
<MProductClass>BA</MProductClass>
<Description>Bicycle Accessories</Description>
<MWarehouse>S</MWarehouse>
<MWarehouseDesc/>
<MBin/>
<MCusSupStkCode/>
<MOrderQty>200.000</MOrderQty>
<MOrderQtyInStockingUm>200.000</MOrderQtyInStockingUm>
<MShipQty>0.000</MShipQty>
<MStockQtyToShp>0.000</MStockQtyToShp>
<QtyReserved>0.000</QtyReserved>
<QtyReservedShip>0.000</QtyReservedShip>
<MBackOrderQty>0.000</MBackOrderQty>
<MBackOrderQtyInStockingUm>0.000</MBackOrderQtyInStockingUm>
<MQtyDispatched>0.000</MQtyDispatched>
<MMulDivQtyFct>M</MMulDivQtyFct>
<MConvFactAlloc>1.000000</MConvFactAlloc>
<MOrderUom>EA</MOrderUom>
<MStockingUom>EA</MStockingUom>
<MStockUnitMass>1.000000</MStockUnitMass>
<MStockUnitVol>0.000000</MStockUnitVol>
<MPrice>24.80000</MPrice>
<MUnitCost>0.00000</MUnitCost>
<MPriceUom>EA</MPriceUom>
<MMulDivPrcFct>M</MMulDivPrcFct>
<MConvFactOrdUm>1.000000</MConvFactOrdUm>
<MPriceCode>A</MPriceCode>
<MContract/>
<MBuyingGroup/>
<MTaxCode>A</MTaxCode>
<CreditReason/>
<MDiscValFlag/>
<MDiscPct1>0.00</MDiscPct1>
<MDiscPct2>0.00</MDiscPct2>
<MDiscPct3>0.00</MDiscPct3>
<OrderLineValue>4960.00</OrderLineValue>
<MLineShipDate>17/03/2008</MLineShipDate>
<MCustRequestDat>17/03/2008</MCustRequestDat>
<MBomType/>
<MParentKitType>N</MParentKitType>
<MQtyPer>0.000000</MQtyPer>
<MScrapPercentage>0.00</MScrapPercentage>
<MQtyChangesFlag/>
<MUserDef/>
<MTariff/>
<Decimals>3</Decimals>
<IncludeInMrp>N</IncludeInMrp>
<SalesOrderDetStat>C</SalesOrderDetStat>
<SalesOrderDetStatDesc>Mark as complete</SalesOrderDetStatDesc>
<TpmUsageFlag/>
<TpmParentLine>0</TpmParentLine>
<PromotionCode/>
<TpmSequence>0</TpmSequence>
<StockAndAltUm>N</StockAndAltUm>
</Merchandise>
</SalesOrderLine>
<SalesOrderLine>
<Merchandise>
<SalesOrderLine>4</SalesOrderLine>
<SalesOrderInitLine>0004</SalesOrderInitLine>
<MStockCode>SER310</MStockCode>
<MStockDes>Bicycle Helmet Medium - Green</MStockDes>
<LongDesc>Serialized - Batch</LongDesc>
<MProductClass>BH</MProductClass>
<Description>Bicycle Helmets</Description>
<MWarehouse>S</MWarehouse>
<MWarehouseDesc/>
<MBin/>
<MCusSupStkCode/>
<MOrderQty>10.000</MOrderQty>
<MOrderQtyInStockingUm>10.000</MOrderQtyInStockingUm>
<MShipQty>0.000</MShipQty>
<MStockQtyToShp>0.000</MStockQtyToShp>
<QtyReserved>0.000</QtyReserved>
<QtyReservedShip>0.000</QtyReservedShip>
<MBackOrderQty>0.000</MBackOrderQty>
<MBackOrderQtyInStockingUm>0.000</MBackOrderQtyInStockingUm>
<MQtyDispatched>0.000</MQtyDispatched>
<MMulDivQtyFct>M</MMulDivQtyFct>
<MConvFactAlloc>1.000000</MConvFactAlloc>
<MOrderUom>EA</MOrderUom>
<MStockingUom>EA</MStockingUom>
<MStockUnitMass>1.000000</MStockUnitMass>
<MStockUnitVol>0.000000</MStockUnitVol>
<MPrice>56.00000</MPrice>
<MUnitCost>0.00000</MUnitCost>
<MPriceUom>EA</MPriceUom>
<MMulDivPrcFct>M</MMulDivPrcFct>
<MConvFactOrdUm>1.000000</MConvFactOrdUm>
<MPriceCode>A</MPriceCode>
<MContract/>
<MBuyingGroup/>
<MTaxCode>A</MTaxCode>
<CreditReason/>
<MDiscValFlag/>
<MDiscPct1>0.00</MDiscPct1>
<MDiscPct2>0.00</MDiscPct2>
<MDiscPct3>0.00</MDiscPct3>
<OrderLineValue>560.00</OrderLineValue>
<MLineShipDate>17/03/2008</MLineShipDate>
<MCustRequestDat>17/03/2008</MCustRequestDat>
<MBomType/>
<MParentKitType>N</MParentKitType>
<MQtyPer>0.000000</MQtyPer>
<MScrapPercentage>0.00</MScrapPercentage>
<MQtyChangesFlag/>
<MUserDef/>
<MTariff/>
<Decimals>3</Decimals>
<IncludeInMrp>N</IncludeInMrp>
<SalesOrderDetStat>C</SalesOrderDetStat>
<SalesOrderDetStatDesc>Mark as complete</SalesOrderDetStatDesc>
<TpmUsageFlag/>
<TpmParentLine>0</TpmParentLine>
<PromotionCode/>
<TpmSequence>0</TpmSequence>
<StockAndAltUm>N</StockAndAltUm>
</Merchandise>
</SalesOrderLine>
<SalesOrderLine>
<CommentLine>
<SalesOrderLine>5</SalesOrderLine>
<NComment>Please remember to send serial certificates</NComment>
<NCommentFromLin>4</NCommentFromLin>
</CommentLine>
</SalesOrderLine>
<SalesOrderLine>
<CommentLine>
<SalesOrderLine>6</SalesOrderLine>
<NComment>with the goods.</NComment>
<NCommentFromLin>4</NCommentFromLin>
</CommentLine>
</SalesOrderLine>
</SorDetail>
If the operator is denied access to the field: Show costs in Inventory/WIP queries (Setup | Security | Operators | Security | Fields), the following fields will not be returned when the element IncludeAttachedItems is Y:
- SctItem node
- Unit cost (MUnitCost)
- Selling price (Mprice)
- RequisitionItem node
- Price (Price)
Refer to SORQRYOUT.XML for a sample of the XML returned by this business object.
Prerequisites
The Sales Orders module must be installed to run this business object.
The Sales Orders Primary Query functional area must be licensed.
Limitations
No limitations apply to this business object.
Copyright © 2026 Syspro PTY Ltd.