Quick Query - Sales Orders by Customer

Quick Query - Sales Orders 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 sales orders available by only displaying the pending or closed orders of the customer indicated in the query.

Query Fields

These fields are displayed in the query:

• Customer Identification: indicates the customer identification code
• Customer Name: indicates the customer company name
• Customer CPF/ CNPJ: indicates the CPF or CNPJ of the customer
• Number: indicates the order number
• Currency: indicates the currency used
• Total Value: indicates the order total value
• Issue Date: indicates the order issue date
• Status: indicates the order status (that can be Pending or Closed)

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 from today's date.
• Last 120 days: considers the issue date with a 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.

To have sales order, pending and/or closed, registered in Protheus SIGAFAT. 

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.