• TurboCASH UK Website • Download TurboCASH FREE • Buy TurboCASH
taken from the Accounting Made Easy e-book








VIEW STOCK LEDGER REPORTS
VIEW STOCK MOVEMENT SUMMARY REPORT
  
The Stock Movement Report will only include the sales documents (Invoices and Credit Notes) and the purchase documents (Purchase or Goods Received Notes and Stock or Goods Returned documents entered in the Input - Documents menu option and which posted or updated to the ledger. If you are using the Point-of Sales facility, only the Point-of Sales Invoices for Shifts, which have been closed, will be included in this report. Any Stock Adjustments processed in the Input - Adjust Stock menu option will also be displayed.

This report is generated on the Stock Movement Options screen on which the following options criteria for the details to be included in this report is selected:
  1. Sequence - To list the details for the selected stock items included in this report according to the Stock Item Code, Description or Stock Groups 1 or 2 if you have created Stock Groups.

  2. Stock Code - select a specific stock item code or a range of codes on the Stock Item search or lookup facility.

  3. Dates - enter or select the date or dates (using the Date picker) for the detail you wish to include in this report.
This report lists the opening and closing quantities and details of the Invoices, Credit Notes, Purchases and Stock or Goods Returned documents created on the selected date or dates and which is updated to the ledger. An example of the Stock Movements report reflecting the details, is as follows:

Name of the business. System date and time. Page number. Name of report. Selected accounting period or periods. Stock code and description or name. Opening Quantity on hand for this Stock Item. Stock code. Document date - this is the transaction date. Document date - this is the transaction date. The document type (Invoices, Credit Notes and POS Invoices for customers/debtors) and (Purchase and Goods Returned documents for suppliers/creditors). Salesperson as selected on Invoices and Credit Notes. For POS Invoices, the Cashier/Salesperson will be displayed. The document number (Invoices, Credit Notes and POS Invoices for customers/debtors) and (Purchase and Goods Returned documents for suppliers/creditors). Purchases and Credit Notes increase the Quantities. Invoices and Goods Returned documents decrease the Quantities. The Cost Price of the Stock Items. The Selling Price of the Stock Items. For Purchase and Goods Returned documents, this is the Cost Price. Closing Quantity on hand for this Stock Item. Stock code and description or name. Opening Quantity on hand for this Stock Item. Document date - this is the transaction date. The document type (Invoices, Credit Notes and POS Invoices for customers/debtors) and (Purchase and Goods Returned documents for suppliers/creditors). Salesperson as selected on Invoices and Credit Notes. For POS Invoices, the Cashier/Salesperson will be displayed. The document number (Invoices, Credit Notes and POS Invoices for customers/debtors) and (Purchase and Goods Returned documents for suppliers/creditors). Purchases and Credit Notes increase the Quantities. Invoices and Goods Returned documents decrease the Quantities. The Cost Price of the Stock Items. The Selling Price of the Stock Items. For Purchase and Goods Returned documents, this is the Cost Price. Closing Quantity on hand for this Stock Item.

The details in this report is displayed in the following 8 columns:
  1. Stock Code - This is the selected Stock Item Code or Codes and the Stock item description will be displayed as headings.

  2. Date - The date is the date when the Document (Invoices, Credit notes, Purchases and Stock or Goods Returned documents) is generated and updated to the ledger. Any documents of which the dates are within the selected range, which are not yet posted or updated to the ledger will not be included in this report.

  3. Type - This is the document type (Invoices, Credit Notes, Purchases and Stock or Goods Returned documents). If any stock quantities have been adjusted in the Input - Adjust Stock menu option, Adjustments will be displayed.

  4. Salesperson - This is the Salesperson, which was selected when Invoices and Credit Notes were generated. No details will be displayed for Purchases and Stock or Goods Returned Documents.

  5. Reference - This is the document number for Invoices, Credit Notes, Purchases and Stock or Goods Returned documents as generated by TurboCASH. If any stock quantities have been adjusted in the Input - Adjust Stock menu option, an asterisk (*) will be displayed.

  6. Quantity - Purchases and Credit Notes as well as any adjustments, which increases the Stock quantities (stock in), will be displayed as a positive quantity. Invoices and Goods Returned documents as well as any adjustments, which decreases the Stock quantities (stock out) will be indicated as a negative figure.

  7. Cost Price - The total cost price (average or latest cost (cost of sales)) for all the selected stock items on the Invoice, Point-of-Sale Invoice or Credit Note. If it is a Purchase document or Goods Returned document, the Cost Price will be reflected as entered on the documents.

  8. Selling Price - This is the total amount of the selected selling prices (selling price 1 /2 / 3) for all the selected stock items on the Invoice, Point-of-Sale Invoice or Credit Note. If it is a Purchase document or Goods Returned document, the Cost price will be reflected.
These amounts or totals are exclusive of VAT. Opening and closing balances for the quantities will be displayed for each of the selected stock items included in this report.

The Quantities which are displayed in <> indicates a credit or negative figure. You may change this negative amount indicator to a minus sign (-) to prefix your quantities or set it to display a D (for Debit) or a C (for Credit) in the Setup - Preferences - Data Parameters menu option.

GNU Free Documentation License 1.2 SourceForge
Content released by Digidan under the GNU Free Documentation License 1.2.