Árvore de páginas

Versões comparadas

Chave

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

...

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 goalpurpose:

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.

...

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


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

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:

  • Freight: Records of freight values are displayed;
  • Occurrence: Details of transport occurrences are displayed.

Simulating Freight Calculation

Quando acionado, é apresentada a tela Simular Cálculo do Frete When activated, the Simulating Freight Calculation (CDF003C). Nesta tela é possível consultar as simulações de frete screen is displayed. On this screen, you can search the freight simulations.

Informações
titleImportante: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.Este botão somente é apresentado, caso o sistema possuir integração com o produto TMS e estiver parametrizado no setup-embarcador a opção Simular Frete. 

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. 

...

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.

Informações
titleImportante:Important:

This number is defined when the invoice is calculated through the Invoice Calculation (FT4003) programEsse número é definido quando da efetivação do cálculo da nota fiscal, por intermédio do programa Cálculo de Nota Fiscal (FT4003).

IECFOAT

Code corresponding to the status of the customer invoice updating.
Important:

Informações
titleImportante:

Cada letra identifica um módulo ou estado de atualização, onde S(Sim) significa que a nota se encontra atualizada N(Não) significa que a nota fiscal não está atualizada. As atualizações opções possíveis são:

  • I = Impressa.

  • E = Atualizada no módulo de Estoque.

  • C = Cancelada.

  • F = Atualizada no módulo de Contas a Receber.

  • O = Atualizada no módulo de Obrigações Fiscais.

  • A = Atualizada em Estatísticas.

  • T = Contabilizada.

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:

  • I = Printed.
  • E = Updated in the Inventory module.
  • C = Canceled.
  • F = Updated in the Accounts Receivable module.
  • O = Updated in the Tax Obligations module.
  • A = Updated in Statistics.
  • T = Accounted.

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. 

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:

  • I = Printed.
  • E = Updated in the Inventory module.
  • C = Canceled.
  • F = Updated in the Accounts Receivable module.
  • O = Updated in the Tax Obligations module.
  • A = Updated in Statistics.
  • T = Accounted.

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.

Nota
titleNote:

This number was defined through the Calculation of Invoices (FT4003) program. 

Payment Term

Payment term code defined for the invoice entered.

Nota
titleNote:

Esse código

Customer Order

Número do pedido do cliente correspondente à nota fiscal informada.

Nota
titleNota:

Esse número foi definido por intermédio do programa Cálculo de Notas Fiscais (FT4003). 

Payment Term

Operation Nature

Code of invoice operation nature

Código da condição de pagamento definida para a nota fiscal informada

.

Nota
titleNota:Note:

This code was defined through the Calculation of Invoices Esse código foi definido por intermédio do programa Cálculo de Notas Fiscais (FT4003) program

Operation Nature

Código da natureza de operação da nota fiscal.

Nota
titleNota:

Esse código foi definido por intermédio do programa Cálculo de Notas Fiscais (FT4003)

Average Expiration Date

Average expiration date to pay the invoice. 

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

Código do representante responsável pela nota fiscal informada

Representative code responsible by the invoice.

Nota
titleNota:Note:

This code was defined through the Calculation of Invoices Esse código foi definido por intermédio do programa Cálculo de Notas Fiscais (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

Quando informado Sim, indica que a nota fiscal teve faturamento. Sendo assim, foram emitidas duplicatas para a nota fiscal.

Na base da duplicata exibe a data que foi informada como base no momento da implantação da nota fiscal

.

Informações
titleImportanteImportant:

Caso não tenha sido informada uma data base de duplicata, ou a nota fiscal não gere faturamento, o sistema assume a data de emissão da nota fiscalIn 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

Data do indicador de atualização do AP para notas fiscais de devolução a fornecedor

Date of the AP updating indicator to the supplier return invoices.

Informações
titleImportante: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.Esse indicador é criado com a data de atualização do AP apenas para as notas de devolução ao fornecedor, no momento da atualização da nota fiscal no estoque, desde que a integração com o AP tenha ocorrido com sucesso

Electronic Invoice Status

Electronic Invoice Status. The possible status is:

1 – Invoice not generated.
2 – In processing.
3 – Authorized use.
4 – Denied use.
5 – Document rejected.
6 – Document canceled.
7 – Document void. 

Perception Activity Code

Image Removed
"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.

Nota
titleNota:Note:

This code was defined through the Calculation of Invoices (FT4003) programEsse código foi definido por intermédio do programa Cálculo de Notas Fiscais FT4003)

Document Type

Code corresponding to the invoice type entered. The possible options:

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

Código do canal de venda determinado para a nota fiscal.

