Dear All,
Recenlty when we ran inventory reconcile against an item, we got the following report, On Inventory Purcahse Receipts Work table it added records as reconcile and add new lot as reconile:0001 and so on.
Further to my investigation, the last invocie posted against this item got pick the unit cost as /0/ and on IV Purchase receipts & HITB table the sales in not recoded.
Kindly advise how to reverse the lots and bring back quantity, for your inforamtion, we use mutliple bins and Lot tracking
System: 1/16/24 3:12:40 PM Page: 1
User Date: 1/16/24 RECONCILE REPORT User ID: ramanan
Inventory Control
Ranges: From: To:
Item Number UB1102/U3(AE) W/ DUST BAG UB1102/U3(AE) W/ DUST BAG
Item Number Description Site Bin
-----------------------------------------------------------------------------------------------------------------------------------
Error Message
-----------------------------------------------------------------------------------------------------------------------------------
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG
Updated Purchase Receipt SEQ record for Item UB1102/U3(AE) W/ DUST BAG.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG All Sites
The On Hand Quantity has been adjusted from 1,878 to 3,756.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN
Added lot number RECONCILE:0000000001.
Added lot number RECONCILE:0000000002.
Added lot number RECONCILE:0000000003.
Added lot number RECONCILE:0000000004.
Added lot number RECONCILE:0000000005.
Added lot number RECONCILE:0000000006.
Added lot number RECONCILE:0000000007.
Added lot number RECONCILE:0000000008.
Added lot number RECONCILE:0000000009.
Added lot number RECONCILE:0000000010.
Added lot number RECONCILE:0000000011.
Added lot number RECONCILE:0000000012.
Added lot number RECONCILE:0000000013.
Added lot number RECONCILE:0000000014.
Added lot number RECONCILE:0000000015.
Added lot number RECONCILE:0000000016.
Added lot number RECONCILE:0000000017.
Added lot number RECONCILE:0000000018.
Added lot number RECONCILE:0000000019.
Added lot number RECONCILE:0000000020.
Added lot number RECONCILE:0000000021.
Added lot number RECONCILE:0000000022.
Added lot number RECONCILE:0000000023.
Added lot number RECONCILE:0000000024.
Added lot number RECONCILE:0000000025.
Added lot number RECONCILE:0000000026.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 37.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 44.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 128.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 128.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 22.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 255.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 128.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 255.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 45.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 128.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 63.
The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
The On Hand Quantity has been adjusted from 1,878 to 3,756.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 06-AWRL
Added purchase receipt /Reconcile/ for lot number MR-11805-CHINA.
Item Number Description Site Bin
-----------------------------------------------------------------------------------------------------------------------------------
Error Message
-----------------------------------------------------------------------------------------------------------------------------------
Added purchase receipt /Reconcile/ for lot number MR-11805-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11925-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11925-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-12269-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-12269-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2514376A
Added purchase receipt /Reconcile/ for lot number MR-11330-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11506-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11506-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2516246A
Added purchase receipt /Reconcile/ for lot number MR-11750-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11750-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2517132A
Added purchase receipt /Reconcile/ for lot number MR-11618-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11618-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2517266A
Added purchase receipt /Reconcile/ for lot number MR-11536-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2517346A
Added purchase receipt /Reconcile/ for lot number MR-11611-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2517346B
Added purchase receipt /Reconcile/ for lot number MR-11611-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11611-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2518256B
Added purchase receipt /Reconcile/ for lot number MR-11825-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11825-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2518276A
Added purchase receipt /Reconcile/ for lot number MR-11825-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2518316A
Added purchase receipt /Reconcile/ for lot number MR-12054-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2519192A
Added purchase receipt /Reconcile/ for lot number MR-11966-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2519366B
Added purchase receipt /Reconcile/ for lot number MR-11631-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-11631-CHINA.
UB1102/U3(AE) W/ DUST BAG ELECTRIC BLOWER WITH DUST BAG MAIN 2524244B
Added purchase receipt /Reconcile/ for lot number MR-12054-CHINA.
Added purchase receipt /Reconcile/ for lot number MR-12054-CHINA.
Total: 1
