Integration between Material and Financials

While deploying the Material module, the work model of Financials module must be defined. The main points to be observed are:

...

• Prefix - as defined in parameter MV_2DUPPREF.
• Number - Established by the number of the inbound document.
• Installment - Established by the MV_1DUP parameter for installment purchases. For cash purchases, the installment is not filled out.
• Type - Determined by the Types of Bills (SES) table. During the initial system configuration, it is defined as NF. It must be highlighted that only one type of bill is allowed for generating these documents and, once defined, it cannot be changed by the Types of Bills Maintenance routine and cannot be used to manually add bills in the Financials module; that is, this type of bill can be used only for integration.
• Supplier/Store - are filled out with the supplier/store data of the inbound document.

...

ACCOUNTS RECEIVABLE

The primary key of the accounts receivable bill is composed of:

...

• Prefix - as defined in parameter MV_1DUPPREF.
• Number - Established by the number of the outbound document.
• Installment - Established by the MV_1DUP parameter for installment purchases. For cash purchases, the installment is not filled out.
• Type - Determined by the Types of Bills (SES) table. During the initial system configuration, it is defined as NF. It must be highlighted that only one type of bill is allowed for generating these documents and, once it is defined, it cannot be changed by the maintenance routine of Types of Bills, and cannot be used for manual addition of bills in the Financial environment, which means, this type of bill can be used only for integration.

...

...

Thus, you can understand the importance of defining the MV_1DUP parameter for correctly filling out term bills and of parameters MV_1DUPNAT and MV_2DUPNAT, for filling out and using Financial Classes.

...

For example, suppose that the tables in Financials are shared and those of Material are exclusive. As the prefix can be changed after the table is saved, you cannot be sure the financial bills are not duplicated, if you do not change these parameters when you define the access method to the tables of the Financials module. 

In short, if you change the method of sharing the Financials module, make sure that, through parameters MV_1DUPPREF/MV_2DUPPREF, no duplication of the primary key occurs in its tables, as shown in the example:

...

RestArea(aArea)

Return(cPrefixo) 

Note: 

If you use the access method defined by TOTVS®, you do not need to change parameters MV_1DUPPREF and MV_2DUPPREF.