View source for EST 336598 Zenith Back Orders

{{Estimate_Head
|Client=ZEN
|Project=DEV
|Site=WHG
|ClientRef=N/A
|OBSRef=336598
|Version=0.2
|Author=A N Walker
|PONum=&nbsp;
|Priority=3
|Date=12/07/2016
|Customer=N/A
|SysVer=3.X
|ClientRequest='''Requirement 1:'''

Back-order lines must be displayed on the POD note.

'''Requirement 2:'''

It is not always clear whether a product was not despatched or not delivered using the current POD format. This will be changed to display the Ordered, Despatched and Delivered quantities.

|Solution={{Note}} All changes to the POD will be made to both the Priced and Unpriced formats.

'''Requirement 1:'''

Sage currently handles this requirement by adding product lines to an order, containing the free text describing the back order status.

Sage will pass through additional product lines that have various levels of information
* Product Code - set if this is a back-order line for the product
* Description - the quantity back-ordered or the back-order reference, for example "Fully Back-Ordered for 1", "** Back-order to follow : XXXXXXX/1 **"
* Status - set to "C" - Complete.
* Sequence - This will be set as the same sequence as the line to which it pertains (for back ordered quantities) or 9000, plus 1 for each new back order reference line, e.g. 9001, 9002, etc.


The Inbound webservice will be changed to allow the user to set a line to completed status - this will ensure that these lines are never prompted for the driver to deliver. The change to the webservice format (XSD) will be passed through to the Sage team for modification after sign-off of this change. 


All product lines on the POD will be ordered by Sequence, ensuring that the new lines will always appear at the end. The sequence should ensure that the line displaying the ordered, despatched and delivered quantity appears first, then the line for the back-ordered qty. Any back-order references should appear at the end after all product and back-order lines.


'''Requirement 2:'''

Sage will pass through the Ordered values for each product line.

A "QTY DESP" column will be added after the existing column "QTY ORD". This will be populated from the planned quantities.

The existing "QTY ORD" column will be changed so that this is populated from the Ordered quantities.


The changes for both requirements will result with c change to the product table on the POD form as per the following example:

<table border="1px">
<tr>
<td bgcolor="silver"><font size="2">'''PRODUCT<br/>CODE'''</font></td>
<td bgcolor="silver"><font size="2">'''PRODUCT&nbsp;DESCRIPTION'''</font></td>
<td bgcolor="silver"><font size="2">'''QTY<br/>ORD'''</font></td>
<td bgcolor="silver"><font size="2">'''QTY<br/>DESP'''</font></td>
<td bgcolor="silver"><font size="2">'''QTY<br/>DEL'''</font></td>
</tr><tr>
<td>WG 011000 </td><td> HARD WATER M/C DETERGENT </td><td> 1 </td><td> 1 </td><td> 1 
</td></tr><tr>
<td>WG 100900 </td><td> ULTRA FLOOR CLEANER </td><td> 6 </td><td> 4 </td><td> 3
</td></tr><tr>
<td>WG 100900 </td><td> Fully Back-ordered for 2 </td><td> 0 </td><td> 0 </td><td> 0
</td></tr><tr>
<td>WG 020500 </td><td> PEBBLE SALT </td><td> 1 </td><td> 1 </td><td> 1
</td></tr><tr>
<td>WG 121700S </td><td> CLOTHS ALL PURPOSE BLUE </td><td> 1 </td><td> 1 </td><td> 1
</td></tr><tr>
<td>190700 </td><td> WINDOW SQUEEGEE 14" WITH HANDLE </td><td> 1 </td><td> 0 </td><td> 0
</td></tr><tr>
<td>190700 </td><td> Fully Back-ordered for 1 </td><td> 0 </td><td> 0 </td><td> 0
</td></tr><tr>
<td></td><td> ** Back-order to follow : XXXXXXX/1 ** </td><td> 0 </td><td> 0 </td><td> 0
</td></tr></table>


All other elements of the POD reports, including all other elements on the Product table, will remain unchanged.

}}

{{EstimateCostDetails
|REQ=0
|EST=0.5
|FS=0.5
|TS=0.5
|DEV=2.0
|ST=0.5
|IMP=0.25
|PM=0.25
|Client=ZEN
|Year=2016
|FOC=N
}}

<table width="100%">
<tr><td align="center"><font size="1">
Copyright © OBS Logistics 2016.<br />
This estimate has an expiry date of 30 days from the specified Estimate Date.<br />
The information contained herein is supplied without liability for errors or omissions.
</font></td></tr></table>
[[Category:ZEN EST]]