Páginas filhas
  • Sales Orders - MATA410 - Billing - P12

Versões comparadas

Chave

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

...

Índice
maxLevel5
outlinetrue
indent8.1.1
exclude.*ndiceIndex
stylenone

Purpose

Formalizing the sale of products or services between the parties involved (supplier and customer), and in this way establish the products or services sold associated with the commercial conditions in which the sale is made, involving prices, discounts, and payment terms, among others.

...

Deck of Cards
effectDuration0.5
historyfalse
idsamples
effectTypefade
Card
defaulttrue
id1
labelAdd

You can add a Sales Order and link it to a contract when the parameter MV_CNPEDVE is set to .T. (True); thus, it is possible to perform the entire measurement process automatically using the data added to the Order. But the system requires that a Sales Contract without authorization control is already registered and effective.

Place the cursor in the Customer field and click F9, then follow the procedures described:

  1. Select the branch and click OK to continue.Press F12 and view the parameter configuration screen. When needed, use the field help instructions.
  2. To continue adding, click Add.This registration has a self-explainable filling-in. But, when necessary, follow the guidance provided in Main Fields.
  3. Then, click Confirm to save the inclusion made.
  4. The system will perform consistency verification before saving.
  5. After this verification, the system allows you to perform releases of order, credit, and stock, up to the outgoing document generation.

When you access the routine, you can see the Sales Orders already registered and identify them quickly using the Caption.

See also the general features available in Other Actions.

Card
defaulttrue
id2
labelAdd with Product Grid

To add a Sales Order with Product Grid, set the parameters as follows:

MV_GRADE set to .T. (True);

MV_MASCGRD set to the grid mask;

MV_GRDMULT set to the program that uses the multi-field grid, allowing the use of different values to the grid products, with price list;


Informações
titleImportant

Sales orders relating to third-party possession or purchase returns must be typed item by item (grid routine not implemented for this type of order).

In the case of traceability, using the grid, the program will always calculate FIFO. To define the batch number, enter the product item by item.

Items with grid reference and items with products without a grid can be in the same sales order.


  1. Access the maintenance screen and click Add;
  2. Enter the data according to the field help instructions, paying attention to the product code, which must be a grid reference code.
  3. The System displays a window for you to select the quantities for each item of the product grid, so you can correctly post material in stock;
  4. If there are differences in the quantities entered, a warning will be displayed with the difference, and the quantity of the item will be updated with the addition of the grid score;
  5. In the product grid interface, also check the following options:
    1. Search
    2. Characteristics Curves
  6. Check the data and confirm the addition of the sales order.
Card
defaulttrue
id3
labelAdd with Price List
  1. It is possible to add a Sales Order when a Price List is already registered.
  2. Note that, when entering the quantities in the grid, in the items registered on it, start Unit Price according to the list price.
  3. Enter the other information and, after saving the information, note that field List (C6_PRUNIT) stores the list price of each item according to the field concept.
  4. If the price of one of the items with a price list changes, the total value difference is displayed at the footer of the Order with a discount or increase, following the concept already found in the Sales Order.


Informações
titleImportant
Use parameter MV_PVRECAL set to .F. to update the prices after changing the order with a new Price List.
Card
defaulttrue
id4
labelAdd with a discount at the header
  1. This type of Sales Order inclusion with a discount at the header requires a Discount Rule, aPrice List, and Payment Terms already registered.
  2. Add a Sales Order by entering the Price List, and enter the discount(s) at the header of the Then, distribute the quantities on the grid.
  3. Check the application of the discount according to the routine rule.
  4. After saving, note that field List (C6_PRUNIT) stores the price list of each item according to the field concept and values calculated with the discount.
Card
defaulttrue
id5
labelAdd with a discount on the item
  1. Adding a Sales Order with a discount on the item requires that the parameter MV_ARREFAT be set to round decimal places.
  2. When adding the order, enter the grid quantities and apply the discount to the Sales Order item.
  3. The discount percentage must be applied to each grid item.
  4. The System does not allow unit price changes to any grid item because the discount percentage applies to all. No changes are allowed.
  5. In this situation, the system displays an explanatory help.
Card
defaulttrue
id6
labelAdd with a grid item with optional items with the sale price
  1. For the correct functioning, previously register a group of optional items with the sale price.
  2. Also, add a structure for one of the Product Grid items and correlate the structure items to the group of optional items.
  3. Then, add a Sales Order and, when you enter the quantity for the item with the structure registered with optional items, the selection of the desired optional item is requested.
  4. Observe that, after selecting it, the selling price defined in the record of the selected optional item is automatically added to the unit price.
  5. If the unit price is changed, the system notifies the sum of the value of the selected optional item.
Card
defaulttrue
id7
labelEdit

When you use this option, the shaded fields cannot be edited.

Adjust the information according to the instructions described in Main Fields.

See also the general features available in Other Actions.

Card
id8
labelView

Place the cursor on the item, then click View to continue.

See also the general features available in Other Actions.

Card
defaulttrue
id9
labelDelete

Other Actions / Delete / Delete

After a Sales Order is created, its deletion is already possible as long as it has not been billed or released.

Informações
titleImportant

To be able to delete a Sales Order, first, delete the order release.
Orders that have generated an invoice cannot be deleted unless the corresponding invoices are canceled.

Check the status of the orders using the caption's indicative colors.

To use the option, follow these guidelines:

  1. To delete a sales order, select the desired order and click Other Actions / Delete.
  2. Check the data and confirm the deletion.


Other Actions / Delete / Residue

To use the option, follow these guidelines:

After you select the Sales Order and activate this option, the system deletes the existing residue, and, to the system, this Sales Order is now displayed as closed. 

Informações
titleImportant

The configuration of parameter MV_RSDOFAT determines the usage of items eliminated by residue.

Card
defaulttrue
id10
labelBarcode

Other Actions/Barcode

With this option, various products can be added in sequence without entering information for each item. After adding the items, enter the other mandatory data for each item to confirm the order.

To use the option, follow these guidelines:

  1. Fill in the sales order header as instructed in the topic "add a sales order".
  2. To start adding items, activate the reader and place it on the barcode.
  3. The system shows a screen with the product code and offers two operation keys:
    • [F5] - To enter product quantity.
    • [F6] - To delete an item.


Other Actions/Barcode/Add

To use the option, follow these guidelines:

  1. Fill in the Sales Order header as instructed in the topic "add a sales order".
  2. To start adding items, activate the reader and place it on the barcode.
    1. [F5] - To enter product quantity.
  3. Complete the missing fields such as TIO Code, among others.
  4. Check the information and confirm.


Other Actions/Barcode/Edit

To use the option, follow these guidelines:

  1. Select the Sales Order.
  2. Click Other Actions/Edit.
  3. Perform the desired adjustment and click OK to continue.
Card
defaulttrue
id11
labelCopy

Other Actions / Copy

This allows you to add a new Sales Order based on the content of a registered order, either pending or not.

Check the completion of parameters MV_TIPCPDT  and MV_PEDFREZ, for the best results in this option.

To use the option, follow these guidelines:

  1. In the Sales Order maintenance window, select the order to be copied and click Copy.
  2. The System shows a sales order inclusion screen, bringing data from the original order.
  3. All fields are copied except for the ones related to transaction table binding, status, and balance tracking. The order will always be copied as Not serviced.
  4. Make any necessary changes and confirm.
Card
defaulttrue
id12
labelReturn

Other Actions/Return

The purpose of this option is to accelerate the inclusion of a Purchase or Processing Return based on the existing incoming documents. Thus, when you select this option, a list containing incoming documents is displayed.

It returns purchases or shipment/return held by third parties for incoming invoices of types N or B.

When updating the sales order return, the System selects the TIO relative to the field Return TIO of the TIO entered in the Incoming Invoice.

To use the option, follow these guidelines:

  1. In the Sales Order maintenance, click Other Actions/Return.
  2. The System displays a screen with the Inbound Invoices.
  3. Select the invoice and click Return.
  4. The System displays the sales order return update screen, with the original data filled out.
  5. Check the information and fill in the field TIO.

Check the data and confirm it.

Card
defaulttrue
id13
labelPrep.outg.doc.

Other Actions / Prep.outg.doc.

This option makes the outgoing document generation process easier so that documents can be prepared automatically from the Sales Order, from release to Billing, and up to the generation of Invoices.

For this process to work as expected, restrictions must not exist for the customer and/or stock for the items ordered.

