(For better results and practical reasons, it is suggested to set key date as last date of previous month and report be executed in 1st week of current month. The buckets are flexible, and can be changed by user as per requirement. The encircled (red) fields represent the buckets or periods to be analysed. Once the plant / material types and key date is entered, valid materials in the selected plant and material type are fetched.Calculating the stocks of the material in the various bucket periods, arrived in previous step, and giving the output.Deriving the periods of time, otherwise known as buckets like stocks within a month, within 2 months….etc, dynamically based on the inputs given on the selection screen.Calculating the stock of the material on a selected key date.The report does three activities predominantly. How the New Inventory ageing report logic differs from the regularly used custom ageing reports:īrief overview of the logic employed in the new ageing report: The buckets of time could be anything within a month, within 6 months or for more than a year. This report aims at giving details of such stock distributions plotted over different periods known as buckets.īy segregating and analysing such materials, the finance and purchasing teams will be able to plan and manage inventories in an efficient manner. This material might not have been consumed and be in stock as non moving item. This stock could have been purchased in 2 lots of 50 and 50 between 6 to 12 months and before 12 months. Inventory ageing report gives an overview about the distribution of available stock of materials from over a period of time, from a selected key date in reverse chronological manner.įor example, a particular material might have a stock of 100 PCS on a selected key date.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |