View source for NOMS

{{Incomplete}}The purpose of this guide is to gather together all information regarding NOMS processes, NOMS-specific screens, generic required screens and their usage.

= Overview =

== Warehouse / Owner codes ==
Company_code = DHL

Owner / stockist_code = ‘E55’

[[File:NOMS-Warehouses.png]]

== Areas that Differ from Standard WMS. ==
Orders are entered by prisoners.  A superuser then assigns these to a route/load using pick wave maintenance.   The wave is allocated and pick listed from pick wave maint.  Orders are then pick confirmed by order num – prisoners do this. Only Superusers can zero pick confirm.  When all orders are pick confirmed, the route/load is despatched confirmed and the delivery manifest printed.

They have a location set up BF01A, a buffer location. All stock should be held in this location and it equates to stock carried around in the delivery vans.

* Pick lists and despatch receipts are produced on Star printers using database packages DP_NOMS_* . The output to these are put in /tmp on the datbase server. 
* For customer upload configurable edi is used.      DP_CONF_EDI_IN.   (owner rule     NOMS = Y )
* For stock upload the standard product upload is used.       DP_EDIGEN_PROD_VAL
* New simple order entry (SOS7000) which included credit checks to ensure each customer (prisoner) has sufficient credit to place order.
* Streamlined pick confirmation  if user is set up as security level 1.  Tote references must be entered and despatch receipts printed from here.
* Goods receipt.  RIAR owner rule = Y and putaway algo = U.   This means at goods receipt pallet ids are generated even though the stock is put into non palletised     locations. When the goods are putaway confirmed the pallet id is removed.

== Menus ==
* Administration
** [[FXMUSER_SIMP]] - Users
* Maintenance
*** [[WHSORA035]] - Customer
*** [[STS1000]] - Owner Rules
** [[SOPSTER01A]] - Sales Territory
** [[WHS0825]] - Prison Master Maintenance
** [[WHS0096]] - Route Code Maintenance
** [[STKPRCC02A]] - Product Class Maintenance
** [[STKSTOC03]] - NOMS Stock Maintenance
** [[STKSTOC01B]] - Stock Maintenance 
** [[STS1085]] - Standard Cost Maintenance
** [[STS1090]] - Selling Price Maintenance
* [[SOS7100]] - Deals
* Goods In
** [[WHS0150]] - GR Conf
* Orders
** [[SOS7000]] - Simple Order Entry (NOMS)
** [[LAS0312]] - Pick Wave
** [[WHS1714]] - Pick Conf
** [[WHS1910]] - Despatch Confirmation
** [[SOS7050]] - Order Returns
* Stock Management
** [[WHS0544_NOM]] - NOMS Stock Take
** [[POS1020]] - Stock Demand Status
** [[POS1021]] - Stock Demand Processing
* Enquiries
** [[ENQSOON01A]] - Enquiry by Order Number
* Reports
** [[WHS1701]] - Manifest Pre Spends Report
** [[SOS7055]] - Amendment Report
** [[WHS1901]] - Despatch Manifest
** [[WHS1705]] - Replenishment Report
** [[WHS1902]] - Despatch Spends Report
** [[WHS1903]] - Order Spends Report
** [[WHS0827]] - Stock Ordering Downloads


= Administration =

== [[FXMUSER_SIMP]] - Users ==
{{:FXMUSER SIMP}}

= Maintenance =

== Prerequisites ==
{{Incomplete}}
Setup and enabled warehouse code (and associated configuration) 

=== Warehouse ===

=== [[WHSORA035]] - Customer ===
Prisoners are held as Customers in the system

You must enter the basic Customer Details (customer name), currency, Addrss type DEL, address details, Sales Territory and Sales Area.<center>
[[File:NOMS-Customer.png]]
</center>

=== [[STS1000]] - Owner Rules ===
The Owner rule NOMS must be set to Y.<center>
[[File:NOMS-OwnerRules.png]]
</center>

== [[SOPSTER01A]] - Sales Territory ==
Initially a SALES TERRITORY record is created – this will be the 'prison name'.<center>
[[File:SOPSTER01A.png]]
</center>

== [[WHS0825]] - Prison Master Maintenance ==
A Prison record is entered in Prison Maintenance – the prison code is validated against Sales Territory.<center>
[[File:WHS0825.png|800x800px]]
</center>Against the Prison record, there is also Stock Demand functionality <center>
[[File:WHS0823-Stock.png|800x800px]]
</center>

== [[WHS0096]] - Route Code Maintenance ==
A route code is also created to match the prison name.<center>
[[File:WHS0086-NOMS.png|800x800px]]
</center>

== [[STKPRCC02A]] - Product Class Maintenance ==
{{:STKPRCC02A}}

== [[STKSTOC03]] - NOMS Stock Maintenance ==
{{:STKSTOC03}}

== Stock Maintenance ([[STKSTOC01B]]) ==
Stock will always be setup against units, so 1 will represent a single item, never a box or case.<center>
[[File:NOMS-Stock.png|898x898px]]
</center>The stock code must always have a pick anchor point setup <center>
[[File:NOMS-Stock2.png]]
</center>

