Páginas filhas
  • EFT Reconciler - Financials (Accounts Receivable) - P12

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

02. RULES AND DEFINITIONS

Operational Flow 

Image Added

Description of processes

  • Make sale:  Through the source module, the system records the sales transactions, allowing even the use of multiple cards for the payment.
  • Integration with Financials:  Generation of bills receivable of respective sales, with specific transaction information: NSU Code - Exclusive Sequential Number of the operation and Authorization Code of sales operation.   
  • Receive file: Receipt of files generated by card companies.
  • Make file available in folder: Saving of files in specific directories:

...

 \baseline\cartao\Import – Directory in which the files are saved for reading/processing.

...

 

...

\baseline\cartao\Process – Directory in which

...

successfully processed files are automatically saved.

...

 

...

\baseline\cartao\falha – Directory in which files with errors are automatically saved.


   To run this process in the SIGALOJA module, register the card companies that must have the "RD - Network" data.

  • Import Payments/Sales file: Saving successfully processed records. This process only embraces ratified layouts: Software Express, Cielo, Rede and Amex. Occasional import criticisms will be available through a log, for future analysis and to take measures.
  • Import log: View import criticisms detailing each occurrence, with option to print.
  • Sales Reconciliation:  Reconcile sales records (imported from files) with financial records of accounts receivable. For reconciliation, configure routine questions. From the configuration of these questions, records are displayed in tabs onscreen to be reconciled, as explained below:

...

- Reconciled: Correspond to imported sales the counterparts of which (financial bills) were found in accordance with the relationship key: Branch, Site, NSU, Installment, Issue Date, Authorization Code, type "CD" (Automatic Debit Card) or "CC" (Automatic Credit Card) and whether the difference between the value of the sale imported and the value of the financial bill balance is within the tolerance percentage set in routine processing questions.

...

  

 - Partially Reconciled: Correspond to imported sales the counterparts of which (financial bills) were found in accordance with the relationship key: Branch, Site, NSU, Installment, Issue Date, Authorization Code, type "CD" (Automatic Debit Card) or "CC" (Automatic Credit Card) and whether the difference between the value of the sale imported and the value of the financial bill balance is outside the tolerance percentage set in routine processing questions.

- Bills Without Sales: Correspond to all bills in the database in the period entered in routine processing questions not found in card issuer files.

- Sales Without Bills: Correspond to sales imported from the card issuer and/or card company file the counterparts of which were not found as financial bills, enabling the manual reconciliation of bills available in the database.

- Divergences: Correspond to information available in card issuer or card company files, for manual action of the system user. For example: Total Refund, Partial Refund, Charge Back, Modality Change.

- Totals: Display quantity of records and values processed by date for each of the respective tabs. 

  • Reconciliation Report: For the evaluation of sales reconciliations. 
  • Payment Reconciliation: Reconcile payment records (imported from files) with financial records.  For reconciliation, configure routine questions. From the configuration of these questions, records are displayed in tabs onscreen to be reconciled, as explained below:

- Reconciled: Correspond to imported payments the counterparts of which (financial bills) were found in accordance with the relationship key: Branch, Site, NSU, Installment, Issue Date, type "CD" (Automatic Debit Card) or "CC" (Automatic Credit Card) and whether the difference between the value of the sale imported and the value of the financial bill balance is within the tolerance percentage set in routine processing questions.

...

- Partially Reconciled: Correspond to imported payments the counterparts of which (financial bills) were found in accordance with the relationship key: Branch, Site, NSU, Installment, Issue Date, Type "CD" (Automatic Debit Card) or "CC" (Automatic Credit Card) and whether the difference between the value of the sale imported and the value of the financial bill balance is outside the tolerance percentage set in routine processing questions.

- Manually Reconciled: Correspond to payments the user has manually reconciled while running this routine.

- Not Reconciled: Correspond to imported payments the counterparts of which (financial bills in Protheus) were not found, enabling manual reconciliation with bills available in the database. 

- Divergences: Correspond to information available in card issuer or card company files, for manual action of the system user. For example: Total Refund, Partial Refund, Charge Back, Modality Change.

- Totals: display quantity of records and values processed by date for each of the respective tabs.
 

  • Postings Report:  You may use default system reports to evaluate postings made by the reconciliation process, such as:    

...

- Postings Report
- Bank Statement
 
     

Utilization Rules and good practices.

...

                                          - FIF->FIF_NSUTEF

                                          - SE1→E1_NSUTEF

                                          - SL1->L1_NSUTEF 

                                          - SL4->L4_NSUTEF   

                                          - MDK->MDK_NSUTEF


 
 

Expandir
titleLayouts

We currently have the following layouts approved for importing: 

Âncora
Layouts
Layouts

Totvs custom tabs box
tabsSoftware Express, Amex, Rede,Cielo
idsSoftExpre,Amex

...

,Rede

...

,Cielo

...

Totvs custom tabs box items
defaultyes
referenciaSoftExpre

Layout: - Documentation Version approved up to this point: 3.6  Especificacao_arquivo_retorno_detalhado.3.6.pdf

Layout Structure

  • Record 0 – Header
  • Record 1 – Sales Details
  • Record 8 – Rejected Details (Records not processed by import routine - FINA914)
  • Record 10 – Credit Details
  • Record 2 – Adjustments (Records not processed by import routine - FINA914)
  • Record 100 – Advance Batch
  • Record 200 – Advanced Transactions
  • Record 9 – Trailer

