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.