Given scenario:
External Document No field in the purchase document is used to register vendor invoice number. This information is also saved in the Vendor Ledger Entries when the purchase document is posted. It is therefore expected also to be shown in the two reports "Vendor Open Entries" and "Vendor Detail Trial Balance"

Replication steps:
-    Create a Purchase Order or Purchase Invoice for one vendor.
        Ensure to enter value on the field Vendor Invoice No.
-    Post the Purchase Order or Purchase Invoice.
-    Open the Vendor card and select that vendor that was used in the
        Purchase Order or Purchase Invoice.
-    Open the Ledger Entries and look for that purchase that was posted.
        You will see that the External Document No. is also saved
        (the vendor invoice no. entered on the first step).
-    Close the ledger entries and vendor card.
-    Generate the report Vendor Open Entries. You will notice that the
        External Document No. is NOT shown per entry.
-    Generate the report Vendor Detail Trial Balance. You will notice that
        the External Document No. is NOT shown per entry.

It was found out that when reconciling paid payables or when analyzing outstanding payables, Accountants use the vendor invoice no. as reference. (esp. for exact application of payment). But due to this missing information in these two reports, Accountants are struggling with matching the payments to the exact invoices.
Accountants therefore believe that this information “External Document No.” or Vendor Invoice No. should be part of standard reports in Navision.

Ideas Administrator

Thank you for your valuable feedback. We have decided to deliver this idea and make it available with Business Central 2019 release wave 2.  

Learn more about what's new and planned for Reconcile payables using the External Doc. No field in the Vendor Detail Trial Balance, Balance to Date, and Open Entries reports in the release plan here: https://docs.microsoft.com/en-us/dynamics365-release-plan/2019wave2/dynamics365-business-central/reconcile-payables-using-external-doc.-no-field-vendor-detail-trial-balance-balance-date-open-entries-reports

Your help was greatly appreciated,  
Ivan Koletic
PM, Microsoft  



The Vendor Details trial balance also have an unnecessary column "Phone".

This is just eating space in the report layout, we used to remove it, but why not to review all internal reports layout and make most of them ready to use without touching from the Partner as well as the customer.

Category: Financial Management


Thanks for the suggestion, Dirk. We'll continue tracking votes for this feature request, and consider it for a future release of the product.



Category: Financial Management


Please note that this can be one of the requirements that Accountants have been looking for and is missing in Navision. 

Category: Financial Management