Outstanding invoices in bought ledger control

Dynamics 365 Business Central/NAV User Forum
1

Hi,

I’m writing a SQL query to extract a list of outstanding invoices from the Vendor Ledger Entry and Detailed Vendor Ledg_ Entry tables.

The total does not match the balance sheet Bought Ledger Control balance.

Help!

Thanks

Tim

2

You only need to extract the data from Detailed Vendor Ledger Entry.