The Debtors Control "Queries" tab enables you to easily request important Accounting & Transactional Data, allowing you to keep track and receive a comprehensive “big picture” of the financial health and activity of your business
The Win Accounting Debtors Control Module offers you important details regarding Account Query and Debtors Document History, as well as options to search for specific posted documents using the Document Number History and Document Stock Code queries
Queries pertaining to Salesman Statistics, Product Analysis and Invoiced Category Items Quantity per Customer are currently in the works, and will be rolled out in the near future
Using Account Query:
Account Query Overview
The Account Query window provides you with an overview of all posted documents for the selected Debtor
From here you can print statements and view the current amount still owing to you, the amounts still owing for each 30-day period (up to 150 days) as well as the Total Balance still owing for the debtor
View other useful information such as the Year to Date Sales and Year to Date Credits, the Date of the Last Sale and Date of the Last Payment, the Debtors Credit Limit and so on
Once a document is highlighted you can also Print and/or Preview the document, as well as click the “Send To” button which enables you to send the entire contents of the list to the Printer, File, Email, FTP or Clipboard
Choose Debtor
Start by selecting the desired Debtor - Once the Debtor is selected, all relevant Accounts Receivable data regarding their Account will automatically populate
View important Account Information and specific details regarding each individual accounting document
Click to Print Statement for the selected Debtor and use the Query Sort to choose how to sort the documents – either by Aging Date, Invoice Number or Transaction Date
Account Details
Once a client has been selected, all posted documents and transactions will appear in the list below
Print Statement for client send orPrint/Preview the Highlighted Document with ease.
Use the Send To option to send the entire contents of the list to your Printer, File, Email, FTP or Clipboard
Use the General Debtor Information section to better manage your client, view account ageing and stay on top of any Late Payments
Using Debtors Document History:
Debtors Document History Overview
The Debtors Document History query window provides you with a history of every document relating to the selected Debtor
This list will show you all Posted Invoices and Credit Notes, as well as any Quotations and Orders that have been created for the selected Debtor
From this window you can easily Print and/or Preview a selected Document, and where it's relevant, you can also view the Item Details for a selected document
Choose Debtor
To receive a concise rundown of every client's Document History, start by selecting the desired Debtor
Once the Debtor is selected, a document history list will automatically populate the window
This list will include all posted Invoices and Credit Notes that have been posted through the Document Capture and/or Enter and Post sections – You will also see all Quotes and Orders that have been created for the Debtor
Choose how you wish to sort the documents, either by Document Type or Document Date
Document List & Details
With a document highlighted, easily Print Document or Preview Document to view more information and/or export/send to your attached printer
Where relevant, use the Item Details to hone in on a highlighted document, viewing line item and other document-related information
Using Document Number History:
Document Number History Overview
To make looking up a document as easy as possible, the Document Number History Query window will show you a list of every posted Invoice and Credit Note (across all debtors) – the list will also include all Quotes and Orders that have been created
From here you can pinpoint the exact document that you're looking for by typing in the relevant document number
Once you have found the specific document, you can easily Print and/or Preview the document – and where it's relevant, you can hone in on the line item and additional document details using the Item Details option
Note: This query feature is particularly useful for user's who know the document number of the document they are searching for, but may not necessarily know which debtor corresponds to said document
Entering Document Number
To search for a document, simply type in the document number (or a partial document number) and Press Tab
Once you press Tab, the program will highlight the specific document (or the document with the number that closes matches what you have searched for)
With the desired document highlighted, you can Print/Preview or hone in on it with ease
Document List & Details
As with the other query windows, with a document highlighted, easilyPrint Documentor Preview Document to view more information and/or export/send to your attached printer
Where relevant, use the Item Details to hone in on a highlighted document, viewing line item and other document-related information
Using Document Stock Code Search:
Document Stock Code Search Overview
The Document Stock Code Search query window is designed to help you find posted documents for a debtor that have specific stock items as line items
This is particularly useful when a returning customer has a question regarding a previous purchase, or wants to purchase another of the same stock item they previously purchased
As with the other query windows, once you've found your desired document, you can easily Print and/or Preview the document and hone in on the line item and additional document details using the Item Details option
Choose Debtor & Stock Code
To receive a concise rundown of every document for a specific Debtor, start by selecting the desired Debtor
Once the Debtor is selected, a document history list will automatically populate the window
You can then enter a Stock Code (or partial Stock Code) and either press TAB to filter the results accordingly, or simply click on one of the documents in the list to filter the results based on the Stock Code entered
The list will now only show documents that contain the specific and/or partial stock code entered within its line items
Document List & Details
With a document highlighted, easily Print Document or Preview Document to view more information and/or export/send to your attached printer
Use the Item Details to hone in on a highlighted document, viewing line item and other document-related information
