NAV data exchange on invoices — endpoints and background job

NAV download (navdownload)

1. For the selected invoices a NAV queryInvoiceData call (navosa->sendQueryInvoiceData) with the owner's NAV credentials (company::getCompanyTaxHUById2).
2. The response (invoiceData, invoiceJson) is stored in invoice_ctrl (saveInvoiceCtrlRaw).
3. Invoice and line additional data go to the analytics model (saveLineAdditionalData), followed by an aggregate rebuild (rebuildAdditionalAggregate) and an invoice kind refresh (applyKind).
4. A result list per invoice.

Invoice kind and reference (navref)

Dlbtinvoice::refreshKindFromNav refreshes the kind (normal, storno, modifying) and the reference. Without a selection it runs on the filtered list: up to 20 invoices at once, above that an asynchronous job on the cron queue (cron_queue, job_type = nav_invoice_ref, insertRunOnce, payload {"invoice_ids": [...]}, at most 20,000 IDs, with the filter's client). If a pending job already exists, no new one is added. The runner is the catalog-side cron; error key: error_navref_queue.

Line additional data (lineadditional, lineadditionalsave)

Manual viewing and saving of NAV additionalLineData and productCodes for an invoice or a line through masterdata/analytic::saveLineAdditionalData; the NAV line is not touched.

Manual labelling (labelsearch, addLabel, removeLabel)

Assignment: dlbtlabel->addLink, source manual. On removal the pass-through rows of the label are deleted; the target invoice only while it is a draft (contract/passthrough::invoiceIsDraft, deleteInvoice).

Data model

Table names carry the installation's own prefix in the database: invoice_ctrl, invoice, invoice_item, analytics tables (masterdata/analytic), label_link, pass-through tables (contract/passthrough), cron_queue.

Permissions and prerequisites

• Layer 2: canAction(navdata) on every endpoint; the key is classified SUBSCRIPTION.
• Layer 3: invoiceInScope per invoice.
• Prerequisite: a NAV technical user at the owner company, the navosa library. Error keys: error_nav_*, error_navref_queue.