Note: For routine FINA914 to import the file, get it from the SiteWeb website, in which you can select the information to be generated in the file. As a .CSV extension file lacks column identifiers, we do not recommend changing its layout, because problems may occur in the import/reconciliation.

Totvs custom tabs box items
defaultno
referenciaAmex

Layout: - Documentation Version approved up to this point: 3.0
Support document version 2.2: 
20160714_Manual - Extrato Eletronico - v3.0 AMEX.pdf

Totvs custom tabs box items
defaultno
referenciaRede

Layout: - Documentation Version approved up to this point: 

  • Credit card sales file: V2.01 - EEVC
  • Debit card sales file: V1.04 - EEVD
  • Payment file: V3.01 - EEFI 

Support documents:      0208_EEVC_Rede_0263_ExtratosOnlineVendasCredito(portugues).pdf

0208_EEVD_Rede_0263_ExtratosOnlineVendasDebito(portugues).pdf

Rede_ExtratosOnlineFinanceiro.pdf

Records not processed by reconciler: 

...

- Record 016 - Summary of sales in installments IATA

- Record 017 - AVS

- Record 018 - Certificate of sale in installments IATA

- Record 019 - Serasa

- Record 020 - Installment of transaction in installments IATA

- Record 021 - SecureCode

- Record 022 - Summary of sales in USD

- Record 024 - Certificate of sale in USD

- Record 033 - Notification of Request (E-Commerce)

- Record 034 - Rotating CV/NSU (E-Commerce)

- Record 035 - Interest Free CV/NSU In Installments (E-Commerce)

- Record 040 – Serasa – Identifies Serasa query details

- Record 041 – AVS – Identifies AVS query details

- Record 042 – SecureCode – Identifies SecureCode query details

- Record 044 – Debits Pending

- Record 045 – Cleared Debits

- Record 049 – Unscheduling of Installments with complementary information

- Record 053 – Net Adjustments and Unscheduling (E-Commerce)

- Record 054 – Debit Adjustments (via Bank) - (E-Commerce)

- Record 055 – Debits Pending (E-Commerce)

- Record 056 – Cleared Debits (E-Commerce)

- Record 057 – Unscheduling of Installments with complementary information (E-Commerce)

- Record 058 – Gateway

- Record 059 – Bank Bill

- Record 060 – Risk Analysis

- Record 061 - Manual Review

Totvs custom tabs box items
defaultno
referenciaCielo

Layout: - Documentation Version approved up to this point: 13 and 14


Support documents:

...

 CIELO Extrato Eletronico - Manual - Versão 13.pdf

  Cielo_Comunicado Extrato EDI_Marco 2017.pdf

  CIELO Extrato Eletronico - Manual - Versao 14.pdf

Records not processed by reconciler: 

07 - ASSIGNMENT OF

...

RECEIVABLES

08 - INSTALLMENTS

...

PENDING

09 - BALANCE PENDING


03. ROUTINES AND FEATURES 

...


Expandir
titleJustification - EFT - FINA911

Enables the addition of standardized justifications to be used on the reconciliation screen. 

...

Image Added

Enter a code and a description. 

...

Image Added

The justification will be required when making effective the reconciliation processes of tabs: Partially Reconciled, Bill without Sale, Sales Without Bill and Divergent. 

Expandir
titleAdjustments Reasons - EFT - FINA912

Enables the addition of standardized reasons for utilization in divergences tab of reconciliation routines. 

...

Image Added

Enter company, a code and a description for this reason.

...

Image Added

Reasons are documented in the manuals of each company.

Expandir
titleBranches to Import - FINA913

It enables only some branches to use the reconciliation process. Use it directly in the file import process. 

...

Image Added

Enter the code of the branch enabled to import the files. 

...

Image Added

...


If you do not register any branch in this option, all branches will be enabled to import the file. When you use the register, the import process will only be completed successfully for the branches registered in it.

If you do not register a branch and find a record for it, the import log will inform that the branch is not enabled for import.  

Expandir
titleImport Wizard - FINA914

The file import process considers only layouts approved for Software Express, Cielo, Rede and Amex. This process ensures data integrity, storing criticisms for users to analyze and take measures.

Expandir
titlePremises
  • Card Issuer correctly registered in table "SITEF Administrators Code" with directory parameters duly set. 

...

Image Added

Eft.FileDir indicates the directory in which the file will be read. 

Proc.FileDir indicates the directory to which the file will be moved after successful processing. 

Proc.Inc.Dir indicates the directory to which the file will be moved after processing with error.

Note: to enable fields for input, Card Type must be RD - Rede

...


  • Branch enabled for execution. See documentation about "Branch Registers to Consider" - FINA913.

...



 - Import screen for payment/sales files from Card Companies. 

...

Image Added


- Detail on directories from which the files will be read.

The import does not consider the branch in which the process is taking place, given that files may have more than one establishment. Thus, branch control does not depend on the sharing of the table at issue. 

...

Image Added

...


- After importing it, a detailed log of criticisms per file is issued for the identification of problems. 

Image Added   

...

Image Added


Description of columns: 

