Hi all,
One of my customers has asked for an inventory ageing report. Can anybody tell me what are the things that needs to be taken care before asking for further details from the customer. I mean can anybody tell me the pre requisites that needs to be there or may be the basic setup in the system??
Like what valuation methods are possible or whether it is possible for serial and lot batch items??
What possible configuration can be done about this?
Any help is appreciated.
I'm not sure my reply could be very helpful.
However, I'd like to share my idea for your first approach.
Maybe following windows could be interesting:
- Warehouse Management\Financial Control\Analysis\Inventory Turnover Rate per Period
(See Solution 48741: "Finally, the Turnover Rate is simply the Issued Value divided by the Average Inventory Value.")
- Warehouse Management\Quantity in Stock\Analysis\Average Issues/Receipts per Period
All these information is based on data shown in
Inventory -> Quantity In Stock -> Analysis -> On Hand Develop per Period
These data are updated by
Warehouse Management\Transaction History\Aggregate Inventory Transactions per Period
Regarding serial and lot batch items have a short look on
- Part Master Data\Master Part\Part/Lot Tracking\Part Serial History
- Part Master Data\Master Part\Part/Lot Tracking\Lot Batch History
Here you can see which valuation methods are available for serial and lot/batch items.
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.