Description
Belgium: Foreign vendor open items
This program issues a list of all foreign vendors, sorted by currencyand country. This report prepares the data required for Belgian legalreporting in this area.

Output
Sum total per currency / Country(group)
A title page and a table for each report type (type 090, 092 and 094).
Every program run is for companies in Luxembourg or Belgium (you choosewhich company by specifying the appropriate parameter).
The report is adapted according to the country in question (e.g. in theBelgian report, the first country is LU and vice versa).
The first column always contains documents in EUR.
The last column ('OTH') contains, in local currency (EUR), the values ofall the other currencies.
The value in EUR is displayed in the detailed reports, along with adisplay of the original currency at the end of every line.
Exception list
Documents without an operation type (field LZBKZ)
The values defined in the document must not necessarily be 090, 092 or094. If, however, they have to be these values, then the field(T015L-LVAWV) must contain the values 090, 092 or 094. You can run theprogram for only a single value (e.g. 090..) by selecting this via theselect options.
You can select documents with empty operation type fields by selectingthe parameter. If not selected, the document will be given the value ofthe parameter. Allowable values are 090, 092 and 094.
ISO code conversion error
-> ISO country code- no code was entered in table T005 or the value doesnot correspond to a defined group in the table (see list of acceptablevalues below).
-> ISO currency code (no ISO code was entered)
You activate both conversions via a parameter on the selection screen.If this parameter is not activated the alternate settings will be used(you cannot reach the country assignment in this case). The ISOcountrycodes are found in the far left column of the table; the valuesfor groups (G01...G12) are as follows:
G01:
AM, AZ, BY, KZ, KG, MD, RU, TJ, TM, UA, UZ
G02:
AL, BA, BG, HR, CZ, EE, HU, LT, MK, PL, RO, SK, SI, LV
G03:
AD, CY, GI, LI, MT, MC, SM, VA
G04:
EC, VE
G05:
DZ, GA, LY, NG
G06:
IR, IQ, KW, GA, SA, AE
G07:
AI, AW, BS, BM, BO, BR, VG, KY, CL, CO, CR, CU, SV, GT, HN, AN, NI, PA,PE, TC, AG, AR, BB, BZ, DM, DO, FK, GD, GY, HT, JM, PY, KN, LC, VC, SR,TT, UY, VI
G08:
BJ, BF, CM, CV, CF, TD, EG, GM, GH, CI, LR,
ML, MR, MA, NG, SN, SL, SD, TG, TN, ZR, AO, IO, BI, KM, CG, DJ, GQ, ET,KE, MG, MW, MV, MZ, RW, ST, SC, SO, SH, TZ, UG, ZW, ZM
G09:
AF, BH, BD, BT, BN, KH, CN, GE, IN, IL, JO, LA,
LB, MV, MN, MM, NP, KP, OM, PK, LK, SY, VN, YE
G10:
UM, AU, FJ, KI, NR, UM, NZ, PG, PN, PL, SB, TO, TU, VU, WS
G11:
HK, TW, KR
G12:
MY, PH, TH
Detail list with all selected items
Items are sorted by transaction type. (090,092,094).
The report prints a total amount per currency.
The detail list displays values from the selected documents in documentcurrency. The table lists the values in units of 1000 of the respectivecurrency. Amounts which are smaller than 1000 units of the currency aretherefore located only on the detail list.
Terms of delivery:
You should enter the estimated percentage value of the delivery terms inthe corresponding parameter on the flow of goods report cover sheet(report type 090).
The total value is compared with 100%.
Setup requirements
1. ISO codes used:
- country codes (country table)
- currency codes (currency definition table)
2. Transaction type (table T015L)
3. Posting key and field selection list : activate the field for foreign
4. Company code, address and tax number must be available (globalcompany code parameter)