Month end inventory valuation based on GL transaction date

I need to create a monthend inventory valuation report that includes transactions posted in the next month but with the prior month GL date and excludes transaction posted in the next month with the next months transaction date.

We invoice in January for shipments in December.  I need a final inventory valuation for December that include all December transactions but not January transactions..  Suggestions?

Assuming that your Item ASOF table (F41112) is accurate, you can write an As Of inventory valuation report using this table instead of F41021.  We wrote a custom program years ago using F41112 that allows us to compare As Of inventory values using multiple cost methods, but it looks like there may be some standard programs as well.  R41541 is the Item Ledger By G/L Class report.  It uses F41112.

Does anyone else know of a standard As Of inventory valuation report?

Thanks,

Travis Wendland

Project Manager

Little Rapids Corporation