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 <ehuels(a)gmail.com>
wrote:
Hi Ryle,
On Fri, Apr 24, 2020 at 10:27 AM Ryle Zabate <ryle_23(a)ymail.com> 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.