INVQRY: Inventory Query
The Inventory Query business object allows you to query details of a stock code
Properties
| Syspro Module | Inventory Control |
| Class | Query |
| Methods | Query |
| Functional Area | Inventory 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.
INVQRY.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2026 SYSPRO Ltd. -->
<!--
Sample XML for the Inventory Query Business Object
-->
<Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="INVQRY.XSD">
<Key>
<StockCode><![CDATA[A100]]></StockCode>
</Key>
<Option>
<MultiMediaImageType>GIF</MultiMediaImageType>
<IncludeHistory>Y</IncludeHistory>
<IncludeBins>Y</IncludeBins>
<IncludeLots>Y</IncludeLots>
<IncludeSerials>Y</IncludeSerials>
<IncludeMovements>Y</IncludeMovements>
<MovementDateSequence>A</MovementDateSequence>
<MovementStartDate>2001-01-12</MovementStartDate>
<MaxNumberMovements>100</MaxNumberMovements>
<IncludeCustomForms>N</IncludeCustomForms>
<IncludeMovementIssues>Y</IncludeMovementIssues>
<IncludeMovementTransfers>Y</IncludeMovementTransfers>
<IncludeMovementReceipts>Y</IncludeMovementReceipts>
<IncludeMovementPhysical>Y</IncludeMovementPhysical>
<IncludeMovementAdjustments>Y</IncludeMovementAdjustments>
<IncludeMovementCostChanges>Y</IncludeMovementCostChanges>
<IncludeMovementCostMods>Y</IncludeMovementCostMods>
<IncludeMovementBinTransfers>Y</IncludeMovementBinTransfers>
<IncludeMovementInvoices>Y</IncludeMovementInvoices>
<IncludeMovementCreditNotes>Y</IncludeMovementCreditNotes>
<IncludeMovementDebitNotes>Y</IncludeMovementDebitNotes>
<IncludeMovementDispatchNotes>Y</IncludeMovementDispatchNotes>
<IncludeMovementCustomForms>Y</IncludeMovementCustomForms>
<IncludeEcc>Y</IncludeEcc>
<IncludeApprovedManuf>Y</IncludeApprovedManuf>
<IncludeNarrations>Y</IncludeNarrations>
<ReturnNarrationsinBlock>N</ReturnNarrationsinBlock>
<IncludeForeignPrices>N</IncludeForeignPrices>
<IncludeSourcingPolicies>N</IncludeSourcingPolicies>
<IncludeLpns>N</IncludeLpns>
<XslStylesheet />
</Option>
<Filter>
<Warehouse FilterType="L" FilterValue="S,N,E" />
</Filter>
</Query>Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2026 SYSPRO Ltd. -->
<!--
Schema for Inventory Query Business Object
-->
<xsd:schema elementFormDefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="Filter">
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element ref="Warehouse" minOccurs="0" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="MultiMediaImageType" type="xsd:string">
<xsd:annotation>
<xsd:documentation>Image type to retrieve (for example: GIF, JPG)</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="IncludeCustomForms" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include fields from custom forms ? (N - No, Y - Yes,)</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="IncludeBins" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include multiple bins ? (N - No, Y - Yes Z - Include zero qty on hand bins)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N" />
<xsd:enumeration value="Y" />
<xsd:enumeration value="Z" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeHistory" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include history ? (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="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include lots ? (N - No, Y - Yes, Z - Include zero qty on hand lots)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N" />
<xsd:enumeration value="Y" />
<xsd:enumeration value="Z" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeMovementAdjustments" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include adjustments ? (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="IncludeMovementBinTransfers" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include bin transfers ? (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="IncludeMovementCostChanges" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include cost changes ? (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="IncludeMovementCostMods" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include cost modifications ? (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="IncludeMovementCreditNotes" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include credit notes ? (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="IncludeMovementDebitNotes" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include debit note movements ? (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="IncludeMovementDispatchNotes" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include dispatch note movements? (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="IncludeMovementInvoices" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include invoice movements? (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="IncludeMovementIssues" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include issue movements ? (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="IncludeMovementPhysical" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include physical movements ? (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="IncludeMovementReceipts" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include receipt movements ? (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="IncludeMovementCustomForms" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include custom forms defined against the movements? (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="IncludeEcc" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include ECC ? (Y - Yes, N - No). The default is Y.</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="IncludeMovements" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include movements ? (N - No, Y - Yes)</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="IncludeMovementTransfers" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include transfer movements ? (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="IncludeSerials" default="N">
<xsd:annotation>
<xsd:documentation>Do you wish to include serial numbers ? (N - No, Y - Yes, Z=Include zero qty on hand serials)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="N" />
<xsd:enumeration value="Y" />
<xsd:enumeration value="Z" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeNarrations" default="Y">
<xsd:annotation>
<xsd:documentation>Indicates whether narrations should be returned. (Y - Yes and N = No). 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="ReturnNarrationsinBlock" default="N">
<xsd:annotation>
<xsd:documentation>Indicates whether narrations 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:element name="Key">
<xsd:annotation>
<xsd:documentation>The key to use for this query.</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element ref="StockCode" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="MovementDateSequence" default="A">
<xsd:annotation>
<xsd:documentation>The sequence of the returned records (A - Ascending date sequence, D - Descending date sequence)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="A" />
<xsd:enumeration value="D" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="MaxNumberMovements">
<xsd:annotation>
<xsd:documentation>The maximum number of Movement entries to return (enter a value between 0 and 99999999 where 0 / blank returns all records)</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="MovementStartDate" type="xsd:date">
<xsd:annotation>
<xsd:documentation>The date from which to extract movements</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Option">
<xsd:annotation>
<xsd:documentation>The list of options</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element ref="MultiMediaImageType" minOccurs="0" />
<xsd:element ref="IncludeHistory" minOccurs="0" />
<xsd:element ref="IncludeBins" minOccurs="0" />
<xsd:element ref="IncludeLots" minOccurs="0" />
<xsd:element ref="IncludeSerials" minOccurs="0" />
<xsd:element ref="IncludeMovements" minOccurs="0" />
<xsd:element ref="MovementDateSequence" minOccurs="0" />
<xsd:element ref="MovementStartDate" minOccurs="0" />
<xsd:element ref="MaxNumberMovements" minOccurs="0" />
<xsd:element ref="IncludeCustomForms" minOccurs="0" />
<xsd:element ref="IncludeMovementIssues" minOccurs="0" />
<xsd:element ref="IncludeMovementTransfers" minOccurs="0" />
<xsd:element ref="IncludeMovementReceipts" minOccurs="0" />
<xsd:element ref="IncludeMovementPhysical" minOccurs="0" />
<xsd:element ref="IncludeMovementAdjustments" minOccurs="0" />
<xsd:element ref="IncludeMovementCostChanges" minOccurs="0" />
<xsd:element ref="IncludeMovementCostMods" minOccurs="0" />
<xsd:element ref="IncludeMovementBinTransfers" minOccurs="0" />
<xsd:element ref="IncludeMovementInvoices" minOccurs="0" />
<xsd:element ref="IncludeMovementCreditNotes" minOccurs="0" />
<xsd:element ref="IncludeMovementDebitNotes" minOccurs="0" />
<xsd:element ref="IncludeMovementDispatchNotes" minOccurs="0" />
<xsd:element ref="IncludeMovementCustomForms" minOccurs="0" />
<xsd:element ref="IncludeEcc" minOccurs="0" />
<xsd:element ref="IncludeApprovedManuf" minOccurs="0" />
<xsd:element ref="IncludeNarrations" minOccurs="0" />
<xsd:element ref="ReturnNarrationsinBlock" minOccurs="0" />
<xsd:element name="IncludeForeignPrices" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Do you wish to include foreign prices. (Y - Yes and N = No). 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:enumeration value="N" />
<xsd:enumeration value="Y" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeSourcingPolicies" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Do you wish to include preferred supplier sourcing policies. (Y - Yes and N = No). 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:enumeration value="N" />
<xsd:enumeration value="Y" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeLpns" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Do you wish to include all the License Plate Number quantitities. (Y - Yes and N = No). 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:enumeration value="N" />
<xsd:enumeration value="Y" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element ref="XslStylesheet" minOccurs="0" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Query">
<xsd:annotation>
<xsd:documentation>The root element</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element ref="Key" />
<xsd:element ref="Option" minOccurs="0" />
<xsd:element ref="Filter" minOccurs="0" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="StockCode">
<xsd:annotation>
<xsd:documentation>The stock code to use for the query</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Warehouse">
<xsd:annotation>
<xsd:documentation> A - All; R - Range or L - List of warehouses separated by commas. (Default A - All).</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" use="optional">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="R" />
<xsd:enumeration value="L" />
<xsd:enumeration value="A" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FilterValue" use="optional">
<xsd:simpleType>
<xsd:restriction base="xsd:string" />
</xsd:simpleType>
</xsd:attribute>
</xsd:complexType>
</xsd:element>
<xsd:element name="XslStylesheet">
<xsd:annotation>
<xsd:documentation>The Stylesheet to be applied</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeApprovedManuf" default="Y">
<xsd:annotation>
<xsd:documentation>Do you wish to include a list of approved manufacturers for this stock code? (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:schema>Output XML
The OUT.XML indicates a sample of the XML returned by this business object.
INVQRYOUT.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2026 SYSPRO Ltd. -->
<!--
Sample XML for the Inventory Query Business Object
-->
<InvQuery xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="INVQRYOUT.XSD">
<SystemInformation>
<CssStyle />
<Language>EN</Language>
<DecFormat>2</DecFormat>
<DateFormat>01</DateFormat>
<Role>01</Role>
<Version>6.1.023</Version>
<CompanyId>A</CompanyId>
<CompanyName>Demo for Sue</CompanyName>
<OperatorCode>ADMIN</OperatorCode>
<OperatorName>Administrator</OperatorName>
<OperatorGroup>ADMIN</OperatorGroup>
<OperatorEmailAddress />
<OperatorLocation />
<LocalCurrency>$</LocalCurrency>
<LocalCurrencyDesc>$</LocalCurrencyDesc>
<GlPrdPerYear>12</GlPrdPerYear>
<ReportDate>07/12/2011 09:27</ReportDate>
<UseSeparatorOnReports>Y</UseSeparatorOnReports>
<SeparatorToUse>,</SeparatorToUse>
<OperatorPrimaryRole />
<NoOfDigits>2</NoOfDigits>
<DecCharToUse>.</DecCharToUse>
<BOMQtyPerDecimals>6</BOMQtyPerDecimals>
</SystemInformation>
<StockItem>
<StockCode>A100</StockCode>
<Description>15 Speed Mountain Bike Boys</Description>
<LongDesc>Distribution</LongDesc>
<AlternateKey1 />
<AlternateKey2 />
<Version />
<Release />
<StockUom>EA</StockUom>
<ManufactureUom />
<AlternateUom>1</AlternateUom>
<ConvFactAltUom>1.000000</ConvFactAltUom>
<ConvMulDiv>M</ConvMulDiv>
<OtherUom>2</OtherUom>
<ConvFactOthUom>1.000000</ConvFactOthUom>
<MulDiv>M</MulDiv>
<StockAndAltUm>N</StockAndAltUm>
<PartCategory>B</PartCategory>
<PartCategoryDesc />
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<ProductClass>MB</ProductClass>
<ProductClassDesc />
<Buyer>JD</Buyer>
<BuyerDesc />
<Planner />
<PlannerDesc />
<TraceableType>I</TraceableType>
<TraceableTypeDesc />
<InspectionFlag>Y</InspectionFlag>
<InspectionFlagDesc>Yes</InspectionFlagDesc>
<MpsFlag />
<MpsFlagDesc>N</MpsFlagDesc>
<SupercessionDate />
<ResourceCode />
<ResourceCodeDesc />
<ComponentCount />
<InclInStrValid />
<LabourCost />
<Edited_LabourCost />
<MaterialCost />
<Edited_MaterialCost />
<FixedOverhead />
<Edited_FixedOverhead />
<VariableOverhead />
<Edited_VariableOverhead />
<SubContractCost />
<Edited_SubContractCost />
<TotalCost />
<Edited_TotalCost />
<CostPriceCurrency />
<QuantityUnsigned />
<DrawOfficeNum />
<Ebq>1.000</Ebq>
<Edited_Ebq />
<DockToStock>0</DockToStock>
<ManufLeadTime>0</ManufLeadTime>
<TariffCode />
<UserField1 />
<UserField2>0.00000</UserField2>
<UserField3 />
<UserField4 />
<UserField5 />
<LeadTime>20</LeadTime>
<WarehouseToUse>FS</WarehouseToUse>
<WarehouseToUseDesc />
<MinimumPricePctAboveCost />
<Edited_MinimumPricePctAboveCost />
<GstTaxCode />
<GstTaxDesc />
<GstIncludedInPrice />
<DemandTimeFenceInDays />
<ShelfLifeInDays />
<MakeToOrderFlag />
<DistributionWarehouseToUse />
<DistributionWarehouseToUseDesc />
<CountryOfOrigin />
<CountryOfOriginDesc />
<GrossReqRule>I</GrossReqRule>
<GrossReqRuleDesc />
<EccUser />
<EccUserDesc />
<BuyingRule />
<BuyingRuleDesc />
<FixedTimeDaysForRuleC />
<EbqPan />
<PanSize />
<PercentageYield />
<LowLevelCode />
<WipCtlGlCode />
<DateStockAdded />
<AbcPreProd />
<AbcManufacturing />
<AbcSales />
<AbcCumPreProd />
<AbcCumManuf />
<SpecificGravity />
<Mass>1.000000</Mass>
<Volume>0.000000</Volume>
<PriceCategory>A</PriceCategory>
<PriceMethod>C</PriceMethod>
<CycleCount>0</CycleCount>
<TaxCode>A</TaxCode>
<TaxCodeDesc />
<OtherTaxCode />
<OtherTaxCodeDesc />
<ListPriceCode>A</ListPriceCode>
<SerialMethod>N</SerialMethod>
<SerialMethodDesc />
<KitType>N</KitType>
<KitTypeDesc />
<BulkIssueFlag>N</BulkIssueFlag>
<BulkIssueFlagDesc />
<AbcClass />
<StockMovementReq>Y</StockMovementReq>
<ClearingFlag>N</ClearingFlag>
<AbcAnalysisReq>Y</AbcAnalysisReq>
<AbcCostingReq>N</AbcCostingReq>
<CostUom>EA</CostUom>
<SellingPrice />
<PriceBasis />
<PriceBasisDesc />
<Edited_SellingPrice />
<SellingPriceCurrency />
<GrossProfitPct />
<StockOnHold />
<StockOnHoldDesc />
<StockOnHoldReason />
<StockOnHoldReasonDesc />
<ProductFamily />
<ProductFamilyDesc />
<Brand />
<BrandDesc />
<Formula />
<FormulaDesc />
<Designation />
<DesignationDesc />
<BinItem>
<Bin />
<QtyOnHand />
<AvailableQty />
<Note />
<OnHold />
<OnHoldReason />
<SoQtyToShip />
<LastSale />
<LastReceiptDate />
<DefaultBin />
</BinItem>
<LotItem>
<LotJob />
<DrawingNum />
<DrawingNumDesc />
<Bin />
<Version />
<Release />
<QtyOnHand />
<AvailableQty />
<Note />
<LotHoldFlag />
<ExpiryDate />
</LotItem>
<SerialItem>
<Serial />
<SerialDescription />
<SerialMethod />
<Location />
<Lot />
<Bin />
<ServiceFlag />
<LoadFlag />
<ServiceDepotFlag />
<QtyOnHand />
<QtyAvailable />
<QtyReceived />
<QtyInTransitOut />
<ExpiryDate />
<ScrapDate />
<DueDate />
</SerialItem>
<EccItem>
<Version />
<Release />
<QtyOnHand />
<AvailableQty />
<QtyOnOrder />
<QtyInInspection />
<QtyOnBackOrder />
<QtyAllocated />
<QtyAllocatedWip />
<DepleteOldestWipQty />
<QtyInTransit />
<QtyDispatched />
</EccItem>
<ApprovedManufactures>
<StockCode />
<AppManufacturer />
<ManPartNumber />
<PreferredFlag />
<Status />
<RevisionNumber />
<EffectiveDate />
</ApprovedManufactures>
<Narrations>
<InspectionText>
<Text>Make sure that all goods are tested on the</Text>
<Text>obstacle course.</Text>
</InspectionText>
<PurchaseOrderAdditionalText>
<Text>Please send our certification on all bicyle</Text>
<Text>components</Text>
</PurchaseOrderAdditionalText>
<SalesOrderAdditionalText>
<Text>Please make sure that you purchase the</Text>
<Text>correct bicycle accessories.</Text>
</SalesOrderAdditionalText>
<TechnicalInformation>
<Text>Bicycle comforms to our specified standards</Text>
<Text>and comes with certification on all</Text>
<Text>components.</Text>
<Text>Warrenties are in place.</Text>
</TechnicalInformation>
</Narrations>
<ForeignPrices>
<ForeignPriceItem>
<StockCode />
<Currency />
<ForeignPrice />
</ForeignPriceItem>
</ForeignPrices>
<LpnItem>
<LicensePlateNumber>125345265341239</LicensePlateNumber>
<CurrentQty>150.000</CurrentQty>
<AvailableQty>100.000</AvailableQty>
<Serial>SER200</Serial>
<Lot>LOT100</Lot>
<Container>Chep Pallet</Container>
<Warehouse>E</Warehouse>
<Bin>E</Bin>
</LpnItem>
</StockItem>
<WarehouseItem>
<Warehouse>S</Warehouse>
<Description>Southern Warehouse</Description>
<QtyOnHand>7455.000</QtyOnHand>
<AvailableQty>7355.000</AvailableQty>
<QtyOnOrder>50.000</QtyOnOrder>
<QtyInInspection>0.000</QtyInInspection>
<MinimumQty>0.000</MinimumQty>
<MaximumQty>0.000</MaximumQty>
<QtyOnBackOrder>100.000</QtyOnBackOrder>
<QtyAllocated>100.000</QtyAllocated>
<MtdQtyReceived>0.000</MtdQtyReceived>
<MtdQtyAdjusted>0.000</MtdQtyAdjusted>
<MtdQtyIssued>0.000</MtdQtyIssued>
<YtdQtySold>290.000</YtdQtySold>
<PrevYearQtySold>3255.000</PrevYearQtySold>
<QtyInTransit>0.000</QtyInTransit>
<QtyAllocatedWip>0.000</QtyAllocatedWip>
<WipQtyReserved>0.000</WipQtyReserved>
<MtdQtySold Height="024" Top=" 650">155.000</MtdQtySold>
<MtdQtyTrf>0.000</MtdQtyTrf>
<DateLastSale />
<DateLastCostChange />
<DateLastCostEntered />
<UnitCost />
<UserField1 />
<UserField2 />
<UserField3 />
<DefaultBin />
<UnitCost>350.00000</UnitCost>
<FutureFree />
<QuantityDispatchNotInvoiced />
<Parameters>
<SafetyStockLevel />
<ReOrderQuantity />
<PalletQuantity />
<DefaultBinLocation />
<ABCclassification />
<RequisitionsInProgress />
<LandedCostMultiplier />
</Parameters>
<Costs>
<Method />
<LastCostEntered />
<Current />
<LastNonMerchandise />
</Costs>
<MTDValues>
<MTDSalesValue />
</MTDValues>
<YTDValues>
<YTDQtyIssued />
<YTDSalesValue />
<YTDUsageValue />
<PySalesValue />
</YTDValues>
<LastActivityDates>
<DateLastStockMovement />
<DateOfLastPurchase />
<DateOfLastCount />
<DateWarehouseAdded />
</LastActivityDates>
<SalesQtyByMonth>
<SalesQty1 Height="021">135.000</SalesQty1>
<SalesQty2 Height="058">380.000</SalesQty2>
<SalesQty3 Height="004">25.000</SalesQty3>
<SalesQty4 Height="069">450.000</SalesQty4>
<SalesQty5 Height="100">650.000</SalesQty5>
<SalesQty6 Height="046">300.000</SalesQty6>
<SalesQty7 Height="092">600.000</SalesQty7>
<SalesQty8 Height="008">50.000</SalesQty8>
<SalesQty9 Height="000">0.000</SalesQty9>
<SalesQty10 Height="031">200.000</SalesQty10>
<SalesQty11 Height="015">100.000</SalesQty11>
<SalesQty12 Height="062">400.000</SalesQty12>
</SalesQtyByMonth>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<TrnTypeDesc />
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<CustomForm>
<Field>
<Sequence>1</Sequence>
<Name>CUS001</Name>
<Prompt>Cust</Prompt>
<Column>Cust</Column>
<Type>A</Type>
<Length>10</Length>
<Decimals>0</Decimals>
<Default>{Spaces}</Default>
<AllowNull>Y</AllowNull>
<ValidationType>1</ValidationType>
<Value>Custom form value</Value>
<ValueNull>N</ValueNull>
</Field>
</CustomForm>
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
</WarehouseItem>
<WarehouseItem>
<Warehouse>N</Warehouse>
<Description>Northern Warehouse</Description>
<QtyOnHand>15352.000</QtyOnHand>
<AvailableQty>14752.000</AvailableQty>
<QtyOnOrder>1500.000</QtyOnOrder>
<QtyInInspection>0.000</QtyInInspection>
<MinimumQty>0.000</MinimumQty>
<MaximumQty>0.000</MaximumQty>
<QtyOnBackOrder>600.000</QtyOnBackOrder>
<QtyAllocated>600.000</QtyAllocated>
<MtdQtyReceived>0.000</MtdQtyReceived>
<MtdQtyAdjusted>0.000</MtdQtyAdjusted>
<MtdQtyIssued>0.000</MtdQtyIssued>
<YtdQtySold>2010.000</YtdQtySold>
<PrevYearQtySold>9350.000</PrevYearQtySold>
<QtyInTransit>10.000</QtyInTransit>
<QtyAllocatedWip>0.000</QtyAllocatedWip>
<WipQtyReserved>0.000</WipQtyReserved>
<MtdQtySold Height="074" Top=" 1500">1110.000</MtdQtySold>
<MtdQtyTrf>-33.000</MtdQtyTrf>
<UserField1 />
<UserField2 />
<UserField3 />
<DefaultBin />
<UnitCost>350.00000</UnitCost>
<FutureFree />
<QuantityDispatchNotInvoiced />
<Parameters>
<SafetyStockLevel />
<ReOrderQuantity />
<PalletQuantity />
<DefaultBinLocation />
<ABCclassification />
<RequisitionsInProgress />
<LandedCostMultiplier />
</Parameters>
<Costs>
<Method />
<LastCostEntered />
<Current />
<LastNonMerchandise />
</Costs>
<MTDValues>
<MTDSalesValue />
</MTDValues>
<YTDValues>
<YTDQtyIssued />
<YTDSalesValue />
<YTDUsageValue />
<PySalesValue />
</YTDValues>
<LastActivityDates>
<DateLastStockMovement />
<DateOfLastPurchase />
<DateOfLastCount />
<DateWarehouseAdded />
</LastActivityDates>
<SalesQtyByMonth>
<SalesQty1 Height="060">900.000</SalesQty1>
<SalesQty2 Height="033">500.000</SalesQty2>
<SalesQty3 Height="017">250.000</SalesQty3>
<SalesQty4 Height="100">1500.000</SalesQty4>
<SalesQty5 Height="087">1300.000</SalesQty5>
<SalesQty6 Height="073">1100.000</SalesQty6>
<SalesQty7 Height="060">900.000</SalesQty7>
<SalesQty8 Height="027">400.000</SalesQty8>
<SalesQty9 Height="007">100.000</SalesQty9>
<SalesQty10 Height="100">1500.000</SalesQty10>
<SalesQty11 Height="033">500.000</SalesQty11>
<SalesQty12 Height="047">700.000</SalesQty12>
</SalesQtyByMonth>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
</WarehouseItem>
<WarehouseItem>
<Warehouse>E</Warehouse>
<Description>Eastern Warehouse</Description>
<QtyOnHand>108390.000</QtyOnHand>
<AvailableQty>107411.153</AvailableQty>
<QtyOnOrder>1341.000</QtyOnOrder>
<QtyInInspection>0.000</QtyInInspection>
<MinimumQty>0.000</MinimumQty>
<MaximumQty>0.000</MaximumQty>
<QtyOnBackOrder>871.847</QtyOnBackOrder>
<QtyAllocated>978.847</QtyAllocated>
<MtdQtyReceived>102123.000</MtdQtyReceived>
<MtdQtyAdjusted>7.000</MtdQtyAdjusted>
<MtdQtyIssued>3024.000</MtdQtyIssued>
<YtdQtySold>589.000</YtdQtySold>
<PrevYearQtySold>5100.000</PrevYearQtySold>
<QtyInTransit>100.000</QtyInTransit>
<QtyAllocatedWip>0.000</QtyAllocatedWip>
<WipQtyReserved>0.000</WipQtyReserved>
<MtdQtySold Height="033" Top=" 1450">479.000</MtdQtySold>
<MtdQtyTrf>-105.000</MtdQtyTrf>
<UserField1 />
<UserField2 />
<UserField3 />
<DefaultBin>E</DefaultBin>
<UnitCost>382.28633</UnitCost>
<FutureFree />
<QuantityDispatchNotInvoiced />
<Parameters>
<SafetyStockLevel />
<ReOrderQuantity />
<PalletQuantity />
<DefaultBinLocation />
<ABCclassification />
<RequisitionsInProgress />
<LandedCostMultiplier />
</Parameters>
<Costs>
<Method />
<LastCostEntered />
<Current />
<LastNonMerchandise />
</Costs>
<MTDValues>
<MTDSalesValue />
</MTDValues>
<YTDValues>
<YTDQtyIssued />
<YTDSalesValue />
<YTDUsageValue />
<PySalesValue />
</YTDValues>
<LastActivityDates>
<DateLastStockMovement />
<DateOfLastPurchase />
<DateOfLastCount />
<DateWarehouseAdded />
</LastActivityDates>
<SalesQtyByMonth>
<SalesQty1 Height="009">125.000</SalesQty1>
<SalesQty2 Height="017">250.000</SalesQty2>
<SalesQty3 Height="003">50.000</SalesQty3>
<SalesQty4 Height="052">750.000</SalesQty4>
<SalesQty5 Height="100">1450.000</SalesQty5>
<SalesQty6 Height="028">400.000</SalesQty6>
<SalesQty7 Height="041">600.000</SalesQty7>
<SalesQty8 Height="007">100.000</SalesQty8>
<SalesQty9 Height="000">0.000</SalesQty9>
<SalesQty10 Height="014">200.000</SalesQty10>
<SalesQty11 Height="017">250.000</SalesQty11>
<SalesQty12 Height="055">800.000</SalesQty12>
</SalesQtyByMonth>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice />
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="I">
<MovementTypeDesc />
<EntryDate>2006-02-25</EntryDate>
<TrnYear />
<TrnMonth />
<Reference>000000212</Reference>
<TrnQty>250.000</TrnQty>
<TrnType>R</TrnType>
<GlCode>20-2010</GlCode>
<Journal>59</Journal>
<AddReference />
<JournalEntry>1</JournalEntry>
<PurchaseOrder>000373</PurchaseOrder>
<Supplier>0000001</Supplier>
<SupplierName>Bicycles Unlimited</SupplierName>
<TrnValue>87500.00</TrnValue>
<UnitCost>350.00000</UnitCost>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
<Movement Type="S">
<MovementTypeDesc />
<EntryDate>2006-03-05</EntryDate>
<TrnYear />
<TrnMonth />
<Invoice>100478</Invoice>
<TrnQty>25.000</TrnQty>
<TrnValue>14000.00</TrnValue>
<Area>S</Area>
<SalesOrder>000805</SalesOrder>
<OrderType>T</OrderType>
<CostValue>8750.00</CostValue>
<UnitCost>350.00000</UnitCost>
<UnitPrice>560.00000</UnitPrice>
<Customer>0000003</Customer>
<Name>Bikes and Blades - South</Name>
<Branch>20</Branch>
<Salesperson>201</Salesperson>
<CustomerPoNumber>South 568</CustomerPoNumber>
<DocType>I</DocType>
<DocTypeDesc />
</Movement>
</WarehouseItem>
<WarehouseTotals>
<QtyOnHand>7455.000</QtyOnHand>
<AvailableQty>7355.000</AvailableQty>
<QtyOnOrder>50.000</QtyOnOrder>
<QtyInInspection>0.000</QtyInInspection>
<MinimumQty>0.000</MinimumQty>
<MaximumQty>0.000</MaximumQty>
<QtyOnBackOrder>100.000</QtyOnBackOrder>
<QtyAllocated>100.000</QtyAllocated>
<MtdQtyReceived>0.000</MtdQtyReceived>
<MtdQtyAdjusted>0.000</MtdQtyAdjusted>
<MtdQtyIssued>0.000</MtdQtyIssued>
<MtdQtySold />
<YtdQtySold>290.000</YtdQtySold>
<PrevYearQtySold>3255.000</PrevYearQtySold>
<QtyInTransit>0.000</QtyInTransit>
<QtyAllocatedWip>0.000</QtyAllocatedWip>
<MtdQtyTrf>0.000</MtdQtyTrf>
<UnitCost />
<SalesQtyTot1 />
<SalesQtyTot2 />
<SalesQtyTot3 />
<SalesQtyTot4 />
<SalesQtyTot5 />
<SalesQtyTot6 />
<SalesQtyTot7 />
<SalesQtyTot8 />
<SalesQtyTot9 />
<SalesQtyTot10 />
<SalesQtyTot11 />
<SalesQtyTot12 />
<Parameters>
<SafetyStockLevel />
<ReOrderQuantity />
<PalletQuantity />
<DefaultBinLocation />
<ABCclassification />
<RequisitionsInProgress />
<LandedCostMultiplier />
</Parameters>
<Costs>
<Method />
<LastCostEntered />
<Current />
<LastNonMerchandise />
</Costs>
<MTDValues>
<MTDSalesValue />
</MTDValues>
<YTDValues>
<YTDQtyIssued />
<YTDSalesValue />
<YTDUsageValue />
<PySalesValue />
</YTDValues>
</WarehouseTotals>
</InvQuery>Prerequisites
No prerequisites are required to use this business object.
Limitations
No limitations apply to this business object.
Copyright © 2026 Syspro PTY Ltd.