View source | View content page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

Projects:Intrastat/Technical Document

Contents

TECHNICAL DOCUMENTATION: INTRASTAT

Purpose of the Project

The purpose of the Project is to add the Intrastat report to the Openbravo ERP. The funcionality will be mainly focus on the Spanish Intrastat's format, but it will also try to be as much generic as possible to be adapted to other European Union countries Intrastat's formats.


Intrastat is a statistical declaration of goods trade within the European Union, which provides tax authorities with good movements information within European Union after European Union customs removal in 1993.

Intrastat report must be sent to the Tax Authorities monthly, within the 12 natural days of the corresponding month after the month in which the transactions were done.


The report must be sent through the INTERNET – on line submission of a valid Intrastat plain file.


Projects and Modules Information

The development of this project will be based on modules. As usual, we will use the Openbravo's forge to centralice the project's information and development status.


The development will be divided into four different modules, which its correspondant forge's projects:

Forge projects

The Intrastat forge project will be created with the following information:

The Intrastat – Spanish translation forge project will be created with the following information:

The Intrastat – Spanish implementation forge project will be created with the following information:

The Incoterms forge project will be created with the following information:

Modules

The Intastat module will be created with the following information:

The Intrastat – Spanish translation module will be created with the following information:

The Intrastat – Spanish implementation module will be created with the following information:

The Incoterms module will be created with the following information:

Database and Application Dictionary

Reference Lists

The following reference list will be created at Application Dictionary || Reference:

Intrastat module:

  1. INTR_TRANSPORTATION_TYPE. Validation Type “List Validation”. List Reference: 8 records
  1. INTR_REPORT_TYPE. Validation Type “List Validation”. List Reference: 3 records
  1. INTR_DECLARATION_TYPE. Validation Type “List Validation”. List Reference: 2 records
  1. INTR_TRANSACTION_TYPE. Validation Type “List Validation”. List Reference: 0 records
  2. INTR_PORT. Validation Type “List Validation”. List Reference: 0 records
  1. INTR_STATISTICAL_REGIME. Validation Type “List Validation”. List Reference: 0 records.
  2. INTR_STATUS. Validation Type “List Validation”. List Reference: 2 records:

Intrastat – Spanish implementation module:

  1. INTR_TRANSACTION_TYPE. Validation Type “List Validation”. (Reference already created in Intrastat Module, need to add the following list references) List Reference: 17 records
  1. INTR_PORT. Validation Type “List Validation”. (Reference already created in Intrastat Module, need to add the following list references) List Reference: 59 records.
Search Key                                                Name

List.png

List1.png


Note: Take a look at SQL scripts


  1. INTR_STATISTICAL_REGIME. Validation Type “List Validation”. (Reference already created in Intrastat Module, need to add the following list references) List Reference: 10 records.

Tables, Windows & Tabs

Intrastat module:

1. INTR_C_UOM.


Column Req. Datatype Description Notes
INTR_C_UOM_ID Y VARCHAR(32) Supplementary Unit of Measure for Intrastat report PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data FK: AD_Org
CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
VALUE Y NVARCHAR2(60) Supplementary UOM search key - Updateable = N

- Identifier

NAME Y NVARCHAR2(60) Supplementary UOM name
DESCRIPTION N NVARCHAR2(255) Supplementary UOM description

2 .INTR_SETUP.


Column Req. Datatype Description Notes
INTR_SETUP_ID Y VARCHAR(32) Intrastat's setup PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data - FK: AD_Org

- Link to parent column

CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
C_CALENDAR_ID Y VARCHAR(32) Reporting Calendar - Just display the ones marked for Intrastat (C_Calendar.Intrastat=Y)
C_YEAR_ID Y VARCHAR(32) The Intrastat's setup for this year - FK to C_Year.- Only Years of the selected calendar
LIMITAMT Y DECIMAL Limit Amount
YTDREPORTED_AMT Y DECIMAL YTD Reported Amount Updateable = N
DECLARATION_TYPE Y VARCHAR(60) Intrastat declaration type Reference: List (INTR_DECLARATION_TYPE)
TODO: INSTRASTAT_FORMAT Spain, Germany, etc.
C_INCOTERMS_ID N VARCHAR(32) Incoterm (Delivery Terms) Ref: TableDir

FK: C_INCOTERMS_ID

TRANSACTION_TYPE N VARCHAR(60) Transaction Type Reference: List (INTR_TRANSACTION_TYPE)
TRANSPORTATION_TYPE N VARCHAR(60) Transportation Type Reference: List (INTR_TRANSPORTATION_TYPE)
PORT N VARCHAR(60) Port/Airport - Reference: List (INTR_PORT)

