Vendor list by department 

This Report enables you to see all the vendors in each department. 

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  

This Vendor list by department Report presents an overview of the vendors encoded in your company’s Sage 50 and sorted by department. 

How to use the Report  

1. Ensure you are connected to the correct company by going to the Logicim XLGL ribbon then clicking Connect. 
2. 
3. Ensure the correct username and password, then click QC. 
4. 
5. If you had the wrong credentials, an error dialog box would appear. If you have the right credentials, the connection should turn green.   
6. 
7. Click the Refresh button on the Logicim XLGL ribbon. 
8. 
9. Click Go to Report… on the Instructions worksheet or click the Vendors-dept worksheet. 
10. 

Common use cases  

This Report is useful when reviewing your active vendors in Sage 50 partitioned per department. 

Troubleshooting  

1. Issue: Wrong values appear on the worksheet. 
2. Solution: Ensure you are connected to the right company. 

FAQs  

1. Q: I am looking for a specific vendor. However, it does not appear.  
2. A1: The vendor may be inactive.  
3. A2: There may be no transactions for that vendor where there is a tagged department. 

Best practices 

Connect with the right company before loading this Report. Ensure that the Refresh after opening checkbox is checked for accurate company and save you from steps such as clicking the Refresh button on the Logicim XLGL ribbon.

Related article

See also: Formatted vendor aging