This process automatically updates the data tables related to the following processes:

  • Sales Order;
  • Order Release;
  • Outgoing Documents;
  • Stock Balances.

It is possible to Account for the Sales Order. For this, you must set the question parameters Online Booking and Show Entry to Yes and create the Standard Entries.

To use the option, follow these guidelines:

  1. In the Sales Order maintenance, place the cursor on the desired order and click Outg. doc.
  2. A wizard is displayed to help you configure the preparation of the outgoing document related to the order selected. Click Next.
  3. The System checks the order release status.
  4. If the Sales Order has no items released for invoicing, the wizard displays a message to warn you and allows the automatic release if a balance exists in stock.
  5. When the release is performed, click Next.
  6. The wizard displays a new message notifying that the Sales Order is released and uses the items ready for invoicing to prepare the outgoing document.
  7. If the order is not fully released, the items not released are ignored. To invoice it, click Next.
  8. At this moment, a verification checks if any credit/stock restriction related to the order exists.
  9. If so, the Sales Order Release window is displayed with the blocked items and the reason for blocking them.
  10. To finish, click Next to view the message for successful completion.
  11. If any items remain to be invoiced, a screen with the Series/Invoice data is displayed.
Informações
titleImportant

Check that the content of parameters MV_TPNRNFS and MV_MUDANUM  is .T. to edit or enter the Invoice number.

13. Select the series/invoice to be invoiced and click Ok.

14. At the next screen, set the parameters to generate the Outgoing Document.

The question Group Equal Orders? set to Yes allows you to group similar Sales Orders into the same outgoing document.

The question Conversion Ref. Dt. allows you to choose the reference date for conversion of the currency used in the Sales Order, Outgoing Document, and Telesales assistance according to DECREE No. 25 OF November 27, 2008, FOREIGN TRADE OFFICE - SECEX PUBLISHED IN THE DOU AT PAGE 00236 ON NOVEMBER 28, 2008.

15. Configure them and confirm. The Outgoing Document is generated, and the Sales Order is closed.

Card
defaulttrue
id14
labelAccounting Tracker

Other Actions/Accounting Tracker

This query is available only when viewing the Sales Order. This allows you to track this document and its items, displaying the main entities related to the Sales Order.

To use the option, follow these guidelines:

  1. Select the document and view the screen with the data.
  2. Select Other Actions/Accounting Tracker;
  3. A screen is displayed with information on the accounting entries.
Card
defaulttrue
id15
labelCaption

Other Actions / Caption

The generated orders follow a classification that identifies the current status of the order in the System, which can be:

 Pending Sales Order

Order ready to be released.

Closed Sales Order

This status appears after the preparation of the outbound document, indicating the order is closed.

Sales Order Released

This order is ready to be evaluated for credit and stock, prior to the preparation of the outbound document.

Sales Order with Rule Blocking

The order is blocked by a business rule. This happens when the sales order items and header do not agree with the definition in the Business Rules file.

Order with Funds Blocking

The order is blocked by a sales fund. This happens when, in the analysis of funds, the System checks whether the discount granted in the order items is greater than that allowed by the company. The difference between the one allowed by the rule and the one granted in the sales order is deducted from the sales fund balance if any. If the balance is insufficient, the order is blocked by the fund.

Card
defaulttrue
id16
labelRelated

Other Actions/Related Actions

This option links to the Sales Order files such as figures, texts, spreadsheets, or any type that has information relevant to the system. 

To use the option, follow these guidelines:

  1. In the routine maintenance, select the desired item;
  2. Click Other Actions/Related;
  3. Select the item you wish to add or enter.
  4. To finish the process, click
Card
defaulttrue
id17
labelCustomers

Other Actions/Customer (Customer Status)

Show important information on the relationship with clients, such as:

  • registration and financial information (returned checks, protested bills, average delay, greatest purchase, last purchase, etc.).

To use the option, follow these guidelines:

  1. When accessing this option, view the parameter configuration screen.
  2. Configure them according to the need. To continue, click
  3. The system displays the screen to query the Customer Status.

The system also provides resources for a quick query of bills outstanding, bills received, references, and billing history. Plus, it also provides buttons for a quick query of pending bills, received bills, orders, billing, references, and collection history.

Card
defaulttrue
id18
labelMethods

Other Actions/Methods (Payment Methods)

This option allows you to define specific payment methods for the order and enter the percentage apportionments between them.

The payment method is different from the condition, because it is only an informative record indicating means, for example, cash or check, and the condition indicates the distribution of values in installments according to the business rules and, therefore, the due date of bills in Financials, in the case of integration. 

Card
defaulttrue
id19
labelSpreadsheet

Other Actions/Spreadsheet (Financial Spreadsheet)

This option shows a forecast of tax calculations that must levy the outgoing document and bills receivable that must be generated (amounts and due dates). 

Card
defaulttrue
id20
labelAdvance

Other Actions/Advances (Anticipated Receipts)

Available to Brazil

To use the option, follow these guidelines:

  1. When you select this option, the system displays the advance selection screen.
  2. After entering the amount, confirm the order.

This option allows you to list advances (RA-type bills) to the Sales Order to be used in payment order deductions of the order to be generated.

Card
defaulttrue
id21
labelSimulation

Other Actions/Simulation

This option is enabled when the integration of the module SIGAOMS into TOTVS GFE is used.

Check Integrations.

Card
defaulttrue
id22
labelFormation

Other Actions/Formation

To use the option, follow these guidelines:

  1. Access this option and check the worksheet presentation;
  2. Select the Standard option and click OK to continue.
  3. Then, set the parameters on the screen and confirm.
  4. The system displays the screen of the worksheet Standard - Actual Average Cost, such as selected.
Card
defaulttrue
id23
labelNFS Binding
title15

Other Actions / NFS Binding

To use the option, follow these guidelines:

  1. For it to work correctly, the field Work Code (C5_OBRA) in the Sales Order must be filled in.
  2. Access this option and view the parameter configuration screen.
  3. Select the invoice and the other fields according to your needs and, to continue, click Confirm.
  4. Then, confirm the order.

...

Deck of Cards
effectDuration0.5
historyfalse
idsamples
effectTypefade
Card
defaulttrue
id1
labelRegular

N = Regular

The type of invoice that fits the default sale situation.

Example:

Registration Type

Field Content

Type of Order

Regular

Customer TypeSolidary
TIO RegCalculating ICMS
Card
defaulttrue
id2
labelPurchase Return

D = Return

  1. Used when it is necessary to return goods.
  2. Use the Add option and, in the Order Type field, select D - Purchase Return.
  3. Find the Product When you position the cursor, the system opens the edit screen.
  4. Find the field Original Invoice (C6_NFORI), position the cursor, and type F4 to view the Incoming Invoices.
  5. Select the Invoice you wish to return.
  6. After you confirm, the system loads the Sales Order with the source invoice data.
  7. Complete the information and confirm to continue.
  8. The system makes the order available for release and preparation of the Outgoing Document.

When needed, enter the Sales Orders referring to the Purchase or Goods return item by item (the Grid Transaction is not implemented for this type of order).

The tax code does not necessarily have to be related to returns. In this case, the Sales Order is not generated for the customer but for the supplier, since it is an incoming invoice.


Return of value only, without quantity.

  1. Use a return TIO compatible with the Sales Order that has the Zeroed Vl. Qty Set to Zero (F4_QTDZERO) field set to Yes;
  2. Adjust the quantity to 0;

The value fields Unit and Total must contain, respectively, the difference of the Value to return.

Card
defaulttrue
id3
labelPrice Complement

C = Quantity/Price Complement

  1. When it is necessary to complement an Invoice, add a new Sales Order and set the Order Type field to C-Quantity/Price Compl.
  2. At the Compl Type field, set the type of operation: 1-Price or 2-Quantity;
  3. Enter a TIO (Type of Inflow and Outflow) taxing as in the original invoice;
  4. Enter a Product, Quantity, Unit Price, and the Total Value.
  5. Find the Original Invoice using the C6_NFORIG field and make the binding
  6. Then, confirm the inclusion.
Card
defaulttrue
id4
labelIPI Complement

P = IPI Complement

This type of invoice is required when the rate of value of invoice IPI is registered lower than the due value.

