Pivot table vendor invoice log

Pivot table vendor invoice log provides you with invoice logs per vendor, including the tax and subtotal. 

Prerequisite 

1. Logicim XLGL version 5.0 or higher 
2. Microsoft Excel 2016 or higher 
3. Sage 50 Canadian Edition (2014 and above) 

What the Report does  

The Report offers an overview of your invoices for the specific period set. The charts enable you to view the month-on-month invoice amounts and the top vendors invoicing the company. The pivot table also provides a detailed view of the invoices per vendor. 

How to use the Report  

1. Enter the Start and End of period dates for the invoices you want to see in cells C8 and C9 on the Instructions worksheet. 
2.  
3. Once set, click the Refresh button on the XLGL ribbon. 
4. 
5. A well-prepared chart would also be available when you click Go to Report… 

Common use cases  

This Report is useful when you want to drill-down on vendor invoices. You can see a detailed view of each invoice per vendor, including the tax incurred.  

Troubleshooting  

1. Issue: No values appear on the worksheet. 
2. Solution 1: Ensure the Start of period date does not surpass the End of period date.  
3. Solution 2: Ensure your account has the necessary permissions to access the Accounts & General Ledger. 

FAQs  

1. Q: Is there a way to extend the pivot table and see the PO as well? 
2. A: Yes, you can! The Report is set as a pivot table, and you can add the PO field. Click anywhere on the pivot table, click PivotTable Analyze > Field List, and click the checkbox for PO Number. 

Best Practices 

Always remember to connect to the right company before loading this Report. Also, ensure that the Refresh after opening checkbox is checked. This will make the Report accurate company-wise and save you some steps, like clicking the Refresh button on the Logicim XLGL ribbon. 

Related article

See also: Customer aging, Vendor list