Open Inventory Transactions Retrieval
Inventory Transactions Retrieval
Here is some general information about the Inventory Reports:
Item Filtering
You can determine the Filtering of Item Cards to be included in the report using the following fields:
Key: The Item Key is the item Identifier Code.
Sort: The Sort Code allows you to create groups in the Items Index. Each group is characterized by a specific Sort Code. The Sort Codes make issuing reports easier. The Trial Balance is sorted as follows: Item Cards are first sorted by Sort Codes, and within each Sort Code they are sorted by Item Keys. The subtotal is printed each time a digit is changed in the Sort Code. An appropriate Header can be defined for each Sort Code.
Filtering: The Filtering allows you to issue a report that includes various items that are not indexed consecutively. Each character may be either a letter or number. Each character may specify a particular characteristic of the item. The filtering contains 10 characters. When entering a filtering in a particular account, all 10 characters must be entered. If the filtering includes less than 10 characters, insert the symbol ^ (shift + 6) instead of a whitespace character.
The general rule is: When issuing reports, items can be retrieved by masking – whenever a character should be ignored, is may be replaced it with an asterisk (*).
Active / Inactive: This section determines whether the report should include only active items or inactive items, or both.
Print Destination: Select from the following options:
Issue: The report is saved to PDF. This file may be printed out or saved.
Excel Issue: Report data will be saved in an Excel file.
Wrap Column Content Exceeding One Row: This section is used for fields that may contain long values (e.g. Item Name, Details), requiring a longer printing space than available inside their printed column. Check this checkbox so the software doesn’t “cut” excessively long fields, but rather continue their printing into the following row (of the same column).
Items Index
This report shows the list of items or a filtering of items.
Item Balances
This report shows the list of items or a filtering of items, including the Inventory Balance for each item.
Open Inventory Transactions Retrieval
Open Inventory Transactions are transactions that have not been closed by a Closing Document. For example, a delivery note transaction that has not yet been closed by an invoice, or an order transaction that has not yet been closed by a delivery note or invoice. This report allows you to view any filtering of open transactions and sort them by a column of your choice.
Inventory Transactions Retrieval
Inventory transactions are all the transactions recorded in Marketing and Purchase documents (quotations, orders, delivery notes, invoices, transfer between warehouses, general entry and shipping out, opening balance). This report allows you to view any filtering of these transactions and sort them by a column of your choice.
Inventory Statement
Inventory Statements show the transactions for each item and their Accumulated Balance (similar to an Accounting Statement).
General Price List
The price list shows the prices of items for all customers.
Price List For Customer
This price list shows the prices for a particular customer according to their own special discounts and prices.
Special Prices
This price list shows the special prices for each customer.
Price Change
This report lists the changes in prices during a specific period.