The IPI value will always be the order total.

  1. In Tax Records, the IPI value is displayed in the column Taxed, regardless of what is set in whether the TIO (Types of Inflow and Outflow) is set to Yes.
  2. The ICMS is calculated when the question Levy IPI in the TIO file is filled in.
  3. The completion procedure must be:
    • Type = P;
    • Product Code = original product code;
    • Quantity = 0 (zero).
Card
defaulttrue
id5
labelICMS Complement

I = ICMS Complement

This type of invoice is required when the rate of value of invoice ICMS is registered lower than the due value.

The ICMS amount will always be the invoice total, irrespective of the definition of the question Calculate ICM (S/N) of the TIO file. In this situation, the IPI amount is not calculated.

In Tax Records, the ICMS value is shown in column Taxed, regardless of what is set in the question ICM Tax Record from TIO File. The invoice is not generated.

The completion procedure must be:

  • Type = I;
  • Product Code = original product code;
  • Quantity = 0 (zero).
Informações
titleNote

A limitation exists on purchases made by customers not registered in the taxpayer record of the state of Alagoas, according to the configuration of parameter MV_LIMFTAL.

To release these blocked orders, use the Rule Release.

Card
defaulttrue
id6
labelProcessing

B - Processing - Use supplier and Processing Operation

Return or Remittance in Third-Party possession (according to TIO used).

  • When sending a product for processing, you must perform the following tasks:
  • Register in the structure a processing code.
  • Issue a raw material invoice referring to remittance to processing. This invoice is saved in the file for balance held by third parties, to track each invoice.
  • Open a PO (Production Order) referring to the product resulting from the processing.
  • When receiving the material through the incoming invoice, enter the code of the product for processing, as well as the previous PO Thus, the request for the same product is generated for the reference PO.

Remittance at Inflow is the remittance to the client, use:

  • Invoice type (B), and
  • TIO with (R) in the Third-Party Poss. field (F4_PODER3).

Remittance at Outflow is a remittance to your supplier, use:

  • Invoice type (B), and
  • TIO with (R) in the Third-Party Poss. field (F4_PODER3).

Return at inflow is the return of a remittance already run to the supplier. Use:

  • Invoice type (N), and
  • TIO with (D) in the field Third-Party Poss. (F4_PODER3).

Return in outflow is the return of the remittance already run by the customer. Use:

  • Invoice Type (N=Regular),and
  • TIO with (D=Return) in the field Third-Party Poss. (F4_PODER3).

Processing operation

When sending a specific product to custody/fixing/processing in third parties, the System provides tracking on these quantities.

To track third-party possession, the Billing, Purchases, and Stock/Costs environments must be implemented.

The system controls the quantity of the company's products in third-party possession and vice-versa.

In third-party possession, there are two basic cases:

1 - With stock transactions:For third parties with stock transactions, the system makes a cost transaction depending on the operation, i.e.:

a) For third-party operations, the cost will be equal to the entry cost.

b) For operations at third parties' facilities, the cost will be the weighted average cost.

2 - Without stock transactions: For the third parties without stock transactions, the system stores the net balance of the product in third-party possession, but that still belongs to the company's stock.

Completion procedure must be: a TIO in Third-Party Possession = (R=Remittance) or (D=Remittance Return) exists according to processing needs.

When the option is "D" (Return), if the source invoice is not typed or selected through the [F4] key on the field "Quantity" (C6_QTDVEN) of the Sales Orders routine, the system will display the remittance invoices with the balance to be returned, where the invoice must be selected and [Enter] pressed.

Card
defaulttrue
id7
labelSales Order - Services

When a Sales Order involving the rendering of a service is issued, check whether the product (service) has a service code registered in its file.

If not, the registration can be done in the Sales Order itself using the field ISS Serv. Code of the Products File.

The Service Code is important because the ISS Registration books perform the calculations based on this code (D2_CODISS), in accordance with the legislation in effect.

Card
defaulttrue
id8
labelSales Order with Reduction at the ICMS Calculation Basis

The Reduction in the ICMS Calculation Basis is a tax benefit granted by the government according to the Product Type.

Sales outside the State in which the ICMS calculation basis reduction apply, may or may not be subject to the same Solidary ICMS calculation basis reduction (withheld).

Important: The system offers the parameter MV_BASERET, which defines if the reduction in the ICMS basis is also applied to the Solidary ICMS calculation base (withheld).

Example:

Notice the example of the invoice with a 30% reduction in the ICMS calculation basis and the Tax Substitution calculation, in which the supplier and the customer are located in Sao Paulo, given a 35% profit margin for Solidary ICMS calculation.

  1. In the TIO (Type of Inflow or Outflow) file, the following fields were defined:

ICMS Red. % (S0_BASEICM) = 41.66

Aggregate Value (F4_AGREG) = S

An order with the following information was saved in the Sales Orders File:

  • Product B.
  • Quantity = 10.
  • Unit Value = BRL 100.00
  • Total Value = BRL 1,000.00
  • Outflow TIO Configured for ICMS Reduction.
  • Order released for invoicing.
  • Credit approved.
  • Stock released.
  • Invoice issued by the Outgoing Document
  • After issuing the Invoice, you can query it and check its calculation:

Goods Value = 1,000.00

Reduced Basis % = 41.66%.

ICMS Rate: 18%.

Value of Calculation Basis = 1000.00 x 41.66/100 = 416.60.

ICMS Value: 416.60 * 18/100 = 83.988. 

Card
defaulttrue
id9
labelSales Order with CSSR

When generating invoices, the amount of the CSSR Rural Social Security Contribution Tax) will be calculated and saved in the Sale Invoices Header File - SF2, field F2_CONTSOC).

To issue a Sale Invoice for a Rural Producer, the following configuration must be followed:

  1. In the Customers File, the field Type (A1_TIPO) = L - Rural Area Producer.
  2. In the Products File, the field Sec. Cont. (B1 ContSoc) = Yes. This field indicates whether the Social Security Payment is levied on the product.
  3. In the Parameters File, Configurator environment, note the content of the parameters:
    1. MV_CONTSOC. This parameter indicates the CSSR (Rural Social Security Payment) percentage to be calculated. Which are: Natural Person (2,2); Special Insured (2,3); Legal Entity (2,7).
    2. MV_DIAFUN It indicates the day when the Social Security Payment bill is generated (FUNRURAL).
  4. In the Companies File, Configurator environment, option Company Creation, set the Rural Producer field (M0_PRODRUR) in Registration Data, folder Complement:

F: Natural Person

J: Legal Entity

L: Special Insured (works with the family group according to IOB Bul. Occupational Social Security Legislation 48/94).

This field is automatically configured by the system as a blank field, i.e. the company is not subject to payment of FUNRURAL. When filled in, it is directly related to the parameter MV_CONTSOC.

Important:

The Product must contain information on the Levy of the Rural Social Security Payment (FUNRURAL) in its record.

After configuring the above-mentioned information, the amount of the Social Security Contribution will be calculated, and the TX-type bill will be generated in the Accounts Payable of the Financials environment.

In the outgoing operations to which the payment of the Rural Social Security Fund (FUNRURAL) must be applied, when the company is a Legal Entity or a Natural Person (M0_PRODRUR = J or F) and the customer is a Natural Person (A1_TIPO = F), a bill payable to the Federal Government will be generated because the responsibility for the payment lies on the company. When the customer is a Legal Entity (A1_TIPO=R), a deduction bill will be generated for the customer, as the responsibility for its payment lies on the customer.

...

Deck of Cards
effectDuration0.5
historyfalse
idsamples
effectTypefade
Card
defaulttrue
id1
labelBlock the edition of a Service Order

To maintain the integrity between the service order and the Sales Order records, some adjustments were made to block the editing of points from a service order when a sales order is pending.
For that, the parameter MV_LIBVINC was created. It is verified when the sales order items are edited.

When set to False (.F.), it blocks editing and adding new items, and, when set to True (.T.), it allows the edition and inclusion of new items.

Card
defaulttrue
id2
labelReopen Purchase Order after returning the Invoice

This option is available after an Outgoing Document of the Return type is added.

This situation happens when goods are received via an Incoming Document, but they have to be returned using a return invoice with a TIO that generates a stock transaction. Thus, the Purchase Order becomes available to be reused with the quantity returned.

Among the fields that must be filled in in the Adm/Fin/Cost folder of the Types of Inflow and Outflowfile, it is important to consider the following criteria:

  • Inflow TIO: field TIO File filled in with the Inflow option and field Stock set to Yes.
  • Output TIO: field TIO Type filled in with the Outflow option and field Stock set to Yes.