== [[STS1085]] - Standard Cost Maintenance ==
{{:STS1085}}

== [[STS1090]] - Selling Price Maintenance ==
A Stock code must have a selling price setup{{:STS1090}}

= [[SOS7100]] - Deals =
{{:SOS7100}}

= Goods In =

== [[WHS0150]] - GR Conf ==
{{:WHS0150}}

= Orders =

== Simple Order Entry (NOMS) (SOS7000) ==
{{:SOS7000}}

== [[OBS7000]] - NOMS order entry ==

== [[LAS0312]] - Pick Wave ==
{{Note|See the Pick Wave screen [[LAS0312]] documentation for more details on the process of Pick Wave building, Allocation and Pick List.}}
Order is then assigned to a pick wave. Note the route code matches the prison name.<center>
[[File:NOMS-PickWave.png]]
</center>


Pick wave is allocated.<center>
[[File:NOMS-Allocation.png]]
</center>


Pick wave is pick listed.<center>
[[File:NOMS-PickList.png]]
</center>The order is now available for pick confirmation.

== [[WHS1714]] - Pick Conf ==
{{Note|See the Pick Confirmation screen [[WHS1714]] documentation for more details on the process of Pick Confirmation.}}
Order is Pick Confirmed<center>
[[File:NOMS-PickConf.png]]
</center>

== [[WHS1910]] - Despatch Confirmation ==
{{Note|See the Despatch Confirmation screen [[WHS1910]] documentation for more details on the process of Despatch Confirmation.}}
Order/Pick wave is despatch confirmed.<center>
[[File:NOMS-DespConf.png]]
</center>The Order Header record is updated to status 9 (despatched) as expected. 

As the order has not been short picked or short despatched, the Order Detail table’s values are the same as before, just order status is updated as expected. 

=== Short Despatch ===
An example of an order which is short despatched containing deals

Order D1P00000000000023853 is created with 1 line of DEALS10, a deal which has a £0.15 deal per item ordered.<center>
[[File:NOMS-24.png|800px]]
</center>Order Header
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
! CUST CODE
!NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
|-
|D1P00000000000023853
|1
|PRISONER
|1.70
|1.70
|Y
|0.30
|}Order Detail - shows 2 units ordered, and both are involved in the deal
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
|-
|1
|1
|DEALS10
|2
|1.00
|Y
|2
|}Order Detail Deal has 2 lines, as the deal is unit based, so 2 units ordered, 2 deals generated .
{| class="wikitable" border="1"
! ORDER NUM
!LINE NO
!STOCKIST CODE
!STOCKIST SUB CODE
!STOCK CODE
!DEAL NAME
!DEAL QTY
!DEAL NUM
!PRICE ORDER UOM
!DEAL DISCOUNT
|-
|D1P00000000000023853
|1
|D1P
|001
|DEALS10
|DEALS10
|1
|1
|1.00
|0.15
|-
| D1P00000000000023853
|1
|D1P
|001
|DEALS10
|DEALS10
|1
| 2
|1.00
|0.15
|}The order is then assigned to pick wave DIF/00257<center>
[[File:NOMS-25.png|800px]]
</center>Picked qty reduced from 0/2 to 0/1 - so reducing deals from 2 to 1 (as deal is unit based)<center>
[[File:NOMS-26.png|800px]]
</center>Even though picked quantity has been reduced, the deal quantity will not be downdated till order is despatched.

As such, order information looks like this:

Order Header
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
!CUST CODE
! NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
|-
|D1P00000000000023853
|6
|PRISONER
|1.70
|1.70
|Y
|0.30
|}Order Detail - shows 2 units ordered, and both are involved in the deal
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
|-
|1
|6
|DEALS10
|2
|1.00
|Y
|2
|}Order Detail Deal has 2 lines, as the deal is unit based, so 2 units ordered, 2 deals generated .
{| class="wikitable" border="1"
!ORDER NUM
!LINE NO
!STOCKIST CODE
!STOCKIST SUB CODE
!STOCK CODE
!DEAL NAME
!DEAL QTY
!DEAL NUM
!PRICE ORDER UOM
!DEAL DISCOUNT
|-
|D1P00000000000023853
|1
|D1P
|001
|DEALS10
|DEALS10
|1
|1
|1.00
|0.15
|-
|D1P00000000000023853
|1
|D1P
|001
|DEALS10
|DEALS10
|1
|2
|1.00
|0.15
|}Pick wave / order is despatched.<center>
[[File:NOMS-27.png|800px]]
</center>Order Header now shows discount value as £0.15 instead of £0.30
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
!CUST CODE
!NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
|-
|D1P00000000000023853
|9
|PRISONER
|1.70
|1.70
|Y
|0.15
|}Order Detail now shows a 'On Deal Qty' of 1 rather than 2
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
|-
|1
|9
|DEALS10
|2
|1.00
|Y
|1
|}Order Detail Deals now only has 1 record.
{| class="wikitable" border="1"
!ORDER NUM
!LINE NO
!STOCKIST CODE
!STOCKIST SUB CODE
!STOCK CODE
!DEAL NAME
!DEAL QTY
!DEAL NUM
!PRICE ORDER UOM
!DEAL DISCOUNT
|-
|D1P00000000000023853
|1
|D1P
|001
|DEALS10
|DEALS10
|1
|1
|1.00
|0.15
|}
The user can then run the prison's despatch manifest, as shown below.

