Program Overview
Allowing the search of documents and their items, as well as analyzing the accounting and identifying the debit and credit transactions linked to the sales invoice, the invoice taxes and information related to the write-off of the inventory.
Invoices Search
Screen purpose: | Allowing the search of documents and their items, as well as analysing the accounting and identifying the debit and credit transactions linked to the sales invoice, the invoice taxes and information related to the write-off of the inventory. |
Other Actions/Related Features:
Feature: | Description: |
Go to | When activated, the screen Go to Invoice, through which you can enter data corresponding to the invoice site, series and number to be searched. |
Taxes Configurator | When activated, the Invoice Taxes Search (CD0760) screen is displayed. |
CFDI Replacement |
|
GFE Invoice Detail | When activated, the CDF010 is displayed. On this screen, you can search data related to the freight services provided, and the information is from the GFE. The screen is divided into two folders:
|
Simulating Freight Calculation | When activated, the Simulating Freight Calculation (CDF003C) screen is displayed. On this screen, you can search the freight simulations. Important: This button is only displayed in case the system is integrated to the TMS product and the option Simulate Freight is parameterized in the setup-shipper. |
Additional Information of Invoice | When activated, the Additional Information of Invoice (CD4035) screen is displayed, it allows the information searched, which is necessary for the completion of the Fiscal SPED file. See further details at Additional Information of Invoice (CD4035). |
Business Unit Data Search | When activated, the Invoice Business Unit Search (FT0908) screen is displayed. |
Related Search | When activated, the Invoice Relationship Search (FT0904B) screen is displayed. |
Main Fields and Parameters:
Field: | Description: |
Site | Site code responsible for the invoice. |
Series | Code corresponding to the invoice series entered. |
Invoice Number | Número da nota fiscal consultada. Important: This number is defined when the invoice is calculated through the Invoice Calculation (FT4003) program. |
IECFOAT | Code corresponding to the status of the customer invoice updating. Important: Each letter identifies a module of state of updating, where S (Yes) means the invoice is updated , N (No) means the invoice is not updated. The updating of possible options:
|
Issue Date | Invoice issue date entered. |
Customer / Supplier | Customer / Supplier description code of the invoice entered. |
Invoice Number | Invoice number corresponding to the invoice entered. |
Customer Order | Customer order number corresponding to the invoice entered. Note: This number was defined through the Calculation of Invoices (FT4003) program. |
Payment Term | Payment term code defined for the invoice entered. Note: Esse código foi definido por intermédio do programa Cálculo de Notas Fiscais (FT4003). |
Operation Nature | Code of invoice operation nature. Note: This code was defined through the Calculation of Invoices (FT4003) program. |
Average Expiration Date | Average expiration date to pay the invoice. |
Cancellation Date | If the invoice is canceled, the invoice cancellation date. |
Goods Outgoing Date | Goods outgoing date in the invoice entered. |
Representative | Representative code responsible by the invoice. Note: This code was defined through the Calculation of Invoices (FT4003) program. |
Actual Delivery Date | Actual date of delivery of the invoice goods. |
Generate Invoice/Trade Note | Upon entering Yes, it indicates the invoice was billed. So, trade notes were issued to the invoice. In the trade note base, the date entered as the base during implementation of invoice is displayed. Important: In case there no base date of the trade note, or the invoice does not generate invoicing, the system assumes the invoice issue date. |
AP Updating | Date of the AP updating indicator to the supplier return invoices. Important: This indicator is created with the AP updating date only for the return invoices to the supplier during the updating of the Invoice in the inventory, as long as the integration with the AP has been successfull.. |
Electronic Invoice Status |
Electronic Invoice Status. The possible status is: 1 – Invoice not generated. |
Perception Activity Code | "System of Activity Registered" code used in the invoice calculation. |
Prices List | Prices table code used in the calculation of the invoice selected. |
Financial Table | Code corresponding to the financial index used for the calculation of the invoice values. |
Financial Index | Sequence of the Financial Index in the table, used in the invoice. |
Interests | When selected, it indicates the Financial Index field displays an interest rate. When not selected, it indicates the Financial Index field displays the Financial index. |
Customer Discount | Discount values for the invoice entered. |
Invoice Value | Total value of the invoice entered. |
Sales Channel | Código do canal de venda determinado para a nota fiscal. Note: This code was defined through the Calculation of Invoices (FT4003) program. |
Document Type | Code corresponding to the invoice type entered. The possible options:
|
Price Type | Origin of the items price in the invoice entered. |
Billing Type | Billing type of the invoice entered. |
Currency | Code of invoice issue currency. |
Type of invoice | Type corresponding to the invoice. The possible options:
Type corresponding to the invoice. The possible options:
|
Anticipation. |
Indicate the invoice is anticipated. |
Invoice Search - Inform 2 Folder
Screen purpose: | Enables you to view the information registered. |
Main Fields and Parameters:
Field: | Description: |
Total Gross Weight | Total gross weight of the items that make the invoice, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Main Folders screen. |
Total Net Weight | Total net weight of the items that make the invoice, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Main Folders screen. |
Package Value | Value of the package for goods that make the invoice, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Transport Folder screen. |
Insurance Value | Value of the insurance for goods that make the invoice, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Transport Folder screen. |
Freight Value | Value of the freight for goods that make the invoice, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Transport Folder screen. |
Goods Value | Total value of the invoice goods. |
Export Rate | Value of the export rate for the respective invoice, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - General Folders screen. |
Exp Process Number | Number of the export process of items of the invoice, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - General Folders screen. |
Bearer | Code of the bearer and modality entered in the sales order, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Main Folder screen. |
Consumer Name | Consumer name of the invoice items. |
Type of Electronic Invoice Issue |
Type of the electronic invoice issue. The possible issue types:
|
Contingency user. |
Code of the user responsible for the issue of the electronic invoice in contingency. |
Electronic Invoice Access Key |
Code of the electronic invoice access key. Note: The key user is composed of: FU Code + Issue AAMM + Issuer EIN + Electronic Invoice model, series and number + numeric code + verifying digit.
|
Calculation User | Code of the user responsible for the invoice calculation. |
Release Invoice | Identify if the invoice may be updated in the inventory, even if the items have balance. This option is defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - General Folders screen. |
Route | Invoice customer route defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Main Folders screen. |
Carrier | Short name of the carrier of the invoice goods, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Transport Folder screen. |
Plate | Plate number of the truck in charge of the transportation of the goods, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Transport Folder screen. |
Goods Destination | Destination of goods defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - General Folders screen. |
Redispatching Carrier | Short name of the redispatching carrier, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - General Data - Transport Folder screen. Important: This field is replaced by the button Redispatchers, when the Datasul EMS 2 is integrated to Datasul TMS and in the function Setup-Shipper , the option “More than one Redispatch in the Invoice” option. When activated, it executes the Redispatchers function, which presents the invoice data (Invoice Site, Series and Number), 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 view up to five redispatchers used in the invoice issue process. |
Message | Message printed in the invoice, defined in the function Calculation of Invoices (FT4003), Calculation of Invoices - Messages screen. |
Shipment | Shipment code and modality. |
Other Expenses | Value of the additional expenses of the invoice, defined in the function Implementation of Sales Orders (PD4000). |
Payment made by third parties |
It indicates if the invoice was paid by third parties. |
Invoice Search - Delivery Folder
Screen purpose: | It enables you to view information related to deliveries. |
Main Fields and Parameters:
Field: | Description: |
Address | Delivery address corresponding to the customer entered. |
District | District corresponding to the customer delivery location. |
City | Delivery location city. |
FU | Federation Unit corresponding to the customer delivery location. |
Country | Country corresponding to the customer delivery location. |
Postal Code | Postal Code corresponding to the customer delivery location. |
CGCMF | Customer federal registration number. |
State Registration | Customer state registration number. |
CIF City | CIF City of the customer delivery location. |
Freight Modality |
|
Ct-e Type | Type of Electronic Bill of Lading (CT-e) |
Invoice Search - Package Folder
Screen ´purpose: | It enables you to view information related to package. |
Main Fields and Parameters:
Field: | Description: |
Acronym | Acronym of the package selected for the invoice. |
Package | Description of the invoice package. |
Vol.Qty. | Quantity of volumes in the package. |
Volumes Description | Description of the volumes in the package. |
Invoice Search - Billing Accounting Folder
Screen purpose: | It enables you to view information related to billing accounting. |
Other Actions/Related Features:
Feature: | Description: |
IFRS Accounting | When activated, the IFRS Accounting (FT0904P) is displayed. |
Main Fields and Parameters:
Field: | Description: |
Account | Accounting codes of the accounts in which billing accounting entries were made. |
Account Description | Description of ledger account in which billing accounting entry was made. |
Credit | Values entered for credit in the respective ledger account. |
Debit | Values entered for debit in the respective ledger account. |
Business Unit | Business Unit of the account in which billing accounting entry was made. |
IFRS Accounting - FT0904P
Screen purpose: | It enables you to view information related to IFRS. |
Main Fields and Parameters:
Field: | Description: |
Account | Accounting codes of the accounts in which IFRS accounting entries were made. |
Account Description | Description of ledger account in which IFRS accounting entry was made. |
Credit | Values entered for credit in the respective ledger account. |
Debit | Values entered for debit in the respective ledger account. |
Business Unit | Business Unit of the ledger account in which IFRS accounting entry was made. |
Invoice Search - Notes Folder
Screen purpose: | It enables you to view information related to notes. |
Main Fields and Parameters:
Field: | Description: |
Notes | Notes printed in the invoice determined in the function Calculation of Invoices (FT4003), Notes folder, Notes Entered field. Note: It enables you to search the approximate total value of the taxes that influenced the sales price of the items. |
Tax Observation | Permite visualizar as mensagens, fiscais ou não, de forma separada, no campo "Observação Fiscal" na aba "Observ". Requisite: Check information of the Tax Message field of the Maintenance of Messages - CD0405. |
Redispatch Conditions | Redispatch conditions were determined for the respective invoice, determined in the Calculation of Invoices (FT4003) function, Transport folder. |
Cancellation Reason | Cancellation reason entered in the Calculation of Invoices (FT4003) function, Cancellation Reason field. |
Invoice Search - Inventory Accounting Folder
Screen purpose | It enables you to view information related to billing inventory accounting. |
Other Actions/Related Features:
Feature: | Description: |
Parameters | When this button is activated, the Accounting Grid Parameters (RE0701F) screen is displayed. See details in the description of the Accounting Grid Parameters screen. |
Main Fields and Parameters:
Field: | Description: |
Account | Accounting codes of the accounts in which the inventory accounting entries were made. |
Bill | Bill of the ledger account in which the inventory accounting entry was made. |
Item | Code of the item accounted in the inventory. |
Debit | Values entered for debit in the respective ledger account. |
Credit | Values entered for credit in the respective ledger account. |
Accounting Grid Parameters - RE0701F
Screen purpose: | It enables you to select the currency, the type of cost to search accounted values and the way the Inventory Accounting Grid is displayed, grouped by ledger accounts or detailed by item. |
Main Fields and Parameters:
Field: | Description: |
Currency | Code corresponding to the currency to be used in the search. Important: If the Inventory Control module uses alternative currencies 1 and 2, it can be searched by the standard currency and by two more currencies, thus being able to choose one of the three currencies available for consultation. |
Average | Type of average price to be used in the search. The options are:
|
Display Accounting Grid per Item? | It indicates the Inventory Accounting Grid is grouped per item. Important: By entering this parameter, you can view each item accounting transaction. If the user does not enter this parameter, the presentation of the Inventory Accounting Grid will be displayed in a summarized way, by accounting account. |
Example
Day | Type of Invoice | Quantity | Value | Online Unit Price |
01 | NFE | 10 | 10.00 | 1.0000 |
01 | NFE | 10 | 20.00 | 1.5000 |
01 | NFS | 02 | 3.00 | 1.5000 |
02 | NFE | 10 | 18.00 | 1.6071 |
02 | NFS | 03 | 4.82 | 1.6071 |
Invoice Search - Return Folder
Screen purpose: | It enables you to view information related to return. |
Main Fields and Parameters:
Field: | Description: |
Series | Invoice series registered as Return invoice for the invoice selected. |
Invoice | Invoice number registered as Return invoice for the invoice selected. |
Operation Nature | Operation nature registered as Return invoice for the invoice selected. |
Issue | Issue date of the Return invoice. |
Un | Unit of measurement of the item returned corresponding to the invoice selected. |
Item | Code of the item returned corresponding to the invoice selected. |
Qty | Quantity return of the item in the unit of measurement in question. |
Invoice Search - Closed Deposit Folder
Screen purpose: | It enables you to view the information related to Sales/Return of Closed Deposit operations; |
Main Fields and Parameters:
Field: | Description: |
Series | Sales/Return invoice series for the invoice selected. |
Invoice | Sales/Return invoice number for the invoice selected. |
Issue | Sales/Return invoice issue date. |
Cancellation Date | Sales/Return invoice cancellation date. |
Operation Nature | Sales/Return invoice operation nature. |
Issue Type | Sales/Return invoice issue type (automatic or manual). |
Type of invoice | Sales/Return invoice type (sales, symbolic return or physical return). |
Invoice Search - Debit/Credit Folder
Screen purpose: | It enables you to view information related to Credit and Debit. |
Related Content:
Updating of Billing Parameters (FT0301)
Maintenance of Global Parameters (CD0101)
Calculation of Invoices (FT4003)
Handling of PIS and COFINS Substitutes
Updating of Billing Parameters (FT0301a)
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas