| Description |
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-237604 - Assistance Needed to Clean Up (Net Out) a "Negative Quantity" at SPF 92|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-237604]
From: Greg Hammer < [ghammer@cbi-global.com|mailto:ghammer@cbi-global.com] >
Sent: 25 October 2019 23:10
To: KR < [kalirajan.s@irely.com|mailto:kalirajan.s@irely.com] >
Cc: Select Products < [admin@cbi-selectproducts.com|mailto:admin@cbi-selectproducts.com] >; Lisa Knight < [lknight@cbi-selectproducts.com|mailto:lknight@cbi-selectproducts.com] >; Jennifer Smith < [jsmith@cbi-global.com|mailto:jsmith@cbi-global.com] >
Subject: Assistance Needed to Clean Up (Net Out) a "Negative Quantity" at SPF 92
KR:
The attached file denotes a Before and After situation which we ran into today at SPF Co. 92. Details as follows :
# SPF attempted to Stage PICK-276 and was unable to do so because the system indicated that action would create a Negative Quantity .
# Using the AS OF Inventory view, I created a download of current status of Item 901317204 and noted that Lot 19280-01-01 had an Opening QTY of Negative (1) which was not visible to the SPF Staff using the inquiry screen. (See First TAB in the File titled Before Staging Pick 276 ).
# Accordingly I created IA-12527 to add 1 to the Lots which they were trying to Stage. Lot 19280-04-01 now had 1 more pound of product than was being staged. Following staging it reflects 1 pound still on hand. (See TAB 2 in the File After Adjustment & Staging ).
Not sure how the first lot got created with a Negative Quantity, but that Lot # is also assigned to Black Pepper and those on hand quantities are valid.
I believe that we need your team to offset the (-1) for Lot 19280-01-01 associated with Cassia Sticks Item # 901317204 (Batch 2081329) with the remaining quantity of 1 for Lot 19280-04-01 for the same Item and Batch #. Refer to Second Tab in the attached file (Column AG, rows 2 and 3).
Hope that is all clear. If so please net the Positive 1 and Negative 1 so that history is clean going forward. Feel free to call me on my mobile any time (614 595-3560) if there are any questions.
Regards,
Greg Hammer
Issue: After unposting the IR, Lot quantity is adjusted to negative quantity
# Create a IR with 2 Lots
# !pastedImage_d126074_0.png|height=614,width=1037!
# Go to Manufacturing --> Inventory View
# Search for the Lots
# !pastedImage_d126074_1.png|height=269,width=1336!
# Go to Inventory --> Inventory Adjustment
# Click on New
# Select the Item No
# Fill all the mandatory fields.
# !pastedImage_d126074_2.png|height=315,width=1342!
# Click on Save.
# Click on Post.
# !pastedImage_d126074_3.png|height=308,width=1313!
# Go to Manufacturing --> Inventory View
# Search for the Lots
# !pastedImage_d126074_4.png|height=308,width=1313!
# Go to Inventory --> Inventory Receipt
# Select the IR
# Unpost the IR
# !pastedImage_d126074_5.png|height=623,width=1044!
# Go to Manufacturing --> Inventory View
# Search for the Lots
# !pastedImage_d126074_6.png|height=305,width=1346!
# System adjusted with negative quantity
Expectation: System should not negative quantity
|