== [[SOS7050]] - Order Returns ==
{{:SOS7050}}

== Order Return and Amendment Examples ==
<center>
[[File:NOMS-30.png|800px]]
</center>*'Return Whole Order' - the order is set to zero.
*'Amendments' - this can be positive or negative. User can even add a stock line to the order that was not in the original order.
An example, the user orders a Twix chocolate bar, but 'amends' the order to return the Twix and instead gets a Mars bar.

=== Example: Return Whole Order ===
Order D1P00000000000023854 is created with 2 lines and contains 2 deals.<center>
[[File:NOMS-31.png|800px]]
</center>Order is allocated/picked and despatched<center>
[[File:NOMS-32.png|800px]]
</center>Order Header - shows the following data
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
!CUST CODE
! NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
|-
| D1P00000000000023854
|9
|PRISONER
|2.35
|2.35
|Y
|0.30
|}Order Detail - shows the following data
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
|-
|1
|9
|SC01
| 1
|0.65
|N
|0
|-
|2
|9
|DEALS10
|2
|1.00
|Y
|2
|}Order Detail Deals- shows both deals
{| class="wikitable" border="1"
!ORDER NUM
!LINE NO
!STOCKIST CODE
!STOCKIST SUB CODE
!STOCK CODE
!DEAL NAME
!DEAL QTY
!DEAL NUM
! PRICE ORDER UOM
!DEAL DISCOUNT
|-
|D1P00000000000023854
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|1
|1.00
|0.15
|-
|D1P00000000000023854
|2
|D1P
| 001
|DEALS10
|DEALS10
|1
|2
|1.00
|0.15
|}The following 2 tables are created at despatch

Despatch_OH
{| class="wikitable" border="1"
! '''WAREHOUSE_ID'''
!NFT
|-
| '''OWNER_CODE'''
|D1P
|-
| '''OWNER_SUB_CODE'''
|001
|-
|'''ORDER_NUM'''
|D1P00000000000023854
|-
|'''DESPATCH_DATE'''
|03/01/2024 14:47:41
|-
|'''SALES_TERRITORY'''
|DIF
|-
|'''SALES_AREA'''
|01/01/01
|-
|'''CUST_CODE'''
|PRISONER
|-
|'''CUSTOMER_SUB_AC_NO'''
|001
|-
|'''DELIVERY_ADDRESS_NO'''
|1
|-
|'''CONTAINS_DEAL'''
|Y
|-
|'''DISCOUNT_VALUE'''
|0.30
|-
|'''ORIG_DISCOUNT_VALUE'''
|0.30
|-
|'''AMEND_CONTAIN_DEAL'''
|
|-
|'''AMEND_DISCOUNT_VALUE'''
|
|}Despatch_OD
{| class="wikitable" border="1"
!'''WAREHOUSE_ID'''
!NFT
!NFT
|-
|'''OWNER_CODE'''
|D1P
|D1P
|-
|'''OWNER_SUB_CODE'''
|001
|001
|-
|'''ORDER_NUM'''
|D1P00000000000023854
|D1P00000000000023854
|-
|'''LINE_NO'''
|1
|2
|-
|'''STOCKIST_CODE'''
|D1P
|D1P
|-
|'''STOCKIST_SUB_CODE'''
|001
|001
|-
|'''STOCK_CODE'''
|SC01
|DEALS10
|-
|'''PRODUCT_TYPE'''
|1
|1
|-
|'''ROUTE_CODE'''
|DIF
|DIF
|-
|'''LOAD_NO'''
|258
|258
|-
|'''PRICE_ORDER_UOM'''
|0.65
|1
|-
|'''NEW_PRICE'''
|
|
|-
|'''QTY_ORDERED'''
|1
|2
|-
|'''QTY_ORIG_DESPATCHED'''
|1
|2
|-
|'''QTY_PREV_DESPATCHED'''
|
|
|-
|'''QTY_NEW_DESPATCHED'''
|
|
|-
|'''REASON_CODE'''
|
|
|-
|'''ON_DEAL'''
|N
|Y
|-
|'''ON_DEAL_QTY'''
|0
|2
|-
|'''WHOLE_ORDER_RET'''
|
|
|-
|'''QTY_RTN_ORIG_AMEND'''
|
|
|}


