You use the AR at a Glance by Branch program to view month-to-date totals of your Accounts Receivable module for the current and previous two months by branch.
This enables you to view Accounts Receivable activity by branch and to determine whether the totals for each Accounts Receivable branch balances with its corresponding control account in the General Ledger.
The AR at a Glance by Branch program can be accessed by selecting the Branch Information function from the At a Glance - Accounts Receivable program.
Month-to-date totals are calculated from the various transaction files/tables. Therefore, if you want 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 (see Accounts Receivable Setup - History tab). |
Field | Description | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Period to view | You use this option to select the month for which you
want to view the month-to-date
information.
|
||||||||||||||||||||||||||
Graph to view | This option enables you to select which graph you want
to view.
|
This listview displays the month-to-date totals for the month selected for the entire company and for each Accounts Receivable branch.
The TOTAL line (by default the first line) of this listview indicates the values for the entire Accounts Receivable module for the month you selected to view. Subsequent lines indicate the totals relating to the respective branches.
|
Details that can be viewed include the following:
Column | Description |
---|---|
Branch |
This indicates the code and description of the branch for which the values are displayed. The TOTAL line indicates the values for the entire Accounts Receivable module. You can use the Smartlink to select one of the following options:
|
Opening balance |
This indicates the opening balance for the Accounts Receivable module as at the beginning of the month you selected to view. It should be equal to the closing balance of the previous month. The value at the Balance forward field includes invoices captured using the AR Initial Invoice Capture program. It is updated automatically with invoices captured using this program. The opening balance for a branch is calculated as the Closing balance less the sum of all the transactions for the period for the branch. |
Sales |
This indicates the total value to date of sales processed against customer accounts for the month you selected to view. This value is taken from the Sales Transaction Invoice Summary table (ArTrnSummary file). This value excludes Balance take-ons, IBT sales (i.e. Inter Branch Transfers), debit notes, credit notes and tax. |
IBT's (Inter-branch transfers) |
This indicates the total value to date of Inter Branch Transfers processed using the Sales Order Entry program for the month you selected to view. This value excludes tax. |
Tax |
This indicates the total value to date of tax processed against customer accounts for the month you selected to view. This includes the tax portion on Sales, Adjustments, Debit notes and Credit notes. |
Adjustments |
This indicates the total value to date of:
This value excludes tax. |
Debit notes |
This indicates the total value to date of debit notes processed using the AR Invoice Posting and Sales Order Entry programs for the month you selected to view. These debit notes are taken from the Sales Transaction Invoice Summary table (ArTrnSummary file). This value excludes tax. |
Credit notes |
This indicates the total value to date of credit notes processed using the AR Invoice Posting and Sales Order Entry programs for the month you selected to view. These credit notes are taken from the Sales Transaction Invoice Summary table (ArTrnSummary file). This value excludes tax. |
Payments |
This indicates the total value to date of payments processed using the Payments and Adjustments program for the month you selected to view. These payments are taken from the Cash Journal Payments and Adjustments table (ArCshJnlDtl file) Counter sales deposit refunds, payments from counter sales and deposits applied as payments to customer accounts processed through the Counter Sales program are included. Cash taken in and Cash paid out and unapplied deposits taken are excluded. Miscellaneous receipts processed using the Payments and Adjustments program are excluded. |
Discounts |
This indicates the total value to date of settlement discounts processed against customer accounts for the month you selected to view. These settlement discounts are taken from the Cash Journal Payments and Adjustments table (ArCshJnlPay file). |
Revaluation |
This indicates the total value to date of revaluations processed using the AR Exchange Rate Revaluation program for the month you selected to view. It includes revaluations on all outstanding invoices, debit and credit notes, including finance charge invoices. The revaluation program creates entries with a transaction type = ‘V’ and with a reference of ‘Reval’. |
Balance correction | This is not displayed when viewing At a Glance information by branch. |
Closing balance |
The closing balance on the TOTAL line indicates the current Accounts Receivable balance to date for the entire Accounts Receivable module for the month you selected to view. The closing balance is taken from the Customer Invoice table (ARInvoice file) and is the total of the current balance of all invoices, debit notes, credit notes and unapplied payments for the select branch and period. You can view the details of this total by printing the AR Trial Balance or the Credit Management or the Summary Credit Management reports for all customers for the relevant month. If the Current A/R balance does not equal the total of any of these reports (for all customers), then you need to run the Balance function of the AR Period End program to enable the system to correct the discrepancy. The balances to date for each branch for the month you selected to view are also displayed. You can print the AR Trial Balance or the Credit Management or the Summary Credit Management reports by Branch for all customers for each branch, to view the details of the branch totals displayed in this listview. |
Details that can be viewed include the following:
Field | Description |
---|---|
Current AR period | This field displays the financial period and year in which your Accounts Receivable module is currently in. |
Current GL period | This field displays the financial period and year in which your General Ledger module is currently in. |
Next document number |
The next document numbers to be used by the system are displayed in these fields. If you selected Invoice numbering By company (Accounts Receivable Setup - Numbering tab), then the next document numbers defined for the company (Accounts Receivable Setup - Numbering tab) are displayed. The same set of numbers is displayed irrespective of which branch is highlighted in the Detailed Month at a Glance pane. If you selected Invoice numbering By branch (Accounts Receivable Setup - Numbering tab), then the next document numbers defined against the currently highlighted branch in the Detailed month at a Glance pane are displayed. |
Invoices | This indicates the number the system will allocate to the next invoice you process. |
Credit notes | This indicates the number the system will allocate to the next credit note you process. |
Debit notes | This indicates the number the system will allocate to the next debit note you process. |
Next cash journals | |
Journal previous year | This indicates the next journal number that will be allocated to payment transactions if you process them into the previous year. |
Journal current year | This indicates the next journal number to be allocated to payment transactions processed for the current year. |
Next invoice register | |
Previous year | This indicates the next invoice register number that will be allocated to invoicing transactions if you process them into the previous year. |
Current year | This indicates the next invoice register number to be allocated to invoicing transactions processed for the current year. |
GL control account |
This displays the General Ledger codes and balances for each Accounts Receivable 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:
|
GL AR total |
This indicates the total value for the Accounts Receivable module in the General Ledger. It is the total of all General Ledger control accounts for Accounts Receivable. 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:
|
The graph you selected at the Graph to view option is displayed.
A maximum of 72 bars can be displayed on the graph. Therefore, if you have more than 72 branches, then only the Branch graph can be displayed. |
If you select the Branch graph, then you can view the graph of totals for a specific branch by using your mouse pointer to highlight the branch listed in the Detailed Month at a Glance listview.
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.
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.
Right-click any form field.
You can also click the triangle menu icon that appears in the title area of a pane.
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.
Select the Close icon in the right-hand corner of the application help pane.
Confirm that you want to delete the pane.