[ledgersmb-users] Re: Exporting Detailed Vendor List

Greetings.

Hello Eric, Thank you for your response.

Indeed, I cannot find any export button on the AP/Vendor Report.

My objective is to to generate an spreadsheet file either by copying and pasting it on file.

I am familiar with the basic SQL command but i am not familiar with the table structure of the LSMB database.

The field that i want to extract are the basic information which each vendor like company name, email address, contact numbers, tin number and other relevant details pertaining vendor profile.

Hope you can help me on which table i should refer to extract these details.

Best Regards and Keep Safe!

Ryle.Msinc/ITDept

On Sunday, 3 May 2020, 08:43:57 pm GMT+8, Erik Huelsmann <..hidden..> wrote:

Hi Ryle,

On Fri, Apr 24, 2020 at 10:27 AM Ryle Zabate <..hidden..> wrote:

I am trying to export vendor list but the reporting only displays a limited column.

My question is how can I export detailed vendor information list either by extrating it to an spreadsheet or pdf format.

To be honest, there's currently no standard way to do that from inside the application. You'd have to run (a series of) queries to extract the desired information. We're working on building web-APIs (web services) which should partially address this problem.

Maybe I can help you by telling you the query you need to retrieve the desired fields? Please let me know which fields you'd want to include in the export.

Regards,

Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.

Robust and Flexible. No vendor lock-in.