Histórico da Página
...
| Índice |
|---|
01. OVERVIEW
The financial transactions display all the company's inflow and outflow.
02. ABOUT THE SCREEN
The screen is divided into four tabs: General, Inflows, Outflows, and Consolidated 
...
03. GENERAL TAB
The General Tab has Inflow and Outflow information in a summarized way.
In the respective positions, we can view the following values:
- 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.
CASH FLOW
The cash flow displays a chart set as default with the monthly display of the last 12 months and the sum of Inflows and Outflows. If you click the captions, you can view only inflows or outflows.If you hover the mouse over the bars, you can see the values in detail.
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.
| Informações | ||
|---|---|---|
| ||
| Any change to the bill will reflect on the cash flow of the New Financial Manager after the execution of the FINA711 job. |
It is also possible to detail the consolidated values. See topic Details - Cash Flow
BUDGETS
| Aviso | ||
|---|---|---|
| ||
| The Budgets correspond to the month/year registered for a nature, therefore, they will only be displayed when the Period Selection of the cash flow is Monthly. |
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.
ACCOUNTS RECEIVABLE/ACCOUNTS PAYABLE
In the third session, 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.
SELECTION OF PERIOD
You can set up the expectation of Balances, Inflows, and Outflows using the Monthly/Weekly/Daily selector.
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:
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:
- 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.
| Aviso | ||
|---|---|---|
| ||
| The Type of Balance field is available for release 12.1.2210 from the continuous dispatch of the 2023 financial module. |
| Dica | ||
|---|---|---|
| ||
| A new option to display blocked (non-released) sales and purchase orders according to the F76_BLQLIB field of the F76 - Order Balances table. To display blocked orders, just deselect the parameter "Display only released orders", which is selected by default. |
...
|
...
|
...
|
SELECTION OF BANK ACCOUNTS
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.
CUSTOMIZED FILTERS
In the Filter Manager, you can register Customized Filters using the fields and create conditional expressions for the cash flow.
| Informações | ||
|---|---|---|
| ||
| All configurations made for the cash flow will be stored in the user profile. |
04. INFLOW AND OUTFLOW TABS
The Inflows and Outflows tabs have similar features, but each one represents its 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, 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. By hovering the mouse, you can have more detailed information on the value in the period.
INFLOWS TABLE
In the second section, we have an Inflows Table 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.
VIEW
View the record in detail, categorized by tabs.
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.
QUICK SEARCH
Search by the bill number.
ADVANCED SEARCH
The advanced search has various fields that can be combined to form a set of customized filters, and thus it is possible to precisely locate records that depend on a combination of varied conditions.
05. CONSOLIDATED TAB
| Informações | ||
|---|---|---|
| ||
| Feature available for release 12.1.33 through the continuous dispatch package of Financials with a date later than September 2, 2022. |
Cash flow is 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.
| Aviso |
|---|
...
| ||||||||||||||||||
The Export button has two options (Excel and PDF). To export via PDF, TOTVS Printer (printer.exe) must exist in the SmartClient and Appserver folders (of all services that may exist in the environment).
|
...
|
CONFIGURATIONS
|
CONFIGURATIONS
- 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.
| Aviso | ||
|---|---|---|
| ||
| The Type of Balance field is available for release 12.1.2210 from the continuous dispatch of the 2023 financial module. |
- 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.
| Informações | ||
|---|---|---|
| ||
To display machine purchase and sales orders, the MV_VEICULO parameter must be set to "S". The machine purchase/sales orders will be available as of the December 2022 continuous dispatch of the financial module. |
PROJECTION
| Informações | ||
|---|---|---|
| ||
| Feature available through the continuous dispatch package of Financials with a date later than May 25, 2023. |
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
| Informações | ||
|---|---|---|
| ||
| Feature available through the continuous dispatch package of Financials with a date later than June 20, 2023. |
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,.
...
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.
SAVE/RESTORE SIMULATION
| Informações | ||
|---|---|---|
| ||
| As of the first continuous dispatch of the financial module of October 2022, you can save and restore your simulation. The user can give a title to the simulation and save all items created to be able to use them again later. |
To save, click the "Save Simulation" button and enter the mandatory simulation information.
After it is saved, the simulation can be accessed using the "Restore Simulation" button of the General Tab of the Financial Transactions screen:
07. CASH FLOW/CONSOLIDATED BREAKDOWN
...
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:
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.
07. CASH FLOW/CONSOLIDATED BREAKDOWN
| Informações | ||
|---|---|---|
| ||
| As of the first continuous dispatch of the financial module of October 2022, you can detail the cash flow/consolidated. |
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).Âncora
...
| Deck of Cards |
|---|
...
|
| ||||
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
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
...
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas