This topic describes how to get Oppr.land in the Produkttransaksjon table updated, since the
Intrastat report will require this information.
Assigning Oppr.land to the product
- Alternative A
- Update the field Oppr.land in the
Produkt table for each
product. This will make it possible to extract records from the Produkttransaksjon table grouped by
Oppr.land.
Merk:
This requires that each product always has the same Oppr.land, if not - see
alternative B.
- Alternative B
- Assumptions:
- The Leveringsalternativ
table is always updated concerning all possible combinations of Produktnr,Lev.nr and
Oppr.land
- The option Oppbevar varepartier in
the Ordrebehandling 2
dialog in the Bedriftsopplysninger table is always
ticked
- Each supplier normally only provides goods from the same Oppr.land
Under these assumption it will always be possible to extract Produkttransaksjon per Oppr.land and
per Vareparti since the
Partinr
is given in the Produkttransaksjon table, the Lev.nr is given in the
Vareparti table and the
combination of Lev.nr,
Produktnr
and Oppr.land is
given in the Leveringsalternativ table.