BOMQA5: ABC Recoveries Estimate Report
The ABC Recoveries Estimate Report business object was primarily written to support an SRS report.
Properties
| Syspro Module | Bill of Materials |
| Class | Query |
| Methods | Query |
| Functional Area | Bill of Material Primary Query |
| Initial version released | Syspro 7 Update 1 |
Input XML
The .XML and .XSD input files indicate the parameters schema and an instance of an XML document for this business object.
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2014 SYSPRO Ltd.-->
<!--
Sample XML for the ABC Recoveries Estimate Report
-->
<Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="BOMQA5.XSD">
<Key>
<StockCode>ABC300</StockCode>
</Key>
<Option>
<ExplosionLevel>S</ExplosionLevel>
<ReportType>D</ReportType>
<Route>0</Route>
<Version></Version>
<Release></Release>
<Quantity>15</Quantity>
</Option>
</Query>
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2014 SYSPRO Ltd.-->
<!--
Schema for ABC Recoveries Estimate Report Business Object
-->
<xsd:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<xsd:element name="Query">
<xsd:annotation>
<xsd:documentation>This is the root element. You use the ABC Recoveries Estimate Report program to produce a what-if report of the estimated ABC recoveries based on the elements held against the stock item entered and the quantities of the product specified.
The report can be used to access the units likely to be recovered as a basis for rate setting. In addition, you can use the program to estimate appropriate recovery rates per element.
You will be unable to access this program if you have not implemented AB Costing (i.e. you selected No at the option: Activity based costing required (Bill of Materials Setup)).
. Maximum length 1 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Key">
<xsd:annotation>
<xsd:documentation>This element contains all the relevant information to query activity based cost stock code. Maximum length 1 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="StockCode">
<xsd:annotation>
<xsd:documentation>You use this field to indicate the stock code you want to add to the list.. Maximum length 30 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Option">
<xsd:annotation>
<xsd:documentation>This element contains the query options available. Maximum length 1 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element default="S" name="ExplosionLevel">
<xsd:annotation>
<xsd:documentation>S - Single - Select this to print recovery details only for first level items within a structure that are detected in the import file.
M - Multi - Select this to print recovery details accumulated from all levels of a structure that are detected in the import file.
. Maximum length 1 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
<xsd:enumeration value="S" />
<xsd:enumeration value="M" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element default="D" name="ReportType">
<xsd:annotation>
<xsd:documentation>This option enables you to indicate the type of report you want to generate. Maximum length 1 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
<xsd:enumeration value="D" />
<xsd:enumeration value="S" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Route">
<xsd:annotation>
<xsd:documentation>You use this field to select the specific route for which you want to print overhead recovery costs against an item. This enables you to establish the recovery costs of an item for a number of different routes.. Maximum length 2 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Version">
<xsd:annotation>
<xsd:documentation>You use this field to indicate the revision of and ECC-controlled stock code you want to add to the list.. Maximum length 5 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Release">
<xsd:annotation>
<xsd:documentation>You use this field to indicate the release of and ECC-controlled stock code you want to add to the list.. Maximum length 5 of type Alphanumeric</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="Quantity">
<xsd:annotation>
<xsd:documentation>You use this field to indicate the quantity of the stock item for which you want to print a report estimating the expected overhead recoveries.. Maximum length 12,6 of type Numeric</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:whiteSpace value="preserve" />
</xsd:restriction>
</xsd:simpleType>
</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.
Copy
<?xml version="1.0" encoding="Windows-1252"?>
<!-- Copyright 1994-2014 SYSPRO Ltd.-->
<!--
Sample XML for the ABC Estimates Query Business Object
-->
<ABCEstimatesQuery xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="BOMQA5OUT.XSD">
<QueryOptions>
<StockCode>ABC100</StockCode>
<ExplosionLevel>M</ExplosionLevel>
<ReportType>D</ReportType>
<Route>0</Route>
<Version/>
<Release/>
<Quantity>50.000000</Quantity>
</QueryOptions>
<ReportDetail>
<Elements>
<Line>
<Level>01</Level>
<StockCode>ABC110</StockCode>
<StockDescription/>
<Route/>
<Sequence>000000</Sequence>
<CompQtyPer>5.000000</CompQtyPer>
<EBQ>1.000000</EBQ>
<Element>M-STOR</Element>
<IncidentCode>M</IncidentCode>
<CalculationMethod>B</CalculationMethod>
<DriverQty>0.5000</DriverQty>
<Rate>0.0000</Rate>
<ComponentValue>0.00000</ComponentValue>
<ParentValue>0.00000</ParentValue>
</Line>
<Line>
<Level>02</Level>
<StockCode>ABC111</StockCode>
<StockDescription/>
<Route/>
<Sequence>000000</Sequence>
<CompQtyPer>5.000000</CompQtyPer>
<EBQ>1.000000</EBQ>
<Element>P-GIIN</Element>
<IncidentCode>P</IncidentCode>
<CalculationMethod>I</CalculationMethod>
<DriverQty>0.3000</DriverQty>
<Rate>0.0000</Rate>
<ComponentValue>0.00000</ComponentValue>
<ParentValue>0.00000</ParentValue>
</Line>
<Line>
<Level>02</Level>
<StockCode>ABC111</StockCode>
<StockDescription/>
<Route/>
<Sequence>000000</Sequence>
<CompQtyPer>5.000000</CompQtyPer>
<EBQ>1.000000</EBQ>
<Element>P-PURC</Element>
<IncidentCode>P</IncidentCode>
<CalculationMethod>S</CalculationMethod>
<DriverQty>0.3000</DriverQty>
<Rate>0.0000</Rate>
<ComponentValue>0.00000</ComponentValue>
<ParentValue>0.00000</ParentValue>
</Line>
<Line>
<Level>01</Level>
<StockCode>ABC112</StockCode>
<StockDescription/>
<Route/>
<Sequence>000010</Sequence>
<CompQtyPer>1.000000</CompQtyPer>
<EBQ>1.000000</EBQ>
<Element>P-GIIN</Element>
<IncidentCode>P</IncidentCode>
<CalculationMethod>I</CalculationMethod>
<DriverQty>0.4000</DriverQty>
<Rate>0.0000</Rate>
<ComponentValue>0.00000</ComponentValue>
<ParentValue>0.00000</ParentValue>
</Line>
<Line>
<Level>01</Level>
<StockCode>ABC112</StockCode>
<StockDescription/>
<Route/>
<Sequence>000010</Sequence>
<CompQtyPer>1.000000</CompQtyPer>
<EBQ>1.000000</EBQ>
<Element>P-PURC</Element>
<IncidentCode>P</IncidentCode>
<CalculationMethod>S</CalculationMethod>
<DriverQty>0.2000</DriverQty>
<Rate>0.0000</Rate>
<ComponentValue>0.00000</ComponentValue>
<ParentValue>0.00000</ParentValue>
</Line>
</Elements>
<Estimates>
<StockCode>ABC100</StockCode>
<StockDescriptions>Product A - Final Assembly</StockDescriptions>
<Route>0</Route>
<Uom>EA</Uom>
<Quantity>50.000000</Quantity>
<Line>
<Element>M-STOR</Element>
<CalculatedMethod>B</CalculatedMethod>
<Rate>0.0000</Rate>
<UnitQuantity>2.500000</UnitQuantity>
<ExtendedQuantity>2.500000</ExtendedQuantity>
<ExtendedValue>0.00</ExtendedValue>
</Line>
<Line>
<Element>P-GIIN</Element>
<CalculatedMethod>I</CalculatedMethod>
<Rate>0.0000</Rate>
<UnitQuantity>1.900000</UnitQuantity>
<ExtendedQuantity>95.000000</ExtendedQuantity>
<ExtendedValue>0.00</ExtendedValue>
</Line>
<Line>
<Element>P-PURC</Element>
<CalculatedMethod>S</CalculatedMethod>
<Rate>0.0000</Rate>
<UnitQuantity>1.700000</UnitQuantity>
<ExtendedQuantity>1.700000</ExtendedQuantity>
<ExtendedValue>0.00</ExtendedValue>
</Line>
</Estimates>
</ReportDetail>
<ReportSummary>
<Line>
<Element>M-STOR</Element>
<Description>Stores Issuing</Description>
<RecoveryQuantity>2.5000</RecoveryQuantity>
<Rate>0.0000</Rate>
<RecoveryValue>0.00</RecoveryValue>
<CalculationMethod>B</CalculationMethod>
<Narrations>
<Narration>Element is calculated on</Narration>
<Narration>amount of handling</Narration>
<Narration>0-3: Hand delivery</Narration>
<Narration>4-6: Light mechanical (Fork</Narration>
<Narration>Lift)</Narration>
<Narration>7-9: Heavy mechnical (Crane)</Narration>
</Narrations>
</Line>
<Line>
<Element>P-GIIN</Element>
<Description>Goods in Inspection</Description>
<RecoveryQuantity>95.0000</RecoveryQuantity>
<Rate>0.0000</Rate>
<RecoveryValue>0.00</RecoveryValue>
<CalculationMethod>I</CalculationMethod>
<Narrations>
<Narration>Element calculation to be on</Narration>
<Narration>percentage of inspection</Narration>
<Narration>required:</Narration>
<Narration>e.g. 0.2 = 20% inspection</Narration>
<Narration>required.</Narration>
</Narrations>
</Line>
<Line>
<Element>P-PURC</Element>
<Description>Purchasing</Description>
<RecoveryQuantity>1.7000</RecoveryQuantity>
<Rate>0.0000</Rate>
<RecoveryValue>0.00</RecoveryValue>
<CalculationMethod>S</CalculationMethod>
<Narrations>
<Narration>Element calculated as</Narration>
<Narration>follows:</Narration>
<Narration>0-3: Reliable Supplier</Narration>
<Narration>4-6: Fairly reliable Supplier</Narration>
<Narration>7-9: Unreliable Supplier</Narration>
</Narrations>
</Line>
</ReportSummary>
</ABCEstimatesQuery>
Prerequisites
No prerequisites are required to use this business object.
Limitations
No limitations apply to this business object.
Copyright © 2026 Syspro PTY Ltd.