| Report Type |
Select the form that you would like to use to report data. Print the desired form by double clicking the desired report type or by selecting it and clicking the Print icon:
The initial balance in reports of all types is the balance from (that is, NOT INCLUDING) the start date for the report (Date From field) and is displayed as a "document" with a series of 11 zeroes (00-000-000000) as its document number.
Movements in the POS module are merged by date and shown with a sequential number: YY - year, DTY - document type, 000000 - series of six zeroes, which mean that the sequential numbers of POS issues are not listed.
|
| Item Type |
Select item types that you would like to include in the report. |
| Document Types |
Select document types that you would like to include in the commercial records report. All document types selected here will be included in the commercial records report. If you would like to create a report without a particular document type(s), uncheck the box next to the document type. Record Only document types are not used in commercial records and are not available to select!
|
| Date from |
The start date for purchase/receiving documents that you would like to include in the report.
If you select the Current Stock by Sale Price report type, this field will not appear.
|
| Date to |
The end date for purchase/receiving documents that you would like to include in the report.
If you select the Current Stock by Sale Price report type, this field will be renamed Stock as of, because this type of report shows the stock on a given day.
|
| Item |
Select an item ID if you would like to limit the commercial records report to a single Item (ID). |
| Primary Category |
Select a primary category if you would like to limit the report to items from a particular item category. |
| Warehouses (Retail Records) |
Select a warehouse(s) from which retail goods have been sold. If you do not select a warehouse, the program will display an error when you attempt to create a Record on Retail Sale and Purchase of Goods report: Warehouse must be specified!
You can also use the right-click menu to select warehouses for the report:
You can also select a warehouse by typing the first letter of the name of the desired warehouse and pressing the SPACE key to select it.
|
| Warehouses
(Wholesale Records)
|
Select a warehouse(s) from which wholesale goods have been sold. If you do not select a warehouse, the program will display an error when you attempt to create a Record on Wholesale Sale and Purchase of Goods report: Warehouse must be specified!
You can also use the right-click menu to select warehouses for the report:
You can also select a warehouse by typing the first letter of the name of the desired warehouse and pressing the SPACE key to select it.
|
| Warehouses
(Records of Services Rendered)
|
Select a warehouse(s) from which services have been sold. If you do not select a warehouse, all warehouses will appear in the record of the sale of services rendered.
You can also use the right-click menu to select warehouses for the report:
You can also select a warehouse by typing the first letter of the name of the desired warehouse and pressing the SPACE key to select it.
|
| Warehouses
(Warehouse Card, Current Stock, and Summary Reports)
|
Select a warehouse(s) for which you would like to report stock or the difference between commercial records and the actual balance at a warehouse (summary report). If you do not select a warehouse, the program will display an error when you attempt to create a Record on Wholesale Sale and Purchase of Goods report: Warehouse must be specified!
You can also use the right-click menu to select warehouses for the report:
You can also select a warehouse by typing the first letter of the name of the desired warehouse and pressing the SPACE key to select it.
|
| Department |
Select a department if you would like to limit the commercial records report to a single department from document lines. |
| Pmnt. Method |
Select a payment method if you would like to limit the commercial records report to a single payment method from receiving and issue documents. |
| Customer Account |
Select Account from Cart of Accounts |
| Use Open States |
See Use Open States |
| Use Date of |
Select the date that you would like to use to find the initial balance and sort records in retail, wholesale, or service commercial records (for an example of how this effects the commercial records report, see Packing Slip Date and Invoice Date).
- Packing Slip - the date of the reception or issue of the goods will be used
- Invoice Issued/Received - the date of the receipt or issue of the invoice will be used
|
| Show Compound Goods |
If this switch is turned on, then Idents of type G (goods packages) are shown in the Current Stock report. If it is not turned on, then only subordinate items are shown.
|
| Price Type |
Select which price the program will use to list receipts and issues (also see the description of the Read Sale Price From box below).
- Cost (Valuation) - this option will create a commercial records report by valuation prices entered in receiving/issue documents. If this option is selected, the Read Sale Price From box (described below) will not appear.
- Retail Price - this option will create a commercial records report using retail prices including tax from the Pricing in the Items register. The pricing valid when the invoice with the item was created will be used.
- Sale Price (excl. VAT) - this option will create a commercial records report using retail prices excluding tax from the Items register. The price valid when the invoice with the item was created will be used.
- Wholesale Price 1 -this option will create a report using the wholesale price 1 from the Items register. The price valid when the invoice with the item was created will be used.
- Wholesale Price 2 -this option will create a report using the wholesale price 2 from the Items register. The price valid when the invoice with the item was created will be used.
See Price Types in Commercial Records for more information.
|
|
Read Sale Price from
|
In commercial record reports by sale prices, sale prices from the Items register that were valid when an invoice with an item was created are usually used (see the above description for more information). You can choose from one of the following options:
-
- Prices - this option will create a commercial records report using the sale prices from the Items register that were valid when an invoice with the item was created, regardless of the actual calculated sale price - any rebates will not appear in the prices in such a report. For an example see Price Types in Commercial Records.
- Document Line - this option will create a commercail records report using the (calculated) sale prices used. Any differences between the actual price and price in the Items register will be shown separately as reversals (in the Purchase section of the report). This is formatlly the most correct option. For an example see Price Types in Commercial Records.
- Use Actual Sale Price - this option will create a commercial records reports using the actual calculated sale prices that appear in the issue invoices. It will ignore the information in the Items register. This option is only suitable for accounting firms who do not have access to the entire database. For an example of use, see Retail Commercial Records Report by Daily Proceeds.
This box will not appear if the Cost (Valuation) option is selected in the Price Type box or if the Record on Rendered Commercial Services report type is selected, because it is not necessary in these cases.
|
 |
This button will create a commercial records report using the criteria that you have selected. |