on 10-08-2018 8:03 AM
Dear Experts,
I have been searching trough the forum, but could not get the correct explanation for the Inventory Turnover Analysis (Under inventory Menu)
1) I understand that this report will help user to manage the inventory, example to decide to increase/ decrease the quantity during purchase based on this report
2) Is the Period Good Issue Qty, Days of stock taking, and Next Reorder Point is always negative? May I know why?
3) Period Good Issue Qty = qty of inventory moving OUT within the selected date range
What is Days of Stock Taking and Next Reorder Point?
I managed to understand the calculation, but could understand, what is exactly the meaning of these two
4) How to calculate the turnover analysis? Is it correct to have positive figure is good?
Thank you in advance.
Hi,
Here answers for your questions,
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Nagarajan,
Can you please post the formula for the Inventory TurnOver field? it's missing from the list you posted above.
I understand that the logic is COGS / Avrg Inventory. but where is the system getting this values? If I run the report from 1/1/20 til 12/31/20 is the COGS current value? and avrg inventory same question. How is the system getting this value to end up with a Inventory Turnover ratio Total of 1.16 from the Pic below.
Hi,
Create few transactions in test environment to understand the definitions.
Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Nagarajan,
Thank you for your suggestion.
I did a few testing to test why the value inside this report always negative.
First, i thought because this item involve Down Payment transaction which user make payment first even the current stock is not enough. I did create a few new item and do transaction without down payment, the value is still negative.
Then I open the Crystal Report designer, to see the back end formula for this report, I can see that the negative started from the period good issue qty, which the value captured from table {Inventory.IssueQty}. This value is always negative as indicate the item OUT from the inventory. Then, this IssueQty used in most of the formula to get days in the period, turnover value, etc..I guess, this is why the report always appear in negative. Am I right?
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.