Inventory Reports

General Information

Items Index

Item Balances

Open Inventory Transactions Retrieval

Inventory Transactions Retrieval

Inventory Statement

General Price List

Price List For Customer

Special Prices

Price Change

Inventory Value Report

 

 

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.

 

Skip to content