one
At this screen, you can view your item – balance list report. The report contains information such as the average, cost, and purchase prices of the items as well as the quantities sold within a specified period of time. The data are retrieved from Exact Globe. From here, it is also possible to drill down to view more information of a particular item.
This screen is accessible if all in the following is met:
Logistics/Reports/Back office/Item – Balance list
To view the overview of back office item – balance list reports, function right 729 — View back office reports is required. Users with the Customer manager role have this function right.
For more details on what you can do with function rights or levels, go to System/Setup/Security/Function rights, select the required module, and then click on the relevant ID. To find out the functions you can perform with a particular role, go to System/Setup/Security/Roles, type in the description, click Refresh, and then click the required link under the Role column.
Click this to display the results according to the defined criteria.
Note: Once you have clicked this button, the name of the button will change to Refresh.
Click this to update the results according to the defined criteria.
Click this to clear the defined criteria so that you can start a new search.
Click this to exit.
Select the required check box(es) to display the item – balance list report of the selected item(s).
Type or select the required option to display the item – balance list report for the selected division. For more information on divisions, see Overview of Divisions. Once you have selected a division, you can view the details of the division by clicking the name of the division displayed next to the box. For more information, see Viewing Division Cards.
Note: By default, the division of the person currently logged in to Exact Synergy Enterprise will be selected. You can only select another division if your role level is equivalent or higher than the division level.
Select Purchase units or Sales unit to display the quantities of items in purchase or sales units.
Type or select the item to display the item – balance list report of the selected item.
Type or select the warehouse code to display the item – balance list report with items that are linked to the selected warehouse.
Type or select the date or range of dates to display the item – balance list report based on the transaction date(s) selected.
Type or select the date to display the item - balance list report based on the reference date selected.
The following screen is an example of the results displayed once you have clicked Show or Refresh:
You can view certain information of the items such as the quantities of items sold within the specified period of time, average, cost, and purchase prices of the items, and more. If the same item exists in Exact Synergy Enterprise, you can click the hyperlink under the Item column to view a particular item in detail. For more information, see Viewing Item Cards.
Click Customize at the title bar to customize the fields, columns, or sections. You can add or remove existing criteria based on your preferences by selecting or clearing the relevant check boxes. Click Save to save the settings, Default to reset your selections to the default settings, or Close to exit. Take note of the following sections/fields:
You can add or remove columns based on the information you want to view. You can arrange the order of the columns by clicking the Up or Down buttons. There are various columns that you can select such as Project, Country, Debtor name, and many more.
You can add or remove the fields for the filter criteria before generating the report by selecting or clearing the relevant check boxes under this section respectively.