The Captions possible for this screen. The text of field Status follows caption details

...

Image Added

File name: Provides details on the file imported. (the file name is used as a control method to avoid duplication of processing)

Processing Date: Date on which the operation was performed

Processing Time: Time in which the operation was performed

Rec. Added: Quantity of records added to sales/payments control table. (depending on the layout/card issuer, we may have sets of lines to form a sale/payment)

Not Processed: Quantity of lines not processed by problems/criticisms. (you may evaluate details on this processing through the import log - FINA917)

Lines Read: Quantity of lines read, sum of all lines evaluated by the program, considering even the header, trailer or any other line not processed by the routine. 

Fi Li Tot: File lines total, the sum of lines not processed plus lines read. 

User Code: Code of user who processed the import. 

Co. Code: Code of Credit Card Company/Issuer involved in the operation. (this information is defined in accordance with the folder in which the file was made available)

...


Image Added

...


Expandir

...

titleSales Reconciliation - FINA916

...


Use this process to reconcile sales imported with bills saved in the system.

Main browser displays all sales records this routine has imported and enabled.

Image Added 

...

Captions

...

Image Added

Captions are updated in accordance with user actions and the comparative results between Protheus and credit card company files.
When files are imported, all records start with "Not Processed", changing status as information is processed.

Reconcile 

When you select option reconcile, we have the following parameters screen

...

Image Added

At this point you need to choose between reconciling sales from the Software Express layout or from Others, which are comprised of Cielo, Rede and Amex:

These options differ in the selection of Card Issuer x Card Company. For Software Express, you can select between one option of various card companies, whereas Others offers only the Cielo, Rede and Amex options. 

After selection, a screen is displayed with parameters you can select:

...


Select Branch: You can select one or more branches. The field is multiple choice for reconciliation of multiple branches.
From Date: Start Date of sale reconciliation. (evaluate the issue date of sale)
To Date: End Date of sale reconciliation. (evaluate issue date of sale)
From NSU NO.?: NSU Number (Single Sequential Number) that starts the sale reconciliation.  (with zeros to the left)
To NSU No.?: NSU Number (Single Sequential Number) that ends the sale reconciliation. (with zeros to the left)
Type: Select the type to be reconciled. Options: Debit/Credit or Both.

...


Image Added

...


Tolerance in %: Percentage of the difference in the bill balances between the net sale value of the imported file and the remaining bill balance in the system

Card Company: Click the "magnifying glass" icon to display card companies. You may select one or more card companies to reconcile sales. (query yields data specific to your selection, whether Software Express or Others)  

Processing Type: Option created for you to choose the data processing type (by tab →  display records of tab selected only) or (General → display records of all tabs) 

Tab for Processing: Tab to be used along with previous parameter. (1-Reconciled / 2-Partially Reconciled / 3-Bills Without Sales / 4-Sales

...

Without Bills / 5-Divergent)


Image Added


Totvs custom tabs box
tabsReconciled, Partially Reconciled, Bills Without Sales, Sales Without Bills, Divergent, Totals
idsConc,NConc,TitSVen,VenSTit,Div,Tot
Totvs custom tabs box items
defaultyes
referenciaConc

Correspond to imported sales the counterparts of which (financial bills in Protheus) were found in accordance with the relationship key, Branch, Establishment, NSU, installment, issue date, authorization code, type (Debit/Credit) and tolerance percentage (the tolerance percentage is set in routine parameters).

Tolerance Percentage: Consider that the net sale value must be greater than or equal to the bill balance minus the specified percentage. 

Example:  Sale


Sale (file)

Bill (Protheus)

Gross Value BRL 200.00

Value BRL 195.00

Net Value BRL 198.00 

Balance BRL 195.00

Tolerance percentage 10% 



Use the following calculation to define whether to fully reconcile it. 

Net Value >= Balance - ( Balance * Percentage) 

198 >= 195 - (195 * 10%) 

198 >= 195 - 19.5 

198 >= 175.

...

5   Image Added

...


Image Added

...


The upper grid shows sales imported through the issuer file, the lower grid shows data from the bill found in the system. The records already appear selected to make the reconciliation effective. You can select item by item or use option "Select All" to change the current selection. 

Print: 

Print the browser in Excel format to analyze the data or to check it later. 

Make Effective:

Enter the reconciliation type already done to change the status in table, so this record is no longer displayed in future reconciliations.

Totvs custom tabs box items
defaultno
referenciaNConc

Correspond to imported sales the counterparts of which (financial bills in Protheus) were found in accordance with the relationship key, Branch, Establishment, NSU, installment, issue date, authorization code, type (Debit/Credit) although "outside" the set tolerance percentage.

Tolerance Percentage: Consider that the net sale value must be smaller than the bill balance minus the specified percentage. 

Example:  Sale


Sale (file)

Bill (Protheus)

Gross Value BRL 200.00 

Value BRL 225.00

Net Value BRL 198.00

Balance BRL 225.00

Tolerance percentage 10%



Use the following calculation to define whether to fully reconcile it. 

Net Value >= Balance - ( Balance * Percentage) 

198 < 225 - (225 * 10%) 

198 < 225 - 22.5 

198 < 202.5Image Added

...


Image Added

...


The upper grid shows sales imported through the issuer file, the lower grid shows data from the bill found in the system. The records already appear selected to make the reconciliation effective. You can select item by item or use option "Select All" to change the current selection. 

Print: 

Print the browser in Excel format to analyze the data or to check it later. 

Make Effective:

To correctly control the reconciliation, enter a justification code and a description so you can continue the activation. (you may create the justifications register according to company needs) 

...

Image Added

Change the status on the table entering the type of reconciliation

...

done and save the justification data of said reconciliation, considering it was made outside regular parameters. This update ensures this record is

...

no longer displayed in future reconciliations.

Totvs custom tabs box items
defaultno
referenciaTitSVen

Correspond to all bills found in Protheus not made available in issuer files within the entered sales period (through reconciliation routine parameters) and to corresponding types (Debit/Credit).

...


Image Added

...


The grid shows bills in system that have no sales recorded. You can select item by item or use option "Select All" to change the current selection. 

Print: 

Print the browser in Excel format to analyze the data or to check it later. 

Make Effective:

To correctly control the reconciliation, enter a justification code and a description so you can continue the activation. (you may create the justifications register according to company needs) 

...

Image Added

Create a record on the sales table based on the data of the bill at issue so future reconciliations no longer show it.

Totvs custom tabs box items
defaultno
referenciaVenSTit

Correspond to sales imported from the issuer file the counterparts of which (financial bills in Protheus) were not found in the Protheus database, enabling manual reconciliation with bills available in the database. 

...


Image Added

...


The upper grid shows sales imported through the issuer file that were not reconciled. The lower grid shows all bills in the database fit for reconciliation with sales from LOJA. 

Print: 

Print the browser in Excel format to analyze the data or to check it later. 

Make Effective:

To correctly control the reconciliation, enter a justification code and a description so you can continue the activation. (you may create the justifications register according to company needs) 

...

Image Added



IMPORTANT: On this screen (Sales Without Bills) some records from imports may not have their respective bills in financials. In this case you may activate the record with a justification. After this activation, the record will have the status: "Record of Sales Without Bills", which you can view in the browser.

...


Totvs custom tabs box items
defaultno
referenciaDiv

Divergences: contains all sales entered in the card company file with some kind of occurrence, such as: Total Refund, Partial Refund, Charge Back, Modality Change. 

...


Image Added

Print: 

Print the browser in Excel format to analyze the data or to check it later. 

Save:

To correctly control the reconciliation, enter a justification code and a description so you can continue the activation. (you may create the justifications register according to company needs) 

...

Image Added

Edit status in table, entering the type of reconciliation made and

...

saving the justification data of said reconciliation, considering it was made outside regular parameters. This update ensures this record is no longer displayed in future reconciliations

...

.

Totvs custom tabs box items
defaultno
referenciaTot

Totals: display quantity of records with gross and net values in BRL by date for each tab.

...


Image Added

...


The process of reconciliation activation only labels the sale as reconciled, no longer showing this sale in future reconciliations. 

Unreconcile 

Wiki Markup

The

process

removes

the

reconciliation

data

from

the

sales

record,

allowing

the

sale

to

be

reconciled

in

future

processes.  

This

process

can

only

be

executed

if

the

payment

reconciliation

has

not

been

executed.

    Reconciliation Report - FINR916 The reconciliation report shows sales in detail with their corresponding reconciliation



Expandir
titleReconciliation Report - FINR916

The reconciliation report shows sales in detail with their corresponding reconciliation "statuses".

Report

Parameters: 

  *

Image Added

Issuer?

*

Select

the

issuer.

1

Soft.

Express.
2

Others

(Amex,

Cielo,

Rede).

*

Card

Brand

Software

Express?

*

Select

the

Card

Brand

to

filter

Software

Express

data.

Use

the

\

[F3

\

]

key

to

query

the

Card

Brand

register. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

*

Card

Company

Others

?

*

Select

the

Brand

to

filter

data

from

other

card

companies

(Amex,

Cielo,

Rede).

Use

the

\

[F3

\

]

key

to

query

the

Card

Company

register.

*

Select

Branches?

*

Select

option

"Yes"

to

filter

branches

for

the

report

or

"No"

to

display

records

from

the

branch

logged.

*

From

Customer?

*

Select

the

initial

code

of

the

range

of

customers

to

be

considered

for

the

report

generation.

Use

the

\

[F3

\

]

key

to

query

the

Customers

register.

*

From

Store?

*

Select

the

initial

code

of

the

range

of

customer

stores

to

be

considered

for

the

report

generation.

  *From

Image Added

To Customer?

*

Select

the

final

code

of

the

range

of

customers

to

be

considered

for

report

generation.

Use

the

\

[F3

\

]

key

to

query

the

Customers

register.

*

To

Store?

*

Select

the

initial

code

of

the

range

of

customer

stores

to

be

considered

for

the

report

generation.

*

From

NSU

No.?

*

Select

the

initial

NSU

code

to

generate

the

report.

*

To

NSU

No.?

*

Select

the

final

NSU

code

to

generate

the

report.

*

Credit

Start

Date?

*

Select

the

start

date

of

credit

generate

the

report.

*

Credit

End

Date?

*

Select

the

end

date

of

credit

to

generate

the

report.

  *Paymt Reconciliation

Image Added

Paymt Reconciliation Status?

*

Select

the

payment