- Display logic: when TRANSPORTATION_TYPE IN (1,3) Nice to have

STATISTICAL_REGIME N VARCHAR(60) Statistical Regime Reference: List (INTR_STATISTICAL_REGIME)
PROCESS Y CHAR(1) Configure next year -Reference: Button

-Process: INTR_CONFIG_YEAR

-Default: N

INTR SETUP.png

3. INTR_M_PRODUCT


Column Req. Datatype Description Notes
INTR_M_PRODUCT_ID Y VARCHAR(32) Intrastat definition for a product PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data FK: AD_Org
CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
M_PRODUCT_ID Y VARCHAR(32) Product FK: M_Product
NC8_CODE N VARCHAR(8) NC8 Item code
HASUNIT Y CHAR(1) Has Supplementary Unit -Reference: YesNo

-Default: N

INTR_C_UOM_ID N VARCHAR(32) Supplementary Unit - FK: INTR_C_UOM

- Display Logic (HASUNIT=Y)

CONVERSION N DECIMAL Conversion rate - Display Logic (HASUNIT=Y)
NETMASS_KG Y DECIMAL Net Mass (Kg)

INTR M PRODUCT.png

4. INTR_C_BPARTNER


Column Req. Datatype Description Notes
INTR_C_BPARTNER_ID Y VARCHAR(32) Intrastat definition for a Business Partner PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data FK: AD_Org
CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
C_BPARTNER_ID Y VARCHAR(32) Business Partner FK: C_BPartner
PO_TRANSPORTATION_TYPE N VARCHAR(60) Transportation Type Reference: List (INTR_TRANSPORTATION_TYPE)

DL: Only for Vendors

PO_PORT N VARCHAR(60) Port/Airport - Reference: List (INTR_PORT)

DL: Only for Vendors

- Display logic: when TRANSPORTATION_TYPE IN (1,3) Nice to have

SO_TRANSPORTATION_TYPE N VARCHAR(60) Transportation Type Reference: List (INTR_TRANSPORTATION_TYPE)

DL: Only for Customers

SO_PORT N VARCHAR(60) Port/Airport - Reference: List (INTR_PORT)

DL: Only for Customers

- Display logic: when TRANSPORTATION_TYPE IN (1,3) Nice to have

ORIG_C_COUNTRY_ID N VARCHAR(32) Origin Country - FK: C_Country

- DL: Only for Vendors

INTR C BPARTNER.png

5. INTR_C_ORDERLINE


Column Req. Datatype Description Notes
INTR_C_ORDERLINE_ID Y VARCHAR(32) Intrastat definition for an Order line's product PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data FK: AD_Org
CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
C_ORDERLINE_ID Y VARCHAR(32) Order line Link to parent column
M_PRODUCT_ID Y VARCHAR(32) Product FK: M_Product
C_INCOTERMS_ID N VARCHAR(32) Incoterm (Delivery Terms) Ref: TableDir

FK: C_INCOTERMS_ID

TRANSACTION_TYPE N VARCHAR(60) Transaction Type Reference: List (INTR_TRANSACTION_TYPE)
TRANSPORTATION_TYPE N VARCHAR(60) Transportation Type Reference: List (INTR_TRANSPORTATION_TYPE)
PORT N VARCHAR(60) Port/Airport - Reference: List (INTR_PORT)

- Display logic: when TRANSPORTATION_TYPE IN (1,3) Nice to have

STATISTICAL_REGIME N VARCHAR(60) Statistical Regime Reference: List (INTR_STATISTICAL_REGIME)
ORIG_C_COUNTRY_ID N VARCHAR(32) Origin Country - FK: C_Country

- DL: Only for Purchase

NC8_CODE N VARCHAR(8) NC8 Item code
HASUNIT Y CHAR(1) Has Supplementary Unit -Reference: YesNo

-Default: N

INTR_C_UOM_ID N VARCHAR(32) Supplementary Unit - FK: INTR_C_UOM

- Display Logic (HASUNIT=Y)

CONVERSION N DECIMAL Conversion rate - Display Logic (HASUNIT=Y)
NETMASS_KG N DECIMAL Net Mass (Kg) - Display Logic (HASUNIT=Y)

6. INTR_M_INOUTLINE


Column Req. Datatype Description Notes
INTR_M_INOUTLINE_ID Y VARCHAR(32) Intrastat definition for a Shipment/Receipt line's product PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data FK: AD_Org
CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
M_INOUTLINE_ID Y VARCHAR(32) Shipment/Receipt line Link to parent column
M_PRODUCT_ID Y VARCHAR(32) Product FK: M_Product
C_INCOTERMS_ID N VARCHAR(32) Incoterm (Delivery Terms) Ref: TableDir

FK: C_INCOTERMS_ID

TRANSACTION_TYPE N VARCHAR(60) Transaction Type Reference: List (INTR_TRANSACTION_TYPE)
TRANSPORTATION_TYPE N VARCHAR(60) Transportation Type Reference: List (INTR_TRANSPORTATION_TYPE)
PORT N VARCHAR(60) Port/Airport - Reference: List (INTR_PORT)

- Display logic: when TRANSPORTATION_TYPE IN (1,3) Nice to have

STATISTICAL_REGIME N VARCHAR(60) Statistical Regime Reference: List (INTR_STATISTICAL_REGIME)
ORIG_C_COUNTRY_ID N VARCHAR(32) Origin Country - FK: C_Country

- DL: Only for Purchase

NC8_CODE N VARCHAR(8) NC8 Item code
HASUNIT Y CHAR(1) Has Supplementary Unit -Reference: YesNo

-Default: N

INTR_C_UOM_ID N VARCHAR(32) Supplementary Unit - FK: INTR_C_UOM

- Display Logic (HASUNIT=Y)

CONVERSION N DECIMAL Conversion rate - Display Logic (HASUNIT=Y)
NETMASS_KG N DECIMAL Net Mass (Kg) - Display Logic (HASUNIT=Y)

7. INTR_C_INVOICELINE


Column Req. Datatype Description Notes
INTR_C_INVOICELINE_ID Y VARCHAR(32) Intrastat definition for an Invoice line's product PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data FK: AD_Org
CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
C_INVOICELINE_ID Y VARCHAR(32) Invoice line Link to parent column
M_PRODUCT_ID Y VARCHAR(32) Product FK: M_Product
C_INCOTERMS_ID N VARCHAR(32) Incoterm (Delivery Terms) Ref: TableDir

FK: C_INCOTERMS_ID

TRANSACTION_TYPE N VARCHAR(60) Transaction Type Reference: List (INTR_TRANSACTION_TYPE)
TRANSPORTATION_TYPE N VARCHAR(60) Transportation Type Reference: List (INTR_TRANSPORTATION_TYPE)
PORT N VARCHAR(60) Port/Airport - Reference: List (INTR_PORT)

- Display logic: when TRANSPORTATION_TYPE IN (1,3) Nice to have

STATISTICAL_REGIME N VARCHAR(60) Statistical Regime Reference: List (INTR_STATISTICAL_REGIME)
ORIG_C_COUNTRY_ID N VARCHAR(32) Origin Country - FK: C_Country

- DL: Only for Purchase

NC8_CODE N VARCHAR(8) NC8 Item code
HASUNIT Y CHAR(1) Has Supplementary Unit -Reference: YesNo

-Default: N

INTR_C_UOM_ID N VARCHAR(32) Supplementary Unit - FK: INTR_C_UOM

- Display Logic (HASUNIT=Y)

CONVERSION N DECIMAL Conversion rate - Display Logic (HASUNIT=Y)
NETMASS_KG N DECIMAL Net Mass (Kg) - Display Logic (HASUNIT=Y)

INTR C INVOICELINE.png


8. INTR_HEADER

Column Req. Datatype Description Notes
INTR_HEADER_ID Y VARCHAR(32) Intrastat report header PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data FK: AD_Org
CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
NAME Y NVARCHAR2(60) Supplementary UOM name
C_Year_ID Y TableDir Year
C_Period_ID Y TableDir Period
DECLARATION_TYPE Y VARCHAR(60) Declaration Type List: INTR_DECLARATION_TYPE
REPORT_TYPE Y VARCHAR(60) Intrastat report type Reference: List (INTR_REPORT_TYPE)
STATUS Y VARCHAR(60) Intrastat Header Status List: INTR_STATUS
TOTAL_AMT Y DECIMAL Total Amount Declared DF: 0
PROCESSED Y CHAR(1) Button: Process the header DF: N
ISGENERATED Y CHAR(1) Button: Generate file DF: N

INTR HEADER.png

9. INTR_LINES

Column Req. Datatype Description Notes
INTR_LINES_ID Y VARCHAR(32) Intrastat report lines PK
AD_CLIENT_ID Y VARCHAR(32) Audit data FK: AD_Client
AD_ORG_ID Y VARCHAR(32) Audit data FK: AD_Org
CREATED Y DATE Audit data DF: SYSDATE
CREATEDBY Y VARCHAR(32) Audit data
UPDATED Y DATE Audit data DF: SYSDATE
UPDATEDBY Y VARCHAR(32) Audit data
ISACTIVE Y CHAR(1) Active Y,N. DF:Y
INTR_HEADER_ID Y VARCHAR(32) Intrastat report header - FK: INTR_HEADER

