Bank Transactions - FINA710

The New Financial Manager is in homologation phase and was released for pilot customers only.

• 01.OVERVIEW
• 02.EXAMPLE OF USE
• 03. MAIN SCREEN
• 04.GENERAL TAB 
  • Balance forecast configuration
  • Filters
  • Cash Flow
  • Bank account selection
  • Bank transaction simulation
  • Cash Flow
  • Accounts Receivable/Accounts Payable
• 05.INFLOW AND OUTFLOW TABS
  • Inflows due and overdue
  • Inflows Table
• 05.TABLES USED

01. OVERVIEW

The financial transactions show the entire flow of incoming and outgoing bills. 

02. EXAMPLE OF USE

The bills data display is updated according to the synchronization of the Job that calculates all displayed values.
In the upper left corner, by clicking on the clock, you can see the last bill update shown.
Image Removed

03. MAIN SCREEN

Image Removed

04. GENERAL TAB 

display all the company's inflow and outflow.

02. ABOUT THE SCREEN 

The screen is divided into four tabs: General, Inflows, Outflows, and Consolidated

Image Added

Image Added

03. GENERAL TAB 

The General Tab has Inflow and Outflow information in a summarized wayThe General tab contemplates a set of Input and Output information in a summarized form.
In the respective positions, we have can view the following values displayed:

• Initial Balance:

...

• The consolidated position

...

• since the start of the period.
• Inflows: Bills receivable in the next 30 days.
• Outflows: Bills payable in the next 30 days

...

• .

...

• Balance in Applications - Total of values in an application (This feature will be available for release 12.1.2210)
• Final balance: Expectation of final balance.

Image Added

CASH FLOW

The cash flow displays a chart set as default with the monthly

Balance forecast configuration

You can configure the forecast of Balances, Inflows and Outflows through the Monthly/Weekly/Daily selector.
Image Removed

Filters

Cash Flow

Display overdue incoming bills
Display overdue outgoing bills
Display purchase orders
Display sales orders
Image Removed

Bank account selection

In the bank account selection, you can choose which banks will be involved in the presentation of the financial transactions.
This setting allows search filters and selection of specific banks and branches.
Image Removed

Bank transaction simulation

Simulate transactions By selecting the Type of transaction as Incoming or Outgoing, filling in the date field, description, and value, it is possible to view the result in the chart and table, in a clear and objective way.
Image Removed

Cash Flow

The Cash Flow presents a graph defined as a default with the Monthly display of the last 12 months and the sum of Inflows and Outflows. By clicking on If you click the captions, you can view only the inflows or the outflows.By hovering If you hover the mouse over the bars, you can see the values in detail. Image Removed

Accounts Receivable/Accounts Payable

For bills in bordereau, the cash flow considers the configuration of "withholding days" (A_RETENCA) of the bank to display the bill according to its due date + bank withholding days.

 

Image Added
It is also possible to detail the consolidated values. See topic Details - Cash Flow

BUDGETS

If the options Display Revenue Budgeted and/or Display Expense Budgeted are enabled, the cash flow displays a series with a monthly exhibition (only), current month, and next 12 months containing the sum of the Revenue and/or Expense budgets.

Image Added

ACCOUNTS RECEIVABLE/ACCOUNTS PAYABLE

In the third sessionIn the third section, we have two Cards representing, respectively, the Accounts Receivable/Accounts Payable:

• Accounts Receivable: Displays the sum of

...

• accounts receivable in the selected period, and

...

• accounts receivable in other periods according to the

...

• Monthly/Weekly/Daily selection.
• Accounts Payable: Displays the sum of

...

• accounts payable in the selected period, and

...

• accounts payable in other periods according to the Monthly/Weekly/Daily selection.

Image Added

SELECTION OF PERIOD

You can set up the expectation of Balances, Inflows, and Outflows using the Monthly/Weekly/Daily selector.

Image Added

SET UP CASH FLOW DATA

You can set up the cash flow data in three different manners: Cash Flow - Display Options, Customized Filters, and Bank Account Selection. For that, click the Configure button as in the pictures below:
Image Added

Image Added

CASH FLOW (OPTIONS FOR DISPLAY)

 This configuration allows you to change the values to be displayed in the chart and the cash flow calculations (except budgets). The options are:

