WAREHOUSE MANAGER TEST PLAN

Move In without GP Bins

User ID / 1
Password / Password
Account / PALHEALTH
/ 1.  From Menu, select Forms, Move In. The Site will be pre-populated with the current site in the user session.
2.  From the Batch ID field, select Commands, Lookup
/ 3.  Select a Batch from the List
/ 4.  Press enter to move to the Total Items field.
/ 5.  The Site Trx Item subform will appear. From the Inbound Item # field, select Commands, Lookup
/ 6.  Select a Standard Item
/ 7.  Enter Quantity and press Enter twice
/ 8.  The Inbound Item #, Item Description, and Inbound Qty will clear
9.  In the Inbound Item # field, key enter the first few letters of a Lotted item # and press enter.
/ 10.  Select a Lotted Item
/ 11.  Press enter to move to the Lot Qty field
/ 12.  The Site Transaction Lot subform will appear
/ 13.  Enter a Lot # and Quantity and press Enter
/ 14.  The Lot # and Qty fields will clear
/ 15.  Enter another Lot # and Quantity and press Enter
/ 16.  The Lot # and Qty fields will clear
17.  Close the subform using the Esc or OK key
/ 18.  The Site Trx Item subform will appear with the Lot Qty field set to the total of all lot quantities entered
19.  Press enter twice to save the line item.
/ 20.  The Inbound Item # and Inbound Qty will clear
21.  From the Inbound Item # field, select Commands, Lookup
/ 22.  Select a Serialized Item
/ 23.  Press enter to move to the Serial Qty field.
/ 24.  The Site Transaction Serial subform will appear.
/ 25.  Enter a Serial # and press Enter
/ 26.  The Serial # will clear
/ 27.  Enter a Serial # and press Enter
/ 28.  The Serial # will clear
29.  Close the subform using the Esc or OK key
/ 30.  The Site Trx Item subform will appear with the Serial Qty field set to the total of all serialized items entered
31.  Press enter twice to save the line item.
/ 32.  The Inbound Item #, Item Description, and Serial Qty will clear. Press ESC to close the subform.
/ 33.  The Move In form will appear with the Total Items updated to reflect the number of Site Transaction Items entered.
34.  Press Enter to save the transaction
/ 35.  The Batch ID and Total Items will clear

Site Transaction

select TOP 1 BACHNUMB, BCHSOURC, IVDOCNBR, RCDOCNUM, IVDOCTYP, DOCDATE, GLPOSTDT, TRXQTYTL from two.dbo.iv10000 order by dex_row_id desc

BACHNUMB / Inventory 1
BCHSOURC / IV_Trxent
IVDOCNBR / AE1176
RCDOCNUM / AE1176
IVDOCTYP / 1
DOCDATE / 2009-01-08 00:00:00.000
GLPOSTDT / 2009-01-08 00:00:00.000
TRXQTYTL / 32.00000

select TOP 1 Type, Status, RecordType, CreateDate, CreateUserID, CompanyID, DirectiveNumber, LocationID, OtherSiteID, TotalItems from directives order by directiveid desc

Type / Move In
Status / Null
RecordType / 615
CreateDate / 2009-01-08 00:30:53.000
CreateUserID / 3724
CompanyID / 5176
DirectiveNumber / AE1176
LocationID / WAREHOUSE
OtherSiteID / Null
TotalItems / 3


Site Transaction Item

select TOP 3 IVDOCNBR, IVDOCTYP, ITEMNMBR, LNSEQNBR, UOFM, QTYBSUOM, TRXQTY, UNITCOST, EXTDCOST, TRXLOCTN, TRNSTLOC, TRFQTYTY, TRTQTYTY, IVIVINDX, IVIVOFIX, DECPLCUR, DECPLQTY, USAGETYPE from two.dbo.iv10001 order by dex_row_id desc

IVDOCNBR / AE1176 / AE1176 / AE1176
IVDOCTYP / 1 / 1 / 1
ITEMNMBR / 100XLG / WIRE-SCD-0001 / 128 SDRAM
LNSEQNBR / 3.00000 / 2.00000 / 1.00000
UOFM / Each / Each / Each
QTYBSUOM / 1.00000 / 1.00000 / 1.00000
TRXQTY / 2.00000 / 25.00000 / 5.00000
UNITCOST / 55.50000 / .16000 / 247.50000
EXTDCOST / 111.00000 / 4.00000 / 1237.50000
TRXLOCTN / WAREHOUSE / WAREHOUSE / WAREHOUSE
TRNSTLOC
TRFQTYTY / 0 / 0 / 0
TRTQTYTY / 0 / 0 / 0
IVIVINDX / 19 / 18 / 18
IVIVOFIX / 502 / 137 / 445
DECPLCUR / 3 / 3 / 3
DECPLQTY / 1 / 1 / 1
USAGETYPE / 0 / 0 / 0


