WIPQJV: WIP Valuation Query
The WIP Valuation Query business object lets you calculate the outstanding work in progress value for a job.
This value is calculated by subtracting the value of any part billings or job receipts made against the job from the accumulated material and labor costs to date. In addition to job header information, the labor hours and value booked to date, the material costs to date and the value of labor and material booked from work in progress, are returned.
Properties
| Syspro Module | Work in Progress |
| Class | Query |
| Methods | Query |
| Functional Area | WIP 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.
WIPQJV.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2024 SYSPRO Ltd.-->
<!--
Sample XML for the WIP Valuation Query Business Object
-->
<Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="WIPQJV.XSD">
<Option>
<AsOfPeriod>C</AsOfPeriod>
<Sequence>J</Sequence>
<IncludeJobsOnHold>I</IncludeJobsOnHold>
<IncludeJobsCompleted>I</IncludeJobsCompleted>
<IncludeJobsUnconfirmed>I</IncludeJobsUnconfirmed>
<IncludeSubJobs>Y</IncludeSubJobs>
<IncludeZeroValueJobs>N</IncludeZeroValueJobs>
<PrintManufacturingUMQuantities>N</PrintManufacturingUMQuantities>
<IncludeMaintenanceJobs>I</IncludeMaintenanceJobs>
<MaintenanceJobType>A</MaintenanceJobType>
<XslStylesheet/>
</Option>
<Filter>
<LedgerCode FilterType="A"/>
<Job FilterType="R" FilterValue="00000140,00000250"/>
<JobClass FilterType="A"/>
<PlannedDeliveryDate FilterType="R" FilterValue="2006-10-01,2006-03-28"/>
<Customer FilterType="A"/>
<StockCode FilterType="A"/>
</Filter>
</Query>
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2024 SYSPRO Ltd.-->
<!--
Schema for the WIP Valuation Query Business Object
-->
<xsd:schema elementFormDefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="Query">
<xsd:annotation>
<xsd:documentation>This is the root element.</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element name="Option" minOccurs="0">
<xsd:annotation>
<xsd:documentation>List of options</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element name="AsOfPeriod" default="C" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies the period from which to return data (C - transactions from the current WIP period backwards, P - transactions from the previous WIP period backwards, B - transactions from WIP previous period two backwards). If not provided, the default is C</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="C"/>
<xsd:enumeration value="P"/>
<xsd:enumeration value="B"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Sequence" default="J" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies which sequence in which the data is returned ( J - Job sequence, C - Job Classification sequence, L - Ledger control account sequence, S - Stock code sequence). If not provided the default is J.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="J"/>
<xsd:enumeration value="C"/>
<xsd:enumeration value="L"/>
<xsd:enumeration value="S"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeJobsOnHold" default="I" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies whether to include jobs on hold ( I - Include, E - Exclude, O - Only). If not provided, the default is I.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="I"/>
<xsd:enumeration value="E"/>
<xsd:enumeration value="O"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeJobsCompleted" default="I" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies whether to include completed jobs ( I - Include, E - Exclude, O - Only). If not provided, the default is I.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="I"/>
<xsd:enumeration value="E"/>
<xsd:enumeration value="O"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeJobsUnconfirmed" default="I" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies whether to include unconfirmed jobs ( I - Include, E - Exclude, O - Only). If not provided, the default is I.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve"/>
<xsd:enumeration value="I"/>
<xsd:enumeration value="E"/>
<xsd:enumeration value="O"/>
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IncludeSubJobs" default="Y" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies whether to include sub jobs ( Y - Yes, N - No). If not provided, the default is 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="IncludeZeroValueJobs" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies whether to include jobs with a WIP value of zero ( Y - Yes, N - No). If not provided, the default is N.</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="PrintManufacturingUMQuantities" default="N" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This is an option to print manufacturing unit of measure quantities instead of stocking unit of measure quantities. Valid entries are Y(Yes) or N(No). Default is N - No.</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="IncludeMaintenanceJobs" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies if maintenance jobs should be included(I - Include, E - Exclude, O - Only). The default is I - Include.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="MaintenanceJobType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies if maintenance jobs should be included,which job type it should be filtered on (A - All, U - Unplanned, P - Planned ). The default is A - All</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="XslStylesheet" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Enter the name of the xsd Stylesheet to use</xsd:documentation>
</xsd:annotation>
<xsd:complexType/>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Filter" minOccurs="0">
<xsd:annotation>
<xsd:documentation>List of filters</xsd:documentation>
</xsd:annotation>
<xsd:complexType mixed="false">
<xsd:sequence>
<xsd:element name="LedgerCode" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies the ledger account control selection ( A - All, S - Single). If not provided the default is A. </xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" type="xsd:string" use="optional" default="A"/>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="Job" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies the selection of jobs ( A - All, S - Single, R - Range, L - List). If not provided the default is A. If R is selected then separated by a -. Example: 1-9</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" type="xsd:string" use="optional" default="A"/>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="JobClass" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies the job class selection ( A - All, S - Single). If not provided the default is A. </xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" type="xsd:string" use="optional" default="A"/>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="PlannedDeliveryDate" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies the selection of planned delivery date ( A - All, S - Single, R - Range). If not provided the default is A. If R is selected then separated by a -. Example: 08/26/02-09/26/02</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" type="xsd:string" use="optional" default="A"/>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="Customer" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies the selection of customers ( A - All, S - Single, R - Range, L - List). If not provided the default is A. If R is selected then separated by a -. Example: 1-9</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" type="xsd:string" use="optional" default="A"/>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="StockCode" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This specifies the selection of stock codes ( A - All, S - Single, R - Range, L - List). If not provided the default is A. If R is selected then separated by a -, .</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:attribute name="FilterType" type="xsd:string" use="optional" default="A"/>
<xsd:attribute name="FilterValue" type="xsd:string" use="optional"/>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
Output XML
The OUT.XML indicates a sample of the XML returned by this business object.
WIPQJVOUT.XML
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2024 SYSPRO Ltd.-->
<!--
Sample XML for the WIP Valuation Query Business Object
-->
<WipValuationQuery>
<SystemInformation>
<CssStyle/>
<Language>05</Language>
<DecFormat>1</DecFormat>
<DateFormat>01</DateFormat>
<Role>01</Role>
<Version>6.0.006</Version>
<CompanyId>0</CompanyId>
<CompanyName>The OUTDOORS Company</CompanyName>
<OperatorCode>ADMIN</OperatorCode>
<OperatorName>SYSPRO Administrator</OperatorName>
<OperatorGroup>ADMIN</OperatorGroup>
<OperatorEmailAddress/>
<OperatorLocation/>
<ReportDate>Friday December 2006 14:39 PM</ReportDate>
<UseSeparatorOnReports>N</UseSeparatorOnReports>
<SeparatorToUse>,</SeparatorToUse>
</SystemInformation>
<Job>
<JobNumber>00000157</JobNumber>
<JobDescription>Handle Bar Assembly</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>B113</StockCode>
<StockDescription>Handle Bar Assembly</StockDescription>
<LongDesc>Sub Assembly</LongDesc>
<Version/>
<Release/>
<Warehouse>SA</Warehouse>
<INVWHC_Description>Subassembly Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/05/26</JobDeliveryDate>
<JobStartDate>2006/04/12</JobStartDate>
<Complete>N</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>57.00000</ExpLabour>
<ExpMaterial>652.39000</ExpMaterial>
<QtyToMake>250.000</QtyToMake>
<QtyManufactured>0.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>0.00</HrsBookToDate>
<LabCostToDate>0.00</LabCostToDate>
<MatCostToDate>562.50</MatCostToDate>
<LabValueIssues>0.00</LabValueIssues>
<MatValueIssues>0.00</MatValueIssues>
</Job>
<Job>
<JobNumber>00000160</JobNumber>
<JobDescription>Handle Bar Assembly</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>B113</StockCode>
<StockDescription>Handle Bar Assembly</StockDescription>
<LongDesc>Sub Assembly</LongDesc>
<Version/>
<Release/>
<Warehouse>SA</Warehouse>
<INVWHC_Description>Subassembly Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/06/17</JobDeliveryDate>
<JobStartDate>2006/04/26</JobStartDate>
<Complete>N</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>57.00000</ExpLabour>
<ExpMaterial>652.39000</ExpMaterial>
<QtyToMake>300.000</QtyToMake>
<QtyManufactured>0.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>0.00</HrsBookToDate>
<LabCostToDate>0.00</LabCostToDate>
<MatCostToDate>675.00</MatCostToDate>
<LabValueIssues>0.00</LabValueIssues>
<MatValueIssues>0.00</MatValueIssues>
</Job>
<Job>
<JobNumber>00000164</JobNumber>
<JobDescription>Wet Work, Foundations</JobDescription>
<JobClassification>PC</JobClassification>
<ClassDescription>Projects and Contracts</ClassDescription>
<StockCode>Construction</StockCode>
<StockDescription>Wet Work, Foundations</StockDescription>
<LongDesc/>
<Version/>
<Release/>
<Warehouse>**</Warehouse>
<INVWHC_Description/>
<Customer>0000016</Customer>
<CustomerName>The OUTDOORS Company</CustomerName>
<JobDeliveryDate>2006/03/03</JobDeliveryDate>
<JobStartDate>2006/03/01</JobStartDate>
<Complete>N</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>0.00000</ExpLabour>
<ExpMaterial>0.00000</ExpMaterial>
<QtyToMake>1.000</QtyToMake>
<QtyManufactured>0.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>0.00</HrsBookToDate>
<LabCostToDate>0.00</LabCostToDate>
<MatCostToDate>6250.00</MatCostToDate>
<LabValueIssues>0.00</LabValueIssues>
<MatValueIssues>0.00</MatValueIssues>
</Job>
<Job>
<JobNumber>00000144</JobNumber>
<JobDescription>Racing Bicycle</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>LOT100</StockCode>
<StockDescription>Racing Bicycle</StockDescription>
<LongDesc>Parent - Lot Traceable</LongDesc>
<Version/>
<Release/>
<Warehouse>FG</Warehouse>
<INVWHC_Description>Finished Goods Warehouse</INVWHC_Description>
<Customer>0000001</Customer>
<CustomerName>Bayside Bikes</CustomerName>
<JobDeliveryDate>2006/03/01</JobDeliveryDate>
<JobStartDate>2006/12/31</JobStartDate>
<Complete>N</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>185.56000</ExpLabour>
<ExpMaterial>2794.99000</ExpMaterial>
<QtyToMake>100.000</QtyToMake>
<QtyManufactured>0.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>0.00</HrsBookToDate>
<LabCostToDate>0.00</LabCostToDate>
<MatCostToDate>3038.24</MatCostToDate>
<LabValueIssues>0.00</LabValueIssues>
<MatValueIssues>0.00</MatValueIssues>
</Job>
<Job>
<Master>Y</Master>
<JobNumber>00000146</JobNumber>
<JobDescription>Racing Bicycle</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>LOT100</StockCode>
<StockDescription>Racing Bicycle</StockDescription>
<LongDesc>Parent - Lot Traceable</LongDesc>
<Version/>
<Release/>
<Warehouse>FG</Warehouse>
<INVWHC_Description>Finished Goods Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/03/17</JobDeliveryDate>
<JobStartDate>2006/02/13</JobStartDate>
<Complete>Y</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>185.87000</ExpLabour>
<ExpMaterial>2688.75800</ExpMaterial>
<QtyToMake>50.000</QtyToMake>
<QtyManufactured>50.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>163.00</HrsBookToDate>
<LabCostToDate>9293.50</LabCostToDate>
<MatCostToDate>134529.55</MatCostToDate>
<LabValueIssues>9293.50</LabValueIssues>
<MatValueIssues>134526.40</MatValueIssues>
<Job>
<Sub>Y</Sub>
<JobNumber>00000147</JobNumber>
<JobDescription>Racing Bicycle</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>LOT111</StockCode>
<StockDescription>Racing Diamond Frame</StockDescription>
<LongDesc>Sub Assembly - Lot Traceable</LongDesc>
<Version/>
<Release/>
<Warehouse>SA</Warehouse>
<INVWHC_Description>Subassembly Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/02/11</JobDeliveryDate>
<JobStartDate>2006/01/28</JobStartDate>
<Complete>Y</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>79.20400</ExpLabour>
<ExpMaterial>539.50000</ExpMaterial>
<QtyToMake>50.000</QtyToMake>
<QtyManufactured>51.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>66.35</HrsBookToDate>
<LabCostToDate>3960.20</LabCostToDate>
<MatCostToDate>26900.65</MatCostToDate>
<LabValueIssues>3960.20</LabValueIssues>
<MatValueIssues>26900.65</MatValueIssues>
</Job>
<Job>
<MasterSub>Y</MasterSub>
<JobNumber>00000148</JobNumber>
<JobDescription>Racing Bicycle</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>LOT113</StockCode>
<StockDescription>Racing Handle Bar Assembly</StockDescription>
<LongDesc>Sub Assembly - Lot Traceable</LongDesc>
<Version/>
<Release/>
<Warehouse>SA</Warehouse>
<INVWHC_Description>Subassembly Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/02/11</JobDeliveryDate>
<JobStartDate>2006/02/02</JobStartDate>
<Complete>Y</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>57.00000</ExpLabour>
<ExpMaterial>652.39000</ExpMaterial>
<QtyToMake>50.000</QtyToMake>
<QtyManufactured>50.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>50.00</HrsBookToDate>
<LabCostToDate>2850.00</LabCostToDate>
<MatCostToDate>32810.50</MatCostToDate>
<LabValueIssues>2850.00</LabValueIssues>
<MatValueIssues>32810.50</MatValueIssues>
<Job>
<Sub>Y</Sub>
<JobNumber>00000151</JobNumber>
<JobDescription>Racing Bicycle</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>LOT1212</StockCode>
<StockDescription>Racing Bicycle Brake Assembly</StockDescription>
<LongDesc>Sub Assembly - Lot Traceable</LongDesc>
<Version/>
<Release/>
<Warehouse>SA</Warehouse>
<INVWHC_Description>Subassembly Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/01/29</JobDeliveryDate>
<JobStartDate>2006/01/26</JobStartDate>
<Complete>Y</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>31.35000</ExpLabour>
<ExpMaterial>182.79000</ExpMaterial>
<QtyToMake>50.000</QtyToMake>
<QtyManufactured>50.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>27.50</HrsBookToDate>
<LabCostToDate>1567.50</LabCostToDate>
<MatCostToDate>9330.50</MatCostToDate>
<LabValueIssues>1567.50</LabValueIssues>
<MatValueIssues>9330.50</MatValueIssues>
</Job>
</Job>
<Job>
<Sub>Y</Sub>
<JobNumber>00000149</JobNumber>
<JobDescription>Racing Bicycle</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>LOT114</StockCode>
<StockDescription>Racing Spoked Front Wheel</StockDescription>
<LongDesc>Sub Assembly - Lot Traceable</LongDesc>
<Version/>
<Release/>
<Warehouse>SA</Warehouse>
<INVWHC_Description>Subassembly Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/02/10</JobDeliveryDate>
<JobStartDate>2006/01/21</JobStartDate>
<Complete>Y</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>65.83200</ExpLabour>
<ExpMaterial>630.50000</ExpMaterial>
<QtyToMake>50.000</QtyToMake>
<QtyManufactured>50.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>57.80</HrsBookToDate>
<LabCostToDate>3291.60</LabCostToDate>
<MatCostToDate>31525.00</MatCostToDate>
<LabValueIssues>3291.60</LabValueIssues>
<MatValueIssues>31525.00</MatValueIssues>
</Job>
<Job>
<Sub>Y</Sub>
<JobNumber>00000150</JobNumber>
<JobDescription>Racing Bicycle</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>LOT115</StockCode>
<StockDescription>Racing Spoked Rear Wheel</StockDescription>
<LongDesc>Sub Assembly - Lot Traceable</LongDesc>
<Version/>
<Release/>
<Warehouse>SA</Warehouse>
<INVWHC_Description>Subassembly Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/02/10</JobDeliveryDate>
<JobStartDate>2006/01/21</JobStartDate>
<Complete>Y</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>65.83200</ExpLabour>
<ExpMaterial>593.50000</ExpMaterial>
<QtyToMake>50.000</QtyToMake>
<QtyManufactured>50.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>57.80</HrsBookToDate>
<LabCostToDate>3291.60</LabCostToDate>
<MatCostToDate>29675.00</MatCostToDate>
<LabValueIssues>3291.60</LabValueIssues>
<MatValueIssues>29675.00</MatValueIssues>
</Job>
</Job>
<Job>
<JobNumber>00000154</JobNumber>
<JobDescription>Racing Handle Bar Assembly</JobDescription>
<JobClassification/>
<ClassDescription/>
<StockCode>LOT113</StockCode>
<StockDescription>Racing Handle Bar Assembly</StockDescription>
<LongDesc>Sub Assembly - Lot Traceable</LongDesc>
<Version/>
<Release/>
<Warehouse>SA</Warehouse>
<INVWHC_Description>Subassembly Warehouse</INVWHC_Description>
<Customer/>
<CustomerName/>
<JobDeliveryDate>2006/04/29</JobDeliveryDate>
<JobStartDate>2006/04/12</JobStartDate>
<Complete>N</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>57.00000</ExpLabour>
<ExpMaterial>652.39000</ExpMaterial>
<QtyToMake>100.000</QtyToMake>
<QtyManufactured>0.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>0.00</HrsBookToDate>
<LabCostToDate>0.00</LabCostToDate>
<MatCostToDate>225.00</MatCostToDate>
<LabValueIssues>0.00</LabValueIssues>
<MatValueIssues>0.00</MatValueIssues>
</Job>
<Job>
<Master>Y</Master>
<JobNumber>00000165</JobNumber>
<JobDescription>Bicycle Special</JobDescription>
<JobClassification>QUOT</JobClassification>
<ClassDescription>Quotations Specials</ClassDescription>
<StockCode>Q100</StockCode>
<StockDescription>Bicycle Special</StockDescription>
<LongDesc/>
<Version/>
<Release/>
<Warehouse>**</Warehouse>
<INVWHC_Description/>
<Customer>0000001</Customer>
<CustomerName>Bayside Bikes</CustomerName>
<JobDeliveryDate>2006/04/20</JobDeliveryDate>
<JobStartDate>2006/03/08</JobStartDate>
<Complete>N</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>185.56000</ExpLabour>
<ExpMaterial>3072.47635</ExpMaterial>
<QtyToMake>100.000</QtyToMake>
<QtyManufactured>0.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>0.00</HrsBookToDate>
<LabCostToDate>0.00</LabCostToDate>
<MatCostToDate>0.00</MatCostToDate>
<LabValueIssues>0.00</LabValueIssues>
<MatValueIssues>0.00</MatValueIssues>
<Job>
<Sub>Y</Sub>
<JobNumber>00000166</JobNumber>
<JobDescription>Special Seat</JobDescription>
<JobClassification>QUOT</JobClassification>
<ClassDescription>Quotations Specials</ClassDescription>
<StockCode>Q103</StockCode>
<StockDescription>Special Seat</StockDescription>
<LongDesc/>
<Version/>
<Release/>
<Warehouse>**</Warehouse>
<INVWHC_Description/>
<Customer>0000001</Customer>
<CustomerName>Bayside Bikes</CustomerName>
<JobDeliveryDate>2006/03/04</JobDeliveryDate>
<JobStartDate>2006/01/26</JobStartDate>
<Complete>N</Complete>
<HoldFlag>N</HoldFlag>
<ExpLabour>171.00000</ExpLabour>
<ExpMaterial>64.25000</ExpMaterial>
<QtyToMake>100.000</QtyToMake>
<QtyManufactured>0.000</QtyManufactured>
<Route>0</Route>
<BOMROU_Description>Factory Main Routing</BOMROU_Description>
<ConfirmedFlag>Y</ConfirmedFlag>
<WipCtlGlCode>01-1510</WipCtlGlCode>
<HrsBookToDate>0.00</HrsBookToDate>
<LabCostToDate>0.00</LabCostToDate>
<MatCostToDate>0.00</MatCostToDate>
<LabValueIssues>0.00</LabValueIssues>
<MatValueIssues>0.00</MatValueIssues>
</Job>
</Job>
</WipValuationQuery>
Prerequisites
No prerequisites are required to use this business object.
Limitations
No limitations apply to this business object.
Copyright © 2026 Syspro PTY Ltd.