Missing Report?

CobaltSS

Hi,
Is there an existing report that will allow the user to choose the Physical Inventory Journal, a batch name, Posting date range, Location etc., and show the user all the adjustments made by that Batch?

I've looked through the Inventory reports, but can't find what is needed.

cheers,

Savatage

No but it's easy to create. You use the Item Ledger Entries.

The Key Here is that you have some kind of Sequenced "Document No." that you can filter on.

What I mean by that. Is we created a seperate number series for "Cycle Counting" I applied this new No. Series to a Batch name create in the Phys Inventory journal. The Number series started @ CC0000001 to CC9999999.

This allows me to filter on all Doc Numbers that start with CC* on the report and then Enter your Posting Date or range & bingo.

OR

the ILE sould also save it's No Series - so If you have one specified JUST FOR these journals you can use that as a filter to.

CobaltSS

Thanks Harry,

You actually read my mind with the Cycle Count example. I'm just surprised nothing that straight forward exists in Base.

cheers,