SYSPRO Ribbon bar > Query > AP at a Glance by Branch

AP at a Glance by Branch

You use this program to view month-to-date totals of your Accounts Payable module by branch for the current and previous two months.

In addition to viewing Accounts Payable activity by branch, you can also use the program to determine whether the totals for each AP branch balances to the corresponding control accounts in General Ledger.

Toolbar and menu

Field Description
Period to view  
Current Displays information for the current month.
Previous month 1 Displays information for the previous month.
Previous month 2 Displays information for the month before last.
Graph to view  
Branch Displays graph totals by branch. You can view the graph for a specific branch by using your mouse pointer to select the branch in the Detailed Month at a Glance listview.
Opening balance Displays a graph of opening balance for the selected period.
Invoices Displays a graph of invoices for the selected period.
Debit notes Displays a graph of debit notes for the selected period.
Credit notes Displays a graph of credit notes for the selected period.
Adjustments Displays a graph of adjustments for the selected period.
Disbursements Displays a graph of disbursements for the selected period.
Revaluations Displays a graph of revaluations for the selected period.
Balance correction Displays a graph of balance corrections for the selected period.
Closing balance Displays a graph of the closing balance for the selected period.

Detailed Month at a Glance

This displays the month-to-date totals for the month selected for the entire company and for each Accounts Payable branch.

The TOTAL line (by default the first line) of this listview indicates the values for the entire Accounts Payable module for the month you selected to view. Subsequent lines indicate the totals relating to the respective branches.

Field Description
Branch Displays the branch relating to the values displayed for that line. You can use the Smartlink to select one of the following options:
Opening balance

Indicates the opening balance for the Accounts Payable module as at the beginning of the month you selected to view.

It is equal to the closing balance of the previous month.

Invoices

Indicates the total value to date of invoices processed using the AP Invoice Posting and AP Permanent Entries Posting programs for the month you selected to view.

Debit notes

Indicates the total value to date of debit notes processed using the AP Invoice Posting program for the month you selected to view.

Credit notes

Indicates the total value to date of credit notes processed using the AP Invoice Posting program for the month you selected to view.

Adjustments

Indicates the total value to date of adjustments processed using the AP Invoice Posting program for the month you selected to view.

This includes currency variances which occur when you change the exchange rate against a foreign currency invoice before applying the payment.

Disbursements Indicates the value to date of payments made to suppliers for month you selected to view.
Revaluation

Indicates the total difference in the value of foreign currency invoices revalued for the month you selected to view.

Invoices can either be revalued using the AP Exchange Rate Revaluation program or, alternatively, at the time of posting a payment when the Default to currency table rate and Apply to outstanding invoice balance setup options are enabled (Accounts Payable Setup).

Tax Relief

Indicates the total value to date of postings made using the AP Tax Relief program and payments processed in the Execute AP Payment Run program for invoices against which tax relief was previously posted.

Balance correction

Indicates the total value of any balance corrections made by the system when you select the Balance function of the AP Period End program.

Closing balance

The closing balance on the TOTAL line indicates the current Accounts Payable balance for the entire Accounts Payable module for the month you selected to view.

You can view the details of this total by printing the AP Trial Balance or the AP Aged Analysis for all suppliers for the relevant month.

If the Current A/P balance does not equal the total of either of these reports (for all suppliers) then you need to run the Balance function of the AP Period End program to enable the system to correct the discrepancy.

The closing balance for each branch for the month you selected to view is also displayed.

You can print the AP Trial Balance or the AP Aged Analysis reports by Branch for all suppliers for each branch, to view the details of the branch totals displayed in this listview.

Posting Information

Field Description
Current A/P period The current financial period and year of your Accounts Payable module.
Current G/L period The current financial period and year of your General Ledger module.
Next payment registers The Register previous year indicates the next payment register number that will be allocated to expense transactions if you process them into the previous year.

The Registers current year indicates the next payment register number to be allocated to expense transactions processed for the current year.

Next expense journals The Journal previous year indicates the next journal number that will be allocated to expense transactions if you process them into the previous year.

The Journal current year indicates the next journal number to be allocated to expense transactions processed for the current year.

GL control account The General Ledger codes and balances for each Accounts Payable branch in the General Ledger.

The total for each branch should equal the total displayed in the Closing balance column of the respective branch(es) in the Detailed Month at a Glance listview.

If these totals do not agree, then you need to use the AP Invoice GL Integration, AP Payments GL Integration and GL Journal Entry programs to create and/or post all journals into the General Ledger.

In addition, ensure that no non-Accounts Payable journals were posted to the Accounts Payable control account(s) in the General Ledger using the GL Journal Entry program.

GL AP total The total value for the Accounts Payable module in the General Ledger (i.e. the total of all General Ledger control accounts for Accounts Payable).

This total should equal the total displayed in the Closing balance column of the TOTAL line in the Detailed Month at a Glance listview.

If these totals do not agree, then you need to use the AP Invoice GL Integration, AP Payments GL Integration and GL Journal Entry programs to create and/or post all journals into the General Ledger.

In addition, you need to ensure that no non-Accounts Payable journals were posted to the Accounts Payable control account(s) in the General Ledger using the GL Journal Entry program.

Graph

This pane displays the graph you selected at the Graph to view option. For a Branch graph, you can view the graph totals for a specific branch by using your mouse pointer to highlight the branch listed in the Detailed Month at a Glance listview.

Notes and warnings

Access control

  • The AP at a Glance by Branch program is regarded as a management query and information is therefore displayed for all branches to provide a meaningful report. Any access levels defined for operators is ignored (see Access and Access Control).

    All information must be displayed to give a meaningful report. Access to this program should therefore only be given to operators who have access to all branches.

Viewing considerations

  • Month-to-date totals are calculated from the various transaction tables. In order to be able to view information for the previous two periods, you must ensure that you are retaining information for a minimum of three months (Accounts Payable Setup).

Graph considerations

  • Up to 72 bars can be displayed on the graph. Consequently, if you have more than 72 branches, then only the Branch graph can be displayed. The values in the TOTAL line include all branches, even if more than 72 branches exist.

Application Help Pane

Application Help Panes provide step-by-step instructions for various functions within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program. The intention is that the pane provides information that is uncluttered and easy to navigate.

You can embed an Application Help Pane:

  • in the main SYSPRO menu

  • in any program with panes, if not using roles

  • when adding a role layout in Design Mode.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.