[motoman]

Has anyone ever created a report / search where it shows the last time an assembly build was done form finished goods inventory. I am trying to determine the age of some of my inventory by the date it was last assembled/ built.

Any help would be appreciated –

I have tried Inventory activity report with the filter of Assembly Build and last transaction date – but the date does not go by the Assembly Build date – just when the last transaction for any transaction. Does me no good.

Thanks
This is a cached copy. Click here to see the original post.

[kvillar]

Hi motoman,

You may try an item saved search for this. Please follow these steps:

1. Navigate to Lists > Search > Saved Searches > New > Item

2. Under Criteria > Standard, set the following:

a. Type > Assembly/Bill Of Materials

b. Transactions Fields… > Type > Assembly Build

3. Under Results > Columns, click Remove All and set the following:

a. Name > Summary Type: Group

b. Location > Summary Type: Group

c. Transaction Fields… > Date > Summary Type: Maximum

4. Rename the Saved Search and click Save & Run

Note: If you do not use Multi-Location Inventory, just remove the Location field on the results.

[Author]

Posts