The purpose of this report is to issue the Detailed list of purchases and credit notes by supplier by periods, which you can filter using the parameters found in the database in a simple, intuitive and objective way.
For this report to work, follow the documentation below to configure TReports in your environment: TReports - Configuration of the Protheus product integrated with TReports |
When you run the Purchase List, the data are stated as follows:
Insert image here.
Filter | Description |
Initial and Final Provider | Run a filter in accordance with initial and final provider. |
Initial and Final Product | Run a filter in accordance with initial and final product. |
Typing Date | Run a filter in accordance with initial and final typing date. |
Field | Description | Type | Size | Context |
F1_DOC | Document number. | C | 2 | Actual |
F1_SERIE | Document Series | C | 3 | Actual |
F1_FORNECE | Supplier code | C | 6 | Actual |
F1_LOJA | Supplier store | C | 2 | Actual |
A2_NOME | Corporate Name | C | 40 | Actual |
A2_NREDUZ | Trade Name | C | 20 | Actual |
F1_DTGIT | Typing Date | N | 8 | Actual |
F1_TXMOEDA | Currency Rate | N | 11.4 | Actual |
F1_MOEDA | Bill Currency | N | 2 | Actual |
F1_ESPECIE | Document Type | C | 5 | Actual |
D1_COD | Product Code | C | 15 | Actual |
B1_DESC | Product Description | C | 15 | Actual |
B1_UM | Product Code | C | 30 | Actual |
D1_QUANT | Product Quantity. | N | 11.2 | Actual |
D1_GRUPO | Product Group | C | 4 | Actual |
D1_TIPO | Document Type | C | 1 | Actual |
D1_TES | Invoice Type | C | 3 | Actual |
D1_TP | Type of Product Sold | C | 2 | Actual |
D1_CUSTO | Inflow Cost Currency 1 | N | 14.2 | Actual |
D1_CUSTO2 | Inflow Cost Currency 2 | N | 14.2 | Actual |
D1_CUSTO3 | Inflow Cost Currency 3 | N | 14.2 | Actual |
D1_CUSTO4 | Inflow Cost Currency 4 | N | 14.2 | Actual |
D1_CUSTO5 | Inflow Cost Currency 5 | N | 14.2 | Actual |