User runs SOS7050 - Order Returns and Amendments<center>
[[File:NOMS-33.png|800px]]
</center>User clicks on 'Return Whole Order' button which enables the reason code field<center>
[[File:NOMS-34.png|800px]]
</center>User enters in reason code and then clicks on 'Validate and Submit Amendment'<center>
[[File:NOMS-35.png|800px]]
</center>Order is updated<center>
[[File:NOMS-36.png|800px]]
</center>Order Header is updated with 'amend contains deal' and 'amend discount value' fields populated.
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
!CUST CODE
!NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
!AMEND CONTAINS DEAL
!AMEND DISCOUNT VALUE
|-
|D1P00000000000023854
|9
|PRISONER
|2.35
|2.35
|Y
|0.30
|N
| -0.30
|}Order Detail is updated with 'amend on deal' and 'amend on deal qty' fields populated.
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
!AMEND ON DEAL
!AMEND ON DEAL QTY
|-
|1
|9
|SC01
|1
|0.65
|N
|0
|
|
|-
|2
|9
|DEALS10
|2
|1.00
|Y
|2
|N
| -2
|}Order Detail Deals record is deleted

Despatch_OH is updated in line with ORDER HEADER with 'amend contains deal' and 'amend discount value' fields populated.
{| class="wikitable" border="1"
!'''WAREHOUSE_ID'''
!NFT
!NFT
|-
|'''OWNER_CODE'''
|D1P
|D1P
|-
|'''OWNER_SUB_CODE'''
|001
|001
|-
|'''ORDER_NUM'''
|D1P00000000000023854
|D1P00000000000023854
|-
|'''DESPATCH_DATE'''
|03/01/2024 14:47:41
|03/01/2024 14:47:41
|-
|'''SALES_TERRITORY'''
|DIF
|DIF
|-
|'''SALES_AREA'''
|01/01/01
|01/01/01
|-
|'''CUST_CODE'''
|PRISONER
|PRISONER
|-
|'''CUSTOMER_SUB_AC_NO'''
|001
|001
|-
|'''DELIVERY_ADDRESS_NO'''
|1
|1
|-
|'''CONTAINS_DEAL'''
|Y
|N
|-
|'''DISCOUNT_VALUE'''
|0.30
|0.00
|-
|'''ORIG_DISCOUNT_VALUE'''
|0.30
|0.30
|-
|'''AMEND_CONTAIN_DEAL'''
|
|N
|-
|'''AMEND_DISCOUNT_VALUE'''
|
| -0.30
|}Despatch_OD is updated in line with ORDER DETAIL with 'On Deal', 'On Deal Qty' populated, as well as 'Qty Prev Despatched' and 'Whole Order Ret'.
{| class="wikitable" border="1"
!'''WAREHOUSE_ID'''
!NFT
!NFT
!NFT
!NFT
|-
|'''OWNER_CODE'''
|D1P
|D1P
|D1P
|D1P
|-
|'''OWNER_SUB_CODE'''
|1
|1
|1
|1
|-
|'''ORDER_NUM'''
|D1P00000000000023854
|D1P00000000000023854
|D1P00000000000023854
|D1P00000000000023854
|-
|'''LINE_NO'''
|1
|2
|1
|2
|-
|'''STOCKIST_CODE'''
|D1P
|D1P
|D1P
|D1P
|-
|'''STOCKIST_SUB_CODE'''
|1
|1
|1
|1
|-
|'''STOCK_CODE'''
|SC01
|DEALS10
|SC01
|DEALS10
|-
|'''PRODUCT_TYPE'''
|1
|1
|1
|1
|-
|'''ROUTE_CODE'''
|DIF
|DIF
|DIF
|DIF
|-
|'''LOAD_NO'''
|258
|258
|258
|258
|-
|'''PRICE_ORDER_UOM'''
|0.65
|1
|0.65
|1
|-
|'''NEW_PRICE'''
|
|
|
|
|-
|'''QTY_ORDERED'''
|1
|2
|1
|2
|-
|'''QTY_ORIG_DESPATCHED'''
|1
|2
|1
|2
|-
|'''QTY_PREV_DESPATCHED'''
|
|
|0
|0
|-
|'''QTY_NEW_DESPATCHED'''
|
|
|
|
|-
|'''REASON_CODE'''
|
|
|
|
|-
|'''ON_DEAL'''
|N
|Y
|N
|N
|-
|'''ON_DEAL_QTY'''
|0
|2
|0
|0
|-
|'''WHOLE_ORDER_RET'''
|
|
|Y
|Y
|-
|'''QTY_RTN_ORIG_AMEND'''
|
|
|
|
|}The next 2 tables are populated only when a post despatch amendment is made.

Despatch_AH
{| class="wikitable" border="1"
!WAREHOUSE ID
!OWNER CODE
!OWNER SUB CODE
!ORDER NUM
!SALES TERRITORY
!AMENDMENT NUM
!DATE STAMP
!USER ID
!AMEND DISCOUNT VALUE
|-
|NFT
|D1P
|001
|D1P00000000000023854
|DIF
|590
|03/01/2024 14:59:59
|DAVE9
| -0.30
|}Despatch_AD
{| class="wikitable" border="1"
!WAREHOUSE_ID
!NFT
!NFT
|-
|OWNER_CODE
|D1P
|D1P
|-
|OWNER_SUB_CODE
|001
|001
|-
|ORDER_NUM
|D1P00000000000023854
|D1P00000000000023854
|-
|AMENDMENT_NUM
|590
|590
|-
|LINE_NO
|1
|2
|-
|QTY_OLD_DESPATCHED
|1
|2
|-
|QTY_NEW_DESPATCHED
|0
|0
|-
|PREVIOUS_PRICE
|0.65
|1.00
|-
|NEW_PRICE
|0.65
|1.00
|-
|NEW_COST
|0.15
|0.02
|-
|REASON_CODE
|01
|01
|-
|GOOD_BAD
|G
|G
|}The CUSTOMERS table is updated with the '''BALANCE''' field being downdated by the order amount.

