VANGELDER SOLUTIONS E-Invoice Platform · Help Nederlands Product

docs.vangeldersolutions.be/e-invoice-platform/map-gl-accounts

Assign G/L Accounts by Line Description

Lines on an incoming supplier document that carry no item are coded to a G/L account by their description, using Business Central's text-to-account mapping. This app checks that in advance and lists the descriptions that resolve to nothing, in the Unresolved Account Lines column on Incoming Supplier Recognition. Fix those before the document imports, and it arrives ready to post.

The reason to do it in advance rather than afterwards is that the failure is silent. It does not stop the import.

How a line is coded

For a line description, the following are tried in order:

  1. A text-to-account mapping row for this vendor.
  2. A text-to-account mapping row for any vendor.
  3. The fallback account on Purchases & Payables Setup, on the Default Accounts FastTab.

If all three miss, the line has no account.

The trap worth knowing

A mapping row that matches the description but leaves the account column empty counts as unresolved. Business Central does not stop — it creates a purchase line with no type and no amount, which can be neither posted nor sent for approval. The document looks like it imported, and then will not move.

This is what the warning names:

No G/L account can be found for descriptions. Business Central looks for a Text-to-Account Mapping on this vendor, then on any vendor, then falls back to Debit Acc. for Non-Item Lines in Purchases & Payables Setup. A mapping row that matches but leaves the account column empty is the trap: the import does not stop, it creates a purchase line with no type and no amount, which can neither be posted nor sent for approval. Fill in Debit Acc. No. on the mapping row, or the fallback account.

Add a mapping

  1. Choose the Tell Me. Search icon, enter Text-to-Account Mapping, and then choose the related link. You can also reach it with the Map Text to Account action.
  2. Add a row with the Mapping Text that appears on the supplier's lines.
  3. Fill in Debit Acc. No. — this is the step that is easy to skip and the one that matters.
  4. Set Vendor No. to make the mapping specific to one supplier, or leave it blank to apply to all.

Matching is on partial text, so a mapping text of consultancy matches a line described Consultancy services April. Keep mapping texts short and distinctive.

Do not use the Credit Acc. No., Bal. Source Type and Bal. Source No. fields for e-documents.

Set the fallback account

For everything you have not mapped, fill in the non-item-lines fallback account on Purchases & Payables Setup, on the Default Accounts FastTab. A fallback means an unmapped line lands somewhere postable instead of nowhere — a suspense account you review is better than a document that cannot move.

Check that it worked

Go back to Incoming Supplier Recognition and choose Rematch on the row, or Add Missing Units on the setup page, which also refreshes the blockers. The Unresolved Account Lines and Will Not Import columns clear themselves once the descriptions resolve.

The re-check reads the stored descriptions rather than the original document, because that document may be gone by then — and the stored half is exactly the half that stops being true when somebody adds a mapping.

Units of measure block the same way

A unit code on an incoming line that no Unit of Measure answers to stops the import before it ever reaches the accounts. Those appear in Unresolved Unit Codes, and Add Missing Units on the setup page creates them. See Troubleshoot Receiving Documents.