reconciliation

statuses

to

be

considered

for

report

generation.

Use

the

\

[F3

\

]

key

to

query

the

rules.

*

From

Paymt

Reconciliation

Date?

*

Select

the

payment

reconciliation

start

date

to

be

considered

for

report

generation.

Sales

records

(FIF)

will

only

contain

this

date

after

the

payment

reconciliation

becomes

effective.

*

To

Paymt

Reconciliation

Date?

*

Select

the

payment

reconciliation

end

date

to

be

considered

for

report

generation.

Sales

records

(FIF)

will

only

contain

this

date

after

the

payment

reconciliation

becomes

effective.

*

Sales

Reconciliation

User?

*

Select

the

user

who

executed

the

sales

reconciliation

for

report

generation.

Sales

records

(FIF)

will

only

contain

this

date

after

the

sales

reconciliation

becomes

effective.

Leave

the

field

blank

(empty)

if

you

want

all

users.

  *From Sales Reconciliation Date?* Select the payment reconciliation start date to be considered for report generation. Sales records (FIF) will only contain this date after the sales reconciliation becomes effective. *To Sales Reconciliation Date?* Select the payment reconciliation end date to be considered for report generation. Sales records (FIF) will only contain this date after the sales reconciliation becomes effective. *Sales Reconciliation User?* Select the user who executed the sales reconciliation for report generation. Sales records (FIF) will only contain this date after the sales reconciliation becomes effective. *Print Justification?  * Select option "Yes" to print reconciliation justifications in report, if filled out at reconciliation activation.  Select "No" to not show the justification. *Print Reconciliation Data?* Select the sales reconciliation start date to be considered for report generation. Sales records (FIF) will only contain this date after the sales reconciliation becomes effective. *Printing Order?* Select the printing order to show in the report. Records ordered by: 1 – Recon. / NSU =   Reconciliation Order2 – NSU / Recon.=   NSU Prder           Import Log - FINA917 *Import Log* After you finish importing the files through routine Wizard (FINA914), the system allows you to evaluate records disregarded in the import through routine Import Logs "EFT (FINA917)". The possible statuses of each import are: * Caption* * *

Image Added

From Sales Reconciliation Date? Select the payment reconciliation start date to be considered for report generation. Sales records (FIF) will only contain this date after the sales reconciliation becomes effective.

To Sales Reconciliation Date? Select the payment reconciliation end date to be considered for report generation. Sales records (FIF) will only contain this date after the sales reconciliation becomes effective.

Sales Reconciliation User? Select the user who executed the sales reconciliation for report generation. Sales records (FIF) will only contain this date after the sales reconciliation becomes effective.

Print Justification?   Select option "Yes" to print reconciliation justifications in report, if filled out at reconciliation activation.  Select "No" to not show the justification.

Print Reconciliation Data? Select the sales reconciliation start date to be considered for report generation. Sales records (FIF) will only contain this date after the sales reconciliation becomes effective.

Printing Order? Select the printing order to show in the report. Records ordered by:

1 – Recon. / NSU =   Reconciliation Order
2 – NSU / Recon.=   NSU Prder


Image Added


Image Added


Expandir
titleImport Log - FINA917

Import Log

After you finish importing the files through routine Wizard (FINA914), the system allows you to evaluate records disregarded in the import through routine Import Logs "EFT (FINA917)".

The possible statuses of each import are:

 Caption

 Image Added

  • Successfully Imported - All file lines read, and the sales/payment records successfully created.
  • File already imported - An import of a file of same name has already been attempted. 
  • Incompatible file version - File layout version not approved for import.
  • Error when opening file - Unable to read file in configured directory. 
  • Partially imported - At least one sales/payment record was successfully imported.
  • Inconsistent File - Only criticisms regarding SERASA are found in file.
  • File Not Imported - No sales/payment record has been imported

...


On the EFT Imports Log screen you can:

View

Print

Other Actions → Print Browser

...

Image Added

Statuses Partially Imported, File Not Imported allow viewing problem details in accordance with the import line.

When the status is "Partially Imported", view the problem detail in the option below:

View

Image Added               

...


Header:

Status = Occurrence found in file in accordance with the caption.

File name = Name of selected file.

Process Date = Date of processing day.

Process Time = Time of processing.

Added Rec = Quantity of sales/payment records added (FIF).

Does Not Process = Quantity of file lines not processed.

Lines Read = Quantity of files lines read (including lines that formed a sales/payment record).

Fi Li Tot = Total quantity of file lines. Sum of lines not processed with lines read.

User Name = Name of user logged during the import.

Co Name = Name of Card Company/Issuer related to the folder in which the file became available.

...


Details:

Proc Line = Line of file for analysis of criticism.

Estab Code = Code of establishment - Use it to relate the code at the company with the system branch, set in parameter (*see parameters).

Certificate = Number of sales certificate. However, the record criticized may not have this information. It is only displayed if found in the line evaluated.

Reason = Occurrence found in file. 

...


Some particularities are related to the reasons. 

When the criticism is related to not finding the Branch or establishment registered, the system criticizes only one line and totals the other lines with problems, grouping this error in only one line to make viewing easier. 

...

Image Added

Example: as the image shows, we have 18 lines of the file with the same establishment code, the parameters of which are not set for any branch; thus, all these lines cannot be processed.