Note: Updates in '''DP_DESP_ORDER_AMEND'''

=== Example: Order amendments ===
3 'identical' orders are created - D1P00000000000023855, D1P00000000000023856 and D1P00000000000023857<center>
[[File:NOMS-37.png|800px]]
</center>All 3 orders are allocated, picked and despatched.<center>
[[File:NOMS-38.png|800px]]
</center>This sets the data as follows:

Order Header
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
!CUST CODE
!NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
|-
|D1P00000000000023855
|9
|PRISONER
|3.00
|3.00
|Y
|0.30
|}Order Detail
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
|-
|1
|9
|SC01
|2
|0.65
|N
|0
|-
|2
|9
|DEALS10
|2
|1.00
|Y
|2
|}Order Detail Deals
{| class="wikitable" border="1"
!ORDER NUM
!LINE NO
!STOCKIST CODE
!STOCKIST SUB CODE
!STOCK CODE
!DEAL NAME
!DEAL QTY
!DEAL NUM
!PRICE ORDER UOM
!DEAL DISCOUNT
|-
|D1P00000000000023855
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|1
|1.00
|0.15
|-
|D1P00000000000023855
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|2
|1.00
|0.15
|}Despatch OH
{| class="wikitable" border="1"
!ORDER NUM
!DESPATCH DATE
!SALES TERRITORY
!SALES AREA
!CUST CODE
!CUSTOMER SUB AC NO
!DELIVERY ADDRESS NO
!CONTAINS DEAL
!DISCOUNT VALUE
!ORIG DISCOUNT VALUE
|-
|D1P00000000000023855
|04/01/2024 08:26:59
|DIF
|01/01/01
|PRISONER
|001
|1
|Y
|0.30
|0.30
|}Despatch OD
{| class="wikitable" border="1"
!WAREHOUSE_ID
!NFT
!NFT
|-
|OWNER_CODE
|D1P
|D1P
|-
|OWNER_SUB_CODE
|001
|001
|-
|ORDER_NUM
|D1P00000000000023855
|D1P00000000000023855
|-
|LINE_NO
|1
|2
|-
|STOCKIST_CODE
|D1P
|D1P
|-
|STOCKIST_SUB_CODE
|001
|001
|-
|STOCK_CODE
|SC01
|DEALS10
|-
|PRODUCT_TYPE
|1
|1
|-
|ROUTE_CODE
|DIF
|DIF
|-
|LOAD_NO
|00259
|00259
|-
|PRICE_ORDER_UOM
|0.65
|1.00
|-
|NEW_PRICE
|
|
|-
|QTY_ORDERED
|2
|2
|-
|QTY_ORIG_DESPATCHED
|2
|2
|-
|QTY_PREV_DESPATCHED
|
|
|-
|QTY_NEW_DESPATCHED
|
|
|-
|REASON_CODE
|
|
|-
|ON_DEAL
|N
|Y
|-
|ON_DEAL_QTY
|0
|2
|-
|WHOLE_ORDER_RET
|
|
|-
|QTY_RTN_ORIG_AMEND
|
|
|}

==== Example Amendment 1 ====
User finds the first order D1P00000000000023855<center>
[[File:NOMS-39.png|800px]]
</center>User reduces despatched qty of SC01 from 2 to 1

