WMS 810 ER024-028: Difference between revisions
From Calidus HUB
(Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|WMS}} {{ERHeader |SystemVersion=WMS 810 |ERNumber=ER024-028 }} {{ERTableHeader}} {{ERTableRow |AT_EDI_SALES_ORDER_DETAIL_344287...") |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 11: | Line 11: | ||
|Alter Table Script | |Alter Table Script | ||
|4.1 | |4.1 | ||
| | |348046 | ||
| | |PO 106282 | ||
| | |3 | ||
| | |Initial release for log 344287 - more to follow. | ||
| | |||
Please note that an additional change has been made to remove code that set a negative available total to zero if the CASB rule is Y or the Stock Snapshot Include in Free Qty flag is set to Y. | |||
In order to zero a negative available total the ANAT owner rule should be set to N or should not be set up. | |||
For the DDU format stock snapshot to work the ANAT owner rule MUST be set to Y to enable the GRN Free Quantities to be calculated correctly, however, the DDU format will then zero any negative quantities. | |||
|Sue Blake | |||
}} | }} | ||
{{ERTableRow | {{ERTableRow | ||
| Line 209: | Line 215: | ||
{{ERTableFooter}} | {{ERTableFooter}} | ||
<table border="1px" width="100%"> | |||
<tr> | |||
<td colspan="3" bgcolor="silver"><font size="2">'''Registry/Rules Settings'''</font></td> | |||
</tr> | |||
<tr> | |||
<td bgcolor="silver"><font size="2">'''Path & Name'''</font></td> | |||
<td bgcolor="silver"><font size="2">'''Setting Value'''</font></td> | |||
<td bgcolor="silver"><font size="2">'''Result'''</font></td> | |||
</tr> | |||
<tr> | |||
<td>ANAT Owner Rule</td> | |||
<td>Y</td> | |||
<td>Allows negative available totals on stock snapshot. This is required to allow quantities to be calculated correctly when adding on pre-advised quantities in the DDU format snapshot. Any negative quantities will be reported as 0 after the calculations have been performed.</td> | |||
</tr> | |||
<tr> | |||
<td>CASB Owner Rule</td> | |||
<td>Y</td> | |||
<td>Subtracts committed quantities from available total.</td> | |||
</tr> | |||
<tr> | |||
<td>DNCC Owner Rule</td> | |||
<td>Y</td> | |||
<td>Reports three character currency code as a suffix on the GEN format despatch note instead of having the currency symbol as a prefix.</td> | |||
</tr> | |||
<tr> | |||
<td>SSMG Owner Rule</td> | |||
<td>000-999</td> | |||
<td>Optional. If set up this should be set to a three digit number (including leading zeroes, e.g. 005 not 5). This will then be the maximum number of GRNs to be included in the DDU format stock snapshot. If the rule is not set or is not set to a valid value this defaults to 10.</td> | |||
</tr> | |||
</table> | |||
<noinclude> | <noinclude> | ||
[[Category:{{#var:System}} ER]] | [[Category:{{#var:System}} ER]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 12:42, 19 December 2017
EMERGENCY RELEASE - WMS 810
RELNOTE ER024-028
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks | Reporter |
| AT_EDI_SALES_ORDER_DETAIL_344287.sql | Alter Table Script | 4.1 | 348046 | PO 106282 | 3 | Initial release for log 344287 - more to follow.
Please note that an additional change has been made to remove code that set a negative available total to zero if the CASB rule is Y or the Stock Snapshot Include in Free Qty flag is set to Y. In order to zero a negative available total the ANAT owner rule should be set to N or should not be set up. For the DDU format stock snapshot to work the ANAT owner rule MUST be set to Y to enable the GRN Free Quantities to be calculated correctly, however, the DDU format will then zero any negative quantities. |
Sue Blake |
| AT_EDI_SALES_ORDER_MASTER_344287.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_ORDER_DETAIL_344287.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_ORDER_HEADER_344287.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| AT_STK_STOCKIST_344287.sql | Alter Table Script | 4.1 | " | " | " | " | " |
| DATA_DYNAMIC_MESSAGES_344287.sql | Data Script | 4.1 | " | " | " | " | " |
| DATA_EDI_MAPS_344287.sql | Data Script | 4.1 | " | " | " | " | " |
| DATA_FILE_TEMPLATE_344287.sql | Data Script | 4.1 | " | " | " | " | " |
| DATA_FILE_TEMPLATE_VALUES_344287.sql | Data Script | 4.1 | " | " | " | " | " |
| DATA_WAREHOUSE_RULES_CONTROL_344287.sql | Data Script | 4.1 | " | " | " | " | " |
| DP_EDI_OUTBOUND.sql | Outbound EDI | 4.99 | " | " | " | " | " |
| DP_EDIGEN_OUT_PDP_CONF.sql | Outbound EDI DESP message | 4.87 | " | " | " | " | " |
| DP_EDIGEN_OUT_ST_BAL.sql | Stock Snapshot | 4.76 | " | " | " | " | " |
| DP_EDIGEN_PRE_ADVICE_LOAD.sql | Pre-Advice Upload | 4.38 | " | " | " | " | " |
| DP_EDIGEN_PRE_ADVICE_VAL.sql | Sales Order upload | 4.62 | " | " | " | " | " |
| DP_EDIGEN_SALES_ORDER_LOAD.sql | Sales Order Upload | 4.202 | " | " | " | " | " |
| DP_EDIGEN_SALES_ORDER_LOAD_2.sql | Sales Order Upload | 4.2 | " | " | " | " | " |
| DP_EDIGEN_SALES_ORDER_VAL.sql | Sales Order Upload | 4.175 | " | " | " | " | " |
| PFS1541.fmx | EDI Sales Order Processing | 4.34 | " | " | " | " | " |
| STS1000.fmx | Owner Maintenance | 4.103 | " | " | " | " | " |
| Registry/Rules Settings | ||
| Path & Name | Setting Value | Result |
| ANAT Owner Rule | Y | Allows negative available totals on stock snapshot. This is required to allow quantities to be calculated correctly when adding on pre-advised quantities in the DDU format snapshot. Any negative quantities will be reported as 0 after the calculations have been performed. |
| CASB Owner Rule | Y | Subtracts committed quantities from available total. |
| DNCC Owner Rule | Y | Reports three character currency code as a suffix on the GEN format despatch note instead of having the currency symbol as a prefix. |
| SSMG Owner Rule | 000-999 | Optional. If set up this should be set to a three digit number (including leading zeroes, e.g. 005 not 5). This will then be the maximum number of GRNs to be included in the DDU format stock snapshot. If the rule is not set or is not set to a valid value this defaults to 10. |
