Datasul Line

Árvore de páginas

Program Overview

The purpose of this function is to make the required calculation for issuing an invoice from a sales order or information entered manually. It also allows maintenance of the invoice's general data at the calculation time.

Note


The numeric control of the pre-printed form allows the user to verify before the document is generated in the system if the invoice number to be printed corresponds to the number of the pre-printed form.
The user will have the possibility to continue with the printing process or cancel it. By interrupting it, the user can access the Fiscal Series Maintenance (FT0114) and correct the number of the last invoice printed; or cancel the use of the number in the Fiscal Number Reservation Maintenance (FT0316). In this way, you can then generate the invoice issue with a number consistent with the pre-printed form.

Important


• The numerical control will be made only for invoices whose Type of Operation has automatic printing.
• Numeric control will not be performed in the invoice generation processes via batch.

Important


This program does not update documents whose items have stock removal directed to the WMS warehouse.

Important


This program allows you to generate invoices of the Prepayment type for XML sending, complying with the CFDI 3.3 legislation of Mexico.

Manual invoices screen – Items folder

Purpose of the Screen:

Allow you to perform calculations for issuing an invoice.


Other Actions/Related Actions:
 

Action:

Description:

Add

When pressed, the Main Information screen (ft4060A) is displayed, in which you can define the main information for issuing the invoice. 

Modify current occurrence

When pressed, the Main Information screen (ft4060A) is displayed, in which you can change the main information for issuing the invoice.

Invoice Calculation

When activated, invoice generation is confirmed based on the data added. 

Simulation of invoice calculation

When activated, a report is generated simulating the generation of the invoice, but only provisionally, anticipating how the invoice would be generated. 

Advance


When activated, a screen is presented with a browse informing the open Prepayments for the issuer that is generating the invoice.

CFDI Replacement


When activated, the CFDI Replacement - MEX0048  screen is displayed, so you can enter the canceled receipt.

Add

When activated, the Maintenance of Manual Invoice Items (FT4061) screen appears, in which you can define the invoice items. 

Edit

When activated, the Maintenance of Manual Invoice Items (FT4061) screen appears, in which you can edit the selected item. 

Delete

When activated, it allows you to delete the selected item. 

At Seq

When activated, the selected sequence is met in its totality for calculating the document. 

At Ord

When activated, all order sequences will be met in their totality for calculating the document.


Main Fields and Parameters:

Field:

Description:

Sequence

Displays the invoice calculation sequence. 

Invoice Type

Displays the type of document to be calculated. 

Site

Displays the site responsible for the invoice to be calculated. 

Cust/Vendor

Displays the short name of the invoice's supplier or customer. 

Operation Nature

Displays the operation nature of the invoice to be calculated. 

Issue Dt

Displays the date when the invoice calculation was issued. 

Invoice No.

Displays the invoice number. 

Customer Order

Displays the sales order number. 

Series

Displays the series of the invoice to be calculated. 

Seq

Displays the item deployment sequence code for issuing the invoice. 

Item

Displays the code of the item that belongs to the invoice to be issued. 

Refer

Displays the reference code of the item to be considered in the invoice to be issued. 

Oper nat

Displays the nature code of the item operation for the invoice to be issued. 

Qty

Displays the number of the selected item requested by the customer for the referred invoice. 

Un

Indicates the measurement unit of the item selected. 

Net Pri

Displays the net price of the invoice item. 

Net goods val

Displays the total open net value of the item for the selected invoice.

Prepayment


Indicate if the document to be updated is of the Prepayment type.
This field will be selected if the operation nature is of the prepayment type.


Main Information Screen - FT4060A

Purpose of the Screen:

Allow you to register the main information.


Main Fields and Parameters:

Field:

Description:

Invoice Type

It displays the type of invoice that is being calculated.

Site

Displays the default site code set in the Order Parameters (PD0301), but allows you to change it. 

Series

Select the invoice series code to be billed.

Note

The series must be related to the site.
Using the series, the system identifies the kind of document to be generated on Accounts Receivable, tracks the next billing, if the issued invoice is Nf-e or not, the number of days outstanding considering the date of the next billing, and the invoice number to be generated. 