Site Transaction Lot / Site Transaction Serial

SELECT TOP 4 IVDOCNBR, IVDOCTYP, ITEMNMBR, SERLTNUM, SERLTQTY, LNSEQNBR, SLTSQNUM, DATERECD, DTSEQNUM, OVRSERLT FROM TWO.dbo.[IV10002] order by dex_row_id desc

IVDOCNBR / AE1176 / AE1176 / AE1176 / AE1176
IVDOCTYP / 1 / 1 / 1 / 1
ITEMNMBR / 100XLG / 100XLG / WIRE-SCD-0001 / WIRE-SCD-0001
SERLTNUM / SERIAL7 / SERIAL6 / LOT7 / LOT6
SERLTQTY / 1.00000 / 1.00000 / 15.00000 / 10.00000
LNSEQNBR / 3.00000 / 3.00000 / 2.00000 / 2.00000
SLTSQNUM / 2 / 1 / 2 / 1
DATERECD / 1900-01-01 00:00:00.000 / 1900-01-01 00:00:00.000 / 2009-01-08 00:00:00.000 / 2009-01-08 00:00:00.000
DTSEQNUM / .00000 / .00000 / .00000 / .00000
OVRSERLT / 0 / 0 / 0 / 0

Site Transaction Batch

Select [NUMOFTRX], [BCHTOTAL] From two.dbo.[SY00500] where [BACHNUMB]='Inventory 1'

NUMOFTRX / 1
BCHTOTAL / 32.00000
/ 1.  Select Commands, Delete

Site Transaction Batch

Select [NUMOFTRX], [BCHTOTAL] From two.dbo.[SY00500] where [BACHNUMB]='Inventory 1'

NUMOFTRX / 1
BCHTOTAL / 20.00000

Item

Select ITEMNMBR, ATYALLOC, QTYONHND From two.dbo.IV00102 where RCRDTYPE = 1 and ITEMNMBR IN ('128 SDRAM', '100XLG','WIRE-SCD-0001') ORDER BY ITEMNMBR

ITEMNMBR / 100XLG / 128 SDRAM / WIRE-SCD-0001
ATYALLOC / 10.00000 / 115.00000 / 125.00000
QTYONHND / 35.00000 / 52736.00000 / 2025.00000

Item Site

Select ITEMNMBR, ATYALLOC, QTYONHND From two.dbo.IV00102 where RCRDTYPE = 2 AND LOCNCODE = 'WAREHOUSE' and ITEMNMBR IN ('128 SDRAM', '100XLG','WIRE-SCD-0001') ORDER BY ITEMNMBR

ITEMNMBR / 100XLG / 128 SDRAM / WIRE-SCD-0001
ATYALLOC / 10.00000 / 115.00000 / 125.00000
QTYONHND / 35.00000 / 1083.00000 / 2025.00000

Item Lot

SELECT ITEMNMBR, LOTNUMBR, BIN, ATYALLOC, QTYRECVD, QTYSOLD From two.dbo.[IV00300] WHERE LOCNCODE = 'WAREHOUSE'and ITEMNMBR = 'WIRE-SCD-0001' AND LOTNUMBR IN ('LOT1', 'LOT2') AND BIN = 'STORE' ORDER BY LOTNUMBR

ITEMNMBR / WIRE-SCD-0001 / WIRE-SCD-0001
LOTNUMBR / LOT1 / LOT2
BIN / STORE / STORE
ATYALLOC / 0.0000 / 0.0000
QTYRECVD / 10.0000 / 10.0000
QTYSOLD / 0.0000 / 0.0000

Item Serial

SELECT ITEMNMBR, SERLNMBR, BIN,SERLNSLD From two.dbo.[IV00200] AS IV00200 WHERE ITEMNMBR = '100XLG' and SERLNMBR IN ('SERIAL1','SERIAL2') ORDER BY SERLNMBR

ITEMNMBR / 100XLG / 100XLG
SERLNMBR / SERIAL1 / SERIAL2
BIN / STORE / STORE
SERLNSLD / 0 / 0