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

Index


Purpose

The Sales Order is an essential company invoicing tool, as it registers business operations of products and services. Using it, a sale is confirmed, and a relationship with the customer is formalized.

Important

When you fill out the Reference Rate and Reference Currency fields, a history of the reference exchange rate is kept for cases in which invoices are issued in local currencies with reference to the dollar and when invoices are issued in dollars with reference to the local currency.

This information is used in routines Invoice Generation and Generate Packing Slip.


The following special cases for issuing sales orders are defined as specific:

Sales Order - Australia

    GST - Goods and Services Tax

    When you issue an outgoing document, the System automatically calculates the GST - Goods and Services Tax value using a rate previously registered in routine Tax Registration (10% for products with GST, and 0% for GST-free).

    GST is the tax applied for most goods and services in Australia, and its value can be refunded for all parts of a production supply chain except for the final consumer.

    Plus, GST is a national tax; its rate is always 10% for eligible products and 0% for GST-free products.

    GST calculation is also performed when the company is registered/eligible for this tax or when it has a requisition to be registered.


    Important

    On invoices, the tax amount and the invoice total show the decimals calculated by the System (always considering two decimals and rounding up when the third decimal is 5 or more).

    Examples:

    1.433 = 1.43

    1.435 = 1.44

    1.437 = 1.44

    The calculated GST amount is displayed in the Tax Vl. field of the Taxes folder.

    Requirements

    Before generating the invoice with the calculated GST, you must:

    1. Register a Product with the GST.
    2. Register a Customer.
    3. Register the TIO (code 501) and enter a sales order using it.

    Upon entering a sales order, the system automatically generates the bill payable.

    Sales Order

    When the invoice value is equal to or above U$1,000.00 (one thousand dollars), you must identify the receiver of the document with Name and ABN (Australian Business Number) or Name and Address. The data added using this validation is saved in the customer's record.

    Sales Order - Colombia

      By meeting Colombian Laws, the System ensures that the invoicing of a sales order considers the calculations required by tax authorities.

      In the following procedures, check some examples of how to add credit memos considering the IVA calculation. The resource also contemplates the ICA calculation, which follows the same reasoning, and the VAT Withholding calculation.

      Important:

      For the System to consider the value as exempt or just not calculated, even with VAT calculation and without the AUI calculation, you must register a TIO indicating option 3-Exempt or option 2-Not Calculated in the field Calculate VAT.

      The result is the invoice with VAT data (rate, basis, and total value) equal to 0 (zero).

        • For the System to perform the VAT calculation with the rate set in the product, without AUI calculation, use TIO 501.
        • The registered product must receive the rate (example: 1%) corresponding to the field IVA Percentage.

      The resulting invoice is generated with calculated VAT, added to the document total, storing the calculation basis of BRL 104,000.00, VAT Value BRL 1,040.00, and a total of document and trade note: BRL 107,040.00.

        • For the System to perform the calculated VAT and AUI calculation, adding only the VAT to the document total, use TIO 517.

      The result is the AUI basis: BRL 100,000.00, AUI rate 10%, AUI value BRL 10,000.00, VAT Basis BRL 1,000.00, VAT Rate 10%, VAT Value BRL 100.00, and document and trade note total: BRL 106,100.00.

      1. Access the Products File and register the product to be invoiced.
      2. Access the Customers File and fill out the customer data. Pay attention to the Customer Type in this step.
      3. In the Sales Order Maintenance routine, press the [F12] key to set the routine parameters.
      4. In the parameters screen, fill out data according to field help instructions.
      5. When you finish filling them out, click Confirm.
      6. Click Add in the browser and, in the Add screen, enter the sales order with the product and customer items previously registered.
      7. Enter the TIO type, the quantity of the product to be invoiced, the product unit value, the freight (FOB), the insurance value, and the value of expenses.
      8. Confirm your addition and invoice the order.

      Example

      Example Result

      Enter the Standard TIO 501;

      Enter the quantity 1;

      Enter the unit value of BRL 100,000.00;

      Enter the freight (FOB) of BRL 1,000.00;

      Enter the insurance of BRL 2,000.00;

      Enter expenses of BRL 3,000.00.

      Invoice generated with VAT calculated and added to the document total,

      Rate of 16% (VAT base = 104,000.00 and VAT value = 16,640.00).

      Document Total: 122,640.00.

      Trade Note Total: 122,640.00.

      1. Enter the TIO type, the quantity of product to be invoiced, enter the product unit value, the freight (FOB), the insurance value, and the value of expenses:

      Example

      Example Result

      Enter the Standard TIO 502;

      Enter the quantity 1;

      Enter the unit value of BRL 100,000.00;

      Enter the freight (FOB) of BRL 1,000.00;

      Enter the insurance of BRL 2,000.00;

      Enter expenses of BRL 3,000.00.

      Invoice generated with VAT calculated and added to the document total,

      Rate of 1.60% (VAT base = 104,000.00 and VAT value = 1,664.00).

      Document Total: 107,664.00.

      Trade Note Total: 107,664.00.

      1. Enter the TIO type, the quantity of the product to be invoiced, the product unit value, the freight (FOB), the insurance value, and the value of expenses.

      Example

      Example Result

      Enter the Standard TIO 503;

      Enter the quantity 1;

      Enter the unit value of BRL 100,000.00;

      Enter the freight (FOB) of BRL 1,000.00;

      Enter the insurance of BRL 2,000.00;

      Enter expenses of BRL 3,000.00.

      Invoice generated with VAT calculated and added to the document total,

      Rate of 5% (VAT base = 104,000.00 and VAT value = 5,200.00).

      Document Total: 111,200.00.

      Trade Note Total: 111,200.00

      1. Enter the TIO type, the quantity of the product to be invoiced, the product unit value, the freight (FOB), the insurance value, and the value of expenses:

      Example

      Example Result

      Enter the Standard TIO 504;

      Enter the quantity 1;

      Enter the unit value of BRL 100,000.00;

      Enter the freight (FOB) of BRL 1,000.00;

      Enter the insurance of BRL 2,000.00;

      Enter expenses of BRL 3,000.00.

      Invoice generated with VAT calculated and added to the document total,

      Rate of 10% (VAT base = 104,000.00 and VAT value = 10,400.00).

      Document Total: 116,400.00.

      Trade Note Total: 116,400.00.

      Sales Order - Ecuador

        By meeting Ecuadorian Laws, the System ensures that the invoicing of a sales order considers the calculations required by tax authorities.

        The System allows adding credit memos considering the VAT calculation.

        The calculation rules are:

          • Calculation Basis: Goods or Services Value - Discounts.
          • Rate: Rate indicated in the Products File or the Variable Taxes File.
          • VAT/IVC: Calculation Base x Rate.

        Note

        Freights, expenses, and insurance in the invoice are entered as items/services in a separate document.

        In this new document, VAT or IVC is regularly calculated according to the calculation rules.

        The tax value and the invoice total will present decimal values calculated by the System.

        Register the product in the Products File.

        1. If you want to calculate using the rate defined in the product, the VAT Perc. field in the Products File must be filled out with the corresponding rate.
        2. Register the customer in the Customers File.
        3. Enter a sales order with the registered product and customer using the default TIO created by the System (check VAT and IVC codes).
            • To calculate VAT or IVC as Exempt, you must set the VAT Calc. field in the TIO[****] File to 3.
            • To calculate VAT or IVC with a Zero (0) Rate, enter 4 in the VAT Calc. field in the TIO [****] File.
        4. Enter the quantity and the unit value, then generate the bill payable;
        5. Release and invoice the order.
        6. The VAT and IVC are calculated and added to the document total.
        1. The basis for calculating VAT withholding is the VAT amount, i.e., first, calculate the VAT and then withhold it.
        2. To determine whether the withholding must take place, you need to indicate the pre-registered TIO correctly (TIO File - VAT Withholding).
        3. Then, access the Customers File and enter 1 in the Agent field.

        The system allows you to generate the Sales Order by calculating ICE or ICC with a rate defined in the product.

        The outgoing documents are enabled for the calculation of the Special Consumption Tax (ICE), which is divided into:

        • Separated ICE (ICE)
        • Added ICE (ICC)

        On the sales of a single good from group I (for example: cigarettes), with a tax rate of 150%. The calculation for the ICC consists of using the following formula:

        Formula:

        Value of goods / 1 + (rate / 100)

        1,000 / (1 + (150 / 100)) --> 1,000 / 2.50

        The ICE value is always added to the bill's total in Financials, which follows the payment condition indicated in the TIO File to determine the due date and the number of installments of the bill.

        Observe how to obtain the rate for the invoices:

        When you add the invoice items, fill out field Concept (Outgoing Invoice Items).

        Using the field Country (Customers File), only generic concepts and those of the country defined in the record are filtered.

        To accomplish this, use index 1 of the CCR table, searching for the Concept + Country.

        By choosing a record from the CCR table, the registered rate is the rate used for tax withholding.

        If no rate is registered, use the rate defined in the table Variable Taxes (SFB).

        If the TIO has the Income Tax Calculation (RIR tax), you are required to fill out the Concept field.

        Note

        The field Income Tax Withh. Agent in the Customers File must be set to S.

        • Withholding Calculation Method - Income Tax
        • Income Tax Withholding Calculation Basis = Value of Goods or Services - Deductions
        • Rate = Percentage entered in CCR or SFB table.
        • Income Tax Withholding = Calculation Base * Rate

        Note

        Regarding freight, insurance, and incidental expenses, the withholding amount is calculated in isolation; that is, a rate exists for each item on the withholding table.

        By Ecuadorian rule, they are entered as items/services in the invoice.

        To divide the invoice in installments, withholding value can be deducted from the first installment or apportioned among them all.

        Set the Withheld Tax Apport. field to:

        • Option 1 - Deduction in the first installment;
        • Option 2 - Apportioned into all installments.


        Invoicing a sales order calculating the Income Tax withholding.

        1. Register any product (no details are provided for registering this product);
        2. Register a customer and, in the Withholding Agent field, enter S.
        3. Register a withholding concept in the Withholding Concepts Table (CCR) for the RIR tax, entering the percentage rate;
        4. Register a payment term;
        5. Register a nature with the Withheld Tax Apport. field enabled with option 1 or 2.
        6. Enter a sales order with the registered product and supplier using the default TIO created by the System.
        7. Enter the quantity and the unit value;
        8. Release the product and invoice it.

        Sales Order - Peru

          TIO 501 - To invoice a sales order calculating IGV with no ISC calculation 

          By meeting Peruvian Laws, the System ensures that the invoicing of a sales order considers the calculations required by tax authorities.

          1. Access the Products File and register the product to be invoiced.
          2. Access the Customers File and fill out customer data. At this stage, be mindful of the Customer Type
          3. Access the Sales Order Maintenance Press the [F12] key to access the routine parameters.
          4. The System displays the parameters screen. Fill them out according to field help instructions.
          5. When you finish filling them out, click Confirm.
          6. Click Add in the browser. In the addition screen, enter the sales order with items product and customer previously registered.
          7. Enter the TIO type, the quantity of the product to be invoiced, the product unit value, the freight (FOB), the insurance value, and the value of expenses.
          8. Confirm your addition and invoice the order.

          Example

          Example Result

          Enter the Standard TIO 501;

          Enter the quantity 1;

          Enter the unit value of BRL 200.00;

          Enter the freight (FOB) value of BRL 10.00;

          Enter the insurance value of BRL 5.00;

          Enter the expense value of BRL 20.00.

          Invoice generated with calculated IGV,

          Rate of 19% (calculation basis = 235.00 and tax = 44.65),

          Adding the tax to the document and trade note total (279.65).

          The IPM value must be generated in the respective saving fields (calculation basis = 235.00 and tax = 4.70).

          Important

          For the System to consider the value as exempt, even with IGV calculation and without ISC calculation, you must register a TIO based on TIO 501, but indicating option 2-Exonerated in the field Calculate IGV. In this case, enter only the unit value and the quantity.

          • The resulting invoice is generated without calculated IGV, storing the calculation basis of BRL 200.00 in field Exempt Values, without saving the IPM value.

          For the System to save the value as unaffected, even with IGV calculation and without ISC calculation, you must register a TIO based on TIO 501, but indicate option 3-Unaffected in the field Calculate IGV. In this case, enter only the unit value and the quantity.

          • The resulting invoice is generated without calculated IGV, storing the calculation basis of BRL 200.00 in field Exempt Values, without saving the IPM value.

          TIO 503 - To invoice a sales order calculating IGV, with ISC calculation 

          1. Access the Products File and register the product to be invoiced.
          2. Access the Customers File and fill out the customer data.
          3. In the Sales Order Maintenance routine, press the [F12] key to set the routine parameters.
          4. The System displays the parameters screen. Fill them out according to field help instructions.
          5. When you finish filling them out, click Confirm.
          6. Click Add in the browser. In the addition screen, enter the sales order with items product and customer previously registered.
          7. Enter the TIO type, the quantity of the product to be invoiced, the product unit value, the freight (FOB), the insurance value, and the value of expenses.
          8. Confirm your addition and invoice the order.

          Example

          Example Result

          Enter code TIO 503;

          Enter the Quantity 1;

          Enter the unit value of BRL 200.00;

          Enter the freight (FOB) value of BRL 10.00;

          Enter the insurance value of BRL 5.00;

          Enter the expense value of BRL 20.00.

          Invoice generated with ISC calculated (calculation base = 235.00 and tax = 11.75 -> calculated by the default rate registered at SFB),

          IGV calculated with a rate of 19% (calculation base = 246.75 and tax = 46.88),

          Adding the tax to the document and trade note total (293.63).

          The IPM is generated in the respective saving fields (calculation basis = 246.75 and tax = 4.94).

          TIO 001 - Incoming Invoice Entry with IGV calculation, no ISC calculation

          1. Access the Products File and register the product to be invoiced.
          2. Access the Customers File and fill out the customer data.
          3. Access the Sales Order Maintenance Press the [F12] key to execute routine parameters.
          4. The System displays the parameters screen.
          5. Fill them out according to field help instructions.
          6. When you finish filling them out, click Confirm.
          7. Click Add in the browser.
          8. In the addition screen, enter the sales order with items product and customer previously registered.
          9. Enter the TIO type, the quantity of the product to be invoiced, the product unit value, the freight (FOB), the insurance value, and the value of expenses.
          10. Confirm your addition and invoice the order.

          Example

          Example Result

          Enter code TIO 001;

          Enter the Quantity 1;

          Enter the unit value of BRL 200.00;

          Enter the freight (FOB) value of BRL 10.00;

          Enter the insurance value of BRL 5.00;

          Enter the expense value of BRL 20.00.

          Invoice generated with calculated IGV, 19% rate (calculation basis = 235.00 and tax = 44.65).

          Adding the tax to the document and trade note total (279.65).

          The IPM value is also generated in respective saving fields (calculation basis = 235.00 and tax = 4.70).

           TIO 003 - Incoming Invoice Entry calculating the IGV, with ISC calculation

          1. Access the Products File and register the product to be invoiced.
          2. Access the Customers File and fill out the customer data.
          3. Access the Sales Order Maintenance Press the [F12] key to execute routine parameters.
          4. The System displays the parameters screen.
          5. Fill them out according to field help instructions.
          6. When you finish filling them out, click Confirm.
          7. Click Add in the browser. In the addition screen, enter the sales order with items product and customer previously registered.
          8. Enter the TIO type, the quantity of the product to be invoiced, the product unit value, the freight (FOB), the insurance value, and the value of expenses.
          9. Confirm your addition and post an inbound document, linked to the registered order.

          Example

          Example Result

          Enter code TIO 003;

          Enter the Quantity 1;

          Enter the unit value of BRL 200.00;

          Enter the freight (FOB) value of BRL 10.00;

          Enter the insurance value of BRL 5.00;

          Enter the expense value of BRL 20.00.

          Invoice generated with ISC calculated (calculation base = 235.00 and tax = 11.75 -> calculated by the default rate registered at SFB),

          IGV calculated with a rate of 19% (calculation base = 246.75 and tax = 46.88),

          Adding the tax to the document and trade note total (293.63).

          The IPM value is also generated in respective saving fields (calculation basis = 246.75 and tax = 4.94).


          Sales Order Invoicing - Perception

          See below how the System enables the generation of an invoice from the Sales Order with the perception variation of the operations involved in the calculation of the General Sales Tax (IGV).

            TIO 508 - Sales Order calculating IGV and IGV perception with ISC calculation

            1. On the Sales Order parameters, enter that the company is not a withholding agent: MV_AGENTE = N.
            2. Enter, in an NCM (Table SYD), the percentage IGV perception calculation.

            Example: 1101.00.00.00 (wheat flour, 2%).

            1. Register a product with NCM that has a perception percentage.
            2. Register a customer that is a perception agent. Enter option 2 into the field Agent.
            3. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
            4. Confirm your addition and invoice the order.

            Example

            Example Result

            Enter the Default TIO 508.

            Enter the Quantity 1;

            Enter the unit value of BRL 1,000.00.

            Invoice generated with calculated ISC of 5% (calculation basis = 1,000.00 and tax = 50.00),

            perception calculated (calculation basis = 1,249.50 and tax = 24.99).

            Adding the taxes to the document and trade note total (1,274.49).

            TIO 507 - Sales order with configuration to calculate IGV perception on TIO and product, but do not calculate IGV perception because the customer is not a perception agent

            1. On the Sales Order parameters, enter that the company is not a withholding agent: MV_AGENTE = S.
            2. Enter, in an NCM (Table SYD), the percentage IGV perception calculation.

            Example: 1101.00.00.00 (wheat flour, 2%).

            1. Register a product with NCM that has a perception percentage.
            2. Register a customer that is a perception agent. Enter option 2 into the field Agent.
            3. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
            4. Confirm your addition and invoice the order.

            Example

            Example Result

            Enter the Default TIO 508.

            Enter the Quantity 1;

            Enter the unit value of BRL 1,000.00.

            Invoice generated with IGV calculated with a rate of 19% (calculation basis = 1,000.00 and tax = 190.00),

            Adding only this tax to the document and trade note total (1,190.00).

            TIO 507 - Sales order with configuration to calculate IGV perception on TIO and product, but do not calculate IGV perception because the company (SIGAMAT) is a withholding agent

            1. On the Sales Order parameters, enter that the company is not a withholding agent: MV_AGENTE = S.
            2. Enter, in an NCM (Table SYD), the percentage for IGV perception calculation.
              1. Example: 1101.00.00.00 (wheat flour, 2%).
            3. Register a product with NCM that has a perception percentage.
            4. Register a customer that is a perception agent. Enter option 2 into the field Agent.
            5. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
            6. Confirm your addition and invoice the order.

            Example

            Example Result

            Enter the Default TIO 507.

            Enter the Quantity 1;

            Enter the unit value of BRL 1,000.00.

            Invoice generated with IGV calculated with a rate of 19% (calculation basis = 1,000.00 and tax = 190.00),

            Adding only this tax to the document and trade note total (1,190.00).

            TIO 507 - Sales Order calculating IGV and IGV perception, with products that have distinct rates, no ISC calculation

            1. On the Sales Order parameters, enter that the company is not a withholding agent: MV_AGENTE = N.
            2. Enter, in an NCM (Table SYD), the percentage for IGV perception calculation.
              1. Example: 1101.00.00.00 (wheat flour, 2%).
            3. Enter, in another NCM, the percentage for IGV perception calculation.
              1. Example: 2201.10.00.11 (mineral water, 1%).
            4. Register a product with NCM that has a perception percentage.
            5. Register more than one product that has NCM with a perception percentage different from the previous product.
            6. Register a customer that is a perception agent. Enter option 2 into the field Agent.
            7. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
            8. Confirm your addition and invoice the order.

            Example

            Example Result

            Enter the Default TIO 507.

            Enter the Quantity 1;

            Enter the unit value of BRL 1,000.00.

            Two invoices are generated, both with IGV calculated with a rate of 19% (calculation base = 1,000.00 and tax = 190.00),

            perception calculated (in one document, calculation basis = 1,190.00 and tax = 23.80, and

            in the other document, calculation basis = 1,190.00 and tax = 11.90),

            Adding the taxes to the document and trade note total (in one document, 1,213.18, and, in the other, 1,201.90).


            Sales Order Invoicing - Detraction

            See below how the System enables the invoice generation from the Sales Order with the variations of the detraction operation involved in the calculation of the General Sales Tax (IGV)

              TIO 511 - Sales Order calculating IGV and IGV detraction with no ISC calculation

              See below how the System enables invoice generation from the Sales Order with the variations of the detraction operation involved in the calculation of the General Sales Tax (IGV).

              1. On the Sales Order parameters, enter that the company is not a withholding agent: MV_AGENTE = N.
              2. Enter, in an NCM (Table SYD), the percentage for calculating IGV detraction.
                1. Example: 1101.00.00.00 (wheat flour, 10%).
              3. Register a product with NCM that has a detraction percentage.
              4. Register a customer that is a detraction agent. Enter option 3 into the field Agent.
              5. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
              6. Confirm your addition and invoice the order.

              Example

              Example Result

              Enter the Default TIO 511.

              Enter the Quantity 1;

              Enter the unit value of BRL 1,000.00.

              Invoice generated with IGV calculated with a rate of 19% (calculation basis = 1,000.00 and tax = 190.00),

              Detraction calculated (calculation basis = 1,190.00 and tax = 119.00),

              adding the taxes (minus detraction) to the document and trade note total (1,190.00).

              TIO 512 - Sales Order calculating IGV and IGV detraction with ISC calculation 

              1. On the Sales Order parameters, enter that the company is not a withholding agent: MV_AGENTE = N.
              2. Enter, in an NCM (Table SYD), the percentage for calculating IGV detraction.
                1. Example: 1101.00.00.00 (wheat flour, 10%).
              3. Register a product with NCM that has a detraction percentage.
              4. Register a customer that is a detraction agent. Enter option 3 into the field Agent.
              5. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
              6. Confirm your addition and invoice the order.

              Example

              Example Result

              Enter the Default TIO 512.

              Enter the Quantity: 1.

              Enter the unit value of BRL 1,000.00.

              Invoice generated with calculated ISC 5% (calculation basis = 1,000.00 and tax = 50.00),

              IGV calculated with a rate of 19% (calculation base = 1,050.00 and tax = 199.50),

              Detraction calculated (calculation basis = 1,199.50 and tax = 119.95),

              Adding the taxes to the document and trade note total (1,249.50).

              TIO 511 - sales order with configuration to calculate IGV detraction on TIO and product, but do not calculate IGV detraction because the customer is not a detraction agent

              1. On the Sales Order parameters, enter that the company is not a withholding agent: MV_AGENTE = N.
              2. Enter, in an NCM (Table SYD), the percentage for calculating IGV detraction.
                1. Example: 1101.00.00.00 (wheat flour, 10%).
              3. Register a product with NCM that has a detraction percentage.
              4. Register a customer that is a detraction agent. Enter option 3 into the field Agent.
              5. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
              6. Confirm your addition and invoice the order.

              Example

              Example Result

              Enter the Default TIO 511.

              Enter the Quantity 1.

              Enter the unit value of BRL 1,000.00.

              Invoice generated with IGV calculated with a rate of 19% (calculation basis = 1,000.00 and tax = 190.00),

              Adding only this tax to the document and trade note total (1,190.00).

              TIO 511 - sales order with configuration to calculate IGV detraction on TIO and product, but do not calculate IGV detraction because the company (SIGAMAT) is a withholding agent

              1. On the Sales Order parameters, enter that the company is a withholding agent: MV_AGENTE = S.
              2. Enter, in an NCM (Table SYD), the percentage for calculating IGV detraction.
                1. Example: 1101.00.00.00 (wheat flour, 10%).
              3. Register a product with NCM that has a detraction percentage.
              4. Register a customer that is a detraction agent. Enter option 3 into the field Agent.
              5. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
              6. Confirm your addition and invoice the order.

              Example

              Example Result

              Enter the Default TIO 511.

              Enter the Quantity 1.

              Enter the unit value of BRL 1,000.00.

              Invoice generated with IGV calculated with a rate of 19% (calculation basis = 1,000.00 and tax = 190.00), adding only this tax to the total of the document and trade note (1,190.00).

              TIO 511 - Sales Order calculating IGV and IGV detraction, with products that have distinct rates, no ISC calculation.

              1. On the Sales Order parameters, enter that the company is a withholding agent: MV_AGENTE = N.
              2. Enter, in an NCM (Table SYD), the percentage for calculating IGV detraction.
                1. Example: 1101.00.00.00 (wheat flour, 10%).
              3. Enter, in another NCM (Table SYD), the percentage for IGV detraction calculation.
                1. Example: 2201.10.00.11 (mineral water, 1%).
              4. Register a product with NCM that has a detraction percentage.
              5. Register more than one product that has an NCM with a detraction percentage different from the previous product.
              6. Register a customer that is a detraction agent. Enter option 3 into the field Agent.
              7. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
              8. Confirm your addition and invoice the order.

              Example

              Example Result

              Enter the Default TIO 511.

              Enter the amount for each product. 1.

              Enter the unit value of BRL 1,000.00.

              Two invoices are generated, both with IGV calculated with a rate of 19% (calculation base = 1,000.00 and tax = 190.00),

              Calculated deduction (in one document, calculation basis = 1.190,00 and tax = 119,00, and in the other document, calculation basis = 1.190,00 and tax = 11,90),

              Adding the taxes (minus detraction) to the total of the document and duplicate (on one document, 1,190.00, and on the other 1,201.90).

              TIO 511 - Sales Order calculating IGV and IGV detraction with no ISC calculation lower than 700 soles.

              1. On the Sales Order parameters, enter that the company is a withholding agent: MV_AGENTE = N.
              2. Enter, in an NCM (Table SYD), the percentage for calculating IGV detraction.
                1. Example: 1101.00.00.00 (wheat flour, 10%).
              3. Register a product with NCM that has a detraction percentage.
              4. Register a customer that is a detraction agent. Enter option 3 into the field Agent.
              5. Enter a sales order with the registered product and customer using the default TIO created by the System, then enter the quantity and unit value.
              6. Confirm your addition and invoice the order.

              Example

              Example Result

              Enter the Default TIO 511.

              Enter the Quantity 1;

              Enter the unit value of BRL 500.00.

              Invoice generated with calculated IGV, 19% rate (calculation basis = 500.00 and tax = 95.00), not calculating detraction by the fact that the invoice is not greater than 700.00 soles, adding the IGV to the document and trade note total (595.00), taxes (minus detraction) to the document and trade note total (in one document, 1,190.00, and, in the other, 1,201.90).

              Sales Order - Venezuela

                To meet Venezuelan Legislation, the System calculates the Tax on Aggregate Value (VAT) by binding the data pre-registered in Variable Taxes, in Types of Inflow and Outflow, and TIO x Taxes Binding following the tax calculation rules.

                The System considers VAT withholding. Learn the calculation method in the help Billing - VAT Withholding.

                Types of Rate

                Legal conditions and rates for this calculation are:

                • General (12%) fill out the Rate Type field with option G-General;
                • Additional (22%) fill out fields Additional Rate % (Variable Tax File) and Rate Type (TIO File) with option A-Additional;
                • Reduced (8%) fill out fields Reduced Rate % (Variable Tax File) and Rate Type (TIO File) with option R-Reduced;

                Export (0%);

                Exempt. 

                Value-Added Tax may also be classified as Separate VAT (VAT) and Added VAT (IVC).



                The calculation rules are:

                Calculation Basis: Goods or Services Value - Discounts.

                Rate: Rate indicated in the Products File or Variable Taxes.

                VAT/IVC: Calculation Base x Rate.

                Separate VAT (VAT) - In this case, use the formula:  Value of Goods/1+(rate/100).            

                Added VAT (IVC) - In this case, for the goods amounting to 1000 (calculation basis), the established tax value is 120 (12% rate).

                Important

                Freights, expenses, and insurance in the invoice are entered as items/services in a separate document. In this new document VAT or IVC are regularly calculated, according to calculation rules.

                The tax value and the invoice total will present the decimal values calculated by the System.

                Related Content