The generation of the Outgoing Document is made using the Sales Order. When the Purchase Order is partially or fully released, the field Expected Incoming Qty. is updated.

After the Outgoing Document of the return type is added, the Purchase Order may change its status to:

  • Pending Order (green caption ): the total order quantity is returned.

Example

Goods

Quantity

Purchase Order

100

Outgoing Document - Return

100


Order Partially Served (yellow caption ): only part of the goods is returned.

Example 

Goods

Quantity

Purchase Order

100

Outgoing Document - Return

50


After each transaction, it is necessary to observe the product balance, i.e., the content of the fields Current Balance and Expected Incoming Qty. 

The process described here follows the following order:

  1. Purchase Order;
  2. Incoming Document;
  3. Sales Order - Return;
  4. Outgoing Document - Return;
  5. Released Order - Partial or Total;
Card
defaulttrue
id3
labelCalculation - TPDP

This procedure enables you to establish the Calculation Basis for the Public Spending Processing Fee (TPDP) for:

  • Sales Orders; 
  • Outgoing Documents, and 
  • Deletion of Outgoing Documents.

After you make the necessary registrations in the Customer and Product with YES and enter the Tax Rate, the System performs the Invoice transactions normally.

Informações
titleNote

Sales Returns

When the goods are returned, if the bills payable of the TPDP generated by the issuance of the Sales Invoice are not yet posted in the Financial module, it is the customer's responsibility to manage them by posting them manually.

However, if the bills payable to the TPDP were posted, resulting in the return of the goods, it is the client's responsibility to seek information from the State to be indemnified or compensated for the amounts unduly paid. This action can be done through an Administrative Process.

  1. To generate, register the parameter MV_ALITPDP according to the procedures.
  2. Register a new Customer with the field TPD = YES. 
  3. Register a Product with the field TPDP = YES.
  4. In the Billing module, access Sales Order and add a new order.
  5. The system makes the Outgoing Invoice transactions normally, calculating the Public Spending Processing Fee (TPDP) and generating financial bills. 
Informações
titleNote

The System validates the following conditions for TPDP calculation, according to three (3) main topics:

The payment processing formalized by creditors of the Federal Union's Direct and Indirect Public Administration Bodies, Autarchies, Foundations, and Mixed Economy Companies is not a taxable event for the TPDP due to:

I - payment lower than BRL 100.00 (one hundred reais);

The amount of R$ 100.00 was also used in the generation of the bills payable in installments. If the value of the installments does not reach the minimum value of BRL 100.00, this is not generated.

Example:

  • Invoice R$ 1000.00 in 12 installments of R$ 83.33 does not generate a payable bill.
  • The TPDP rate corresponds to BRL 1.50 (one real and fifty cents) for each BRL 100.00 (one hundred reais) or a fraction of BRL 100.00 (one hundred reais) to be paid by the States to their debtors.
  • TPDP cannot be greater than BRL 30,000.00 (thirty thousand reais).

Bills generated on Financials to Accounts Payable (regarding fee collection) have their due date set to three days prior to the bill's date on Accounts Receivable (regarding the Invoice) and account with validation in workdays.

Card
defaulttrue
id4
labelCompose the Withheld ICMS Basis

The parameter MV_ICMPAUT sets the withheld ICMS base composition method when an ICMS basis is entered into the operation.

If the parameter is set to .T. (True): The ICMS calculation withheld base will be started by the base value, even if the sales price is greater or lower than the Base value.

When the parameter is set to .F. (False): If the sales price is lower than the base value, the calculation base withheld ICMS will be the base value, but if the sales price is greater than the base value, the calculation base withheld ICMS is obtained by the sales price value.

Example:

The composition of the calculation base withheld ICMS according to parameter configuration and several different sales prices.

Adding a Sales Order using a product with a solidarity margin of 30% and a tax exception with an internal rate of 12% and ICMS BASE of BRL 9.60.

Parameter MV_ICMPAUT = .F. and sales price LOWER (BRL 8.00) than the Base value;
ICMS Basis = 8.00 * ICMS Rate 12% = ICMS Value = 0.96
Withheld ICMS Rate = 12.48 Composition (9.60 + 30% margin)

ParameterMV_ICMPAUT = .F. and sale value GREATER (BRL 10.00) than the base value;
ICMS Basis = 10.00 * ICMS Rate = 12% = ICMS Value = 1.20
Withheld ICMS Basis = 13.00 Composition (10.00 + 30% margin)

Parameter MV_ICMPAUT = .F. and sales price LOWER (BRL 8.00) than the Base value;
ICMS Basis = 8.00 * ICMS Rate 12% = ICMS Value = 0.96
Withheld ICMS Rate = 12.48 Composition (9.60 + 30% margin)

Parameter MV_ICMPAUT = .T. and sale value GREATER (BRL 10.00) than the base value;
ICMS Basis = 10.00 * ICMS Rate = 12% = ICMS Value = 1.20
Withheld ICMS Basis = 12.48 Composition (9.60 + 30% margin)

Card
defaulttrue
id5
labelTax Payment Form and Bill Payable for Local ICMS

Use this routine to generate, in Sales Orders and Outgoing Document, the National Tax Payment Form (GNRE) of Local ICMS, as well as generate bills payable in the Financials module for each outgoing invoice issued to another State.

  1. In Billing (SIGAFAT), access Outgoing Document Doc. Prep. andselect YES for the following questions:
    1. Generate Local ICMS Bill?
    2. Generate Local ICMS Form?
  2. Use a TIO configured for Local ICMS calculation with the Customer, Nature (SA1), and Product (SB1) files:
    1. F4_ICM = Yes;
    2. F4_LFICN = T;
  3. Confirm saving of Outgoing Invoice.
  4. The generation of the GNRE national tax payment form is displayed, and a bill of ICM prefix is generated in Financials (SIGAFIN).
Card
defaulttrue
id6
labelTax Payment in the State of Mato Grosso

The system contemplates the calculation of several contributions, check some of them below and click the corresponding link to get more information.

The State Fund for Transport and Housing (FETHAB) is the contribution targeted at financing planning, execution, follow-up, and evaluation of transport and housing works and services in the state of Mato Grosso.

The Support fund to soybean cultivation (FACS) is the contribution aimed at financing actions targeted at the support and development of soybean cultivation, and the organization of the respective Production System through entities represented by this segment.

The Support fund to cattle development (FABOV) is the contribution aimed at financing actions targeted at cattle support and development, and the organization of the respective Production System through entities represented by this segment.

Card
defaulttrue
id7
labelCalculation of PIS and COFINS Basis - Used Vehicles

Tax calculation in outgoing Invoices to consider the calculation basis of taxes and payments regarding used vehicle operations.

...

Deck of Cards
effectDuration0.5
historyfalse
idsamples
effectTypefade
Card
defaulttrue
id1
labelService Invoice (ISS)

Services companies with Taxpayer Register for Service Providers (CCM), and the Invoice is the NFS.

In the Configurator module, use Table 60 (ISS Service Code) and the codes of the services provided by the company.


Configure the fields of the processes:

Products File: 

ISS Serv. Code (B1_CODISS) - code referring to the service rendered, used to detail the operation before the levying city administration.

ISS Rate (B1_ISS) - enter the ISS calculation rate. When this field is blank, the system uses the information in the parameter MV_ALIQISS.


TIO File:

ISS Tax Record (F4_LFISS) - you must enter how the Service Invoice will be classified in the ISS Tax Records: Taxed, Exempt, Other, or Not Classified column.

Calculate ISS (F4_ISS) - enter Yes in this field when the company is not responsible for collecting the tax.


Customers File:

        Collect ISS (A1_RECISS) set to Yes (relates the financial nature to the service provision). The invoice issued has ISS calculation and a bill generated in Accounts Payable (Financials).

Card
defaulttrue
id2
labelSolidary ICMS Invoice - Tax Substitution

In this situation, the collection of ICMS-ST is anticipated. The tax is often collected based on an estimation of prices to be charged in sales to the final consumer.

This type of Solidary ICMS is collected in invoices of customers trading products difficult to inspect, such as cigarettes, records, parts, beverages, fuels, petroleum by-products, meats, etc.

In the Tax Record, the amount of Solidary ICMS is placed in the column Notes. In sales statistics, it must be considered similarly to Freight. A map lists these withheld ICMS amounts.

For S-type customers, the program calculates the Solidary ICMS through the profit margin entered in the Products file.

