5.1. Configurar condiciones para lotes SII
TransacciónTransaction:
/EDGE/SII_CU_007 A través de esta transacción se configuran los criterios para la agrupación de eDocuments intermedios en lotes. Se debe crear como mínimo un criterio de asignación por tipo de lote. Si se crea más de una condición para un eDocument, se establecen criterios de prioridad desde la más restrictiva a la menos restrictiva.
Los datos a rellenar en la creación de un criterio de asignación son los siguientes:
Campo | Significado |
ID Criterio | Contador por defecto |
Prioridad | Debe ir de la más restrictiva a la menos restrictiva |
Tipo de eDocument | Tipo de eDocument (Lote) |
Número de registro por lote | Cantidad de documentos a incluir en el lote |
Vista en B+SII:
Una vez creado el criterio, se indican las condiciones de la siguiente forma:
Campo | Sociedad |
Número de condición | Contador propuesto |
Tabla | Nombre de la tabla que afecta para que se cumpla la condición |
Nombre campo | Nombre del campo (dentro de la tabla) para que se cumpla la condición |
Signo | Indicar si es una condición de Inclusión o Exclusión |
Opción | Tipo de condición que se tiene que cumplir: igual a, entre, menor o igual… |
Límite inferior | Límite de intervalo inferior |
Límite superior | Límite de intervalo superior |
Para que un criterio se considere válido se deben cumplir todas las condiciones.
Relación estados eDocument intermedios:
Relación estados lotes:
Vista en B+SII:
Through this transaction the criteria for the grouping of intermediate eDocuments in batches are configured. At least one allocation criterion must be created by lot type. If more than one condition is created for an eDocument, priority criteria are set from the most restrictive to the least restrictive.
The data to be filled in to create an allocation criterion are the following:
Field | Description |
|---|---|
Criterion ID | Default Counter |
Priority | It must go from the most restrictive to the least restrictive |
eDocument type | eDocument Type(Batch) |
Number or records per batch | Number of documents to include in the batch (It is recommended to parameterize a maximum of 1,000 records per batch) o include in the batch |
View in B+SII:
Inputs to be customized in Batch assignment criteria:
General Operations: Issued Invoices, Received, Investment Assets, Intra-Community Operations.
Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
| 1 | 5 | /EDGE/FR_L | 1.000 |
| 2 | 5 | /EDGE/FE_L | 1.000 |
| 3 | 5 | /EDGE/BI_L | 1.000 |
| 4 | 5 | /EDGE/OI_L | 1.000 |
| 5 | 5 | /EDGE/FR_M | 1.000 |
| 6 | 5 | /EDGE/FE_M | 1.000 |
| 7 | 5 | /EDGE/BI_M | 1.000 |
| 8 | 5 | /EDGE/OI_M | 1.000 |
| 9 | 5 | /EDGE/FRLB | 1.000 |
| 10 | 5 | /EDGE/FELB | 1.000 |
| 11 | 5 | /EDGE/BILB | 1.000 |
| 12 | 5 | /EDGE/OILB | 1.000 |
Payments and charges: Charges of Issued, Payments for Received.
Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
19 | 5 | /EDGE/CE_L | 1,000 |
20 | 5 | /EDGE/PR_L | 1,000 |
Batches of type Tax Free: For Issued invoices.
More information on this functionality 2.1.5.3.Tax free batches with communications type A4
| Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
| 21 | 4 | /EDGE/FE_T | 1,000 |
Cancellation of the invoice due to change in the invoice ID : Issued, Received, Investment Assets and Intra-Community Operations.
More information on this functionality 3.1.3.7. eDocument self-management on changes to Invoice ID
| Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
| 22 | 5 | /EDGE/FELI | 1,000 |
| 23 | 5 | /EDGE/FRLI | 1,000 |
| 24 | 5 | /EDGE/BILI | 1,000 |
| 25 | 5 | /EDGE/OILI | 1,000 |
Type of batches ISU/FICA.
| Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
26 | 5 | /EDGE/IS_L | 1,000 |
27 | 5 | /EDGE/IS_M | 1,000 |
28 | 5 | /EDGE/ISLB | 1,000 |
29 | 5 | /EDGE/FC_L | 1,000 |
30 | 5 | /EDGE/FC_M | 1,000 |
31 | 5 | /EDGE/FCLB | 1,000 |
Batch types for new book of Additional Properties
| Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
| 116 | 5 | /EDGE/RC_L | 1,000 |
| 127 | 5 | /EDGE/RCBL | 1,000 |
Batch types for new book of Additional Properties for FICA
| Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
| 126 | 5 | /EDGE/RF_L | 1,000 |
| 134 | 5 | /EDGE/RF_B | 1,000 |
Batches of type Return VAT for travelers: For issued invoices .
More information on this functionality: 18.5.1 Lots VAT Return Travelers with communication type A5 and A6
| Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
| 117 | 4 | /EDGE/FE_5 | 1.000 |
| 118 | 4 | /EDGE/FE_6 | 1.000 |
| Info | ||
|---|---|---|
| ||
New parameterization Version 1.1 Bis |
Types of lot for new book of sale of goods on consignment.
Criteria ID | Priority | eDocument Type | Number of records per batch |
|---|---|---|---|
| 157 | 5 | /EDGE/VB_L | 1,000 |
| 158 | 5 | /EDGE/VB_M | 1,000 |
| 159 | 5 | /EDGE/VBLB | 1,000 |
Once the criterion is created, the conditions are indicated as follows:
Field | Description |
|---|---|
Condition number | Proposed Counter |
Table | Name of the table that affects for the condition to be met |
Field name | Name of the field that is affected |
Sign | Indicate if it is an Inclusion or Exclusion condition (by default parameter I - Inclusive) |
Option | Type of condition to be met: equal to, between, less than or equal ... (By default we parameterize EQ Equal to) |
Low Limit | Lower range limit |
High Limit | Higer range limit |
In order for a criterion to be considered valid, all conditions must be met.
Intermediate eDocument states relation:
Batch Status Report:
View in B+SII:
Inputs to be customized in Conditions for criterion:
Now we will go on to detail the criterion conditions for each customized batch assignment criterion.
General Operations: Issued Invoices, Received, Investment Assets, Intra-Community Operations.
| CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| /EDGE/FR_L | edocument | EDOC_TYPE | I | EQ | /EDGE/FR | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| /EDGE/FR_M | edocument | EDOC_TYPE | I | EQ | /EDGE/FR | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| /EDGE/FE_L | edocument | EDOC_TYPE | I | EQ | /EDGE/FE | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| /EDGE/FE_M | edocument | EDOC_TYPE | I | EQ | /EDGE/FE | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| /EDGE/BI_L | edocument | EDOC_TYPE | I | EQ | /EDGE/BI | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| /EDGE/BI_M | edocument | EDOC_TYPE | I | EQ | /EDGE/BI | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| /EDGE/OI_L | edocument | EDOC_TYPE | I | EQ | /EDGE/OI | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| /EDGE/OI_M | edocument | EDOC_TYPE | I | EQ | /EDGE/OI | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| /EDGE/FRLB | edocument | EDOC_TYPE | I | EQ | /EDGE/FRB | |
| /EDGE/FELB | edocument | EDOC_TYPE | I | EQ | /EDGE/FEB | |
| /EDGE/BILB | edocument | EDOC_TYPE | I | EQ | /EDGE/BIB | |
| /EDGE/OILB | edocument | EDOC_TYPE | I | EQ | /EDGE/OIB |
Payments and charges: Charges of Issued, Payments for Received.
| CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| /EDGE/CE_L | edocument | EDOC_TYPE | I | EQ | /EDGE/CE | |
| /EDGE/PR_L | edocument | EDOC_TYPE | I | EQ | /EDGE/PR |
Batches of type Tax Free: For Issued Invoices.
| CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| /EDGE/FE_T | edocument | EDOC_TYPE | I | EQ | /EDGE/FE | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| bkpf | XREF2_HD | I | EQ | TAXFREE |
Cancellations for change of Invoice ID: Issued, Received, Investment Assets and Intra-Community Operations.
| CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| /EDGE/FELI | edocument | EDOC_TYPE | I | EQ | /EDGE/FEI | |
| /EDGE/FRLI | edocument | EDOC_TYPE | I | EQ | /EDGE/FRI | |
| /EDGE/BILI | edocument | EDOC_TYPE | I | EQ | /EDGE/BII | |
| /EDGE/OILI | edocument | EDOC_TYPE | I | EQ | /EDGE/OII |
Batch types for ISU / FICA.
| CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| /EDGE/IS_L | edocument | EDOC_TYPE | I | EQ | /EDGE/IS | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| /EDGE/IS_M | edocument | EDOC_TYPE | I | EQ | /EDGE/IS | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| /EDGE/ISLB | edocument | EDOC_TYPE | I | EQ | /EDGE/ISB | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| /EDGE/FC_L | edocument | EDOC_TYPE | I | EQ | /EDGE/FC | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| /EDGE/FC_M | edocument | EDOC_TYPE | I | EQ | /EDGE/FC | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| /EDGE/FCLB | edocument | EDOC_TYPE | I | EQ | /EDGE/FCB | |
| edocument | PROC_STATUS | I | EQ | CREA |
New Additional Properties
| CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| /EDGE/RC_L | edocument | EDOC_TYPE | I | EQ | /EDGE/RC | |
| edocument | PROC_STATUS | I | BT | CORR | CREA | |
| /EDGE/RCBL | edocument | EDOC_TYPE | I | EQ | /EDGE/RCB | |
| edocument | PROC_STATUS | I | BT | CORR | CREA |
New Additional Properties for FICA
| CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| EDGE/RF_L | edocument | EDOC_TYPE | I | EQ | /EDGE/RF | |
| edocument | PROC_STATUS | I | BT | CORR | CREA | |
| /EDGE/RF_B | edocument | EDOC_TYPE | I | EQ | /EDGE/RFB | |
| edocument | PROC_STATUS | I | BT | CORR | CREA |
Batches of type Return VAT for travelers: For issued invoices.
| CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| EDGE/FE_5 | edocument | EDOC_TYPE | I | EQ | /EDGE/FE | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| bkpf | XBLNR | I | BT | A50000000000 | A59999999999 | |
| /EDGE/RF_6 | edocument | EDOC_TYPE | I | EQ | /EDGE/FE | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| bkpf | XBLNR | I | BT | A50000000000 | A59999999999 |
| Info | ||
|---|---|---|
| ||
New parameterization Version 1.1 Bis |
Lots of type Sale of goods on consignment.
CRITERION | TABLE | FIELD NAME | SIGN | OPTION | LOWER LIMIT | UPPER LIMIT |
|---|---|---|---|---|---|---|
| /EDGE/VB_L | edocument | EDOC_TYPE | I | EQ | /EDGE/VB | |
| edocument | PROC_STATUS | I | EQ | CREA | ||
| /EDGE/VB_M | edocument | EDOC_TYPE | I | EQ | /EDGE/VB | |
| edocument | PROC_STATUS | I | EQ | CORR | ||
| /EDGE/VBLB | edocument | EDOC_TYPE | I | EQ | /EDGE/VBB |