Image Added

• Display overdue incoming bills - Adds to the cash flow the overdue incoming bills (F75 - Bill Balances).
• Display overdue outgoing bills - Adds to the cash flow the overdue outgoing bills (F75 - Bill Balances).
• Display Purchase Orders - Adds to the cash flow the purchase orders (F76 - Order Balances).
• Display Sales Orders - Adds to the cash flow the sales orders (F76 - Order Balances).
• Display only released bills - Adds to the cash flow the sales and purchase orders released (F76 - Order Balances).
• Display Income Budgets - Adds to the cash flow the income budgets (SE7 - Budgets).
• Display Expense Budgets - Adds to the cash flow the expense budgets (SE7 - Budgets).
• Consider only the current month - The sum of the cash flow will be only for the records (F75 -Bill Balances and F76 - Order Balances).
• Consider Applications - Displays the values according to the options:
  • All - Displays the total of pending invested values.
  • Do not consider - Does not show values. The fields will be displayed with a "0" value.
  • Consider Released - Displays only applications with the Release Date field filled in (SEH - Application/Loan Tracking).
• Type of Balance - Sets which balance types of the selected accounts will be used when calculating the cash flow:
  • • Regular - Uses the default balance (Reconciled and Not Reconciled).
    • Reconciled - Uses ONLY the reconciled balance.
    • Not Reconciled - Uses ONLY the balance not reconciled.

...

SELECTION OF BANK ACCOUNTS

Image Added
In the bank account selection, you can choose which banks will be involved when displaying bank transactions.

This configuration allows search filters and the selection of specific banks and branches.

Image Added

CUSTOMIZED FILTERS

Image Added
In the Filter Manager, you can register Customized Filters using the fields and create conditional expressions for the cash flow.

04.

...

INFLOW AND OUTFLOW TABS

The Inflows

...

The Inflow and Outflow and Outflows tabs have similar functionalitiesfeatures, but each one represents its own condition, just as the Inflow tab status. Plus, the Inflows tab will correspond to Bills Receivable, while Outflows will correspond to Bills Payable.

The bills to be presented may or may not be configured for cash flow (E1_FLUXO, E2_FLUXO), i.e., all bills receivable/payable. Thus, the Outflow tab represents bills payable. these tabs are not linked to the cash flow.

INFLOWS DUE AND INFLOWS OVERDUE

In the first section, we have the sum of Inflows Due and Inflows Overdue, as well as their percentage, and by hovering over it . By hovering the mouse, you can have more detailed information about on the value of in the period. Image Removed

Image Added

...

INFLOWS TABLE

In the second sessionsection, we have the layout of an Inflow Inflows Table showing available with the last 10 records.

Here, the information of the entire database is shown regardless of the filters and configurations of the Overview and Consolidated tabs. Filters are only applied using the Advanced Search button. 

Image Added

VIEW

Image Removed
Functionalities:
View: View the record in detail, categorized by tabs. Image Removed

Image Added

EXPORT REPORT

Export Report: Export data on screen, or full data for Excel.

The export will load updated values from table F75. 

The F75_TXMOED - Currency Rate exported to the spreadsheet is used to store the rate used to convert the bill balance. This field will not store the rate used when posting the bill.

When a bill is posted in foreign currency with no balance and no contracted rate, the F75_TXMOED field will be updated to value 0.

Image Added

QUICK SEARCH

complete data to Excel.
Image Removed
Quick Search: Search by the bill 's number.

Image Added

ADVANCED SEARCH 

The Image Removed
Advanced search: The advanced search has several various fields that can be combined to form a set of custom customized filters, so that you can and thus it is possible to precisely locate records that depend on a combination of varying varied conditions. Image Removed

Image Added

05.

...

CONSOLIDATED TAB

Cash flow consolidated by periods, with an option for exporting to a spreadsheet. 

The balances in cash and the bank allow the edition to simulate results with the balance entered.

       In applications, will show values in an application (this feature will be available for release 12.1.2210). 

The export to the spreadsheet will display, in the first table, the balances of bills overdue, balances in cash and banks, and total payable and receivable.

The second table will present the consolidated value on screen.