The profit margin that calculates solidary ICMS with the default ICMS rate of the customer's state is applied to the total item value.

To obtain the solidary ICMS, the regular ICMS is deducted from the ICMS with a profit margin. The system has the field Add Solid. in the TIO (Type of Inflow and Outflow) File, where an S or blank field can be entered so that the amount of ICMS withheld is considered in the Invoice total amount, or N so that it is not considered.

Configuration for usage:

To issue a Sale Invoice with Tax Substitution, the following configuration must be made:

  • In the Customers File, set field Type (A1_TIPO) = S - Solidary.
  • In the Products File, field Outgoing Solid. (B1_PCIMRET) is the Profit Margin for calculating the Solidary or Withheld ICMS. Example: 30.00%
  • In the TIO (Type of Inflow or Outflow) File, the fields:

Add Solid. (F4_INCSOL) to Yes to set that the Solidary ICMS value will be added to the Invoice Total.

Field Bs ICMS ST (F4_STDESC) with Gross or Net Amount to define whether the Calculation Basis of the Tax Substitution considers the Gross or Net Amount, that is, if a Discount is provided to the Customer, which is the value to consider for the Calculation Basis (Goods Amount or Goods Amount - Discounts).

Card
defaulttrue
id3
labelInvoice - Sale to Free Economic Zone

Some specifications exist for invoices generated in the Free Economic Zone of Manaus. The sale is identified when the customer has the SUFRAMA code (Superintendência Zona Franca de Manaus) and, when generating the invoice, the System grants a 7% discount on the unit price.

The discount value is kept in its own field in the Outgoing Invoice Itemsfile and can be highlighted in the invoice depending on the invoice printing script.

To issue an Invoice with a discount in cases of sales to the Free Economic Zone of Manaus, the following configuration is necessary:

  • In the Customers File, the fields:

Suframa (A1_SUFRAMA): Customer's Code in Suframa.

State Reg. (A1_INSCR): Customer's State Registration.

State (A1_EST): Customer's state (Must be a part of the content of parameter MV_NORTE).

Disc. to Sufr. (A1_CALCSUF): This field determines whether to calculate the discount to the Free Economic Zone of Manaus or not (ICMS calculation = 7% for customers with Suframa);

ZFM City Code: according to the definition of table S1 - Table of Cities for Free Economic Zone of Manaus and Free Trade, topic Tables, in the Configurator environment.

  • In the Products File, the field:

Free Econ. Z. Tax = No or blank (allowing the discount).

  • In the TIO File (Type of Inflow and Outflow), set it to calculate ICMS.

Practical example:

Notice the example of the Sales Invoice to the Free Economic Zone of Manaus in which the supplier is located in the state of Sao Paulo, and the customer is located in Ceara.

  1. In the A Product file, the field Free Econ. Z. Tax is set to
  2. In the File of Customer RO Indústria e Comércio Ltda, the following fields have been entered:
    • State = CE.
    • State Registration entered.
    • Suframa with Customer's code at Suframa.
    • Discount for Suframa set to S.
    • ZFM City Code set to 00105.

3. An order with the following information was saved in the Sales Orders File:

    • Customer RO Trade and Industry Ltd.
    • Customer Type: Reseller.
    • Product A.
    • Quantity = 10.
    • Unit Value = $ 100.00.
    • Total Value = $ 1,000.00.
    • TIO of Outflow for sale.

4. Order released for billing.

5. Credit released.

6. Stock released.

7. Invoice issued by the Outgoing Document routine.

8. After issuing the Invoice, you can query it and check its calculation:

    • Value of Goods 10 * 100.00 = 1,000.00
    • Calculation Basis of ICMS appropriate to operation = 1,000.00
    • ICMS appropriate to operation 1,000.00 * 7 % = 70.00 (Free Economic Zone of Manaus Discount).

Main Fields 

...

This indicates whether to group entries with the
Deck of Cards
effectDuration0.5
historyfalse
idPrincipais Campos
effectTypefade
Card
defaulttrue
id1
labelHeader

Field

Description

Number

This can be filled in automatically or manually.

Example:

FAT001

Order Type

Use the indicator arrow and select from the available options:

N-Regular

C-Quantity/Price Compl.;

I-ICMS Compl.;

P-IPI Compl.;

D-Purchase Ret.;

B-Use Supplier;

Customer/Store

  • Code that identifies the Customer or the Supplier depending on what is entered in the Type field.
  • After the customer is entered, the system already fills in the Store field.
  • If the type entered is Return, enter the Supplier Code.
  • When you position in the field Customer and press the F9 Key, if the parameter MV_CNPEDVE is active, the screen Contract Bound is displayed, allowing you to add an order, bind it to a contract, and perform the entire measurement process automatically using the sales order data.
  • Use the magnifying glass or the F3 key to access the default query and select the customer.

Example:

Armarinhos Sandra.

Customer Type

This field has an influence on the calculation of taxes levied on the outgoing operation. It is loaded automatically when the customer code is entered based on the information presented in the Customers File, but it can be edited manually if required by the order operation.

Select among the options presented:

  • F-End Consumer;
  • L-Rural Area Producer;
  • R-Reseller;
  • S-Solidary;
  • X-Export/Import;

Delivery Cust.

Code that identifies the delivery customer. It is used when the delivery location is in a state different from the acquirer's state, affecting the calculation of taxes, mainly ICMS.

This field is not for information only.

Use the default query available using the magnifying glass next to the field, or press F3.

Example:

000002

Paymt. Term.

Enter the payment term to generate bills to the Financial environment, and it will be considered according to the definition of rules set on the Sales Scenario. The formula for defining the payment term is informed in the Payment Terms File.

Use the magnifying glass or the F3 key to access the default query and select the item.

See more information about the Payment Terms in this FAQ.

Example:

001 - 2 Installments

List

In this field, you determine which price list is used for the Sales Order. However, if the list is not entered, the System brings the sales price informed in the Products File. It is worth noting that this field is considered according to the rules set in the Sales Scenario.

Use the magnifying glass or the F3 key to access the default query and select the list.

Example:

001 - Default List

Status

Used to Activate and Deactivate Records. The purpose is to allow the activation or deactivation of records, preventing the inactive ones from remaining in use by the application. 

Use the indicator arrow and select from the available options: 1-Inactive or 2-Active.

When the content of a field is Inactive, it means the record is blocked, and it is shown in the browse with a different color.

Work Type

This field allows you to enter the type of work directed to the building industry when issuing Service Invoices.

Use the indicator arrow and select from the available options:

  • 1-Minha Casa Minha Vida;
  • 2-Presumed System;
  • 3-Regular System.

Ecom Status

Use the indicator arrow and select from the available options:

  • 00-Generated;
  • 05-Under analysis;
  • 10-Payment Confirmed;
  • 15-Packed;
  • 21-Partially sent;
  • 30-Sent;
  • 90-Canceled;
  • 91-Returned.

Compl.Type

Use the indicator arrow and select from the available options:

  • 1-Price;
  • 2-Quantity;

Carrier

This field indicates the party responsible for the transportation of the goods included in the sales order.

When the outgoing document is generated, and you enter the carrier and the freight type (CIF or FOB), the System processes the freight values.

These values can be verified when querying the Outgoing Invoices.

Use the default query available in the magnifying glass next to the field or press F3.

Example:

FAT001 - Dois Irmaos Carrier.

Discount 1 to 5

Enter the discount percentage that falls in cascade applied to the product's list price (Products File or Price List). When no price list, the discount is not applied.

The discount percentage is relative to the order header. Cascading discounts are applied cumulatively and not added, i.e., if you enter Disc 1 and Disc 5 with 10% each, the resulting percentage will be 19%.

Example

Considering that the sales price of the item is $ 100.00: Discount 1 = 10% Sales Price = $ 90.00 Discount 2 = 10% The system will apply 10% on $ 90.00 = $ 81.00.

Installment 1 to 4 and Due Date 1 to 4

These fields are entered when the sales payment term is type 9 (the term in which the user enters the amounts and installments of the bills).

Use this term when no predefined rules exist and you must enter the installment and due date data information manually in the sales order.  

As default, the system provides up to four fields for installments and four fields for due dates.

The number of installments can be increased up to 26 as long as the parameter MV_NUMPARC is edited. When using this feature, it is necessary to create installment and due date fields in table SC5 consistent with the ones defined in the parameter. The field creation is made in the Configurator module

