STOCK SUMMARY REPORT

After moving from one company to another in Indonesia which is using axapta, I have 1 report that always required by user, that Repot is 'Stock Summary' which is summarized by period, product, inventory dimension in row base and Opening Qty, In Qty, Out Qty, Closing Qty in column base. I' don't know why microsoft doesn't provide this report, even it is only country-specific features. The version of this report is many but these report have only one pattern as described before. Some consultant suggesting to use physical inventory reports group or inventory value report group, but those reports doesn't fit the user requirements.
The idea of creating this report is read all Qty in inventtrans table with period by physical date and relate to inventdim table. By this Idea you can find out the qty that was transacted at axapta, except if you need to create Stock summary base on financial transaction it's mean only transaction have final financial amount in inventtrans table. Just look at customer balance list report it's similar report although different in displaying/providing data. Just take a look at picture below hope this can help anybody that required report like this especially for Indonesia user





Beside the report above some user need supporting report to describe the real transaction. The following report is Stock Summary detail that used to explain behavior of transaction on the IN or OUT at Stock Summary. The Idea is same with Stock summary report, the additional information come from 'transrefid' in inventtras table. Some consultant suggesting to use inventory transaction report to handle detail information but this is not quite informative because difficult to read and not easy to summarize.








inventory transaction report axapta standard





pls let me know if you difficult to create this report and good luck !