Hi All,
I am trying to create a saved search to differentiate the inventory detail lines in the ‘Item Receipt’, but when I build the saved search it is giving me duplicate lines.
For Example:
I have an Item Receipt for an Item ‘X’ and quantity as 10. I am receiving the item into 2 lots Lot1: #ABC1 & Lot2: #ABC2 with each quantity as 5
These are the criteria & results, I am using in the saved search:
Criteria:
Type : Item Receipt
Internal ID : Item Receipt Internal ID
Main Line : false
Tax Line : false
COGS Line : false
Shipping Line : false
Results:
Item : Internal ID
Item Number/Inventory Number : Internal ID
Inventory Detail : Quantity
Transaction Serial/Lot Number
this is resulting in 4 lines, it is repeating the 2 lines for the Lot Numbers, i.e., it is repeating the Internal Id’s of the lot number for twice.
Note: I need the internal id’s of the inventory numbers based on the Item Receipt, but not from the Inventory detail of Item Receipt.
Thanks,
Sundeep
This is a cached copy. Click here to see the original post.