To use the Installment fields as percentages to be divided in the Payment Term file, the field Paymt. Term must contain the % symbol or 0 for the installments to be regarded in currency value.

Example:

Percentage 1 - 10%; Percentage 2 - 10%; Percentage 3 - 15%; Percentage 4 - 8%

For due dates 1 to 4, use the calendar next to the field to set these dates.

Freight Type

Use the indicator arrow and select from the available options:

C - CIF; F - FOB; T - On the account of third parties or S - No freight;

This field indicates the type of freight highlighted on the invoice, so the value entered is considered in the calculation basis of taxes such as ICMS and the value of the outgoing document, regardless of the type of freight entered.

When the carrier and the freight type are entered, the system treats the amounts relating to the freight while generating the outgoing document. These values can be verified when querying the Outgoing Invoices.

Check the explanatory material at Freight - Freight Concept - CIF and FOB

Freight / Insurance / Expense

These fields must not be used as information only.

Freight The apportionment or distribution of the freight value among the order items is set by the configuration of parameter MV_RATDESP. The distribution of the freight values may affect the calculation of taxes in the outgoing document.

  • Regarding taxes:

ICMS: it is levied by the invoice rate, given that it belongs to the products involved.

IPI: it is levied by a rate proportional to the weight of the items. 

If no weight exists, the calculation is proportional to the value.

In sales statistics, the freight is displayed separately.

Insurance The value entered is considered in the calculation basis for taxes such as ICMS, and the total amount of the outgoing document. If the invoice is issued including the insurance of the goods for transportation or handling of the products, this field must be filled in with the value attributed to this insurance.

This information is highlighted in the invoice, and the tax calculation occurs according to the Freight field.

Expense Enter the expense values to compose the Invoice value. This information is highlighted in the invoice, and the tax calculations occur according to the fields Freight and Insurance.

The apportionment of expenses (freight/insurance/expenses) in the sales order items is based on the content of parameter MV_RATDESP, and it can be:

  • By weight, in which the distribution is proportional.
  • By value

Example:

Consider a 1,000 kg order, the first product weighing 800 kg and the other product, 200 kg, and the parameter MV_RATDESP is set to weight, with a freight amount of $ 500.00. The System calculates as follows:

80% of 500.00 for the freight of the 1st item

20% of 500.00 for freight of 2nd item

Autonomous freight

The freelance carrier is classified as a non-taxpayer. Autonomous freight occurs when an individual performs the goods transportation, and the responsibility for paying the ICMS on the freight is on the Invoice issuer, even if the freight is contracted by the recipient.

When the invoice is issued with this type of carrier, the amount of ICMS must be paid by the company acquiring the service. When the invoice is prepared, the amount of ICMS on autonomous freight is calculated plus the invoice amount.

As an example of this situation, observe:

Description

Value

Product Value

1,000.00

Freight Value

35.00

ICMS value on freight

35.00 * 18% = 6.30

Total value of invoice

1,006.30

In this type of operation, notice that only the ICMS on the freight is collected from the customer, since the freight is contracted by the recipient, and the issuer is responsible for the payment.

Concept of Third-Party Freight

Third-Party freight occurs when the recipient hires the freight to ship the goods; however, the Invoice issuer is the one responsible for paying the ICMS-ST (by Tax Substitution) on the freight.

In this type of operation, the third-party freight must be added to the ICMS-ST calculation basis.

As an example of this situation, observe:

Description

Value

Product Value

1,000.00

Freight Value

35.00

ICMS Value

1,000.00 * 18% = 180.00

Basis of withheld

1,035.00 * 1.35 = 1,397.25

ICMS-ST Value

1,397.25 * 18% - 180.00 = 71.50

Total value of invoice

1,071.50

Handling of ICMS or ICMS-ST in the Autonomous Freight field

The content of the field Auton. Freight field (F4_FRETAUT) in the TIO File indicates if the value of the autonomous freight entered in this field is relative to the ICMS or the ICMS-ST, in which case:

  • 1 - For ICMS
  • 2 - For ICMS-ST

Thus, the System considers the information of the field Auton. Freight of the TIO File and the value entered in the field Autonomous Freight of the Sales Order to compose the Invoice total.

Currency

This refers to the Sales Order currency. This information determines in which currency the order values are expressed (check the Currencies File).

Thus, when you choose to order in Dollars (USD) when generating the outgoing document, the values are converted to the local currency (currency 1) using the rate defined in the currencies file for the system's base date.

The freight and insurance values can be expressed in local currency or order currency according to the configuration of the MV_FRETMOE parameter.

Example:

1 (Real)

Volume 1 to 4 / Kind 1 to 4

Volume 1 to 4 / Kind 1 to 4

The volumes relating to the kind of products belonging to the sales order must be entered in the fields Volume 1 to 4.

Example:

Volume 1: 10

Class 1: Cashiers

This data will be retrieved in the generation of the outgoing document.

You must fill out these fields to print the Volumes Label report.

Indemnification / Indemnification %

These fields identify discounts in amount (Indemnification) or percentage (Indemnification %) when Indemnification occurs. The fields are calculated while generating the invoice and are not considered while releasing the credit.

The Indemnification can be granted by either value or percentage, though not both simultaneously.

It is noteworthy that the System considers the credit limit; that is, even with an Indemnification, the customer cannot buy above their credit limit.

Example:

Suppose Customer X is in the following situation:

Description

Value

Customer credit limit

900.00

Sales Order

1,000.00

Compensation

200.00

In this case, the system blocks the customer's credit because the amount, even with indemnification, exceeds the credit limit.

Financial Surcharge

This field displays the percentage of financial surcharges entered in the payment term. If the term has no financial surcharge, this information can be typed in the field. This percentage will be added to the sales price at the time of generating the outgoing document.

Example:

Description

Value

Financial Surcharge

10%

Sales price

1,000.00

Final price on generating the outflow document

1,100.00

Added ISS

This field is suggested through the Customers file, field ISS in Price, and informs the system whether the amount of ISS is included in the price.

If it is not added, when you enter No, the System adds the ISS value to the total.

Use the indicator arrow and select from the available options:

S-Yes or N-No

Load

Use the indicator arrow and select from the available options:

1-Use, assembles the load and enters the unitization (when the load is divided into various unitizers; pallets, or containers).

2-Do not use, the order does not go into load assembly.

This field indicates whether the order will be included in the loading map of the OMS module.

Collect ISS?

Use the indicator arrow and select from the available options: 1 - Yes or 2- No.

Use this field to indicate, in the Sales Order entry, whether the ISS is withheld in the operation, regardless of the configuration entered in the Customers/Suppliers files.

If the Collect ISS field of the Customers File is filled out with 2=No and the Collect ISS field of the sales order header is set to 1=Yes, the System disregards the Customers File information. The same applies to the Suppliers File.

Delivery distance

/Freight list

In the field Delivery Dist., enter the delivery distance according to the Freight List File.

When you enter this field, the System automatically calculates the Freight List value.

Example:

120 Km.



Card
defaulttrue
id1
labelSales Order Items

Field

Description

Product

Code that identifies the product or service sold.

Example of a product with a grid:

JEANS_PANTS, with the color variations (AM, AZ, PT, and VD) and size (40, 42, 44).

Quantity

In the C6_QTDVEN field, enter the original quantity of the product according to the transaction: sale, purchase return, dispatch, or return from third-party possession.

The quantity that the user determines can be typed; however, if there is not enough in stock, the order will be released but blocked later by stock. There is the possibility of releasing the stock, but it will be negative.

When an order is related to a third-party possession transaction (according to the TIO), the system allows querying of balances using the keys ENTER + F4.

Unit Price

In this field (C6_PRCVEN), enter the Net Unit Price. List price with the application of financial increases and discounts.

This price may come from a Price List or the Products File. The system will evaluate the discount rules defined.

When relating to a purchase return, the original invoice can be queried. After the query, this field is filled in according to the price of the inflow invoice.

Example

For this, the sales order must have the following characteristics:

a. Type B -> Order Type field (C5_TIPO) = B;

b. Product Selection;

c. In the ORIGINAL INVOICE field (C6_NFORI), press ENTER + F4. All data from the original invoice can be queried. When you confirm this field, the System updates the Price Unit field according to the data queried.

Released Quantity

Enter the product quantity released for the order. To query the quantity in stock, press the [F4] key.

When you fill out the Released Qty. field, the System performs the appropriate consistencies and releases the order for billing as long as no customer credit or product stock restrictions are found.

