Stock Turnover |
Top Previous Next |
Watch the video tutorial https://www.youtube.com/watch?v=y1_-jhf4tLI
Hover the mouse over the different fields on the form. If the cursor changes to a hand (
) , click to get more information.
Stock Turnover
Go to Stock Items > Stock Turnover
The Stock Turnover screen is a powerful audit and analysis tool designed to detect errors, fraud, and pricing issues.
Hover the mouse over the different fields on the form. If the cursor changes to a hand () , click to get more information.
Stock Turnover - Right-Click Actions
Action |
Use Case |
Open Original Document |
View the source document (Invoice, GRN, Credit Note, etc.). → See who sold, when, and to whom.
|
Open Inventory Main Form |
Check cost, selling prices, Price 10, markup settings.
|
View Scanned GRN Image |
Verify physical proof of receipt — catch admin errors fast.
|
Drill to Stock Detail |
See full movement history (in/out, adjustments, etc).
|
Stock Turnover Grid Reports
Use Grid Reports to generate customized performance reports and uncover stock or pricing issues.
Below are useful examples you can generate and save:
Report Name |
Purpose |
Filter Expression
|
Items with Zero Cost |
Identify items missing cost prices. |
[Cost] = 0 And [Service] = False |
Markup Achieved vs.Target Markup |
Compare actual markup against target values from Stock Group Setup. |
Contains([Origin], 'INV') And [Service] = False |
Items Sold Below Cost |
Items sold below cost. The system will now display all stock items that were sold for less than their cost price.
|
[Profit] <= 0.0m And [Origin] Like 'inv' |
Negative Markup Items |
Detect items with negative markups — a strong indicator of pricing errors. |
[Profit] <= 0.0m And [Origin] Like 'inv' |
Selling Price vs. Price 10 |
Compare selling price to Price 10. Investigate pricing differences (e.g., promotions or overrides).
|
[Pr10 Diff %] <> 0) |
Sort by Markup |
Sort the Markup column (ascending/descending) to find lowest markups and possible fraud.
|
How the Markup % is calculated.
Get it in Stock | Stock Turnover | Pivot Grid Tab
E.g.
Turnover Cost Profit MU
Item 1 500 400 100 25%
Item 2 300 100 200 200%
------------------------------------------------------------------
Total 800 500 300 60%
------------------------------------------------------------------
The 60% markup (MU) is calculated by dividing the cost into the profit * 100 (300/500*100 = 60%)
Fix Zero Cost Issue:
1) Navigate to: Stock Turnover > Extra > Fix Zero Cost
2) Problem to fix: The Stock Turnover form is missing a cost price, resulting in a profit calculation of 100%.
Possible Cause:
Invoices might have been created without an Average Cost Price or Supplier List Price in the Main Inventory form. This issue may occur if the item was sold before the Goods Received Note (GRN) was processed.
How to correct: Zero Cost |
|
Step 1 |
Ensure there is a Supplier List Price or Average Cost Price in the Main Inventory form. Select the Cost of Sales/ Valuation Method you want to use (e.g., if using Average Cost Price, select Average Cost as the valuation method).
To see a list of items that will be affected: •Look for the column labeled 'Cost' and filter for cost = 0. •Right-click on the item, select Open Inventory Form, and ensure there is a cost price and the valuation method is correct. |
Step 2 |
1. Select the date range. 2. Select the Extra button on the menu and then Fix Zero Cost. (This works with all the items displayed in the grid and which cost price is 0). |
The Cost price will be changed in the Cost Column. An adjustment journal will be made with the following entries: Debit Cost of Sales and Credit Stock. |
|
Change the Cost of Sales /Valuation Method back to your desired method. |
For a summary of the data, select the analysis tab.
