Quick Query - Invoices by Customers EM APROVAÇÃO

Go to metadata end

Go to metadata start

Index

• 1 Purpose
• 2 Query Fields
• 3 Development/Procedure
• 3.1 Requirements
• 3.2 Quick Query View
• 4 Considerations

Purpose

It consists on making information related to outbound invoices available, by only displaying the ones that have been issued for the indicated customer.

Query Fields

These fields are displayed in the query:

• Customer code: indicates the customer code
• Customer Name: indicates the customer name
• Customer CPF/ CNPJ: indicates the CPF or CNPJ of the customer
• Number: indicates the invoice number
• Series: indicates the invoice series
• Issue Date: indicates the invoice issue date
• Type: indicates the invoice type
• Total Value: indicates the invoice total value
• Payment Condition: indicates the invoice payment term

Filters Used:

• Last 30 days: considers the issue date with thirty days from today's date.
• Last 60 days: considers the issue date with sixty days from today's date.
• Last 90 Days: considers the issue date with ninety days prior to today's date;
• Last 120 days: considers the issue date with hundred and twenty days from today's date.
• Last 360 days: considers the issue date with three hundred and sixty days from today's date.

Development/Procedure

Requirements

Fluig must be integrated with Protheus, release 12.1.1 or later.

Quick query view

To view the quick query, follow these steps:

• Step 1
• Step 2
• Step 3
• Step 4
• Step 5
• Step 6
• Step 7
• Step 8
• Step 9
• Step 10

• Access the community in which you want to add the quick query:

Considerations

For further information, access http://tdn.totvs.com/display/fluig/Plataforma+Fluig.