EXCEL-Format

Record layout – Send open item list

Open items:

EXCEL Record layout OP V2

ø  Attention:

  • It is imperative that with delivery of the FIRST open item-list EACH individual open position is marked as „new turnover“ (see column Q: „Code for new turnover“).
  • Afterwards only the newly added turnover of the open item-list will be marked as „new turnover“.

EXAMPLE:

EXCEL Datensatzaufbau Beispiel OP V2

Debtor file:

ø  Attention:

  • For the column M „ insurance, coded“ please use the following abbreviations:

EXAMPLE: