Exibir origem

Easy Accounting Management Panels

The Easy Accounting management panels display in a functional and efficient way information pertinent to the daily experience of system users.

Exports per Period (Type 2 - Bar Model)

Reading of EEC table based on the selection criteria defined by you.

The Shipment total (EEC_TOTPED) in the original currency (EEC_MOEDA) is converted to US Dollar.

The totals in US$ per month are accrued.

Data Displayed:

•	Y-Axis – Values in US$.

•	X-Axis – Months (Example: Jan/2007, Feb/2007, Mar/2007, etc).

Selection Criteria:

•	The Shipment Date (EEC_DTEMBA) must be in accordance with the parameterization entry (initial date and final date in month/year format).

Tables used:

Table	Description
EEC	Export Shipment

Fields used:

Table	Field	Description
EEC	EEC_DTEMBA	Shipment Date
EEC	EEC_MOEDA	Currency Negotiated
EEC	EEC_TOTPED	Shipment Value in the Currency Negotiated

Imports (Type 2 - Bar Model)

Reading of SW6 table based on the selection criteria defined by the user.

Reading of all Invoices (SW9) for each SW6 record. Remember that the access key is the index 3 of SW9 (W9_FILIAL+W9_HAWB).

Invoice Total (W9_FOB_TOT) in the origin currency (W9_MOE_FOB) of Invoices is converted into US Dollar.

The totals in US$ per month are accrued.

Data Displayed:

•	Y-Axis – Values in US$.

•	X-Axis – Months (Example: Jan/2007, Feb/2007, Mar/2007, etc.).

Selection Criteria:

•	Type of Closing (W6_TIPOFEC) must be equal to DI or DIN.

•	Clearance Date (W6_DTDESE) must be in compliance with the parameterization entry (initial and final date in month/year format) compulsorily defined by the user.

Tables used:

Table	Description
SW6	Clearance Process
SW9	Invoice

Fields used:

Table	Field	Description
SW6	W6_DTDESE	Clearance Date
SW6	W6_TIPOFEC	Type of Closing: • DA – Declaration of Temporary Admission (warehouse) • DI – Import Declaration • DIN – Nationalization DI
SW9	W9_MOE_FOB	Invoice Currency
SW9	W9_FOB_TOT	Invoice Total

Export Request (Type 2 - Pie Model)

Reading of EE7 table based on the selection criteria defined by you. For each EE7 register, read the EE8 registers through index 1 (EE8_FILIAL+EE8_PEDIDO +...).

If the Balance of Items (EE8_SLDATU) is equal to the initial quantity (EE8_SLDINI) and the field EE8_RV is empty, the request will be as Pending. But only if ALL items follow this condition.

For requests out of the situation previously described (Pending), the following processing is performed:

•	For each register of the table EE8, the system performs a search in the table EE9, through index 1 (EE9_FILIAL+EE9_PEDIDO), checking the nature of some register. If no register is found, the Request will be Forwarded (with RV or Shipment).

•	If a register is found on the EE9 table, the content of the EE9_PREEMB field is used to search the EEC table, to check the Shipment Date (EEC_DTEMBA) entry. If the date is found, the corresponding request is Finished (Shipped).

The number of Pending, Forwarded and Finished requests is totaled on the panel.

Data Displayed:

•	Y-Axis – Amount of Processes.

•	X-Axis – Types of Processes (Pending, Forwarded and Finished).

Selection Criteria:

•	The Request Date (EE7_DTPROC) must be in accordance with the parameterization entry (initial date and final date) defined by the user.

Tables used:

Table	Description
EE7	Cover of Export Request
EE8	Items of Export Request
EEC	Cover of Export Shipment
EE9	Items of Export Shipment

Fields used:

Table	Field	Description
EE7	EE7_PEDIDO	Request Code
EE7	EE7_DTPROC	Request Date
EE8	EE8_SLDINI	Initial Quantity
EE8	EE8_SLDATU	Balance
EE8	EE8_PEDIDO	Request Code
EE8	EE8_RV	RV Number
EEC	EEC_PREEMB	Shipment Code
EEC	EEC_DTEMBA	Shipment Date
EE9	EE9_PREEMB	Shipment Code
EE9	EE9_PEDIDO	Request Code

Export Exchange (Type 2 - Bars Model)

Reading of SWB table based on the selection criteria defined by the user, considering only the exchange installments related to the clearance (field WB_PO_DI = D).

The Exchange Total (WB_FOB_MOE) in the original currency (WB_MOEDA) of the Shipment is converted to US Dollar.

To accrue the Total per month, the system assumes the Settlement Date (WB_CA_DT) entry classifies the exchange as PAID. If this date is blank, the exchange is PAYABLE.