User adds 1 unit of SC02, which was not in the original order.<center>
[[File:NOMS-40.png|800px]]
</center>Order changes are confirmed with no deal changes.<center>
[[File:NOMS-41.png|800px]]
</center>Order Header - no change
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
!CUST CODE
!NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
|-
|D1P00000000000023855
|9
|PRISONER
|3.00
|3.00
|Y
|0.30
|}Order Detail - no change
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
|-
|1
|9
|SC01
|2
|0.65
|N
|0
|-
|2
|9
|DEALS10
|2
|1.00
|Y
|2
|}Order Detail Deals - no change
{| class="wikitable" border="1"
!ORDER NUM
!LINE NO
!STOCKIST CODE
!STOCKIST SUB CODE
!STOCK CODE
!DEAL NAME
!DEAL QTY
!DEAL NUM
!PRICE ORDER UOM
!DEAL DISCOUNT
|-
|D1P00000000000023855
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|1
|1.00
|0.15
|-
|D1P00000000000023855
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|2
|1.00
|0.15
|}Despatch OH - no change
{| class="wikitable" border="1"
!ORDER NUM
!DESPATCH DATE
!SALES TERRITORY
!SALES AREA
!CUST CODE
!CUSTOMER SUB AC NO
!DELIVERY ADDRESS NO
!CONTAINS DEAL
!DISCOUNT VALUE
!ORIG DISCOUNT VALUE
|-
|D1P00000000000023855
|04/01/2024 08:26:59
|DIF
|01/01/01
|PRISONER
|001
|1
|Y
|0.30
|0.30
|}Despatch OD is changed - 'qty prev despatched' is updated in row 1, and a new row 3 record is created
{| class="wikitable" border="1"
!WAREHOUSE_ID
!NFT
!NFT
!NFT
|-
|OWNER_CODE
|D1P
|D1P
|D1P
|-
|OWNER_SUB_CODE
|001
|001
|001
|-
|ORDER_NUM
|D1P00000000000023855
|D1P00000000000023855
|D1P00000000000023855
|-
|LINE_NO
|1
|2
|3
|-
|STOCKIST_CODE
|D1P
|D1P
|D1P
|-
|STOCKIST_SUB_CODE
|001
|001
|001
|-
|STOCK_CODE
|SC01
|DEALS10
|SC02
|-
|PRODUCT_TYPE
|1
|1
|1
|-
|ROUTE_CODE
|DIF
|DIF
|
|-
|LOAD_NO
|00259
|00259
|
|-
|PRICE_ORDER_UOM
|0.65
|1.00
|
|-
|NEW_PRICE
|
|
|
|-
|QTY_ORDERED
|2
|2
|
|-
|QTY_ORIG_DESPATCHED
|2
|2
|
|-
|QTY_PREV_DESPATCHED
|1
|
|1
|-
|QTY_NEW_DESPATCHED
|
|
|
|-
|REASON_CODE
|
|
|
|-
|ON_DEAL
|N
|Y
|
|-
|ON_DEAL_QTY
|0
|2
|
|-
|WHOLE_ORDER_RET
|
|
|
|-
|QTY_RTN_ORIG_AMEND
|
|
|
|}The following Despatch AH record is created - changes marked with amendment no 591
{| class="wikitable" border="1"
!WAREHOUSE ID
!OWNER CODE
!OWNER SUB CODE
!ORDER NUM
!SALES TERRITORY
!AMENDMENT NUM
!DATE STAMP
!USER ID
!AMEND DISCOUNT VALUE
|-
|NFT
|D1P
|001
|D1P00000000000023855
|DIF
|591
|04/01/2024 08:40:30
|DAVE9
|0.00
|}The following Despatch AD records are created - showing changes
{| class="wikitable" border="1"
!WAREHOUSE ID
!NFT
!NFT
|-
|OWNER CODE
|D1P
|D1P
|-
|OWNER SUB CODE
|001
|001
|-
|ORDER NUM
|D1P00000000000023855
|D1P00000000000023855
|-
|AMENDMENT NUM
|591
|591
|-
|LINE NO
|1
|3
|-
|QTY OLD DESPATCHED
|2
|
|-
|QTY NEW DESPATCHED
|1
|1
|-
|PREVIOUS PRICE
|0.65
|0.45
|-
|NEW PRICE
|0.65
|0.45
|-
|NEW COST
|0.15
|0.25
|-
|REASON CODE
|01
|01
|-
|GOOD BAD
|G
|G
|}Customer record updated to reflect new BALANCE, as user has returned as £0.65 and bought a £0.45 item, so him balance is now £0.20 better than before.

User can run report for pick wave to see changes.<center>
[[File:NOMS-42.png|800px]]
</center>Report shows £0.20 refund owning.<center>
[[File:NOMS-43.png|800px]]
</center>Note: PINS are goods with a product group of '77' (phone cards) - they are reported differently from all other stock lines.

==== Example Amendment 2 ====
User finds order D1P00000000000023856<center>
[[File:NOMS-44.png|800px]]
</center>User adds an extra unit of DEALS10, hence triggering a 3<sup>rd</sup> deal.<center>
[[File:NOMS-45.png|800px]]
</center>Changes are confirmed<center>
[[File:NOMS-46.png|800px]]
</center>Order Header - 'Amend Contains Deal' and 'Amend Discount Value' fields updated as deal value is increased by £0.15
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
!CUST CODE
!NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
!AMEND CONTAINS DEAL
!AMEND DISCOUNT VALUE
|-
|D1P00000000000023856
|9
|PRISONER
|3.00
|3.00
|Y
|0.30
|Y
|0.15
|}Order Details - 'Amend On Deal Qty' updated as deal value a third unit of DEALS10 is ordered.
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
!AMEND ON DEAL
!AMEND ON DEAL QTY
|-
|1
|9
|SC01
|2
|0.65
|N
|0
|
|
|-
|2
|9
|DEALS10
|2
|1.00
|Y
|2
|Y
|1
|}Order Detail Deals - a new 3<sup>rd</sup> line is created - note created date is later than the other dates, showing record created separately.
{| class="wikitable" border="1"
!ORDER NUM
!LINE NO
!STOCKIST CODE
!STOCKIST SUB CODE
!STOCK CODE
!DEAL NAME
!DEAL QTY
!DEAL NUM
!PRICE ORDER UOM
!CREATED DATE
!DEAL DISCOUNT
|-
|D1P00000000000023856
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|1
|1.00
|04/01/2024 08:17:53
|0.15
|-
|D1P00000000000023856
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|2
|1.00
|04/01/2024 08:17:53
|0.15
|-
|D1P00000000000023856
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|3
|1.00
|04/01/2024 09:02:53
|0.15
|}Despatch OH - in line with ORDER HEADER, 'Amend Contains Deal' and 'Amend Discount Value' fields updated.
{| class="wikitable" border="1"
!ORDER NUM
!DESPATCH DATE
!SALES TERRITORY
!SALES AREA
!CUST CODE
!CUSTOMER SUB AC NO
!DELIVERY ADDRESS NO
!CONTAINS DEAL
!DISCOUNT VALUE
!ORIG DISCOUNT VALUE
!AMEND CONTAIN DEAL
!AMEND DISCOUNT VALUE
|-
|D1P00000000000023856
|04/01/2024 08:27:52
|DIF
|01/01/01
|PRISONER
|001
|1
|Y
|0.45
|0.30
|Y
|0.15
|}Despatch OD updated - 'on deal qty' and 'qty pre despatched' updated
{| class="wikitable" border="1"
!WAREHOUSE_ID
!NFT
!NFT
|-
|OWNER_CODE
|D1P
|D1P
|-
|OWNER_SUB_CODE
|001
|001
|-
|ORDER_NUM
|D1P00000000000023856
|D1P00000000000023856
|-
|LINE_NO
|1
|2
|-
|STOCKIST_CODE
|D1P
|D1P
|-
|STOCKIST_SUB_CODE
|001
|001
|-
|STOCK_CODE
|SC01
|DEALS10
|-
|PRODUCT_TYPE
|1
|1
|-
|ROUTE_CODE
|DIF
|DIF
|-
|LOAD_NO
|00260
|00260
|-
|PRICE_ORDER_UOM
|0.65
|1.00
|-
|NEW_PRICE
|
|
|-
|QTY_ORDERED
|2
|2
|-
|QTY_ORIG_DESPATCHED
|2
|2
|-
|QTY_PREV_DESPATCHED
|
|3
|-
|QTY_NEW_DESPATCHED
|
|
|-
|REASON_CODE
|
|
|-
|ON_DEAL
|N
|Y
|-
|ON_DEAL_QTY
|0
|3
|-
|WHOLE_ORDER_RET
|
|
|-
|QTY_RTN_ORIG_AMEND
|
|
|}Despatch AH created - with amendment No 592
{| class="wikitable" border="1"
!WAREHOUSE ID
!OWNER CODE
!OWNER SUB CODE
!ORDER NUM
!SALES TERRITORY
!AMENDMENT NUM
!DATE STAMP
!USER ID
!AMEND DISCOUNT VALUE
|-
|NFT
|D1P
|001
|D1P00000000000023856
|DIF
|592
|04/01/2024 09:02:53
|DAVE9
|0.45
|}The following DESPATCH AD - linked via Amendment No, and shows old and new Despatched Qty
{| class="wikitable" border="1"
!WAREHOUSE ID
!OWNER CODE
!OWNER SUB CODE
!ORDER NUM
!AMENDMENT NUM
!LINE NO
!QTY OLD DESPATCHED
!QTY NEW DESPATCHED
!PREVIOUS PRICE
!NEW PRICE
!NEW COST
!REASON CODE
!GOOD BAD
|-
|NFT
|D1P
|001
|D1P00000000000023856
|592
|2
|2
|3
|1.00
|1.00
|0.00
|01
|G
|}The Order Amendment report shows order value increased by £0.85<center>
[[File:NOMS-47.png|800px]]
</center>