It is worth noting that the quantity released cannot be higher than the quantity sold, but the quantities can also be partially released. In this case, the order will remain pending, awaiting the balance to be billed.

This field can be filled in automatically by the system with the remaining balance to be released if the question Suggest Released Quantity, displayed when pressing F12 on the main screen of the routine, is set to YES.

This is an auxiliary field, i.e. after the order item is saved and released, the field content resets to zero. Thus, it does not store the quantity already released.

Released Quantity 2nd Unit of Measure

In this field, you must apply the same concept as in the field Released Quantity, though the process is performed for the 2nd measurement unit configured in the Products File.

Enter the quantity to be released in the second measurement unit. This field can be entered when the product has a second measurement unit and the conversion factor is entered in the Products File.

Thus, the system gets the quantity to release in the default measurement unit.

Example:

Suppose a product is registered with 100 units in each box. Its 1st measurement unit is unit and the 2nd is box. If you enter 2 for the second measurement unit, the System considers 200 in the 1st unit, and vice-versa.

Second MU

Update performed as entered in the corresponding field in the Products File.

Example:

Cashiers

Cash Registers

Operation Tp.

The Intelligent TIO uses this field to fill out the C6_TES field automatically, thus making it easier to fill out the sales order.

Example:

Sale of goods

Outflow Type

The type of outflow used, registered in the Types of Inflow and Outflow table (TIO). This is a compulsory field and allows selecting the Type of Inflow and Outflow for the sales order.

The type of outflow defines various aspects of the outflow operation, indicating whether the operation updates the stock and generates trade notes, influencing the calculation and bookkeeping of various taxes (ICMS, IPI, ISS, PIS, and COFINS).

If needed, check more information in the Types of Inflow and Outflow file (TIO).

Example:

555 TSS Free Economic Zone

Sold Quantity 2nd Unit of Measure

Enter the quantity sold in the second measurement unit. This field can be entered when the product has a second measurement unit and the conversion factor is entered in the Products File.

Thus, the system gets the quantity in the default measurement unit.

Example:

100 units

Warehouse

Enter the code of the warehouse where the stock transaction is performed if the item is configured to generate a stock transaction.

If the sales order has more than one item and uses different warehouses, if one of the warehouses is locked, it will be necessary to check another available warehouse.

The items that are stored without blocking can be billed through the Prep. Docs routine in the program MATA461 (Outgoing Documents). The items can be reversed to released in the Sales Order using routine "Rever. Docs" contained in routine MATA461 (Outgoing Documents).

Tax Code

In this field, enter the Operation's Tax Code (CFO). The CFOs are registered in table 13 of the dictionary SX5. This code is usually filled in automatically based on the content of the Types of Inflow and Outflow (TIO) entered, but it can be edited if the operation requires it.

Use the default query available using the magnifying glass or press F3.

Example:

1101 - Purchase for manufacture

% Discount / Discount Amount

Enter the discount percentage or value on the sales order item.

The percentage is applied to the unit price, which does not require the product to have a list price, but if one exists, the discount is applied to the list price.

The discount will be calculated in tiers if the header discount has been filled in.

Example:

Supposing the sales price of product X is 1000 and the header of the sales order offers discount 1 of 10% and discount 2 of 5%. Next to the discount on the header, it offers a discount of 10% on the item.

The product price is 769.50.

It must be noted that the discount percentage can be determined in the Discount Rules.

The discount value is the total discount value referring to the item. In this way, the amount reported is divided by the quantity to determine the unit discount, which is applied to the unit price.

The discount amount does not require the product to have a list price, but if it does, the discount is applied to the list price. The system needs to get a new valid unit price when you enter the discount, so if the new unit price cannot be expressed using the number of decimal places available, the system recalculates the item's discount to a consistent value.

Delivery

This field suggests the base date of the System and indicates the delivery date of the sales order item.

The System allows the order to be partially invoiced and, through this field, sets differentiated delivery dates for each item.

Using parameter MV_DPDTEMI, it is possible to view, through the Financial Spreadsheet, bills divided by the delivery date of each item or by order issue date:

  • When the parameter is set to .T., the bill view will be based on the order issue date.
  • When the parameter is set to .F., the bill view will be dismantled according to each delivery date of the respective items.

Example:

25/XX/2XXXX

List Price

This field displays the product list price according to Product File information or the price list entered on the order header.

It is worth noting that all the discounts/surcharges are applied to the sale price, and the list price remains unchanged.

Example:

$ 100.00

Third-Party Possession Identifier

The system fills this field when the Sales Order refers to a Third-Party Possession Return operation.

Example:

  • Enter an Incoming Invoice with a Remittance TIO;
  • In the sales order, select:

a. the product corresponding to the return operation;

b. the TIO;

c. in the field Quantity, press ENTER + F4 so that the data corresponding to the original invoice is displayed.

When you confirm this field, the system fills in the third-party possession identifier.

 Blockage

This field refers to the manual blockage of the order item.

This prevents the order to be automatically released when the field Qty. Released is entered, besides controlling Product Reservation.

To release the order, the question Consider blocked orders? must be answered with S (Yes). In this manner, the order will be available for release.

The order can be blocked by using the following codes:

  • S = Blocked

Select this option when you need to block an item manually.

  • N = Not Blocked
  • R = Residue Blockage

Used to delete residues from order items.

It is possible to view the cause of the blockage using Related Features / Rule Blk.

Therefore, it is necessary to set the parameter MV_VEBLQRG to .T..

Original Invoice

This corresponds to the number of the source tax document.

Enter this field on purchase order types for purchase returns, price complement, ICMS complement, and IPI (Social Integration Program) complement.

When the type is equal to D (return), it is imperative to fill it out.

To fill this field out, it is required:

a. that the sales order has the field Order Type (C5_TYPE) = D (Purchase Return);

b. that you select the product in the sales order items and, then, in the field Original Invoice, press keys ENTER +F4. The system lists the original invoices that will be returned.

This field must also be entered when the order refers to a price complement for ICMS/IPI of an invoice.

Series / Original Item

Fill out the Original Serial field when you select the original invoice. Enter this field on purchase order types for purchase returns, price complement, ICMS complement, and IPI (Social Integration Program) complement.

The field Original Invoice Item indicates the original invoice item being returned, even if the item differs from that in the current invoice. Enter this field on purchase order types for purchase returns, price complement, ICMS complement, and IPI (Social Integration Program) complement.

If you fill this field out, the invoice must necessarily exist in the System.

ISS Serv. Code

This field shows the ISS code according to the information in field ISS Serv Code of the Taxes folder on the Product File.

Example:

1401. NFSe Service

Grid/Grid Item

These fields are filled in by the system when the product entered is a part of a product grid.

Batch/ Sub-batch / Validity

If the product selected in the sales order item has traceability control (entered in the Product File), this field allows you to select from which batch to remove the product sold.

In this manner, by using this field, the user can choose to sell an item that has a lower expiration date (controlled in the product batch).

Example:

1. The product to be used must have the Track field (B1_RASTRO) filled out with Batch or Sub-batch.

2. The parameter MV_RASTRO must be filled in with Yes.

3. Enter an Incoming Document.

4. When issuing the Sales Order, identify the product, then, in the Batch field, press Enter + F4. When you confirm, the Sub-Batch and Expiration Dt fields will be filled in automatically.

S.O. Optional

This field displays product options, according to the registered structure.

For further details, refer to the Option Group File.

 Address

This identifies the product's address in the warehouse if it has a physical location.

For the product to have a physical location:

  • The field Address Track. (B1_LOCALIZ) in the product file must indicate if the product uses address tracking;
  • The parameter MV_LOCALIZ must be set to Yes.

Serial Number

This field can be entered when the product has a physical location and serial number.

In this case, the quantity of the product must be equal to 1 (1 unit), because the serial number is controlled for each product.

It is also used in the Field Service - Technical Assistance module to control the product on an installed base, given that field Tech. Updt. of the TIO File is configured to handle the situation.

P.O. Number / Item

The System fills out these fields when a production order is generated for the product from the Stock/Costs and PCP environments.

Tax Status

This field displays the tax status of the product in the sales order according to the sum of the contents of the fields below:

  • Products File - Field: B1_ORIGEM
  • TIO File - Field F4_SITTRIB

 Example:

If, in the Products File, the B1_ORIGEM field is set to 0 and, in the TIO File, the F4_SITTRIB field is set to 10, the content of the Tax Status field in the Sales Order will be 010.