Issue Dt

Displays the invoice issue date. The date of the last billing of the series is suggested it there is a tracking of the next billing. If the series used has control for the next billing, this date must agree with the date of the next billing in the Series x Site relationship (FT0114) registration. 
If the series used has control for the next billing, this date must agree with the date of the next billing in the program[ FT0110-Series x Company Maintenance

Cust/Vendor

Choose the code of the Customer or Supplier for which you want to calculate the invoice.

Note

A supplier can only be entered when the invoice to be calculated is of one of the business transaction types:
•  NFD (Return Invoice)
•  Transfer between sites
•  Operation with third parties, except Consignment Invoicing. 

Operation Nature

Select the operation nature to which the invoice generation refers. 

Sales Channel

Select the sales channel that will service the invoice generation. 

Customer Order

Select the number of the customer order.

Note

If the sales order is entered, the system tracks the order portfolio.

Invoice No.

Displays the number of the invoice to be generated according to this invoice's series. The format of this field is displayed according to the program FT0301A - Billing Parameters Update.

Invoice Branch


Enter the number of the branch of the invoice. This value is presented automatically according to the value defined for the series entered.

Point of Sale


Enter the number of the invoice's point of sale. This value is presented automatically according to the value defined for the series entered.


Manual Invoice Information Screen - Main Folders

Purpose of the Screen:

Allow you to register the main information of the manual invoices.


Main Fields and Parameters:

Field:

Description

Operation Nature

Select the operation nature code for the sales order or customer registration. 

Sales Channel

Select the sales channel code of the sales order or the customer. 

Representative

Select the code of the main representative. 

Paym Term

Enter the code of the payment term of the customer or sales order. 

Price Tab

Display the standard price list predefined by the sequence of the following registrations:
1 - Customer Channel Maintenance (CD1521),
2 - Customer Update (CD1510)
3 - Order Parameters Update (PD0301)

Important

If there are no price lists determined in the above registrations, this "Price Tab" field does not show any information and remains blank. 

Currency

Select the currency in which the manual invoice values will be reported. 

Invoicing Currency

Enter the currency code used for billing the manual invoice.

Note

In cases where the values on the manual invoice were reported in another currency, when billing the invoice, the values will be converted to the invoicing currency.

Tab Fin

Select the financing/interest table to be applied to the invoice calculation. With this information, the system adds the selected financing rate and generates the original price right when the sales order sequence is implemented in the invoice calculation. Initially, the system displays the payment term financing table entered.

Important

When the price type is the Informed Price, the rate for obtaining the original price is not applied and must be entered manually.
When the payment term is a special term "0", this field shows the default financing table, which is defined in Order Parameters Maintenance (PD0301).

Use discount table

When selected, this indicates that the discount table will be used for the document.

CFDI Use


Enter the CFDI (Digital Tax Receipt via the Internet) use code according to the registration made in the CFDI Use Type Maintenance program (MX0101).

Note

Filling out this field is necessary so that the code is informed in the XML file of the Electronic Invoice.

Transfer type


Select the transfer type of the waybill. The options are:

  1. Operation constitutes sale;
  2. Sale to be effected;
  3. Consignment;
  4. Free delivery;
  5. Internal transfers;
  6. Other transfers without sale;
  7. Return bill;
  8. Transport for export;

  9. Sale for export.

    Information

    This field will be displayed only if the series used is of the Waybill type.

MiPyme Trans Tp


Enter the option that identifies the MiPyme transaction type to be performed. The options are:

  • Open Circulation System (SCA)

  • Collective Deposit Agent (ADC).

    Note

    The field will be enabled if the series used is from MiPyME.
    When a document is added, the value parameterized in the program Dados_Complementares_Cliente_Fornecedor_-_ARG0009 is displayed.

Finan Index No

Select the sequence of the financing/interest rate from the financing table. This number determines which index or interest percentage should be applied for the price correction of the invoice items. Initially, this field presents the sequence of the financing rate according to the average term of the payment term entered for the order.

Important

If the company does not use price correction in credit sales, enter 0 (zero) in this field. That way, the program will not fix the prices of the products.
When the payment term is a special "0" term, this field displays the default index, which is defined in the Order Parameters Maintenance (PD0301).

Dup Base Dt

Insert the current date as a base for the calculation of trade note due dates.

Due First Dt

Enter the trade note first due date.

% Disc Tab

Enter the discount percentage according to the price list.

Disc % 1

Enter the additional discount percentage to be applied to the document.

Note

If the order informs that there is a discount for the customer, it will be entered in this field.
When you enter an order and the order has a customer discount (Customer Disc field - Order Deployment function, Main option), it will be shown in this field.

Disc % 2

Enter the discount percentage to be applied on the value obtained after the discount percentage 1.

Ord Tot Disc

Enter the total discount granted directly in orders.

Total Net Weight

Enter the total net weight of the item in the document.

Note

This field is only enabled when the Inform Net Weight field is checked in the Information folder of the Billing Parameters Maintenance function (FT0301).

Total Gross Weight

Enter the total gross weight of the item in the document.

Note

This field is only enabled when the Inform Gross Weight field in the Information folder of the Billing Parameters Maintenance function (FT0301) is checked.

Manual Invoice Information Screen - General Folders


Purpose of the Screen:

Allow you to record general information.


Main Fields and Parameters:

Field:

Description:

Route

Select the code of the route entered in the sales order. 

Bearer/modality

Select the bearer code and the modality entered in the sales order. 

Clear. Transf/Third-p.

Select the code of the clearing account that receives the postings from the movement of materials for consignment or processing, or for inter-site transfers.

Note

When the invoices handled are vendor returns, this field will be enabled, and the Returns Clearing Account will be provided as default by the system.

Fut Ent Inv Series

Enter the series code of the future delivery billing invoice.

Fut Del Inv No.

Select the number of the future delivery billing invoice.

Release Invoice

When checked, indicates that the invoice can be updated in stock even if its items have no balance in stock.

Note

This field will be enabled according to the business user parameters defined in the User Permission Maintenance function (CD0821), Complem. folder.

Payment made by third parties


When selected, it indicates that the invoice will be paid by third parties.

Note

If this parameter is selected, the operation nature cannot issue a trade note.

Invoice Type

Allows you to select one of the options that identify the document type. Options available:

  • FTD - Return Invoice.
  • FTS - Outgoing Invoice;
  • FTT - Transfer Invoice;

Goods Target

Select the destination of the goods. Options available:

  • Trade/Industry
  • Own consumption/active
    This information affects the calculation of the document fees.

Export information

Enter information referring to export.
Export Rate - Enter a rate different from the one registered in the Currency quotations routine (CD0103).
Export Process Number - Enter the number of the export process for the invoice in question.

In the invoice calculation, the relation of the invoice to the export process will be generated, and the export rate that was informed on the screen will also be considered.


Manual Invoice Information Screen - Transport Folders

Purpose of the Screen:

Allow you to register the information referring to the transport.


Main Fields and Parameters:

Field:

Description

Freight Perc.

Display the goods' freight percentage. This percentage (corresponding value) will be considered as a document's constant expense.

Note

This field is not enabled, and this type of expense must be entered through the Expenses button of the Shipment/Packing List calculation function (FT4040).

Insurance Perc.

Displays the goods' insurance percentage. This percentage (corresponding value) will be considered as a document's constant expense.

Note

This field is not enabled, and this type of expense must be entered through the Expenses button of the Shipment/Packing List calculation function (FT4040).

Package Perc.

Displays the percentage corresponding to the packaging of the goods. This percentage (corresponding value) will be considered as a document's constant expense.

Note

This field is not enabled, and this type of expense must be entered through the Expenses button of the Shipment/Packing List calculation function (FT4040).

Carrier

Select the carrier code.

Note

This code is suggested from the carrier entered in the Customer Channel Maintenance function (CD1521). If it is blank in this function, the carrier code entered in the Sales Order Deployment function (PD4000) or the Customer Maintenance function (CD0704) is suggested.

Redesp. Carrier

Select the code of the redispatch carrier.

Important

This field is replaced by the button  Redispatchers when the Datasul EMS 2 is integrated to Datasul TMS and, in the  Setup-Shipper function, the option "More than one Redispatch in the Invoice" option is selected. When activated, it executes the Redispatchers function, which presents the invoice data (Invoice Site, Series and Sequence), the carrier, and the Sender cities (Site City) and Recipient - delivery (Customer City) entered in the invoice. In this functionality, the XC0406 program is displayed, where you can enter up to five redispatchers during the invoice issue process.

Plate

Enter the license plate number of the truck that will transport the goods.

Note

This information is used to generate information for the CAT/95 of the State of São Paulo.

Volume Brand

Enter the brand of the volumes corresponding to the goods transported.

Note

This field is only enabled when the Enter Volume Brand field in the Information folder of the Billing Parameters Maintenance function (FT0301) is checked.

Freight Value

Display the freight value for the goods. This value will be considered as a document's constant expense.

Note

This field is not enabled, and this type of expense must be entered through the Expenses button of the Shipment/Packing List calculation function (FT4040).

Insurance Value

Displays the insurance value for the goods. This value will be considered as a document's constant expense.

Note

This field is not enabled, and this type of expense must be entered through the Expenses button of the Shipment/Packing List calculation function (FT4040).

Package Value

Display the package value for the goods. This value will be considered as a document's constant expense.

Note

This field is not enabled, and this type of expense must be entered through the Expenses button of the Shipment/Packing List calculation function (FT4040).

State

Select the State corresponding to the carrier's address.

Volume No.

Enter the number of volumes to be transported.

Note

This field is enabled only when the Enter Volume No. field in the Information folder of the Billing Parameters Maintenance function (FT0301) is checked.

Service Cd

Enter the service code.

Note

This information only applies to Brazil.

Redispatching Conditions

In this field, you can enter, if necessary, conditions or comments regarding the redispatching of the transported goods.


Manual Invoice Information Screen - Address Folders

Purpose of the Screen:

Allow you to record information referring to the address.


Main Fields and Parameters:

Field:

Description:

Shipping

Select the code corresponding to the customer's shipping address. 

Complete Address

Enter the complement to the customer's shipping address to make it easier to locate. 

Address

Enter the shipping address corresponding to the customer entered. 

District

Enter the district of the customer's shipping location. 

Postal Code

Enter the postal code of the customer's shipping address. 

City

Select the city. 

State

Select the State corresponding to the customer's shipping address. 

Country

Select the country of the customer's shipping address. 

CIF City

Enter the CIF City of the customer's shipping address. 

Postal Code

Enter the postal code of the CIF city of the customer's shipping address. 

C.U.I.T.


Enter the Unique Tax Identification Key number.

CGCMF

Enter the customer's federal registration number. 

State Registration

Enter the customer's state registration number.


Manual Invoice Information Screen - Notes Folder

Purpose of the Screen:

Allow you to register notes related to the invoice information.


Other Actions/Related Actions:
 

Action:

Description:

Modify

When activated, the Invoice Calculation - Messages screen (FT4014) is displayed, where you can add or edit invoice messages.

Note

The message defined for the nature of operation used in the invoice calculation is used as the default for generating a message. However, other messages can be used.
The invoice issuance program prints, in the invoice body notes, the invoice notes plus the notes entered. Thus, it is no longer necessary to print the message entered in the invoice or in the operation nature.


Main Fields and Parameters:

Field:

Description:

Note entered

Enter, if necessary, the comments or messages related to the operation performed. 

Additional note

Informs the message registered for the type of transaction used in the document referred.


Manual Invoices – Repres Folder

Purpose of the Screen:

Allow you to register information referring to the representatives.

Note

The Add, Edit, and Delete buttons will be enabled only when the invoice refers to the sale of products and the item values are already entered.


Other Actions/Related Actions:

Action:

Description:

Add

When activated, the Invoice Calculation - Representatives screen (FT4008) is presented, in which it is possible to include the representatives who will receive a commission on the sale. 

Edit

When activated, the Invoice Calculation - Representatives screen (FT4008) is presented, where it is possible to make changes to the selected representative. 

Delete

When activated, it allows you to delete the invoice link to the selected representative.


Main Fields and Parameters:

Field:

Description:

Rprs

Displays the code of the representative who will receive a commission on the invoice sales. 

Short Name

Displays the short name of the representative who will receive a commission on the invoice sales. 

% Comm

Displays the total percentage of commission for this representative, for the invoice to be issued. 

Iss %

Displays the percentage of commission that will be paid to the representative when the order is issued.


Manual Invoices Screen – Trade Note Folder

Purpose of the Screen:

Allow you to register information referring to the trade notes.

Note

The Add, Edit, Delete, and Recalculate Invoice Total buttons will be enabled only when the invoice (Operation Nature) includes the generation of trade notes.


Other Actions/Related Actions: 

Action:

Description:

Add

When activated, the NF Calculation - Trade Notes screen (FT4006) is presented, in which it is possible to include the trade note installments referring to the invoice. 

Edit

When activated, the NF Calculation - Trade Notes screen (FT4006) is presented, on which it is possible to make changes to the selected trade note installment. 

Delete

When activated, allows you to delete the selected installment. 

Recalculate Invoice Total

When activated, the invoice total values will be automatically recalculated.


Main Fields and Parameters:

Field:

Description:

In

Displays the number of the trade note invoice installment. 

DDC

Displays the invoice's due date code. 

Due Date

Displays the invoice due date. 

Disc Dt

Displays the deadline for offering a discount on the trade note. 

Disc Vl

Displays the discount value for payments performed in advance.

Net Vl

Displays the net value of each trade note installment.

Commission

Displays the base calculation value of the representative commission.


Manual Invoice Screen – Packages Folder

Purpose of the Screen:

Allow you to register information referring to packages.

Note

This folder is enabled when the invoice data are confirmed. To access the information in this folder, simply enter the invoice item, or click on it when the item has already been assumed in the sales order.


Other Actions/Related Actions: 

Action:

Description:

Maintenance

When you press this button, you will be presented with the Invoice Calculation - Packages screen (FT4013), where you can manually add, edit, and/or delete packages related to the invoice items. See more information in the description of the Invoice Calculation – Packages screen. 

Automatic Generation

When this button is pressed, it will allow the automatic generation of packaging for the invoice items, as long as they have the item x packaging relationship in the Item/Packaging Maintenance function (FT0305).


Main Fields and Parameters:

Field:

Description:

Acronym

Displays the acronym of the package selected for the invoice. 

Desc

Displays the invoice package description. 

Vol.Qty.

Displays the number of volumes that the package will contain. 

Volume Description

Displays the description of the volumes in the package.


Manual Invoices Screen - Expenses Folder

Purpose of the Screen:

Allow you to register information referring to expenses.


Other Actions/Related Actions: 

Action:

Description:

Add

When pressed, the FT4025 screen is presented, where you can add new expenses for the invoice.

Edit

When pressed, the FT4025 screen appears, where you can maintain the selected expense.

Delete

When pressed, you can delete the selected expense.

Automatic Gen

When pressed it determines that the expenses should be generated automatically, considering the definitions of the Expense x Customer Relationship (CD1071).


Main Fields and Parameters:

Field:

Description:

Exp

Displays the code of the expense related to the invoice.

Description

Displays the description of the expense related to the invoice.

Exp %

Displays the percentage of the expense in relation to the note if it was registered as a percentage.

Exp Vl

Displays the expense value in relation to the note when it was registered as a value.


Related Content:
Item Maintenance (CD0204)
Site maintenance (CD0403)
Operation Nature Maintenance (CD0606)
Customer Maintenance (CD0704)
Representatives Maintenance (CD0708)
Sales Channel Maintenance (CD1517)
Sales Order Implementation (PD4000)