Data Displayed:

•	Y-Axis – Values in US$.

•	X-Axis – Months (with two columns for each month: Payable and Paid).

Selection Criteria:

•	Due Date (WB_DT_VEN) must be in compliance with the parameterization entry (initial and final date) defined by the user.

Tables used:

Table	Description
SWB	Import Exchange

Fields used:

Table	Field	Description
SWB	WB_DT_VEN	Due Date
SWB	WB_PO_DI	Exchange Type, being C=Clearance and A=Advance.
SWB	WB_MOEDA	Currency
SWB	WB_FOB_MOE	Value
SWB	WB_CA_DT	Settlement Date

Import Exchange (Type 2 - Bar Model)

Reading of SWB table based on the selection criteria defined by the user, considering only the exchange installments concerning Clearance (WB_PO_DI = \"D\").

Exchange Total (WB_FOB_MOE) in the origin currency (WB_MOEDA) is converted into US Dollar.

To accrue the Total per month, the system considers that the completion of Settlement Date (WB_CA_DT) classifies the exchange as PAID. If this date is blank, the exchange is PAYABLE.

Data Displayed:

•	Y-Axis – Values in US$.

•	X-Axis – Months (with two columns for each month: Payable and Paid).

Selection Criteria:

•	Due Date (WB_DT_VEN) must be in compliance with the parameterization entry (initial and final date) defined by the user.

Tables used:

Table	Description
SWB	Import Exchange

Fields used:

Table	Field	Description
SWB	WB_DT_VEN	Due Date
SWB	WB_PO_DI	Exchange Type, being C=Clearance and A=Advance.
SWB	WB_MOEDA	Currency
SWB	WB_FOB_MOE	Value
SWB	WB_CA_DT	Settlement Date

Average Interest Rate for Financing (Type 1-1 Dimension)

It displays the average rate of interests of Import and Export, the number of pending contracts and Invoices to settle (Import and Export).

•	Average rate of interests of export financing:

To calculate the average rate of interests of export financing, the system must consider contracts from the Table of Financing Contracts (EF1), where the Contract Type is Export (EF1_TPMODU = \"E\").

The calculation will be the average from the interests rates of the contracts, weighted by their values.

Contract Value = Total value of financing in Brazilian Real (BRL).

Average Contract Rate = Average rate of contract interests, considering the average from the periods of the contract weighted by the number of days.

With Payment Installments = the average of the contract rate will be the sum of the averages of the rates from the different types of interests.

•	Number of pending Export Contracts:

To calculate the number of export financing contracts, the system must consider contracts from the EF1 Table, where the Type of Contract is Export (EF1_TPMODU = \"E\").

For contracts with the same key (EF1_FILIAL+EF1_TPMODU+EF1_CONTRA+EF1_BAN_FI+EF1_PRACA), but with different sequences (EF1_SEQCNT), the system verifies if there is at least one pending sequence; if any, it is considered just a pending contract. If there is more than one pending sequence, they must not be considered in the calculation.

•	Number of pending Import Contracts:

To calculate the number of import financing contracts, the system must consider contracts from the EF1 Table, where the Type of Contract is Import (EF1_TPMODU = I).

For contracts with the same key (EF1_FILIAL+EF1_TPMODU+EF1_CONTRA+EF1_BAN_FI+EF1_PRACA), but with different sequences (EF1_SEQCNT), the system verifies if there is at least one pending sequence; if any, it is considered just a pending contract. If there is more than one pending sequence, they must not be considered in the calculation.

•	Number of Pending Invoices linked to Export contracts:

To calculate the number of pending invoices linked to export financing contracts, the system must consider contracts from the EF1 Table, where the Type of Contract is Export (EF1_TPMODU = E).

Tables used:

Table	Description
EF1	Cover of Export Financing
EF3	Contract Events

Fields used:

Table	Field	Description
EF1	EF1_VL_MOE	Value of Financing in the Currency
EF1	EF1_TP_FIN	Type of Financing
EF1	EF1_DT_ENC	Finishing Date
EF1	EF1_DT_CON	Contract Date
EF1	EF1_DT_VEN	Contract Due Date
EF1	EF1_DT_JUR	Initial Date of Interests
EF1	EF1_BAN_FI	Closing Bank
EF1	EF1_CONTRA	Contract Number
EF3	EF3_CODEVE	Event Code

For the panels previously described (excepting Export Requests), you must note the following details:

•	The currency symbol US$ must be read from the parameter MV_EECUSS. Hence, the correct completion of this parameter is a requirement for the routine operation.

•	If the origin currency is US Dollar, conversion is not executed.