Old Reports -> Stock -> Stock Item Listing

Parent Previous Next

Bug

If All Selling Prices option is selected and the Price Inclusive field is selected (ticked), the selling prices will display only Selling Price 1 as inclusive of VAT/GST/Sales Tax. Selling Price 1 and 2 will display the selling prices as Exclusive of VAT/GST/Sales Tax.

New / Related Topic

The following reportman versions of the Stock Item Listing reports are available from the Reports → Stock Item Listing menu:

All Selling Prices

Stock Item Listing


To Print Labels for Stock Items, you may go to the Edit → Stock Items screen and select the Stock Item Listing from the sidebar on the Stock Item list screen.

This option lists the code, description, quantity, cost price, selling price and total value. The system allows you to select certain options, e.g. if you want to produce a price list, the system does not allow you to select quantities and cost price, thus only producing a price list.

This report lists the accumulative quantities and stock values, as well as any latest and average cost prices and the selling prices for the Invoices, Credit Notes, Purchase and Supplier Returns documents which are updated to the ledger. You may also select to list the selling prices of a selected stock item, or a range of stock items (price list).

Print Stock Item Listing Reports

To Generate a Stock Item Listing Report:

1.Click on the Tools  → Old Reports → Stock → Stock Item Listing menu.

The Stock List Options screen is displayed:

2.Send Report to - Select the output method (screen, printer, file, e-mail or fax).

3.Sequence - Select to list the Stock Items according to the Stock Codes, Stock Description, Stock Groups 1 or 2 (Reporting Groups 1 and 2).

The description of Stock Group 1 or 2 you have entered on the Reporting Group Name field on the Stock Groups tab on the Setup → System parameters → Groups menu, may be reflected in this list.

4.From Stock Code ... To - Select the stock code, or a range of stock codes, to include in the report.

5.Information to include:

a)Stock Count - If selected, a column will be inserted in which the physical stock item count during stocktaking may be written in pen.

If there are any discrepancies (surpluses or shortages) in the stock items on hand according to TurboCASH and the physical stock items on the shelves or in the stores, you may need to adjust the stock items.

b)Selling Price - You may select all your Selling Prices or any one of the Selling Prices. You may also choose not to view any Selling Price.

If you select all Selling Prices, the Stock Count, Average Cost, Cost Price and Stock Value fields cannot be selected. They may be selected if no selling price or any specific selling price is selected.

The descriptions of Selling Price 1 / 2 / 3 will be displayed in the drop-down list as entered or changed on the Setup → System parameters → Stock Information menu.

c)Average Cost - If this field is selected, the Average Cost price will be displayed.

d)Cost Price - If this field is selected, the Cost Price will be displayed.

e)Stock Value - If this field is selected, the Stock Value will be displayed. This is the Quantity of Stock on Hand multiplied by the Cost Price.

f)Quantity on Hand - If this field is selected, the Quantity on Hand will be displayed. This is the Quantity of Stock Items at Hand according to TurboCASH.

The physical Quantity in the Stores may differ slightly from time to time due to theft, etc.

g)Include Zero Balances - If this field is selected, all the Stock Codes existing in your Stock Code file will be displayed. To view only those with balances leave this field blank.

h)Price Inclusive - If this field is selected, it will list the selling prices inclusive of VAT/GST/Sales Tax.

Bug

If All Selling Prices option is selected and the Price Inclusive field is selected (ticked), the selling prices will display only Selling Price 1 as inclusive of VAT/GST/Sales Tax. Selling Price 1 and 2 will display the selling prices as Exclusive of VAT/GST/Sales Tax.

If Selling Price 1 / 2 / 3 is selected on the Price Inclusive field is selected (ticked), the selling prices will display as inclusive of VAT/GST/Sales Tax.

6.Click on the OK button to send the report to the medium selected in the Send Report to field.

You need to select the following options on the Stock Item List Options screen to:

Check the Codes, Descriptions, Units and Latest and Average Cost Price, all the applicable options need to be selected in the Stock List Options screen.

Check that you have entered your selling prices correctly, you have to select All Prices in the Stock List Options screen.

View Stock Item Listing Reports

An example of the Stock Item Listing is:

The number of columns in which the information will be displayed, depends on the selected information to include. This report displays the information if all the information to include is selected, and one selling price in the following nine (9) columns.

1.Stock Code - The selected Stock Item code will be displayed.

2.Description - The name or description of the selected Stock Item code.

3.Unit - This is the selected unit (each, litres, boxes, etc. in which stock items are traded, as defined in the Setup → System parameters → Stock Information menu, and as selected for each Stock item in the Edit → Stock Items menu.

4.Qty On Hand - This is updated when opening stock quantities and cost prices were taken on in the Input → Adjust Stock (Take-on tab) menu and when documents are updated to the ledger. Purchases and Credit Notes as well as any adjustments which increases the Stock quantities (stock in) will update the quantity on hand as a positive quantity. Invoices and Supplier Returns documents as well as any adjustments will decrease the Stock quantities (stock out).

5.Latest Cost Price - This is the latest cost price (excluding VAT/GST/Sales Tax) for each unit of a Stock Item, as entered on the last Purchase documents which is updated to the ledger.

6.Average Cost Price - This is the average cost price (excluding VAT/GST/Sales Tax) for each unit of a Stock Item of the Stock items purchased.

This may differ from the latest cost price, if you have purchased a stock item for which a higher or lower price was entered on Purchase documents, which is updated to the ledger.

7.Sell Price - If you have selected to view No selling prices this column will not be displayed. You may select to view any one of the available three selling prices with any combination of the information included in this report. Should you select to view all three selling prices you may only select to include the Quantities on Hand.

The selling prices (up to three selling prices) which may be displayed on this report, are entered in the Edit → Stock Items menu, or as adjusted on the Input → Adjust Stock (Selling Prices tab) menu.

8.Stock Count - This column is blank. This enables you to enter (write) the physical stock count, when you do stocktaking on the printed item listing. Once this is done, you need to adjust the stock quantities in the Quantity and Average Cost, or Quantity and Latest Cost options in the Input → Adjust Stock menu, if the Stock Count Quantities are not the same as that of the System Quantities on Hand.

9.Stock Value - This is updated when opening stock quantities and cost prices were taken on in the Input → Adjust Stock (Take-on tab) menu, and when documents are updated to the ledger.

Purchases and Credit Notes, as well as any adjustments, will increase the stock value with the cost prices.


Invoices and Supplier Returns documents, as well as any adjustments, will decrease the stock value with the cost prices.


An example of the Stock Item Listing reflecting the Selling Prices is:

No quantities on the Stock Item Listing should reflect a negative quantity. If a quantity is displayed as a negative quantity, it could indicate that the Opening Quantities and Cost were not taken on in the Input → Adjust Stock (Take-on tab) menu, or that Purchase documents and Credit Notes are not yet updated to the ledger.


Created with the Personal Edition of HelpNDoc: Benefits of a Help Authoring Tool