Note
This routine was adjusted to comply with the General Personal Data Protection Law (Statute No. 13.70), so that some fields containing data regarded as sensitive and/or personal are blurred, becoming illegible.
The Accounts Receivable routine controls all documents, also called bills, that generate income for the company. These bills can be Trade Notes, Checks, Promissory Notes, Payments in Advance, Invoices, etc.
The inclusion of a bill in the receivables portfolio can be done manually (with bills inserted individually via typing) or automatically (which requires integration with the Billing module, as well as that the TIO - Type of Inflow and Outflow - be configured to generate trade notes).
Note
The Accounts Receivable file is prepared as follows:
Invoice created in the Billing module | Bills generated in Accounts Receivable |
|---|---|
101010 (BRL 6,000) in 6 installments of 1,000 | 101010 A - 1,000 101010 B - 1,000 101010 C - 1,000 101010 D - 1,000 101010 E - 1,000 101010 F - 1,000 |
To configure installments alphabetically, set the content of parameter MV_1DUP to the letter A. Yet, to divide installments numerically, select option 1.
The bill prefix corresponds to the Invoice series generated by the Billing module, as defined by the parameter MV_1DUPREF.
The system stores information about bills receivable and their natures. Based on these data, the taxes due are generated.
In the implementation of a bill, the updating of customer balances, cash flow, calculation of commissions, and accounting through parameters and the registration of standardized entries is generated.
Note
In e-commerce sales, the generation of accounts receivable bills can be done before the Invoice is issued.
To avoid duplicate transactions, the TIO associated with the sale of the item should not generate financials.
In this diagram, the data refer to the features of the routine:
Before you start the addition process, press key [F12] to set routine parameters, following these criteria:
Field: | Description |
|---|---|
Display Acctg. Entry? | Select Yes or No to indicate whether to display accounting entries when booking online. Example: No. |
Book Prov. Bills? | Select Yes or No to indicate whether to book provisional bills. Example: Yes. |
Online Booking? | Select Yes or No to indicate whether to book transactions online; that is, one at a time when the transaction is effected (adding a bill, posting, generating a check, deleting, etc.) or offline, with all entries not made online booked in one batch process. Example: No. |
Apportion value? | Enter a value for accounts payable apportionment. It offers options Gross (bill value plus taxes) and Net (value without taxes). Example: Gross. |
On the main page of the routine, the following options are available:
You can add information from documents/bills to be received by the company.
Upon selecting this option, choose the Branch desired and click Ok.
Follow the instructions in Main Fields to fill out the data.
See also the features available in Other Actions.
Note
When adding bills via an automatic routine (Excauto) or manually, the system validates the type of bill entered and its respective nature.
For example, if a bill is included with the NF type (invoice) and COFINS nature, the routine will not allow the inclusion, changing the type to CF- (COFINS deduction type), and if there is no bill to receive this deduction (CF-) a warning will be displayed.
You can edit information from documents/bills to be received by the company.
Upon selecting this option, choose the Branch desired and click Ok.
Follow the instructions in Main Fields to adjust the data.
See also the features available in Other Actions.
Note
After generating and sending the electronic bank collection bordereau via the CNAB system, there may be the need to edit the bill and send it to the bank.
In Edit, the system automatically identifies and provides the resource Add Collection Instructions. By adding it, you can immediately register the banking instruction for future sending. If this criterion is not used, any edition made in any of the fields will make the system automatically display a screen to add instructions. This way, the user knows he is editing a bill that is already in bank collection.
After changing it, the bank instruction file is generated through the routine Collection Instructions, in which a new submission file is generated according to the configurations entered and only for those bills changed.
Therefore, these new instructions are stored in table FI2 (CNAB Occurrences). They are only generated in this file if they were not sent yet or when, in routine Generation of Instruction File, the parameter Show generated? is set to Yes.
Adding Collection Instructions for bills sent via bordereau using the CNAB system is only possible through the Collections File option.
Allows the deletion of a document/bill, as long as it has a status of 0=Portfolio. That way, all other statuses shall be reversed before the bill is deleted.
To do so, select the item and click Related Features / Delete.
Check available data and click Confirm.
See also the features available in Other Actions.
You can view information from documents/bills to be received by the company.
Also, check more features available in Other Actions.
Use filters to search for information, ordering it in accordance with a given characteristic.
Example:
Characteristically, you can add a provisional bill in the accounts receivable routine without the company having the invoice or the official document. Thus, when the provisional bill is replaced by the original one, you can edit such data as values, nature, history, taxes, etc. You can also select bills of different currencies and generate them in the target currency following these criteria:
When you activate the option Replace, enter the customer number and bill store. If you prefer, use the standard query feature (press key F3).
A list of bills is displayed in accordance with the selected customer of type PR.
Select and confirm the bill. The system then offers the option to register the bill receivable.
This option deletes breakdown components bills.
When the tax base is calculated by a certain period or value, procedures of manual deletion must be followed.
Run the default knowledge base routine of the system with generic information stored in files. This information can be pictures, texts, spreadsheets or any relevant file type.
This allows you to locate and display accounting entries from the document that originated them.
Use this option to indicate the status of bills through colors and/or symbols.
Displays processing log data or changes performed on the selected bill, and also allows you to search its information using filters that sort it according to the characteristic desired, such as date+time or user+date+time.
Use option Details to view highlighted data on date, time, user, message, process, and sub-process.
Editing a bill's data
Transfer of collection status
Bill negotiations
Serasa
The bill history log should record the additions and withdrawals from Serasa, that is, in the processing routine of the return from Serasa for sending or withdrawal files.
This resource makes available information for revenue management. The selected project presents information about EDT, task, value (considering 5 currency options), and reference date.
Makes available information of the checks related to the type of bill.
Note
The deduction, advance, or provisional bills will not have incoming checks related to them.
Example:
This option allows editing bills receivable in batch using the Facilitator (MATA984) functionality.
The fields of this folder are automatically filled out in accordance with the instructions registered in routines Nature and Customer (here, tax withholding follows the business rule attributed to the customer). You can adjust the values that are automatically filled out; however, they interfere in the calculation of the bill for payment.
In the case of accounts receivable, deduction bills will be generated in favor of the customer.
Field: |
Description |
|---|---|
Tax Base: |
It contemplates a differentiated basis of values for withholding Income Tax, PIS, COFINS, CSLL, INSS, and ISS taxes in the accounts receivable portfolio considered in the following processes:
|
ISS: |
The content of this field refers to service tax and is automatically calculated by the system following this priority:
Thus, when the field is filled out with Yes, the system does not perform the calculation (because the supplier collects the ISS). If it is set to option No, the system calculates it in accordance with MV_ALIQISS parameter settings. Note The following parameters are also considered:
Example:
With this scenario, the addition of a bill payable of BRL 1,000.00 will have field ISS automatically filled out with the amount of BRL 50.00. Note
Observe that, in Accounts Payable, the system automatically creates a bill (Type TX) for the payment of the ISS due to the municipality.
|
IRRF: |
Field IRRF (Income Tax Withheld by Tax Authorities) is automatically calculated in accordance with the priorities set for Natural Person and Legal Entity. This field has its content automatically calculated considering the following priorities:
Note For both situations, the use of common parameters is worth considering; however, their settings meet each profile in their own way and occasion:
Example: First, in the Nature registration, consider the field Calculate Inc. Tax? with the option Yes and the percentage of 3% in the field Inc. Tax Perc. Then, when adding a bill receivable of BRL 1,000.00 you can check the amount of BRL 30.00 automatically calculated for the Inc. Tax field. Note
At the time of adding the bill, the system generates a bill receivable of type Income Tax with characteristics of discount and does not change the original value, because it is discounted only when the bill is posted. The system generates the Income Tax nature to classify this tax.
Accrual basis in the calculation of IRRF PJ The accumulation of the bases for calculating the corporate income tax includes the following criteria:
This information is controlled by the MV_AGLIMPJ parameter that can be contemplated according to some applications:
Example: Consider the following information: COMPANY A – BRANCH 01. COMPANY A – BRANCH 02. SUPPLIER A – BRANCH 01. SUPPLIER A – BRANCH 02. Exclusive tables SA1, SA2, SE1, and SE2. Operation nature that calculates Income Tax (1.5%) Suppliers with the same basis of CNPJ (the first eight digits), one at each branch.
Case 1 Configure the parameter MV_AGLIMPJ with content equal to one (1). Add a bill of accounts payable for supplier A in branch 01, in the amount of R$ 600.00, with issue and due date established by the user. Now, add another bill of accounts payable for the same supplier in branch 02, also in the amount of BRL 600.00 with the same issue and due date. Inc. Tax = (600.00 * 1.5%) = 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 01. Inc. Tax = (600.00 * 1.5%) = 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 02. In this situation, when confirming an addition to the bill in branch 02, tax is not withheld since checking is only effective for the current branch and supplier. Configure the parameter MV_AGLIMPJ with content equal to 2. Using the previous example, add a bill of accounts payable for supplier A in branch 01, in the amount of BRL 600.00, with issue and due date established by the user. Inc. Tax = (600.00 * 1.5%) = 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 01. Inc. Tax = (600.00 * 1.5%) = 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 02. In this situation, when confirming the addition of bill in branch 02, there will be tax withholding as checking is effective in all branches and suppliers with the same CNPJ. However, bills are summed in accordance with the EIN of the issuer company (supplier) and with the EIN of the branches of the customer company (SM0). Tax withholding is effective in the second invoice. Configure parameter MV_AGLIMPJ with content equal to 3. Inc. Tax = (600.00 * 1.5%) = 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 01. Inc. Tax = (600.00 * 1.5%) = 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 02. By confirming the addition of the bill in branch 02, there will be tax withholding. In this case, values are summed in accordance with the CNPJ basis of the issuer company (supplier) and the CNPJ basis of the branches of the customer company (SM0). Tax withholding is effective in the second invoice in the amount of BRL 18.00
Case 2 Configure parameter MV_AGLIMPJ with content equal to 1. Add a bill 01 in accounts payable in branch 01 in the amount of BRL 300.00, with issue and due dates established by the user. Add a bill 02 in accounts payable for the same supplier, but in branch 02 in the amount of BRL 300.00, with the same issue and due dates. Considering this supplier, add in branch 02 a bill 03 in accounts payable in the amount of BRL 600.00, also with the same issue and due dates. Inc. Tax = (300.00 * 1.5%) = BRL 4.50 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10) in branch 01. Inc. Tax = (300.00 * 1.5%) = BRL 4.50 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10) in branch 02. Inc. Tax = (600.00 * 1.5%) = BRL 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10) in branch 02. When confirming the addition of bill 03 in branch 02, there is no tax withholding. Checking is effective only in the current branch and supplier. Configure parameter MV_AGLIMPJ with content equal to 2. Inc. Tax = (300 * 1.5%) = BRL 4.50 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 01. Inc. Tax = (300 * 1.5%) = BRL 4.50 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 02. Inc. Tax = (600 * 1.5%) = BRL 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 02. When confirming the addition of bill 03 in branch 02, there is no tax withholding. In this case, the bills are summed according to the EIN of the issuer company (supplier) and the EIN of the branches of the customer companies (SM0). There is no tax withholding (suppliers and customers' company branches have the same EIN basis). Configure parameter MV_AGLIMPJ with content equal to 3. Inc. Tax = (300.00 * 1.5%) = BRL 4.50 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 01. Inc. Tax = (300.00 * 1.5%) = BRL 4.50 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 02. Inc. Tax = (600.00 * 1.5%) = BRL 9.00 (less than the minimum value of Inc. Tax withholding, which is equivalent to BRL 10.00) in branch 02. By confirming the addition of the bill in branch 02, there will be tax withholding. In this situation, bills are summed in accordance with the CNPJ basis of the issuer company (supplier) and with the CNPJ basis of the branches of the customer company (SM0). In bill 03, there will be tax withholding in the amount of BRL 18.00 |
INSS: |
This field pertains the Contribution to the National Institute of Social Security. The system automatically fills it out when a bill receivable is added, following these criteria:
Note The content of this field also affects the settings of some parameters: MV_INSS: enter the nature for INSS bill classification. MV_VLRETIN: Enter the minimum value for exemption from payment, without generating the bill. Example: First, consider a Nature registration that calculates INSS (8% percentage), as well as a customer who also calculates this tax. Then, when adding a bill receivable of BRL 1,000.00, you can see that the INSS field is automatically filled out with the value of BRL 80.00. Note
The system generates a bill for BRL 80.00 (Type IN) referring to the INSS amount, with a discount feature, and does not change the original value of the bill, since it is only discounted when the bill is posted. The system generates the IRRF nature to classify this tax.
|
CSLL: |
A value that corresponds to the Social Contribution rate on profits in accordance with the activities performed. It is automatically filled by the system when a bill receivable is added, according to the following priority:
Note The content of this field also affects the settings of some parameters:
Example: First, consider a Nature registration that calculates CSLL (5% percentage), as well as a customer who also calculates this tax. Then, when adding a bill receivable of BRL 1,000.00, you can see that the CSLL field is automatically filled out with the value of BRL 50.00. Note
Observe that the system generates a bill of BRL 50.00, type CS-, relating to the amount of Social Contribution on Net Profits.
|
COFINS: |
Contribution value for Social Security Financing calculated on the gross revenue of companies. It is automatically filled by the system when a bill receivable is added, according to the following priority:
Note The content of this field also affects the settings of some parameters:
Example: First, in the Nature registration, consider the field Calculate Inc. Tax? with the option Yes and the percentage of 2% in the field COFINS Perc. Then, when adding a bill receivable of BRL 1,000.00 you can check the amount of BRL 20.00 automatically calculated for the COFINS field. Note
The system generates a bill for BRL 50.00 (Type CF) referring to the COFINS amount, with a discount feature, and does not change the original value of the bill, since it is only discounted when the bill is posted.
|
PIS/PASEP: |
A value that corresponds to the 1% rate levied on the payroll. It is automatically filled by the system when a bill receivable is added, according to the following priority:
Note The content of this field also affects the settings of some parameters: MV_PISNAT: enter the nature for PIS bill classification. MV_VLRETPIS: Indicates the minimum amount for exemption from PIS withholding. MV_PISVENC: Determines the number of days to be considered for collecting PIS and the calculation period. MV_TXPIS: When the PIS rate in the nature file is zeroed, the system uses the rate contained in this parameter to calculate the PIS amount while adding a bill receivable. Example: First, consider a Nature record that calculates PIS (0.65% percentage), as well as a customer who also calculates this tax. Then, when adding a bill receivable of BRL 1,000.00, you can see that the PIS field is automatically filled out with the value of BRL 6.50. Note
The system generates a bill for BRL 6.50 (Type PI) referring to the PIS amount, with a discount feature, and does not change the original value of the bill, since it is only discounted when the bill is posted.
|
ISS Supp. |
Enter the code of the Municipality (supplier) that will be used for payment of the ISS tax. If it is blank, the system will respect the content of the Municipality field or the MV_MUNIC parameter. |
| PISCOF PubAg.: | Identifies a good or service hired by a public agency. Fill out this field by selecting between options: 1-Yes and 2-No. Example: 2-No |
Form. With ISS: |
Enter the condition to be applied in calculation of ISSQN withholding (Tax over Services of Any Nature) for this bill, which can consider the minimum value for withholding or always withhold it. Fill out this field with one of these options: 1 – Cons. Min. Val. (default value). 2 – Always withhold it. |
FETHAB Inst.: |
Installment number of FETHAB (State Fund for Transport and Housing). |
FETHAB Val.: |
Bill value of FETHAB (State Fund for Transport and Housing). |
Apply Vl.: |
Indicates the verification of the limit (minimum value) of PIS, COFINS, and CSLL, thus, the field completion is defined through the options 1=Yes and 2=No. |
ISS Rate Code: |
This field remains enabled when the ISS rate is registered through routine ISS Multiple Rates, thus allowing the selection of an ISS rate for the bill payable. If you do not fill out this field, the rate used in the bill payable is the rate set in parameter MV_ALIQISS. |
FABOV Val.: |
Value of FABOV tax (Cattle Raising Development Fund). |
FABOV Inst.: |
Installment of FABOV tax (Cattle Raising Development Fund). |
FACS Val.: |
Value of FACS tax (Soy Culture Development Fund). |
FACS Inst.: |
Installment of FACS tax (Soy Culture Development Fund). |
Vl. Minimum ISS: |
Applies minimum ISS amount. |
INSS Prov.: |
This field stores the INSS provisioning for bills of type PA (Advance Payment) in accordance with the settings of parameters MV_PABRUTO=2 and MV_PAPRIME=2. |
F100 Desc.: |
Classifies the Decrease value as Conditional or Unconditional when sending the data in block F100 of SPED PIS/COFINS. If the bill is classified as F100 Discount = I (unconditional), the decrease value is subtracted in the base value for the calculation of the computations, and the record referring to the discount value is not sent in block F100 of SPED PIS/COFINS. Default: C (conditional). |
Inc. Tax Fed. Rev. Code: |
Enter the revenue code for the Withholding Income Tax, according to the Federal Revenue Service's table. |
ISS Prov.: |
This field will store the ISS provisioning for bills of type RA when the MV_RARTIMP parameter is set to 1. |
Note
Tax Withholding Control - PIS, Cofins, and CSLL
This contemplates situations in which there is the maintenance of accounts receivable securities in the following transactions:
Example:
Inclusion of three bills receivable in the amount of BRL 2,000.00 each, with due date in the current month and with customer and nature registered.
When you add the third bill, the tax amounts are calculated in: BRL 60.00, BRL 180.00, and BRL 39.00 for CSLL, COFINS, and PIS, respectively.
By changing the amount of bill 01 from BRL 2,000.00 to BRL 3,000.00, the tax amounts are recalculated to BRL 210.00, BRL 70.00, and BRL 45.50 for CSLL, COFINS, and PIS, respectively.
To control tax withholding successfully, the following items are required:
Parameter MV_BR10925 defines the time of deduction of the amounts of these taxes and can be set to 1 (tax deduction occurs when the document is posted) or 2 (tax deduction occurs when the document is issued). if it is set to 1, the following scenarios are considered:
Regular bills |
Bills of Advance Collection (RA) |
|---|---|
|
|
Field: |
Description |
||||||
|---|---|---|---|---|---|---|---|
Delinq. Fee: |
In this field, enter the value to be added to the bill for each day of payment arrears. For calculation purposes, the system takes consecutive days into account and this field has priority on field Interest Perc. at bill posting. Note If needed, you can change the priority depending on the settings of parameter MV_FINJRTP which follows some criteria when bills have both fields filled out: 1 - Apply only the Delinquency Fee (default content). 2 - Apply only Interest. 3 - Apply the Delinquency Fee and Interest. Example: Considering a bill with the following characteristics:
At bill posting, the system displays the following data:
|
||||||
Interest Perc.: |
In this field, enter the interest percentage to be levied per day on the original bill value for payment in arrears. For calculation purposes, the system uses consecutive days. For the system to use the interest percentage, do not fill out the field Delinquency Fee, otherwise, it is given priority. Note If needed, you can change the priority depending on the settings of parameter MV_FINJRTP which follows some criteria when bills have both fields filled out: 1 - Apply only the Delinquency Fee (default content). 2 - Apply only Interest. 3 - Apply the Delinquency Fee and Interest. Example: Consider a bill due on 4/11/2015 (Saturday). In this case, its actual due date is on 4/13/2015; however, if the payment is made on 4/16/2015, the system considers 5 days of arrears and the scenario becomes as follows:
|
||||||
Financ. Disc: |
If necessary, enter the discount percentage to be given to the bill. It will also be used as a percentage of the discount for early payment which, in this case, is due monthly. The system provides financial discounts for bills posted in advance through input in the fields Financ. Disc., Days for Disc., and Discount Tp. when adding the bill receivable. Examples: Single Discount
If the bill is paid up to 10 days before maturity, the discount is 2.7% on the amount. Proportional discount
In the example above, if the bill is paid on 04/03/15, the discount will be 2.7% per month, proportional to 50 days, with a total discount of BRL 29.62. |
||||||
Days for Disc.: |
The number of days that should be considered as the deadline for granting the financial discount when posting the bill. If not entered, the discount will be granted until the due date according to the content defined in the Discount Type field. |
||||||
Discount Type: |
This defines the type of discount granted by selecting the following options: 1=Fixed: the percentage will be applied on the receipt value up to the deadline for granting the discount. 2=Proportional: the discount percentage will be applied proportionally to the receipt value according to the receipt date, i.e., the earlier the anticipation, the higher the discount. Note
The deadline will be set to the date defined on parameter MV_DTDESCF minus the days of discount granted.
|
||||||
Addition: |
An amount of surcharge that must be applied to the receipt of the bond, regardless of delays. It is fixed and handled as interest amounts. |
||||||
Reduction: |
An amount of surcharge that must be applied to the receipt of the bond, regardless of delays. It is fixed and handled as the discount amounts. |
||||||
Mult. Natures: |
Use this field to define whether to classify bills in multiple natures. For tax calculation purposes, the definitions of the nature entered in the Nature field prevail. This field is also enabled when the bill receivable is added according to the criterion chosen in the MV_MULNATR parameter. While distributing the bill amount among multiple natures, it is possible to apportion the amount of each nature among various cost centers. Therefore, in the column Apport. Cost C., enter 1 to distribute the nature value among different cost centers. Otherwise, enter 2. The standard entries considered in the accounts receivable routine are: 506 - Apportionment by cost center of distribution in multiple natures. 507 - Cancellation of apportionment by cost center of distribution in multiple natures. These standard entries are available for online (506, 507) or offline (506) accounting and must be used together with standard entry 500 (addition of accounts receivable bills). Distributions of values by multiple natures that do not use apportionment by cost center are booked as additions (standard entry 500). Distributions that use apportionment by cost center are booked by the aforementioned entries (however, standard entry 506 is not executed if standard entry 500 does not exist). The accounting of bills receivable distributed in multiple natures is done using the same standard entry as the bill inclusion/deletion. To do this, you only need to enter the value in the Standard Entry record as follows:
|
||||||
Breakdown: |
This field allows you to generate several bills with different due dates, from a single addition. Use this resource for expenses with fixed due dates (such as rental payments). For operational reasons, this option does not treat multiple natures, since bills are generated automatically, without providing the apportionment interface. To calculate taxes, the following items are required when there is a bill breakdown:
Thus, tax bills configured for withholding when bills receivable are issued are generated according to the calculation rule of each tax. Note Criteria considered when adding the bill:
For accounting purposes, use the Standard Entry code 504 (addition of accounts receivable bills through breakdown). |
||||||
Src. Prefix: |
The source prefix in the moment of bill generation. |
||||||
Interest Disc.: |
Percentage of discount over interest. |
Field: |
Description |
|---|---|
Sales Representative 1: |
Code that identifies the first sales representative that participates with commissions in the bill. If preferred, use the standard query to select the option registered in the Sales Representative routine. |
Sales Representative 2: |
Code that identifies the second Sales Representative that participates with commissions in the bill. If preferred, use the standard query to select the option registered in the Sales Representative routine. |
Sales Representative 3: |
Code that identifies the third sales representative that participates with commissions in the bill. If preferred, use the standard query to select the option registered in the Sales Representative routine. |
Sales Representative 4: |
Code that identifies the fourth sales representative that participates with commissions in the bill. If preferred, use the standard query to select the option registered in the Sales Representative routine. |
Sales Representative 5: |
Code that identifies the fifth Sales Representative that participates with commissions in the bill. If preferred, use the standard query to select the option registered in the Sales Representative routine. |
Commission % 1: |
Commission percentage of the first sales representative who participates in the bill's commissions. The system fetches this percentage from the Sales Representatives file. |
Commission % 2: |
Commission percentage of the second sales representative who participates in the bill's commissions. The system fetches this percentage from the Sales Representatives file. |
Commission % 3: |
Commission percentage of the third sales representative who participates in the bill's commissions. The system fetches this percentage from the Sales Representatives file. |
Commission % 4: |
Commission percentage of the fourth sales representative who participates in the bill's commissions. The system fetches this percentage from the Sales Representatives file. |
Commission % 5: |
Commission percentage of the fifth sales representative who participates in the bill's commissions. The system fetches this percentage from the Sales Representatives file. |
Commiss. Vl. 1: |
Value of the commission referring to currency 1. |
Commiss. Vl. 2: |
Value of the commission referring to currency 2. |
Commiss. Vl. 3: |
Value of the commission referring to currency 3. |
Commiss. Vl. 4: |
Value of the commission referring to currency 4. |
Commiss. Vl. 5: |
Value of the commission referring to currency 5. |
Order No.: |
The number of the order that originated the bill. |
NSU Number: |
A unique sequential number that represents the return code issued by the network that acquires a sales operation performed using cards. |
NSU SITEF: |
NSU SITEF Number. |
Field: |
Description |
|---|---|
Primar. Inst.: |
The primary instruction of the collection. |
Second. Inst.: |
Secondary instruction of the collection. |
Date for Clear.: |
Date of the bill receivable to be credited in the bank. |
Receipt Mode: |
Expected receipt mode (SPB). Example: 1-TED. |
Cust. Bank: |
Customer bank used in the collection distribution bordereau. |
Field: |
Description |
|---|---|
Occurr. Code: |
Remittance occurrence desired. This code is considered according to the manual of the Bank that performs the collection. Example: 01-Remittance. |
Daily seq.: |
Sequential code of journal for accounting. |
Journal code: |
Code of the journal to be used for transactions. |
Cost c.: |
Cost Center considered in the accounts receivable process. |
Field: |
Description |
|---|---|
Installment: |
Bill Installment. The system allows you to control the breakdowns of a bill. |
Proj. Apport.: |
Indicator of apportionment of Projects (linked to PMS - Project Management). Select option 1 - Yes or 2 - No to fill out the content of this field. |
Budg. Code: |
Represents the code of budget plan and the request is validated in this plan in relation to budgeted and executed. The system always uses the content of this plan with the default plan set in parameter MV_PLAPAD; however, you can also enter the desired plan to make the purchase and, consequently, the reservation of the values preset in this plan. |
Financ. Agreem.: |
Number of the Financial Agreement. |
Rate Currency indexation rate Currency: |
The last rate used in indexation calculation for bills with a currency other than 1. |
Sched. No.: |
Code of financial schedule of contract. |
Contract No.: |
Code of contract. |
Meas. No.: |
Measurement number. |
Spreadsh. No.: |
Code of contract spreadsheet. |
Installment No.: |
Installment of financial schedule. |
Revision: |
Code of contract revision. |
Transaction: |
This indicates the number of the transaction where the bill receivable was generated. It is used for cash transaction control in commercial automation. Example: 1, 2, 3. |
Contr. Fine: |
Value of contract fines deducted in the financial bill. |
Contr. Bonus: |
Value of contract bonuses deducted in the financial bill. |
Contr. Discount: |
Value of contract discounts deducted in the financial bill. |
Send Report: |
Define whether to send a report by selecting between options 1-Yes and 2-No. |
Contr. Withh.: |
Value of contract withholding deducted in the financial bill. |
Class: |
Class code. |
Ref. proc.: |
The number of the referenced process related to the bill. This information is used when generating SPED, PIS, and COFINS. |
Process tp.: |
Define the type of process related to the bill. This information is used when generating SPED, PIS, and COFINS. |
TPDP Vl.: |
Value of the public expenses processing fee. |
TPDP Inst.: |
Installment of the Public Expenses Processing Fee. |
FUMIPEQ Vl.: |
Value of FUMIPEQ (Municipal Stimulus Fund for Micro and Small Businesses). |
FAMAD Inst.: |
Installment of FAMAD (Timber Development Fund). |
FUMIPEQ Inst.: |
Installment of FUMIPEQ (Municipal Stimulus Fund for Micro and Small Businesses). |
Service Tp.: |
Type of service referring to the bill. Example:
|
CNO Code: |
Code related to the national construction work registration. |