The other criticisms are displayed line by line or in a group of lines, depending on the layout of each card issuer.

...

Image Added


In View you can also Print the Import Logs Report FINR917 with the details onscreen with no need to select parameters. Just click "Other Actions - Print"

...


Image Added

Print 

Use it to print the Import Logs Report FINR917, setting parameters and including all import details.

...

 


Print Browser 

Standard feature to print the current browser.

 

Expandir
titleImport Report - FINR917

Printing via Import Logs routine (menu)

The EFT import log report provides details on the logs generated when importing the "EFT (FINA914)" reconciliation files.

You may call the report via menu, through routine Import Logs (FINR917)

Option Print.

...

Image Added

...

Image Added

...


Report Parameters.

From File Name? Enter the name of a given import file to print (Start).

To File Name? You can enter the name of a given import file for printing (End).

From Processing Date? Select the date in which you wish to print the report or period (Start).

To Processing Date? Select the date in which you wish to print the report or period (End).

...

Card Company? Select the card company.

User of Import? Filter by user who executed the file import.

...

Image Added

...



Top header displays the Import Log table data (FVR)

Co Name: Display card company name.

File Name: Display imported file name.

Bottom header displays the Import Log Details table data (FVR)

Proc Line: File line that generated log.

Estab Code: Code of logged line establishment.

Certificate: Number of certificate.

Reason: Display the reason, in detail, why the file line was not included in the import.

...


Image Added

...


Process Date: Display the date of import file processing.

Pro Time: Display the time of import file processing.

Pr.Rec.Qty: Display the quantity of sales/payment records entered in the system that generate EFT reconciliation files (FIF).

Not Pr.Qty: Display the quantity of lines not processed and registered in table FV3

Pr.Ln.Qty: Display the quantity of lines processed. Example:  Header, Trailer, sales details, adjustments, etc.

Lines Qty: Shows the sum of lines processed and not processed, adding up to the total of lines in the file. Sum of Not Pr.Qty and Pr.Ln.Qty.

User Name: Display the name of the user responsible for importing the file.

Status: Display the status of file import.


Image Added

...

Expandir

...

titlePayment Reconciliation - FINA918

...


Image Added

...

Main browser displays all sales/payment records this routine has imported and enabled. From this browser the reconciliation process begins.

The process reconciles payments, which are records from file imports of the card issuers:  CIELO, REDECARD, AMEX and from the Card Company SOFTWARE EXPRESS, with financial records of accounts receivable, which had as payment methods:  credit or debit card.  

When a payment is reconciled, the bill is posted and its value enters the bank transactions.

Caption: 

...

Image Added

Captions are updated in accordance with user actions and the comparative results between Protheus and files from the issuers:  CIELO, REDECARD, AMEX and from the Credit Card Company SOFTWARE EXPRESS
When files are imported, all records start with "Not Processed", changing status as information is processed.

Edit 

If needed, you can edit the "status" field of a sales bill. The statuses you can change are:

...

Image Added

Posted: This status occurs when payments are reconciled, because this process posts the bills. 

Divergent:  This status occurs when there are full returns, partial returns, charge back or modality changes.

Not Processed: This status occurs when bills are not reconciled.

It must be emphasized that status adjustments do not reverse bill postings.

Reconciliation 

When you select option reconcile, we have this parameters screen: Software Express or Others:

...

Image Added

Software Express: reconciliation of sales from the Layout of Software Express.

Others: reconciliation of sales from the Layout Others, which are: Cielo, Rede and Amex.

These options differ in the selection of Card Issuer x Card Company. For Software Express, you can select various card companies, whereas Others offers only the Cielo, Rede and Amex options. 

After selection, a screen is displayed with parameters you can fill out:

Totvs custom tabs box
tabsSoftware Express, Others
idsSoftExpress,Others
Totvs custom tabs box items
defaultyes
referenciaSoftExpress

From Branch? : Initial branch to search sales.

To Branch? : Final branch to search sales. 

From Credit Date: Start Date of sale reconciliation. (evaluate the issue date of sale).

To Credit Date: End Date of sale reconciliation. (evaluate the issue date of sale). 

From NSU No?: NSU Number (Single Sequential Number) that starts the sale reconciliation.  (with zeros to the left). 

To NSU No.?: NSU Number (Single Sequential Number) that ends the sale reconciliation. (with zeros to the left). 

...

Image Added

Generation?: Individual - Manually posts bill by bill.  By Batch - Automatically posts by batch of bills.

Type?: Select the type to be reconciled. Options: Debit/Credit or Both.

Search Prev Days?: Subtract days from start of selected search. Example: Credit Date 8/20/2018 with this option equal to 2, sales are selected from 8/18/2018.

Tolerance in %?: Percentage of the difference in the bill balances between the net sale value of the imported file and the remaining bill balance in the system

From Financial Company?: Code of initial financial company for the filter. 

To Financial Company?: Code of final financial company for the filter. 

...


Image Added

...


Posting Date?: Set the date of bill posting. Base Date - day of reconciliation execution and SITEF Credit - Credit date sent in file. 

Validate NSU f/ Not Rec.?: Validate in tab "Not Reconciled" whether the relationship between a sale and a bill in financials must have the same NSU.

...


Image Added