The third table will load the bank balances used.

Image Added

CONFIGURATIONS

            Image Added

• Periodicity - the type of date grouping for display, which may be daily, weekly, every 10 days, every 15 days, or monthly.
• Number of periods - the number of periods to be displayed.
• Display overdue incoming bills - displays the value of bills receivable overdue and sums the value to the initial balance.
• Display overdue outgoing bills - displays the value of bills payable overdue and sums the value to the initial balance.
• Display purchase orders - considers the value of the purchase orders in the periods
• Display sales orders - considers the value of the sales orders in the periods
• Display only released orders - Consider or not only purchase and sales orders without blocks
• Display machine purchase order - Considers the value of machine purchase orders in the periods.
• Display machine sales orders - considers the value of the machine sales orders in the periods
• Consider Applications - Displays the values according to the options:
  • • All - Displays the total of pending invested values.
    • Do not consider - Does not show values. The fields will be displayed with a "0" value.
    • Consider Released - Displays only applications with the Release Date field filled in (SEH - Application/Loan Tracking).
• Type of Balance - Sets which balance types of the selected accounts will be used when calculating the cash flow:
  • • Regular - Uses the default balance (Reconciled and Not Reconciled).
    • Reconciled - Uses ONLY the reconciled balance.
    • Not Reconciled - Uses ONLY the balance not reconciled.

• Bank account selection - Select the bank accounts that will be used to compose the initial balance.
• Customized Filters - Filters that can be applied to build the data.

It is also possible to detail the consolidated values, see topic Details - Consolidated.

PROJECTION

This will allow the user to change the incoming and outgoing values of the Consolidated tab thus projecting the values for the desired period.

Access the projection option in Other actions → Projection. After this step, the Input and Output columns will now be editable and only allow the insertion of positive values. If a negative value is entered in one of the columns, the calculation of variation, balance, inputs, and outputs will not be performed. The view of Details for that period will be prevented.

After projecting the values, you can generate a PDF or Excel file. To do so, access the options using the Other Actions button and select the desired file format.

When the projection is closed, the table will be reloaded with the initial values of the cash flow, and the Details view will be available again.

RESTORE SIMULATION

It is also possible to restore the simulations created for the cash flow in the consolidated projection. To learn more about the process, see the topic Simulation of financial transactions. After restoring the simulation, the values will be added to the Inflow or Output column according to the period in which that simulated value fits, and the interface will be equal to the projection. It is worth mentioning that it will be possible to restore only one simulation at a time. If you need to change the simulation, click the Close button. After that, the screen will be reloaded. access again the option to restore simulation in Other actions → Restore Simulation and select the correct simulation.

06. SIMULATION OF FINANCIAL TRANSACTIONS

CREATING SIMULATIONS

To access the simulation, go to the General Tab and click the "Simulate Transactions" button. Then, access the simulation screen.

Image AddedImage Added

Image Added

You can add a record to the simulation by entering the fields Type, Date, Description, and Value according to the necessity. After you add the simulation record, the data of the inflow and outflow charts will be updated.

Image Added

SAVE/RESTORE SIMULATION

To save, click the "Save Simulation" button and enter the mandatory simulation information.

Image Added

After it is saved, the simulation can be accessed using the "Restore Simulation" button of the General Tab of the Financial Transactions screen:

Image AddedImage Added

DELETE SIMULATION

After adding a simulation, you can delete it using the "Restore Simulation" button of the General Tab of the Financial Transactions or Consolidated Cash Flow screens:

Image Added Image Added

You can delete only the simulations made by your user, be them public or private. If the simulation was made by another user, the Delete button will be disabled.

Image Added

07. CASH FLOW/CONSOLIDATED BREAKDOWN

This functionality allows the user to view the records that make up a period entered (either the series of the graph or the consolidated period).

08. TABLES

• F75 - Bill balances
• F76 - Order Balances
• SE7 - Budgets
• SC6 - Sales Order Items
• SC7 - Sales Order Items
• F7D - Cash flow simulation
• F7E - Cash flow simulation items
• VQ0 - Vehicle Order
• VV0 - Vehicle Outflows           
• F75 - Bills Balances
• F76 - Orders Balances