TESTCASE: TC_FMSE_00277
SUBJECT: Save Stock - Packed B2B Order
OBJECTIVE:
To verify that stock is calculated and save data to RDS if user packed b2b order
PREREQUISITE:
For B2B Packed
1. Prepare 6 SKUs (11 Mat)
CREATE (sku): ***API
SKU_NO | MAT_NO | SOURCE_TYPE | SUPPLIER_CODE | BU
SKU01 | SKU01A | RT | SUP01 | BUB2B1
SKU01 | SKU01B | CT | SUP01 | BUB2B1
SKU02 | SKU02A | RX | SUP01 | BUB2B1
SKU03 | SKU03A | MF | SUP02 | BUB2B1
SKU03 | SKU03B | MX | SUP02 | BUB2B1
SKU04 | SKU04A | RT | SUP01 | BUB2B1
SKU04 | SKU04B | CT | SUP01 | BUB2B1
SKU04 | SKU04B | RX | SUP01 | BUB2B1
SKU05 | SKU05A | MF | SUP02 | BUB2B1
SKU06 | SKU06A | MX | SUP02 | BUB2B1
SKU07 | SKU07A | MF | SUP02 | BUB2B1
2. Prepare UIDs 17 uid
SKU01.RT (3)
SKU01.CT (2)
SKU02.RX (2)
SKU03.MF (1)
SKU03.MX (1)
SKU04.RT (1)
SKU04.CT (1)
SKU04.RX (1)
SKU05.MF (2)
SKU06.MX (1)
SKU07.MF (2)
CREATE (inventory): ***API
SKU | UID | SOURCE_TYPE
SKU01 | UIDSKU01A | RT
SKU01 | UIDSKU01B | RT
SKU01 | UIDSKU01C | RT
SKU01 | UIDSKU01D | CT
SKU01 | UIDSKU01E | CT
SKU02 | UIDSKU02C | RX
SKU02 | UIDSKU02D | RX
SKU03 | UIDSKU03A | MF
SKU03 | UIDSKU03D | MX
SKU04 | UIDSKU04A | RT
SKU04 | UIDSKU04B | CT
SKU04 | UIDSKU04D | RX
SKU05 | UIDSKU05A | MF
SKU05 | UIDSKU05B | MF
SKU06 | UIDSKU06B | MX
SKU07 | UIDSKU07A | MF
SKU07 | UIDSKU07B | MF
3. Prepare outbound with prepared sku:
SKU01.RT (3)
SKU01.CT (2)
SKU02.RX (2)
SKU03.MF (1)
SKU03.MX (1)
SKU04.RT (1)
SKU04.CT (1)
SKU04.RX (1)
SKU05.MF (2)
SKU06.MX (1)
SKU07.MF (2)
CREATE (outbound.b2c): ***SQL
OB_LINE_NO | SKU
OBLINE01 | SKU01
OBLINE02 | SKU01
OBLINE03 | SKU01
OBLINE04 | SKU01
OBLINE05 | SKU01
OBLINE06 | SKU02
OBLINE07 | SKU02
OBLINE08 | SKU03
OBLINE09 | SKU03
OBLINE10 | SKU04
OBLINE11 | SKU04
OBLINE12 | SKU04
OBLINE13 | SKU05
OBLINE14 | SKU05
OBLINE15 | SKU06
OBLINE16 | SKU07
OBLINE17 | SKU07
STEP:
Packed item and check data on event bus
1. FMS -> Login
2. Outbound -> List outbound for packing
3. Search Order
4. Click create package button
5. Scan => UIDSKU01A (RT)
6. Scan => UIDSKU01B (RT)
7. Scan => UIDSKU01C (RT)
8. Scan => UIDSKU01D (CT)
9. Scan => UIDSKU02C (RX)
10 Scan => UIDSKU02D (RX)
11. Scan => UIDSKU03A (MF)
12. Scan => UIDSKU03D (MX)
14. Scan => UIDSKU04A (RT)
15. Scan => UIDSKU04B (CT)
16. Scan => UIDSKU04C (RX)
17. Scan => UIDSKU05B (MF)
18. Scan => UIDSKU06B (MX)
20. Input package code
21. Click done.
EXPECTED:
We scanned:
SKU01.RT (3)
SKU01.CT (1)
SKU02.RX (2)
SKU03.MF (1)
SKU03.MX (1)
SKU04.RT (1)
SKU04.CT (1)
SKU04.RX (1)
SKU05.MF (1)
SKU06.MX (1)
From:
SKU01.RT (3)
SKU01.CT (2)
SKU02.RX (2)
SKU03.MF (1)
SKU03.MX (1)
SKU04.RT (1)
SKU04.CT (1)
SKU04.RX (1)
SKU05.MF (2)
SKU06.MX (1)
SKU07.MF (2)
Then: in Event Bus we must have
SKU | SOUTCE_TYPE | MOVEMENT | TOTAL
SKU01 | RT | -3 | 0
SKU01 | CT | -1 | 1
SKU03 | MF | -1 | 0
SKU04 | RT | -1 | 0
SKU04 | CT | -1 | 0
SKU05 | MF | -1 | 1
SKU07 | MF | 0 | 2
21.1 Found data in dynamo db 1 row(s)
Row#1
""type"" : ""StockDecreased"",
""data"": [
{
""sku"":""SKU01"",
""source_type"" : ""RT"",
""supplier_code"" : ""SUP01"",
""total"" : 1,
""qty"" : 2,
""bu_code"" : ""BUB2B1""
},
{
""sku"":""SKU01"",
""source_type"" : ""CT"",
""supplier_code"" : ""SUP01"",
""total"" : 0,
""qty"" : 2,
""bu_code"" : ""BUB2B1""
},
{
""sku"":""SKU03"",
""source_type"" : ""MF"",
""supplier_code"" : ""SUP02"",
""total"" : 0,
""qty"" :1,
""bu_code"" : ""BUB2B1""
},
{
""sku"":""SKU04"",
""source_type"" : ""RT"",
""supplier_code"" : ""SUP01"",
""total"" : 0,
""qty"" : 1,
""bu_code"" : ""BUB2B1""
},
{
""sku"":""SKU04"",
""source_type"" : ""CT"",
""supplier_code"" : ""SUP01"",
""total"" : 0,
""qty"" : 1,
""bu_code"" : ""BUB2B1""
},
{
""sku"":""SKU05"",
""source_type"" : ""MF"",
""supplier_code"" : ""SUP02"",
""total"" : 1,
""qty"" : 1,
""bu_code"" : ""BUB2B1""
}
]
21.2 Found 6 row(s) in RDS table 'stocks'
Row#1
- sku = SKU01
- bu_code = BUB2B1
- total = 1
- source_type=RT
- supplier_code=SUP01
Row#2
- sku = SKU01
- bu_code=BUB2B1
- total = 0
- source_type=CT
- supplier_code=SUP01
Row#3
- sku = SKU03
- bu_code = BUB2B1
- total = 0
- source_type=MF
- supplier_code=SUP02
Row#4
- sku = SKU04
- bu_code=BUB2B1
- total=0
- source_type=RT
- supplier_code=SUP01
Row#5
- sku=SKU04
- source_type=CT
- Supplier_code=SUP01
- total=0
- bu_code=BUB2B1
Row#6
- sku=SKU05
- source_type=MF
- supplier_code=SUP02
- total=1
- bu_code=BUB2C1
21.3 Not found 'SKU01', 'SKU03', 'SKU04', 'SKU05' in table 'failures
21.4 Found data in dynamo DB 4 row(s)
Row#1
""type"" : ""StockSent"",
""action"" : ""packed"",
""data"": [
{
""sku"":""SKU01"",
""source_type"" : ""RT"",
""supplier_code"" : ""SUP01"",
""total"" : 1,
""bu_code"" : ""BUB2B1"",
""movement_type"":""StockDecreased"",
},
{
""sku"":""SKU01"",
""source_type"" : ""CT"",
""supplier_code"" : ""SUP01"",
""total"" : 0,
""bu_code"" : ""BUB2B1"",
""movement_type"":""StockDecreased"",
},
{
""sku"":""SKU03"",
""source_type"" : ""MF"",
""supplier_code"" : ""SUP02"",
""total"" : 0,
""qty"" : 0,
""bu_code"" : ""BUB2B1"",
""movement_type"":""StockDecreased"",
},
{
""sku"":""SKU04"",
""source_type"" : ""RT"",
""supplier_code"" : ""SUP01"",
""total"" : 0,
""bu_code"" : ""BUB2B1"",
""movement_type"":""StockDecreased""
},
{
""sku"":""SKU04"",
""source_type"" : ""CT"",
""supplier_code"" : ""SUP01"",
""total"" : 0,
""bu_code"" : ""BUB2B1"",
""movement_type"":""StockDecreased"",
},
{
""sku"":""SKU05"",
""source_type"" : ""MF"",
""supplier_code"" : ""SUP02"",
""total"" : 1,
""bu_code"" : ""BUB2B1"",
""movement_type"":""StockDecreased""
}
]
21.5 Not found event type 'StockSentFailed'
21.6 All UIDs that scanned has changed to 'packed'
Last active
June 14, 2017 07:00
-
-
Save ilumin/4d9b948d539f83a47b1f64ca5290c3f4 to your computer and use it in GitHub Desktop.
TC_FMSE_00277
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment