When you use an Excel data model using PowerPivot to this table, you get the benefits of flexibility to let you look at things such as aging bucket and filter by a host of different factors. As the screenshot below shows, it is very sophisticated report.
Let’s take a look at the out-of-the-box AP aged payable report first. The caveat is, unlike AR where you can use an invoice and/or document number to join the invoice and receipts tables, in AP you have to combine vendor and invoice to join the invoice and payment tables since you could potentially have the same invoice number from different vendors. The Excel data model for AP aging is similar to that of AR. Following my previous blog about creating AR aging reports using PowerPivot in Excel, I’d like to cover AP (Accounts Payable) in this blog.
0 kommentar(er)
