Páginas filhas
  • Clearing Between Portfolios - FINA450 - Financials P12

Versões comparadas

Chave

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

...

Deck of Cards
idParâmetros
effectTypefade
Card
id1
labelQuestions (F12)
effectTypefade

Question

Description

Group Entries?

Enter "Yes" to group the accounting entries generated through the clearance in a single entry 

Display Entries?

Enter "Yes" to display onscreen the accounting entries generated through clearance, otherwise "No" 

Clear Transferred Bills?

Enter "Yes" to allow clearance of bills transferred to the bank (Bordereau), otherwise "No"

Select Branches? 

If "Yes" the branch selection screen is displayed for the multi-branch clearance process

Card
id2
labelParameters (SX6)
effectTypefade

Question

Description 

Default

MV_BX10925

Define when the withholding of PIS COFINS and CSLL taxes are processed: 1 = At Posting or 2 = At Issue  

1

MV_BP10925

Define whether to consider the gross value of partial posting or the net value plus taxes. (1=Gross Val./2=Net Val.)

1

MV_CC10925

Configure the calculation and withholding of PCC in Clearance Between Portfolios. 1. (Default) Do Not Calculate PCC,  2. Calculate PCC on payable, 3. Calculate PCC on payable and receivable

1

MV_NUMCOMP

Sequential numbering for clearance between portfolios.  

000000

MV_CTLIPAG

Control postings payable through filled-out release date. If .T., the system checks whether field E2_DATALIB is filled out, otherwise, it does not control them 

F

MV_VLMINPG

The minimum value to post the bill, even if field E2_DATALIB is not filled out and the content of parameter MV_CTLIPAG is .T.  

0

MV_JURTIPO

The interest for bills receivable can be: (S)imple, (C)ompound only or (M)ixed = Simple up to 30 days overdue and then Compound.  

M

MV_LJINTFS

Indicate integration with Financial Services.

.F.

MV_JURXFIN

Enable integration between modules SIGAFIN - Financials and SIGAPFS - Legal. Disabled by default.  

.F.


05. MAIN PROCESSES


Deck of Cards
idprocessos
effectTypefade
Card
id1
labelClear
effectTypefade

Procedures

To execute a clearance between portfolios:

  1. Have a bill payable available for clearance.
  2. Have a bill receivable available for clearance.
  3. In the Clearance between Portfolios browser, press (F12) to set routine parameters.
  4. Configure them and confirm.
  5. Then, click option Clear, and a parameter settings screen opens

Note: in this screen, fill out data on bills from steps 1 and 2.

6. Then, mark the bills registered in step 1 and 2, then select option Save in the right-hand corner of the screen.

 

Informações
titleInformation

Clearance between portfolios uses a sequential numbering through parameter MV_NUMCOMP, controlled by field IDENTEE in tables SE1, SE2 and SE5, and field IDPROC in tables FK1 and FK2

Card
id2
labelCancel
effectTypefade

Procedures

To cancel a clearance between portfolios:

  1. Have a clearance between portfolios.
  2. In the Clearance Between Portfolios browser, press (F12) to set routine parameters.
  3. Set and confirm routine parameters.
  4. Place the cursor on the bill cleared and select option Cancel.

5. Press OK


Aviso
titleImportant

The operation to cancel the clearance between portfolios is done based on tables FK1 and FK2, using field IDPROC to locate the records cleared.

The integrity of these tables is crucial to this operation

Card
id3
labelReverse
effectTypefade

Procedures

To execute a clearance between portfolios:

  1. Have a clearance between portfolios.
  2. In the Clearance Between Portfolios browser, press (F12) to set routine parameters.
  3. Set and confirm routine parameters.
  4. Place the cursor on the bill cleared and select option Reverse.

5. Press OK.


Aviso
titleImportant

The operation to reverse the clearance between portfolios is done based on tables FK1 and FK2, using field IDPROC to locate the records cleared.

The integrity of these tables is crucial to this operation.

Card
id1
labelClearance with PCC withholding
effectTypefade

The Clearance Between Portfolios routine performs the withholding of PIS, Cofins, and CSLL when the company using Protheus withholds these taxes, because it is possible to control the withholding through the generation of 'TX' type bills.


Informações
titleImportant

The Clearance between Portfolios routine will now withhold PIS, Cofins, and CSLL taxes for both accounts payable and accounts receivable, starting with sources with version later than December 2021. 


To withhold PIS, COFINS and CSLL taxes in routine Clearance Between Portfolios, set parameters as shown below:

MV_BX10925 = 1 (PCC withholding on posting)
MV_BR10925 = 1 (PCC withholding on posting)
MV_CC10925 = 2 or 3 (enable PCC withholding on clearance between portfolios)
MV_BP10925 = 1 or 2 (Net or Gross)
MV_BQ10925 = 1 or 2 (Net or Gross)


For the correct withholding of PIS, COFINS, and CSLL taxes in the Clearance Between Portfolios, the parameters MV_BP10925 and MV_BQ10925 must have consistent content (Net or Gross for both). Otherwise, the system will display the following message:

Another point regarding the configuration of parameters MV_BP10925 and MV_BQ10925, depending on the chosen configuration (Net or Gross), on the screen for selecting bills that will be cleared, the bills will be presented with their net or gross value. 


Informações
titleInformation
  • To withhold the PCC of Bills Payable in routine Clearance Between Portfolios, set parameter MV_BX10925 = 1 (at posting).
  • This implementation includes only the withholding of PCC, not of IR and ISS.
  • If the value of bill receivable is lower than the net value of the bill payable, the PCC is calculated on the cleared value (value of bill receivable).
Card
id1
labelClearance with Income Tax on Posting
effectTypefade

The Clearance between Portfolios routine performs Income Tax withholding on posting for both bills payable and bills receivable.


Informações
titleImportant

The routine of clearance between portfolios now performs the withholding income tax on the posting contemplating cumulatively for both accounts payable and accounts receivable, as of sources with version later than December 2021. 

...

The booking of processes applied to an accounts payable clearance via the Financials module is done through the standard entries below:

SE

Taxable Event

ON

OFF (CTBAFIN)

535

Cancellation of Bills Payable/Receivable Clearance

X


594

Accounts Payable/Receivable - Clearance Between Portfolios

X



07.  RELATED TABLES

  • SE2 - Accounts Payable Register
  • SE1 - Accounts Receivable Register
  • SE5 - Bank Transaction
  • SED - Natures Register
  • SA1 – Customers Register
  • SA2 – Suppliers Register
  • FK2 - Postings Payable
  • FK1 - Postings Receivable
  • FK6 - Accessory Values
  • FK7 - Auxiliary Table
  • FKA - Transaction Tracing

08. ENTRY POINTS

Entry point

Note

F450BROW

Entry point that allows handling field contents, and which fields will compose the browser in the clearance between portfolios routine.

Document: https://tdn.totvs.com/x/p6Rc

lFA450BU

Entry point lFA450BU allows the customer to add a button.

Document: https://tdn.totvs.com/x/E6Vc

F450ValCon

Use entry point F450ValCon to validate the data related to selected bills and to control the clearance confirmation process, in routine Portfolios clearance. Executed in function FA450CMP().

Document: https://tdn.totvs.com/x/haVc

F450SE5

Entry point F450SE5 is executed after all bills selected onscreen are cleared.

Document: https://tdn.totvs.com/x/GqNc

F450OWN

 Assemble filter expression of SE1 file in IndRegua. 

Document: https://tdn.totvs.com/x/FqNc

F450FIL

Customize IndRegua filter 

Document: https://tdn.totvs.com/x/nwtRCg

F450OWN1

Assemble filter expression of SE2 file in IndRegua. 

Document: https://tdn.totvs.com/x/9GASCw

F450FIL1

Customize IndRegua filter 

Document: https://tdn.totvs.com/x/ogtRCg

F450ORDEM


F450GRAVA

To handle the data of the temporary table responsible for clearance.

Document: https://tdn.totvs.com/x/k422C

F450Conf

Entry point F450CONF validates the marking of bills for clearance.

Document: https://tdn.totvs.com/x/FaNc

F450valid

Use this entry point to validate clearance screen data.

Document: https://tdn.totvs.com/x/iaVc

F450CAES

Entry point F450CAES validates or executes a procedure after the user confirms the Cancellation/Reversal of clearance between portfolios.

Document: https://tdn.totvs.com/x/FKNc

F450SE1C

Entry point F450SE1C makes complementary recordings in file SE1. It requires no return and does not go through any parameter.

Document: https://tdn.totvs.com/x/GKNc

F450SE2C

Entry point F450SE2C makes complementary recordings in file SE2. It requires no return and does not go through any parameter.

Document: https://tdn.totvs.com/x/GaNc

FA450BUT

Entry point FA450BUT adds toolbar options. Its return is the button array.

Document: https://tdn.totvs.com/x/vaNc

FILEMOT

Entry point to read the text file of accounts receivable posting reasons.

Document: https://tdn.totvs.com/x/IF1NDQ