Iptor.com Help Centre

Related topics

The following describes how you can make a balance enquiry on Distribution and Financials information in the system database.

For this example you will use the template you created in Create a balance enquiry template in Analyser, thereby analysing customer information.

Prerequisites
Before you can make a balance enquiry, the following must/should exist:

At least one template must exist. (See Create a balance enquiry template in Analyser.)
Summary levels should have been generated on the iSeries for the key combination in the template. This will ensure accurate hits for the keys you enter in the enquiry. (See Define a summary level .)

When working with a Balance enquiry you have the option to do a number of things, including:

Accumulate the values for every enquiry in one session
View the totals of the accumulated values
Save the totals for later use – also accessible to anyone in your network (if you have made the information public)
Add additional formula columns
Drill down on the following lower-level transactions:

DIS Invoice transactions
G/L transactions. This option is only available if the keys in the template are FIN related keys.
A/P transactions
A/R transactions

Select Query groups

Do as follows:

Access the Balances menu item from the Business reporting sub-menu.
You view the Balance details view window, with the input fields and columns corresponding to the last template you selected. To switch to the Customer balances template you configured, select Template/select from the menu bar.
On the Selection required window, select Customer balances and then click Select.
You view the Balance details view window displaying the input keys available and the columns for the template.

You can now start to analyse the net sales value and sales quantity for the applicable customers.

Note: The Relative year is set at 0 by default. You can select to add / subtract from this to see years after / before the relative year.

To enter the customer number you have two methods from which to choose. You can:

Manually enter the customer number in the Cust/supp number field
Click Find to the right of the Cust/supp number field. You access the Customer browser, where you can find and select the applicable customer.

When the applicable customer number has been entered/loaded in the Cust/supp number field, click Show balance.

You view the results of the Customer’s balances in the bottom section of the window.

Accumulating values
You can add or subtract the values of all enquiries you make within one Balances session. The result of the calculation is stored in the accumulator. To use the accumulator, do as follows:

Make an enquiry as described above (i.e. enter the applicable customer number and click Show balances).
Add the resulting values to the Accumulator. Click the Add to accumulator icon or choose Calculation/add from the menu bar.
Make an enquiry for another applicable customer and add the resulting values to the Accumulator.
Repeat for all applicable customers.

To subtract the resulting values, click the Subtract from accumulator icon or choose Calculation/Subtract from the menu bar.

Toggle accumulated values and details
You can toggle the accumulated values of all keys you have made an enquiry on and individual details for last entered key value. To view the results of the accumulated values for the selected keys (i.e. customers entered for this example), click the Show accumulated values icon. To return to the details of the previous enquiry, click the Show details icon.

To clear the accumulator when you have completed your accumulation work, click the Clear accumulator icon or choose Calculation/Clear from the menu bar.

View balance totals and save key info for later use
You can view the totals of all enquiries you have made in one template during one session.

Click the Show totals list icon or choose View/Totals list from the menu bar. You view the Balance totals view window outlining the totals for all enquiries made.

Saving the key totals for later use
In the Balance totals view window, you can save the key value group to be re-used or select a previous key value group.

To save a key value group, choose Keys/Save as… from the menu bar in the Balance totals view window.
In the Key value group window, enter the user-defined Code and Description. Check the Public box if you want to make the key value group available across the network. If you uncheck the box, the key value group will only be displayed to you as the creator. Click Save.

When a key value group has been saved, you have the following options:

To change the description and network availability of a key value group, choose Keys/Save from the menu bar in the Balance totals view window.
To select a keys value group, click the Select keys icon in the Balance totals view window or choose Keys/Select from the menu bar. Select the key value group and choose Select or double click the key value group.

Creating a formula column
In both the Balance details view window and the Balance totals view window, the calculator function allows you to create an additional column, whereby the output is determined by a formula.

To use the calculator, do as follows:

From either window, click the Show calculator icon (alternatively, choose Calculation/Formula from the menu bar in the Balance details view window or Show/Calculator from the menu bar in the Balance totals view window).
You access the Formula view window.

You must enter the user-defined Title for the additional column and then select the columns and computations for the formula.

Click OK to save the formula.

You return to the Balance totals view window or Balance details view window (depending on where you started) in which you view the column you have created.

Viewing lower level transactions
You have the possibility to view the following lower level transactions. You access these transactions by clicking the Show transactions icon or by choosing View/Transactions/View selected from the menu bar.

DIS invoice browser	This is the default transaction enquiry that will be accessed by clicking the Show transactions icon if the keys in the template are DIS and Customer-related keys. For more information on how to work with the Invoice browser, see DIS invoice enquiry in Analyser.
G/L Transaction browser	You can only access the G/L Transaction browser when you are using a template that holds keys relating to Financial data. At least one account part must be included amongst the keys. For information on how to work with the General Ledger Transaction browser, see General Ledger enquiry in Analyser.
A/R Transaction browser	You can access these transactions if the keys in the template are FIN and Customer-related keys. For more information on how to work with the A/R Transaction browser, see A/P and A/R transaction enquiry in Analyser.
A/R Transaction browser	A/P Transaction browser. You can access these transactions if the keys in the template are FIN and Vendor-related keys. For more information on how to work with the A/R Transaction browser, see A/P and A/R transaction enquiry in Analyser.