- Link to parent column

ISINCLUDED Y CHAR(1) Included DF: Y
ISMANUALCHANGE Y CHAR(1) Manual Change DF: N
C_INVOICELINE_ID N VARCHAR(32) Invoice Line -FK: C_INVOICELINE
INVOICE_DATE N DATE Invoice date
INVOICELINE_AMT Y DECIMAL Invoice Line Amount
C_BPARTNER_ID N VARCHAR(32) Business Partner FK: C_BPARTNER
C_INCOTERMS_ID N VARCHAR(32) Incoterm (Delivery Terms) Ref: TableDir

FK: C_INCOTERMS_ID

TRANSACTION_TYPE N VARCHAR(60) Transaction Type Reference: List (INTR_TRANSACTION_TYPE)
TRANSPORTATION_TYPE N VARCHAR(60) Transportation Type Reference: List (INTR_TRANSPORTATION_TYPE)
PORT N VARCHAR(60) Port/Airport - Reference: List (INTR_PORT)

- Display logic: when TRANSPORTATION_TYPE IN (1,3) Nice to have

STATISTICAL_REGIME N VARCHAR(60) Statistical Regime Reference: List (INTR_STATISTICAL_REGIME)
ORIG_C_COUNTRY_ID N VARCHAR(32) Origin Country - FK: C_Country

- DL: Only for Purchase

NC8_CODE N VARCHAR(8) NC8 Item code
HASUNIT Y CHAR(1) Has Supplementary Unit -Reference: YesNo

-Default: N

INTR_C_UOM_ID N VARCHAR(32) Supplementary Unit - FK: INTR_C_UOM

- Display Logic (HASUNIT=Y)

CONVERSION N DECIMAL Conversion rate - Display Logic (HASUNIT=Y)
NETMASS_KG N DECIMAL Net Mass (Kg) - Display Logic (HASUNIT=Y)

This table corresponds to a new tab, called Intrastat, inside Intrastat/Intrastat report/Lines.

INTR LINES.png

Reports & Process

Intrastat module:

  1. INTR_LAUNCHER


Column Req. Reference Description Validation
AD_ORG_ID Y TableDir Organization Show only Legal Entities
C_Year_ID Y TableDir Year Only Years of the selected organization (or its parents)
C_Period_ID Y TableDir Period Only Periods of the selected year
DECLARATION_TYPE Y List: INTR_DECLARATION_TYPE Declaration Type
REPORT_TYPE Y List: INTR_REPORT_TYPE Instrastat Declaration

INTR LAUNCHER.png


2. INTR_COPY_YEAR


Columns in core's tables

Intrastat module:

1. C_REGION
Column Req. Datatype Description Notes
EM_INTR_CODE N VARCHAR(2) Intrastat Region code
2. C_DOCTYPE
Column Req. Datatype Description Notes
EM_INTR_TRANSACTION_TYPE N VARCHAR(60) Transaction Type - Reference: List (INTR_TRANSACTION_TYPE)

- Display Logic: DOCBASETYPE IN ('ARI', 'API')

EM_INTR_STATISTICAL_REGIME N VARCHAR(60) Statistical Regime Reference: List (INTR_STATISTICAL_REGIME)

- Display Logic: DOCBASETYPE IN ('ARI', 'API')

3. M_FREIGHTCATEGORY
Column Req. Datatype Description Notes
EM_INTR_TRANSPORTATION_TYPE N VARCHAR(60) Transportation Type Reference: List (INTR_TRANSPORTATION_TYPE)
4. C_CALENDAR
Column Req. Datatype Description Notes
EM_INTR_ISINTRASTAT Y CHAR(1) Intrastat Calendar - DF: Y

- On create default: 'Y'

Datasets

Incoterms module:

Intrastat – Spanish implementation module:

  1. Supplementary Unit of Measure


Table Activ SQL where clause Notes
INTR_C_UOM Y - Include All Columns = Y

- IsBusinessObject = N

- Exclude Audit Info = Y