==== Example Amendment 3 ====
User finds order D1P00000000000023857 and reduces the despatched qty of DEALS10 from 2 to 1, so reducing the no of deals from 2 to 1.<center>
[[File:NOMS-48.png|800px]]
</center>Changes are confirmed<center>
[[File:NOMS-49.png|800px]]
</center>Order Header - 'Amend Contains Deal' and 'Amend Discount Value' fields updated as deal value is reduced by £0.15
{| class="wikitable" border="1"
!ORDER NUM
!ORDER STATUS
!CUST CODE
!NET ORDER VALUE
!GROSS ORDER VALUE
!CONTAINS DEAL
!DISCOUNT VALUE
!AMEND CONTAINS DEAL
!AMEND DISCOUNT VALUE
|-
|D1P00000000000023857
|9
|PRISONER
|3.00
|3.00
|Y
|0.30
|N
| -0.15
|}Order Details - 'Amend On Deal Qty' updated as despatched deal value of DEALS10 is reduced from 2 to 1.
{| class="wikitable" border="1"
!LINE NO
!ORDER STATUS
!STOCK CODE
!ORDERED UNITS
!PRICE ORDER UOM
!ON DEAL
!ON DEAL QTY
!AMEND ON DEAL
!AMEND ON DEAL QTY
|-
|1
|9
|SC01
|2
|0.65
|N
|0
|
|
|-
|2
|9
|DEALS10
|2
|1.00
|Y
|2
|
| -1
|}Order Details Deals - no of records reduced from 2 to 1
{| class="wikitable" border="1"
!ORDER NUM
!LINE NO
!STOCKIST CODE
!STOCKIST SUB CODE
!STOCK CODE
!DEAL NAME
!DEAL QTY
!DEAL NUM
!PRICE ORDER UOM
!DEAL DISCOUNT
|-
|D1P00000000000023857
|2
|D1P
|001
|DEALS10
|DEALS10
|1
|1
|1.00
|0.15
|}Despatch OH - in line with ORDER HEADER, 'Amend Contains Deal' and 'Amend Discount Value' fields updated.
{| class="wikitable" border="1"
!ORDER NUM
!DESPATCH DATE
!SALES TERRITORY
!SALES AREA
!CUST CODE
!CUSTOMER SUB AC NO
!DELIVERY ADDRESS NO
!CONTAINS DEAL
!DISCOUNT VALUE
!ORIG DISCOUNT VALUE
!AMEND CONTAIN DEAL
!AMEND DISCOUNT VALUE
|-
|D1P00000000000023857
|04/01/2024 08:28:16
|DIF
|01/01/01
|PRISONER
|001
|1
|Y
|0.15
|0.30
|Y
| -0.15
|}Despatch OD updated - 'on deal qty' and 'qty pre despatched' updated
{| class="wikitable" border="1"
!WAREHOUSE_ID
!NFT
!NFT
|-
|OWNER_CODE
|D1P
|D1P
|-
|OWNER_SUB_CODE
|001
|001
|-
|ORDER_NUM
|D1P00000000000023857
|D1P00000000000023857
|-
|LINE_NO
|1
|2
|-
|STOCKIST_CODE
|D1P
|D1P
|-
|STOCKIST_SUB_CODE
|001
|001
|-
|STOCK_CODE
|SC01
|DEALS10
|-
|PRODUCT_TYPE
|1
|1
|-
|ROUTE_CODE
|DIF
|DIF
|-
|LOAD_NO
|00261
|00261
|-
|PRICE_ORDER_UOM
|0.65
|1.00
|-
|NEW_PRICE
|
|
|-
|QTY_ORDERED
|2
|2
|-
|QTY_ORIG_DESPATCHED
|2
|2
|-
|QTY_PREV_DESPATCHED
|
|1
|-
|QTY_NEW_DESPATCHED
|
|
|-
|REASON_CODE
|
|
|-
|ON_DEAL
|N
|Y
|-
|ON_DEAL_QTY
|0
|1
|-
|WHOLE_ORDER_RET
|
|
|-
|QTY_RTN_ORIG_AMEND
|
|
|}Despatch AH created - with amendment No 592
{| class="wikitable" border="1"
!WAREHOUSE ID
!OWNER CODE
!OWNER SUB CODE
!ORDER NUM
!SALES TERRITORY
!AMENDMENT NUM
!DATE STAMP
!USER ID
!AMEND DISCOUNT VALUE
|-
|NFT
|D1P
|001
|D1P00000000000023857
|DIF
|593
|04/01/2024 09:23:09
|DAVE9
| -0.15
|}The following DESPATCH AD - linked via Amendment No, and shows old and new Despatched Qty
{| class="wikitable" border="1"
!WAREHOUSE ID
!OWNER CODE
!OWNER SUB CODE
!ORDER NUM
!AMENDMENT NUM
!LINE NO
!QTY OLD DESPATCHED
!QTY NEW DESPATCHED
!PREVIOUS PRICE
!NEW PRICE
!NEW COST
!REASON CODE
!GOOD BAD
|-
|NFT
|D1P
|001
|D1P00000000000023857
|593
|2
|2
|1
|1.00
|1.00
|0.00
|01
|G
|}Order Amendment report show a refund of £0.85 - which is the order price £1 minus deal vale £0.15<center>
[[File:NOMS-50.png|800px]]
</center>

= Stock Management =

== NOMS Stock Take (WHS0544_NOM) ==
{{:WHS0544 NOM}}

==== Adding Lines (WHS0542) ====
{{:WHS0542}}

== [[POS1020]] - Stock Demand Status ==

== [[POS1021]] - Stock Demand Processing ==

= Enquiries =

== [[ENQSOON01A]] - Enquiry by Order Number ==
{{:ENQSOON01A}}

= Reports =

== [[WHS1701]] - Manifest Pre Spends Report ==
{{:WHS1701}}

== [[SOS7055]] - Amendment Report ==
{{:SOS7055}}

== [[WHS1901]] - Despatch Manifest ==
{{:WHS1901}}

== [[WHS1705]] - Replenishment Report ==

== [[WHS1902]] - Despatch Spends Report ==

== [[WHS1903]] - Order Spends Report ==

== [[WHS0827]] - Stock Ordering Downloads ==
{{:WHS0827}}
[[Category:Customer-Specific]]