Image Removed

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:

  • Manual Invoice
  • Additional Invoice of Goods.
  • Price Difference.
  • Additional Tax Invoice.
    Image Removed

Type corresponding to the invoice. The possible options:

  • System.
  • Manual.
  • Debit.
  • Credit.

Anticipation.

Indicate the invoice is anticipated.

Invoice Search - Inform 2 Folder

Screen purpose:

Enables you to view the information registered.

...

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:

  • Normal.
  • Offline contingency.
  • SCAN contingency.

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.

Nota
titleNotaNote:

O código da chave é composto por: Código da UF + AAMM da emissão + CNPJ do emitente + Modelo, série e número da NF-e + código numérico + dígito verificadorThe key user is composed of: FU Code + Issue AAMM + Issuer EIN + Electronic Invoice model, series and number + numeric code + verifying digit.


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

Nome abreviado da transportadora de redespacho, definido na função Cálculo de Notas Fiscais

Short name of the redispatching carrier, defined in the function  Calculation of Invoices (FT4003),

tela Cálculo de NF – Dados Gerais - Pasta Transporte

Calculation of Invoices - General Data - Transport Folder screen.

Informações
titleImportante: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 processEste campo será substituído pelo botão Redespachantes, quando o Datasul EMS 2 estiver integrado ao Datasul TMS e na função Setup-Embarcador estiver selecionada a opção "Mais de um Redespacho na NF". Quando acionado, executa a função Redespachantes, que apresenta os dados da nota fiscal (Estabelecimento, Série e Nr da Nota Fiscal), o transportador, e as cidades do Remetente (Cidade Estabelecimento) e do Destinatário - entrega (Cidade Cliente) informadas na nota fiscal. Nesta funcionalidade será apresentado o programa XC0406 onde será possível visualizar até cinco redespachantes utilizados durante o processo de emissão da nota fiscal.

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.

...

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


Freight modality estimated for Electronic Invoice and SPED.

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.

...

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 goal:

It enables you to view information related to billing accounting.

...

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.

...

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

Observações que foram impressas na nota fiscal, determinadas na função Cálculo de Notas Fiscais

Notes printed in the invoice determined in the function  Calculation of Invoices (FT4003),

pasta Observações, campo Observações Informadas

 Notes folder, Notes Entered field.

Nota
titleNotaNote:

Permite consultar o valor total aproximado dos impostos que influenciaram no preço de venda dos itensIt 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".

Nota
titlePré-requisito:Requisite:

Check information of the Tax Message field of the  Maintenance of Messages Verificar informações do campo Mensagem Fiscal, do Manutenção de Mensagens - 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.

...

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.

...

Field:

Description:

Currency

Código correspondente a moeda a ser utilizada na consulta

Code corresponding to the currency to be used in the search.

Informações
titleImportante: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 consultationCaso o módulo Controle de Estoque utilize as moedas alternativas 1 e 2, poderá ser consultado pela moeda-padrão e por mais duas moedas, podendo, desta forma, escolher uma das três moedas disponíveis para a consulta

Average

Type of average price to be used in the search. The options are:

  • Monthly: the debit and credit values displayed in the Inventory Accounting Grid are the result of the calculation made through the CE0401 - Calculation of Average Price program.
  • Online: the debit and credit values displayed in the Inventory Accounting Grid represent the online cost during the updating of the invoice in the system.
  • Standard: the debit and credit values displayed in the Inventory Accounting Grid derive from the cost parameterized as standard cost of the item, registered by the  Maintenance of the Standard Price (CD0185) program.

Display Accounting Grid per Item?

Indica que a forma de apresentação da grade contábil do Estoque será agrupada por

It indicates the Inventory Accounting Grid is grouped per item.

Informações
titleImportante: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

Informando este parâmetro será possível visualizar a movimentação contábil de cada item.
Caso o usuário não informe este parâmetro, a forma de apresentação da grade contábil do estoque será demonstrada de forma sumariada, por conta contábil

.


Example

Day

Type of Invoice

Quantity

Value

Online Unit Price

01

NFE

10 (mais)

10.00 (mais)

1.0000

01

NFE

10 (mais)

20.00 (mais)

1.5000

01

NFS

02 (menos)

3.00 (menos)

1.5000

02

NFE

10 (mais)

18.00 (mais)

1.6071

02

NFS

03 (menos)

4.82 (menos)

1.6071

Invoice Search - Return Folder

Screen goalpurpose:

It enables you to view information related to return.

...

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 PIS and COFINS Substitutes
IRFS
Image Removed

Updating of Billing Parameters (FT0301a)
Image Removed