Totvs custom tabs box items
defaultno
referenciaOthers

Select Branches: You can select one or more branches. The field is multiple choice for reconciliation of multiple branches.

From Credit Date: Start Date of sale reconciliation. (evaluate the issue date of sale)  

To Credit Date: End Date of sale reconciliation. (evaluate the issue date of sale) 

From NSU No?: NSU Number (Single Sequential Number) that starts the sale reconciliation.  (with zeros to the left) 

To NSU No.?: NSU Number (Single Sequential Number) that ends the sale reconciliation. (with zeros to the left) 

Generation?: Individual - Manually posts bill by bill.  By Batch - Automatically posts by batch of bills. 

...


Image Added

...


Type: Select the type to be reconciled. Options: Debit/Credit or Both.

Search Prev Days?: Subtract days from start of selected search. Example: Credit Date 8/20/2018 with this option equal to 2, sales are selected from 8/18/2018.

Tolerance in %: Percentage of the difference in the bill balances between the net sale value of the imported file and the remaining bill balance in the system

Card Company: Click the "magnifying glass" icon to display card companies. You may select one or more card companies to reconcile sales.

Posting Date? : Set the date of bill posting. Base Date - day of reconciliation execution and SITEF Credit - Credit date sent in file. 

Validate NSU f/ Not Rec.? : Validate in tab "Not Reconciled" whether the relationship between a sale and a bill in financials must have the same NSU. 

...

Image Added


Processing Type?: Option created for you to choose the data processing type (by tab →  display records of tab selected only) or (General → display records of all tabs) 

Tab for Processing?: Tab to be used along with previous parameter. (1-Reconciled / 2-Partially Reconciled / 3-Bills Without Sales / 4-Sales Without Bills / 5-Divergent)

...


Image Added




Totvs custom tabs box
tabsReconciled, Partially Reconciled, Manually Reconciled, Not Reconciled, Divergent, Totals
idsPConc,PNConc,PConcManual,PNaoConc,PDiv,PTot
Totvs custom tabs box items
defaultyes
referenciaPConc

...

Correspond to imported sales the counterparts of which (financial bills in Protheus) were found in accordance with the relationship key: Branch, Establishment, NSU, installment, issue date, authorization code, type (Debit/Credit) and tolerance percentage (the tolerance percentage is set in routine parameters).

Tolerance Percentage: Consider that the net sale value must be greater than or equal to the bill balance minus the specified percentage. 

Example:  Sale

Sale (file)

Bill (Protheus)

Gross Value BRL 200.00

Value BRL 195.00

Net Value BRL 198.00 

Balance BRL 195.00

Tolerance percentage 10% 


Use the following calculation to define whether to fully reconcile it. 

Net Value >= Balance - ( Balance * Percentage) 

198 >= 195 - (195 * 10%) 

198 >= 195 - 19.5 

198 >= 175.

...

Image Added


Image Added


The grid above shows sales, imported through the issuer file, already related with bills found in the system. The records already become fit to be reconciled through button "Activate Reconciliation". Reset item selections by clicking item by item.

Print: 

To print the upper and lower grids, generated in different tabs, in Excel format for data analysis or to check it later. 

Save:

When the reconciliation becomes effective, the bills are posted and, consequently, a bank transaction is made based on the option selected in question Generation (Individual or Batch) and the bank balance is updated with the value posted. 

Totvs custom tabs box items
defaultno
referenciaPNConc

Correspond to imported sales the counterparts of which (financial bills in Protheus) were found in accordance with the relationship key, Branch, Establishment, NSU, installment, issue date, type (Debit/Credit) although "outside" the set tolerance percentage.

Tolerance Percentage: Consider that the net sale value must be smaller than the bill balance minus the specified percentage. 

Example:  Sale

Sale (file)

Bill (Protheus)

Gross Value BRL 200.00 

Value BRL 225.00

Net Value BRL 198.00

Balance BRL 225.00

Tolerance percentage 10%


Use the following calculation to define whether to fully reconcile it

...

:

Net Value >= Balance - ( Balance * Percentage) 

198 < 225 - (225 * 10%) 

198 < 225 - 22.5 

198 < 202.5Image Added

...


Image Added


The upper grid shows sales imported through the file from the card issuer and card companies, whereas the lower grid shows data from the bill found in the system. The records already appear selected to make the reconciliation effective. You can select item by item or use option "Select All" to change the current selection. 

Print:

To print the upper and lower grids, generated in different tabs, in Excel format for data analysis or to check it later. 

Save:

To correctly control the reconciliation, enter a justification code and a description so you can continue the activation. (you may create the justifications register according to company needs) 

...

Image Added

When the reconciliation becomes effective, the bills are posted and, consequently, a bank transaction is made based on the option selected in question Generation (Individual or Batch) and the bank balance is updated with the value posted. Save justification data of said reconciliation, considering it was made outside regular parameters.

...

Totvs custom tabs box items
defaultno
referenciaPConcManual

Tab "Manually Reconciled" displays bills made effective in tab "Not Reconciled", because in tab not reconciled bills are made effective with justifications and, once confirmed, this record is transferred to tab manually reconciled.

...

Image Added


The grid displays sales made effective in tab not reconciled with justifications entered by the operator. This tab displays data in execution time onscreen, that is, it always starts empty, being filled as the manual reconciliations occur. 

Print: 

Print the grid in Excel format to analyze the data or to check it later. 

Totvs custom tabs box items
defaultno
referenciaPNaoConc

Correspond to sales imported from the issuer files the counterparts of which (financial bills in Protheus) were not found in the Protheus database, enabling manual reconciliation with bills available in the database. 

...


Image Added


The upper grid shows sales imported through the issuer files that were not reconciled. The lower grid shows all bills in the database fit for reconciliation with sales from SIGALOJA. 

If the question at start is Validate NSU f/ Not Rec.?: Is set to YES, the relationship is only allowed if NSU is the same between bill and sale, otherwise the relationship between sale and bill is possible. 

Print: 

To print the upper and lower grids, generated in different tabs, in Excel format for data analysis or to check it later. 

Save:

To correctly control the reconciliation, enter a justification code and a description so you can continue the activation. (you may create the justifications register according to company needs) 

...

Image Added

When the reconciliation becomes effective, the bills are posted and, consequently, a bank transaction is made based on the option selected in question Generation (Individual or Batch) and the bank balance is updated with the value posted. Save justification data of said reconciliation, considering it was made outside regular parameters.

Totvs custom tabs box items
defaultno
referenciaPDiv

Divergent: contains all sales entered in the card company file with some kind of occurrence, such as: Total Refund, Partial Refund, Charge Back, Modality Change. 

...


Image Added

Print: 

Print the grid in Excel format to analyze the data or to check it later. 

Save:

To correctly control the reconciliation, enter a justification code and a description so you can continue the activation. (you may create the justifications register according to company needs) 

...

Image Added

Enter type of reconciliation made and save the justification data of said reconciliation, considering it was made outside regular parameters. This update ensures this record is no longer displayed in future reconciliations.

Totvs custom tabs box items
defaultno
referenciaPTot

Totals: display quantity of records with gross and net values in BRL by date for each tab.

...

Image Added

Print: 

Print the grid in Excel format to analyze the data or to check it later. 

View Log: 

Use option "View Log" to evaluate who executed the payment reconciliation routine. Find the name of the user who executed the process in column "User".

...

Image Added


04.  PARAMETERSPARAMETERS


Expandir

...

titleParameters In Use.

...

Set the parameters below for the reconciler to operate correctly. 

MV_EMPTEF - Establishment code configured for the Software Express card company

MV_EMPTCIE - Establishment code configured for the Cielo card issuer

MV_EMPTAME - Establishment code configured for the AMEX card issuer

MV_EMPTRED - Establishment code configured for the REDE card issuer

All these parameters must be exclusive, representing the Branch to be used in reconciler.

...

 

Other parameters used by the routine: 

MV_USAMEP - Enter whether the system must use table MEP to reconcile SITEF files (T = uses it; F = does not use it).

MV_1DUP - Define initialization of 1st installment of generated bill. Example: A -> for numeric sequence.  

MV_LJGERTX - Generate accounts payable for financial company with rate value, not deducting this rate from accounts receivable.

MV_BXCNAB - Define whether to group bills posted in CNAB return. (S)yes or (N)o.

MV_BLATHD - Quantity of Threads for Payment Reconciliation processing. Maximum of 20.

MV_BLADOC - Define whether to reconcile through field NSU SITEF (FIF_NSUTEF) or Certificate Number (FIF_NUCOMP)

...


05. ENTRY POINTS

...

Expandir
titleEntry Points

    

Entry points used in the payment file import process (Software Express specific)

FINFIF - To add fields when importing the Software Express file - Support Document: 

...

http://tdn.totvs.com/x/SX4CE

...

FIN910FIL - To edit the contents of file Branch when importing the Software Express file - Support Document: 

...

http://tdn.totvs.com/x/s4wDCw

...

 

Entry points used in the payment reconciliation process. 

FINA910F - Define bank data when posting bills - Support Document: 

...

http://tdn.totvs.com/x/X6Vc

...

 

FA110TOT -

...

To save data complementary to the totalizer record of automatic posting of accounts receivable (FINA110) - Support Document: 

...

http://tdn.totvs

...

.com/x/2YQDCw


06. TABLES

Totvs custom tabs box
tabsTables,Fields
idsTabelas,Campos
Totvs custom tabs box items
defaultyes
referenciaTabelas

06. TABLES

...

TableDescription
AcronymFIF
NameSITEF Reconciliation File
TableDescription
AcronymFV3
NameEFT Import Log Detail
TableDescription
AcronymFVR
NameSITEF Import Logs
TableDescription
AcronymFVX
NameJustifications

...

Register 
TableDescription
AcronymFVY
Name

...

Issuer Reasons

...

Register
TableDescription
AcronymFVZ

...

NomeBranches to Consider
TableDescription
AcronymMDE
NameSITEF Card Company
TableDescription
AcronymMEP
NameSITEF Payment in Installments 
TableDescription
AcronymTable G3 of SX5
NameEFT Reconciler Financial Co. - Software Express
Totvs custom tabs box items
defaultno
referenciaCampos

For payment reconciliation to work properly, create the fields below.

...


FieldE1_MSFIL
NameOrigin branch
FieldMEP_MSFIL
NameOrigin branch
FieldFIF_MSFIL
NameOrigin branch

...