Value Name
BO BOMBONA
BR ARQUEO BRUTO
CE CENTENAS (100 UNIDADES)
CL NUMERO DE CELDAS
CT CAPACIDAD CARGA UTIL EN TONELADAS METRICAS
GI GRAMOS ISOTOPOS FISIONABLES
GN GRAMOS NETOS
HA GRADO ALCOHOLICO VOLUMENTRICO POR NÚMERO DE HETOLITROS
HG HETOLITROS DE ALCOHOL PURO 100%
HL HECTOLITROS
HM HECTOMETROS
HP HECTOLITRO x GRADO PLATO
H1 HECTOKILOGRAMOS DE AZUCAR BLACA (100kg)
H2 HECTOKILOGRAMOS DE TRIGO BLANCO (100kg)
H3 HECTOKILOGRAMOS NETO DE MATERIA SECA (100kg)
H4 HECTOKILOGRAMOS NETOS POR FRACIÓN DEL 1% DEL PESO
EN SACAROSA
H5 HECTOLILOGRAMOS DE PESO VIVO
KA KILOGRAMOS TOTAL ALCOHOL
KL MILES DE LITROS
KN KILOGRAMOS NETOS
KP KILOGRAMO DE MATERIA LACTICA
KT KILOGRAMO DE MATERIA SECA LACTICA
LA LITROS DE ALCHOHOL PURO 100%
LT LITROS
M1 METROS LINEALES
M2 METROS CUADRADOS
M3 METROS CUBICOS
M4 MIL METROS CUBICOS
MI MILLARES
MK MILES KILOVATIOS/HORA
PA NUMERO DE PARES
QE QUINTALES DE PESO NETO ESCURRIDO
QN QUINTALES NETOS
TA TONELADAS DE CLORURO POTASICO
TB TONELADAS NETAS DE MATERIA SECA
TC TONELADA NETA POR FRACCIÓN DEL 1% DEL PESO
TJ TERAJOULE
TN TONELADAS NETAS
UN UNIDADES
WA KILOGRAMOS NETOS DE DIHIDROESTRETOMICINA
WB KILOGRAMOS NETOS DE COLINCLORURO
WE KILOGRAMOS DE PESO NETO ESCURRIDO
WL NUMERO DE QUILATES
W1 KILOGRAMOS NETOS DE K20 (OXIDO DE POTASION)
W2 KILOGRAMOS NETOS DE KOH (HIDROXIDO DE POTASION)
W3 KILOGRAMOS NETOS DE N (NITROGENO)
W4 KILOGRAMOS NETOS DE NaOH (HIDROXIDO DE SODIO)
W5 KILOGRAMOS NETOS DE P205 (PENTAOXIDO DE DIFOSFORO)
W6 KILOGRAMOS NETOS DE U (URANIO)
W7 KILOGRAMOS NETOS DE MATERIA SECA AL 90%
W8 KILOGRAMOS NETOS DE AGUA OXIGENADA H2O2
W9 KILOGRAMOS DE METILAMINA
  1. Intrastat Spanish Region codes


Table Activ SQL where clause Notes
C_Region Y country.name='Spain' - Include All Columns = N

- IsBusinessObject = N

- Exclude Audit Info = Y


Column Active Excluded
EM_INTR_CODE Y N

The EM_INTR_CODE column of the C_Region table must be filled with the following data, where “CODIGO” represents the EM_INTR_CODE, and “PROVINCIA” represents the Spanish region (NAME column of the C_Region table):


CODIGO.png


CHANGES REQUIRED IN CORE FOR C_BPARTNER TABLE

  1. Add new columns to C_BPartner table:


Column Req. Datatype Description Notes
PO_C_INCOTERMS_ID N VARCHAR(32) Incoterm (Delivery Terms) Reference: TableDir (C_INCOTERMS).Display only for vendor
SO_C_INCOTERMS_ID N VARCHAR(32) Incoterm (Delivery Terms) Reference: TableDir (C_INCOTERMS).Display only for customers

Modify SE_Order_BPartner callout. This callout is used when introducing a Business Partner into the Purchase/Sales Order window. It fills all the data related with the Business Partner, like the Address, Contact, etc. We must extend the callout to also fill the default Incoterm configured at the Business Partner window.


BUSINESS FLOWS

1. Intrastat Launcher (INTR_LAUNCHER)

BFLOWS1.png

2. Copy Intrastat configuration (INTR_CONFIG_YEAR)

BFLOWS2.png

3. INTR_C_ORDERLINE_TRG

BFLOWS3.png

4. INTR_M_INOUTLINE_TRG

BFLOWS4.png

5. INTR_C_INVOICELINE_TRG

BFLOWS5.png

6. Copy Business Partner and Product info from Defaults

BFLOWS6.png

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Intrastat/Technical_Document"

This page has been accessed 8,244 times. This page was last modified on 8 June 2012, at 05:28. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.