Stock Turnover

Top  Previous  Next

Go to Stock Items > Stock Turnover

Watch the video tutorial

Hover the mouse over the different fields on the form. If the cursor changes to a hand (Hand_Cursor) , click to get more information.

Suppliers With Stock To OrderHelpSecurity SetupTabsUnlock MonitorQuick AddCalendardashboardCompanyEmployeeQuoteWorkshopSupplierCustomerLedgerInvoiceFileRTS LookupGoods ReceivingGRN LookupPO LookupNew RTSNew POPurchase PlanningExtraStock GroupsStock TakeStock AdjustmentsStock OptionsStock TurnoverItem LookupExtended Item LookupStock DetailNew ItemStock Main Menu


Hover the mouse over the different fields on the form. If the cursor changes to a hand (Hand_Cursor) , click to get more information.

ServiceUnitCommissionCommissionVariable PriceCustomer RepConsignmentrepDoc. No.RetrieveOriginInventory GroupBin LocationEmployeeCheckboxSearch RowSummary BarClearBranchClearAnalysisRep ReportPrintClear Grid FilterRefreshExtraEdit FilterGrid ReportSelect VisibleOpen GL DetailOpen EnquiriesOpen Original DocumentOpen inventory FormDate Range QuickDate RangeStock_Turnover

Click on the Analysis Tab for summary's and graphs.


How the Markup % is calculated.

Get it in Stock | Stock Turnover | Pivot Grid Tab


                         Turnover    Cost    Profit        MU

Item 1                  500           400    100           25%

Item 2                  300           100    200          200%


Total                    800            500    300          60%

The 60% (MU%) is thus calculated by dividing the cost into the profit * 100 (300/500*100 = 60%)


Fix Zero Cost.

Go to, Stock Turnover > Extra > Fix Zero Cost

Problem to fix: There is no cost price in the Stock Turnover form, thus the profit is 100%.

This problem can occur if the invoices were made out and there was no Average Cost Price or Supplier List price in the Main Inventory form. Reason: maybe the item was sold before the GRN was processed.


How to correct: Zero Cost

Step 1

Make sure that there is a Supplier List Price or Average Cost Price in the Main Inventory form. Select the Cost of Sales/ Valuation Method that you want to use. E.g if you want to use the Average Cost Price, select Average Cost as the valuation method.


To see a list of items that will be affected, go to the item lookup -  filter for cost = 0. Right-click on item, select open inventory form and make sure that there is a cost price and that the valuation method is correct.

Step 2

Make a backup of your data.

Step 3

3.1 Go to the Stock Turnover form

3.2 Select the date range

3.3 Select the Extra button on the menu and then Fix Zero Cost

Step 4

Check that everything is correct

The Cost price will be changed in the Cost Column.

An adjustment journal will be made. Entries will be: Debit Cost of Sales And Credit Stock.

Step 5

Change the COST of Sales /Valuation Method back to what you want.


For a summary of the data, select the analysis tab.


Keywords: Calculation of MU% & GP%,Fix Zero Cost,History per item,Markup,Representative Report,Stock Turnover,Turnover Per item