Other Reports Auditors Reports Creditors Document History Gives a full report on Creditors Documents which have been posted. Report is filtered by Document type and date. Creditor to select the creditor Date From to select the date from which the report will run from Doc Number to enter document number Division to select the division from the drop-down arrow Creditor Status to select the status from the drop-down arrow Status to select the document status - Posted or Preparation Document Type to select the document type from the drop-down arrow Date To select the date to Project to select a project  Region to select the region from the drop-down arrow Order By to arrange the document history by selecting order by from the drop-down arrow Category   Recurring Order Creditors Journal Transactions Report Creditors> Reports> Report List Full transactional history of all postings done within Creditors. With the opening and closing balance per creditor and movement between dates specified. The "Print Creditors" tick is a filter to include creditors that have a closing balance but do not have any transactions within the selected date range that the report is generated for. Removing this tick will return only creditors that have transactions within the report date range.  Branch   Creditor From Creditor To Division Region From Year To Year From Period To Period Sort By Sort the report by selecting one option from the drop-down arrow. Options area: by Code, Description, Group Code or Bin Location Sub Sort By Show PO Tick Print Creditors Tick Show Source Doc Tick   Debtors Document History Debtors> Reports> Report list Gives a full report on Debtors Documents which are posted. Report is filtered by document type and date. This is a full report of posted documents of a selected debtor Debtor to select the debtor Date From to select the date from which the report will run from Sales Rep Doc Number to enter document number Division to select the division from the drop down arrow Region to select the region from the drop down arrow Category Debtor Status to select the status from the drop down arrow Status - Posted or Preparation to select the document status Branch Show Local Currency Only Document Type to select the document type from the drop down arrow Date To select the date to Project to select a project  Order By to arrange the document history by selecting order by from the drop down arrow Contact Person Acct. Manager Order Number Job Number Recurring Invoices Show Columns Debtors Journal Trans Report Debtors> Reports> Report list Full transactional history of all postings in debtors with opening and closing balance per debtor and movement between dates specified. This is a debtor’s full transactional history of posted documents Branch to select the branch from the drop down arrow Debtor From to select the debtor from which the transaction report will run from Division to select the division from the drop down arrow Status to select the report status from the drop down arrow  Debtor To to limit debtors report by selecting the debtor to Region to select the region from the drop down arrow Account Manager to select the account manager from the drop down arrow  Year From to select year from and Year To from the drop down arrow Period From to select the period from and the period To from the drop down arrow Sort By to sort the report by selecting from the drop down arrow Print Debtors with no Transactions to tick the box in order to include debtors with no transactions Year To to select year from and Year To from the drop down arrow Period To to select the period from and the period To from the drop down arrow Sub Sort By to select sub sort from the drop down arrow GL Cashbook General Ledger> Reports> Report List Lists all transactions by a specific bank account and also shows whether the transaction has been reconciled or not, gives the opening and closing balance based on the date selected.  This is a report that lists all transactions by a specific bank account and also shows whether the transactions has been reconciled or not.  Account to select the account from the drop down arrow  Division to select the division from the drop down arrow Region to select the region from the drop down arrow  From Year to select the year from which the GL cashbook report will run from and year to, for limiting the report run From Period to select the period from which the GL cashbook report will run from and the period to, for limiting the report run Sort By to sort the report by selecting from the drop down arrow GL Summary Income Report Gives a monthly to yearly summary report, per financial period, Turnover less cost of sales, giving gross profit plus income less expenses to nett profit. Can also be viewed as a summary income statement. Inventory Valuation Inventory module> Reports> Reports List Gives a report of all items cost, multiplied by quantity, to give the total value of stock.  This can be given by warehouse, group codes and by various Work in Progress areas.  Work In Progress   Sort By Show Serials Warehouse Sub Sort Show Zero  Show Inactive Stock Type From Item Show Movement From Item Sum Fixed Assets Use Groups Summary Decimal Places Group Selection   Inventory Valuation Back Dated Auditors Reports >Inventory Valuation Back Dated Report Similar to Inventory Valuation report but allows one to find out what the quantity and cost of items on a specific date. TAKE NOTE: This report could possibly not be accurate due to back dating of transactions. Warehouse Stock Type Stock From Sort By Date To Decimal Places Stock To Allow Zero Tick Tax Report Report shows from month to month the VAT or Tax due for this period. It is possible to view a summary or detail of VAT allocated. Summary   Detail Year From Period From VAT Type Summary Calculation Incl. Account Branch Year To Period To Sort By   Users Security Report Auditors Reports >Users Security Report Report listing the various rights and accesses for the users User From User To Active Tick Order By Financial Reports Book Value Per Share Report This report displays the Book Value per share worked out by total owners' equity divided by number of shares issued Shares   Generate to run the report Current Ratio Report Works out the current ratio by taking the total current assets divided by the total current liabilities Year   Acc Level Period Print to print the report Earnings Per Share Basic Report Earnings per share gives a share value per financial period month and is worked out nett profit divided by number of shares issued From Year Select the year from From Period Select the date from To Year Select the year to To Period Select the date to Project Branch Shares Gross Margin Ratio Report Gross margin ratio report is given on a financial period per month and is worked out by gross margin divided by turnover From Year select the year from From Period select the date from To Year select the year to To Period select the date to Project Branch Profit Ratio Report The profit ratio is then worked out per period. The report gives a monthly to yearly summary per financial period to Turnover less Cost of sales giving Gross Profit plus Income less expenses to Nett Profit Year From   Period From Year To Period To Project Branch Serial Numbers Fixed Asset Bar Code Report Inventory Type   Report Type Fixed Asset From Fixed Asset To Warehouse Debtor Report Listing Serial Number at a Client Debtor   Reference Date From / To Show Prices Serial Rental Report Debtor   Reference Date From / To Show Prices Serial Number Listing Shows a full report of all serial numbers used in the system and the last date of movement that occurred. Serial Number   Stock Item From / To Report Type Sort By Serial Number Movement Report Shows each item sold to a specific debtor with invoice number and which serial numbers were used Serial Number From / To   Date From / To Group By Document Type Show Last Movements Number Of Movements Serial Number Report Reports on serial number associated with stock / fixed asset by debtor, stock or warehouse Stock Types   Report Types Group By Warehouse Debtor From Stock From Stock To Exclude Values Serial Number Transactions Shows each item with the date and detail where the serial number had been used Stock Item   Serial Number Date From Date To Show In Stock VAT VAT Report - Payment Method VAT report for payment method Branch   Year Tax Type Summary Notice Reporting Method Period Sort By Exclude Zero Values Report Transactions with no VAT Selected Report shows items that have no VAT selected on them. Broken up between various documents Date From / To   Sort By Select All Select VAT 201 Calculation Report Branch   Financial Year From Financial Year To Financial Period From Financial Period To VAT Recovery Exports Tax File Export   Creditor File Export Debtor File Export GL Account Export Transaction Type Export Transactions Export VAT Report - Payment Method Bank Only VAT report for payment method only showing bank transactions Financial Year From / To   Period From / To Customer Tax Type Sort By Supplier Tax Type VAT Report Original Report shows from month to month with the Tax (VAT or GST) due for this period. A Summary or detail of Tax (VAT or GST) allocated Summary   Detail Year From Period From VAT Type Summary Calculation Incl. Account Branch Year To Period To Sort By VAT Report with Period Closing Report is based on VAT periods being closed. This report will also look at back dated transactions and put them in the current period. Report shows from month to month with Tax (VAT or GST) due for this period. Branch   Year Tax Type Summary Inc Account Show Post Dated Reporting Method Period Sort By Exclude Zero Values Consolidate Keep GL Detail