Contract Number / Item

These fields display the number and the item of the partnership contract generated in the Partnership Contract File.

P.O. Type

This field allows you to identify the type of Production Order to be generated from this sales order, which can be:

  • Firm - This type of production order is that which will actually be produced, that is, the actual P.O.
  • Estimate - This type is used to estimate production for planning and control of raw materials to be used and the availability of the resources for production.

Use the field when the P.O. is generated by Sales.

Structure Review

If the product has a structure review, this field will be filled in the sales order that originated the Production Order, at the time of generating the PO by Sale.

Service

Use this field in case of integration with the WMS environment to enter the type of service to be rendered in the Service Execution.

Example:

Receipt.

Destination Address

This field identifies the destination address after the service is executed.

It is used when there is an integration with the WMS environment on Service execution.

Example:

Warehouse 1 - Purchases

Physical Structure

This field indicates the type of physical structure of the address to where the products are sent, for example, expedition docs.

It is used when an integration exists with the WMS environment on Service execution.

Example:

Internal warehouse sector B with 2000 m2

No./Type/Contract Item

These fields are filled in automatically by the System when generating a Partnership Contract.

Task/EDT/Project code

These fields inform the codes for the project, EDT (Work Breakdown Structure), and task to be linked to the outgoing document.

The bond to the product outgoing document has two features set by field Proj. Trans. (F4_MOVPRJ) of the TIO File:

  • 1 - Expense (Add Cost to the Project) - This is used in situations in which the product item leaves the stock and is sent to the project, and its cost will be then added to a project task.

Note: Expenses can only be bound to tasks. The system does not consider bonds made to an EDT.

  • 2 - Income - This is used in situations in which the product item is a part of the project billing, thus generating the project’s income.

Note: The project’s income can be bound to tasks or EDTs.

Power

The field D3_POTENCIA presents the content entered in the Internal Transactions File and indicates the batch power for the product.

Sales Representative 1 to 5/Commission 1 to 5

Enter the sales representatives that took part in the sale and that will receive a commission on it. The system allows you to set up to four sales representatives in the same order, and the commissions are calculated only if the order generates trade notes.

Commission percentage in relation to sales representatives 1 to 4, respectively. The commission is automatically filled in when entered in the Sales Representatives File, or manually.

Example:

The company can promote products that are for a long time in stock by offering the sales representatives a commission on sold items besides the commission on the total order.



This indicates whether to display accounting entries when the modality is online
Card
defaulttrue
id3
labelConfiguration Parameters

To access these configuration parameters, after accessing parameter settings, you need to access the routine and choosing Add, press the <F12> key to view and configure themfor viewing and configuration.

Field

Description

Display Accounting Entry?

Suggest Released Qty?

Determine that the filter use the quantity released.

Select Yes or No.

Group Entries?

Sales Price w/ Subst.?

Determine that the filter use sales prices with substitution

same accounting definition

This indicates if accounting entries must be generated in the online modality.

.

Select Yes or No.

Online Booking?

Triangular Op.?

Determine that the filter use triangular operations.

Customer -> Suppl1 -> Suppl2 -> Customer

Select Yes or No.

Book Cost Online

Financial Spreadsheet?

Indicate if the cost will be accounted for online. The users that use the average cost re-calculation routine must not activate this feature.

Select Yes or No.

Round.insp.unit prc?

This parameter is disabled. Its feature is met by the system parameter MV_ARREFAT.

Aggreg. release from?

This indicates the initial code/number of the release aggregator to be considered.

Aggreg. release to?

This indicates the final code/number of the release aggregator to be considered.

Group Same Ord.?

This indicates if sales orders for the same customer are grouped (items added) in the same invoice, respecting parameter MV_NUMITEN.

Select Yes or No.

Minimum Vl. to Bill?

This indicates the minimum value to be considered to generate the Invoice (total value by Invoice).

From Carrier?

Use the standard query by clicking the magnifying lens next to the field or press F3 to set a specific carrier or from a carrier.

To carrier?

Use the standard query by clicking the magnifying lens next to the field or press F3.

Update Cust x Prod?

This indicates whether to update the Customer x Product binding file.

Select Yes or No.

Issue?

This indicates whether to generate invoices or tax coupons.

Select from the options:

  • Invoice;
  • Tax Coupon, or
  • DAV.

Generate Bill?

Enter whether to generate a bill payable for the Tax Substitution ICMS when this is calculated in the document and the target State is different from the State that is issuing the document.

Select Yes or No.

Print Payment Form?

Enter if you must generate the ICMS Tax Substitution Payment Form when it is calculated in the document and the target State is different from the State that is issuing the document.

The system displays a screen for you to enter the information needed for generating the Form.  

Select Yes or No.

Generate Local ICMS Bill?

 Enter whether to generate a bill payable for the Local ICMS when this is calculated in the document and the target State is different from the State that is issuing the document.

Select Yes or No.

Generate Local ICMS Form?

Enter if you must generate the Local ICMS Payment Form when it is calculated in the document and the target State is different from the State that is issuing the document.

The system displays a screen for you to enter the information needed for generating the Form.  

Select Yes or No.

Conversion Ref.Dt?

Enter the reference date for converting values if you use a currency different from currency 1.

According to ordinance 25 of SECEX of November 27, 2008.

If it is blank, the current date is used.

Generate Bill by Product?

Enter whether to generate a bill payable for the Tax Substitution ICMS by Product when this is calculated in the document and the target State is different from the State that is issuing the document.

Select Yes or No.

Generate form by Product?

Enter if the system must generate the ICMS Tax Substitution Payment Form by Product when it is calculated in the document and the target State is different from the State that is issuing the document.

Generate Targ St ICMS Compl Form?

Enter if the system must generate a complementary ICMS Payment Form for the Target State when it is calculated in the document and the target State is different from the State that is issuing the document.

The system displays a screen for you to enter the information needed for generating the Form.

Select Yes or No.

Generate FECP form of Target State?

Enter the Balance to use the remaining sales order balance, that which was billed and had residue eliminated or Total.

Select Balance or Total.

Online Booking?

Enter whether booking is online or offline. If online, the process is booked when a transaction takes place. If offline, all entries not made online are booked in a process by batch.

Select Yes or No.

Group Accounting Entry?

Enter whether to group accounting entries in a single line, if accounts, cost center, item and value class are the same in the entries.

Display Entry?

Enter whether to display accounting entry when booking online

Enter if the system must generate a payment form of the ICMS value related to the Anti-poverty Fund in the Target State when it is calculated in the document and the target State is different from the State that is issuing the document. The system displays a screen for you to enter the information needed for generating the Form.

Select Yes or No

.

Source Fragmentation

Deck of Cards
effectDuration0.5
idsamples
effectTypefade
Card
defaulttrue
id1
labelFlow

To serve the demand of Incremental Releases processes, the source MATA410 (Sales Orders) was fragmented according to the naming sequence as follows:

Card
defaulttrue
id2
labelExamples

The sources are now fragmented by processes and types of actions, and, to make identification easier, they are separated by acronyms.

Examples:

MATA410 (default existing source) = BASE - contains the operations that can be performed by the application, e.g.: adding, editing, operation, viewing, deleting, setting views and charts, browsing routine, and interfaces.

B = Business: Contains processes for saving records and business rules in general.

V = Validation: Contains pre and post-validation of forms, rows, and others.

I = Integration: Contains processes for integration between systems.

In some cases, acronyms of sources are used for better organization of processes.

See:

MATV410

Default validation of form

MAT

Source name already exists.

V

Type (V = Validation).

410

Number already exists.

MATV410A

Validation relevant to international market

MAT

Source name already exists.

V

Type (V = Validation).

410

Number already exists.

A

Source break acronym.

Therefore, the division of Sales Orders (MATA410) sources goes as follows:

MATA410 - Base (EXISTING)

MATA410B - Single Message (EXISTING)

MATV410 - Validation (Header, Header Folders, Menu Options, and Processes from Other Modules) (NEW)

MATV410A - Items Validation (NEW)

MATN410 - Business Rules involving the Billing module. (NEW)

MATN410A - Business Rules involving Supply Management. (NEW)

MATN410B - Business Rules involving Tracking of Stores, Tax Management, Logistics, Third-Party Software, and Other Modules. (NEW)

MATN410C - Business Rules to add orders via barcode. (NEW)

...