Hallo,
I see WebService::HMRC on cpan with a note that it was originally
developed for LedgerSMB, but I can find no reference to it in the list
archives.
Is there an existing implementation of this?
Cheers
Lyn
I'm having troubles with configuration, setup, running. I have
been using SQL-Ledger for many years but now I must update...
I can access the ledgersmb login using links browser pointed to
localhost. But I'm failing to figure out how to allows LAN access.
I have a fresh install of Debian on a machine. I used the package
manager to install ledgerSMB 1.6.9. To keep it light, no X. This
system is for a very small organization. One login typical, never
more than 5, access from inside the LAN only.
Any clues on how to setup Apache or Starman or ?? to make this
setup work?
-- fm
Hello,
I am testing Ledgersmb to see if it is a fit. I am currently using Shopify for shopping cart and I sell on Amazon. Therefore, I will need to sync my orders and inventory with each of the platform. I look around and I can't see how to upload data to Ledgersmb. I would also find it useful for migration. Any hints?
Regards,
Joe
Hi all,
In preparation of the final release of LedgerSMB 1.8, the release branch
has been created for a period of stabilization. In order to release the
most stable version released by the project ever released, a preview
version was published earlier today: 1.8.0-beta1.
Users are encouraged to download the Docker images (tag:
ledgersmb/ledgersmb:1.8) or the tarball (
https://download.ledgersmb.org/f/Beta%20Releases/1.8.0-beta1/) for
evaluation purposes. Bugreports either in response to this mail or as
GitHub issues are highly appreciated!
The 1.8 release shifts away from HTTP Basic authentication, using encrypted
cookies instead. This eliminates the popup authentication dialog on expired
sessions. Additionally, does it provide a broader range of settings for
outgoing e-mail and has support been added to upload logos and other files
which can be used in downloadable documents.
Please test LedgerSMB 1.8.0-beta1 with your use-cases (but not in
production) and report any issues you're experiencing so they can be fixed
before the final 1.8.0 release!
Thanks,
--
Bye,
Erik.
http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:
Changelog for 1.7.15
* Fix tax on invoice differs from search results (#4651)
* Fix COGS for purchased-in-arrears parts (#4658)
* Update Dojo to 1.15.3
IMPORTANT
The COGS fix addresses a bug which results in incorrect accounting
in case inventory is used and parts are sold before they are
purchased. This problem doesn't impact services or GL-only accounting.
While this fix addresses the core problem, it doesn't fix any data
that may have been recorded incorrectly! If you use inventory *and*
have sold parts before buying them (such that inventory ended up
being negative), LedgerSMB may have debited income and credited
expenses instead of crediting inventory and debiting expenses.
This leads to too high inventory, too low income and too low expenses.
The LedgerSMB team recommends consulting an accountant if this bug
affects your books or contact a LedgerSMB consultant to identify if
your books are affected (e.g. from
https://ledgersmb.org/content/commercial-support).
Downloads
For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.7.15/README.md
The release can be downloaded from our download site at
https://download.ledgersmb.org/f/Releases/1.7.15
The release can be downloaded from GitHub at
https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.15
Or pulled from Docker Hub using the command
$ docker pull ledgersmb/ledgersmb:1.7.15
These are the sha256 checksums of the uploaded files:
868cfb31edfb62a404d5f264327c84e5ea5999aeb56a4adac5c7ac532c156f8d ledgersmb-1.7.15.tar.gz
f28a92326f99a4440f1be9ba74187ae4e61101a28262b8287ac8fca08e3e6d11 ledgersmb-1.7.15.tar.gz.asc
The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:
Changelog for 1.6.21
* Fix COGS for purchased-in-arrears parts (Erik H)
* Update Dojo toolkit dependency to 1.13.7 (Erik H)
Erik H is Erik Huelsmann
IMPORTANT
The COGS fix addresses a bug which results in incorrect accounting
in case inventory is used and parts are sold before they are
purchased. This problem doesn't impact services or GL-only accounting.
While this fix addresses the core problem, it doesn't fix any data
that may have been recorded incorrectly! If you use inventory *and*
have sold parts before buying them (such that inventory ended up
being negative), LedgerSMB may have debited income and credited
expenses instead of crediting inventory and debiting expenses.
This leads to too high inventory, too low income and too low expenses.
The LedgerSMB team recommends consulting an accountant if this bug
affects your books or contact a LedgerSMB consultant to identify if
your books are affected (e.g. from
https://ledgersmb.org/content/commercial-support).
For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.6.21/README.md
The release can be downloaded from our download site at
https://download.ledgersmb.org/f/Releases/1.6.21
The release can be downloaded from GitHub at
https://github.com/ledgersmb/LedgerSMB/releases/tag/1.6.21
Or pulled from Docker Hub using the command
$ docker pull ledgersmb/ledgersmb:1.6.21
These are the sha256 checksums of the uploaded files:
d64ae4d5a457a8bc6096982b0fde6d8002df29b59831a0940136519b915ed482 ledgersmb-1.6.21.tar.gz
2cca4d598c02e701c0e80e562ce7c23f83ce40f8aadc1ea27b40273311b0ddc0 ledgersmb-1.6.21.tar.gz.asc
The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:
Changelog for 1.7.14
* Fix AR/AP account being reset to default on transaction Update-s (#4599)
* Fix CSV, ODS or TXT reports being downloaded without extensions (#4613)
* Fix 'To pay' amount resetting on second updates in single payments (#4633)
* Fix 'Paid' amount incorrect when 'Apply discount' unchecked (#4514)
* Fix income statement failing to filter on invoice reporting units (#4615)
* Fix payment discount not being posted (#4616)
* Fix tax base and amount doubled on printed invoice (#4645)
For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.7.14/README.md
The release can be downloaded from our download site at
https://download.ledgersmb.org/f/Releases/1.7.14
The release can be downloaded from GitHub at
https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.14
Or pulled from Docker Hub using the command
$ docker pull ledgersmb/ledgersmb:1.7.14
These are the sha256 checksums of the uploaded files:
3d66daeaf62e6c236d168619d8ebf2f5f7e2adf4505c36f334ec507445614d48 ledgersmb-1.7.14.tar.gz
5969e1e883cc8339d501f74ed91da1479519237f18fd2f1fdca2874b1c338710 ledgersmb-1.7.14.tar.gz.asc
Hello,
I'm trying to upgrade an ancient LSMB (1.2.26) to a slightly less
ancient one (1.3.47) and the upgrade is not going smoothly, as you might
imagine.
This error is present in the database log:
2020-04-16 11:42:42 BST ERROR: role "lsmb_<?lsmb dbname ?>__part_edit" does not exist
2020-04-16 11:42:42 BST STATEMENT: GRANT "lsmb_testbooks__file_read" TO "lsmb_<?lsmb dbname ?>__part_edit";
which seems to relate to line 707 in sql/modules/Roles.sql:
GRANT "lsmb_<?lsmb dbname ?>__file_read" TO "lsmb_<?lsmb dbname ?>__part_edit";
So, it looks like the substitution of the second dbname token in that
line is not happening.
Can you suggest any reason why that might be and how/where I should go
about fixing it?
Thanks very much,
Pete
--
Openstrike - improving business through open source
https://www.openstrike.co.uk/ or call 01722 770036
Hi,
As promised on my GitHub Sponsors account (
https://github.com/sponsors/ehuelsmann) I've drawn up a selection of bugs
that I'm ready to take on. The community will be offered an opportunity to
help select the bug that adds most value when being solved.
These are up for selection:
* Cannot delete business unit class
A bug reported for 1.7; for details see
https://github.com/ledgersmb/LedgerSMB/issues/4597
* AR Search for using salesperson doesn't filter
A bug reported for 1.7; for details see
https://github.com/ledgersmb/LedgerSMB/issues/4604
* Adding a reporting unit fails under some circumstances
A bug reported for 1.7; for details see
https://github.com/ledgersmb/LedgerSMB/issues/4614
* Payment discounts not posted
A bug reported for 1.7; for details see
https://github.com/ledgersmb/LedgerSMB/issues/4616
* Filtering the income statement by salesperson doesn't filter
A bug reported for 1.7 as
https://github.com/ledgersmb/LedgerSMB/issues/4615
Please provide your feedback by Wednesday May 20. Please note that sponsors
get an actual vote; all others provide advisory feedback.
If you most-wanted bug isn't in this list, please mail me directly about
that and I'll check to see if I can add it to the list on its next
iteration. Before you mail me, please make sure your bug is registered as a
bug on GitHub (https://github.com/ledgersmb/LedgerSMB/issues).
--
Thanks!
Erik.
http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
Hello Sir,
A gentle follow up with regards to exporting details.
thank you and best regards,
Ryle.Msinc/ITDept
On Monday, 4 May 2020, 12:19:19 pm GMT+8, <users-request(a)lists.ledgersmb.org> wrote:
Send users mailing list submissions to
users(a)lists.ledgersmb.org
To subscribe or unsubscribe via email, send a message with subject or
body 'help' to
users-request(a)lists.ledgersmb.org
You can reach the person managing the list at
users-owner(a)lists.ledgersmb.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users digest..."
Today's Topics:
1. Data Center Build Technician (udayfield03(a)gmail.com)
2. LedgerSMB 1.7.12 released (Erik Huelsmann)
3. Re: Exporting Detailed Vendor List (Erik Huelsmann)
4. Re: Import Sales and purchases (Erik Huelsmann)
5. Re: Exporting Detailed Vendor List (Ryle Zabate)
----------------------------------------------------------------------
Date: Mon, 27 Apr 2020 13:08:51 -0000
From: udayfield03(a)gmail.com
Subject: [ledgersmb-users] Data Center Build Technician
To: users(a)lists.ledgersmb.org
Message-ID: <158799293109.3356.14468310243343504016@6a93023516d7>
Content-Type: text/plain; charset="utf-8"
Data Center Build Technician is responsible for identifying and troubleshooting any issues with basic network and operating system installation and configuration. The professional must examine and evaluate quality assurance of server hardware. They should professionally troubleshoot any hardware issues with the help of trouble tickets. The expert will offer assistance for automated provisioning system for new server orders.
https://www.fieldengineer.com/skills/data-center-build-technician
------------------------------
Date: Mon, 27 Apr 2020 16:49:46 +0000 (UTC)
From: Erik Huelsmann <erik(a)efficito.com>
Subject: [ledgersmb-users] LedgerSMB 1.7.12 released
To: announce(a)lists.ledgersmb.org, users(a)lists.ledgersmb.org,
devel(a)lists.ledgersmb.org
Message-ID: <20200427164946.6DEF2103009F(a)s.efficito.com>
The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:
Changelog for 1.7.12
* Reconciliation reports list now shows usernames rather than user ids (#4388)
* Single payment interface throws error without open invoices (#4529)
* Fix CSV data imports discading the first row (#4567)
* Improve Chart of Accounts import no longer discards heading (#4567)
For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.7.12/README.md
The release can be downloaded from our download site at
https://download.ledgersmb.org/f/Releases/1.7.12
The release can be downloaded from GitHub at
https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.12
Or pulled from Docker Hub using the command
$ docker pull ledgersmb/ledgersmb:1.7.12
These are the sha256 checksums of the uploaded files:
9f25e4a4ff7ac15d4cef7f9d615548b9866fc41fe40d5891c34b1d802157e532 ledgersmb-1.7.12.tar.gz
6537bd20015615a9f10e42e72bc9e1bb8d8a8d039152c2bf41a280100e97d50d ledgersmb-1.7.12.tar.gz.asc
------------------------------
Date: Sun, 3 May 2020 14:43:43 +0200
From: Erik Huelsmann <ehuels(a)gmail.com>
Subject: [ledgersmb-users] Re: Exporting Detailed Vendor List
To: Ryle Zabate <ryle_23(a)ymail.com>
Cc: "users(a)lists.ledgersmb.org" <users(a)lists.ledgersmb.org>, Paulo
Haneva <phaneva(a)multistylespecialist.com>
Message-ID:
<CACOoB6ihqwzmsVCpjZ++vS2+noN0pajDGL7GRy8Pgv6z_JVx-w(a)mail.gmail.com>
Content-Type: multipart/alternative;
boundary="0000000000006cd5ab05a4bdc475"
--0000000000006cd5ab05a4bdc475
Content-Type: text/plain; charset="UTF-8"
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.
--0000000000006cd5ab05a4bdc475
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div dir=3D"ltr"><div>Hi Ryle,</div><div><br></div></div><=
br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri,=
Apr 24, 2020 at 10:27 AM Ryle Zabate <<a href=3D"mailto:ryle_23@ymail.c=
om">ryle_23(a)ymail.com</a>> wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><div><div style=3D"font-family:Helvetica Neue,Helvetic=
a,Arial,sans-serif;font-size:16px"><div>I am trying to export vendor list b=
ut the reporting only displays a limited column.<div dir=3D"ltr"></div></di=
v></div></div></blockquote><div>=C2=A0</div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex"><div><div style=3D"font-family:Helvetica Neue,Helvetica,=
Arial,sans-serif;font-size:16px"><div><div dir=3D"ltr">My question is how c=
an I export detailed vendor information list either by extrating it to an s=
preadsheet or pdf format.</div></div></div></div></blockquote><div><br></di=
v><div>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 extr=
act the desired information. We're working on building web-APIs (web se=
rvices) which should partially address this problem.</div><div><br></div><d=
iv>Maybe I can help you by telling you the query you need to retrieve the d=
esired fields? Please let me know which fields you'd want to include in=
the export.</div><div><br></div><div>Regards,<br></div><br></div>-- <br><d=
iv dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Bye,<div><br></di=
v><div>Erik.</div><div><br></div><div><a href=3D"http://efficito.com/" targ=
et=3D"_blank">http://efficito.com</a>=C2=A0-- Hosted accounting and ERP.</d=
iv><div>Robust and Flexible. No vendor lock-in.</div></div></div></div>
--0000000000006cd5ab05a4bdc475--
------------------------------
Date: Sun, 3 May 2020 15:44:15 +0200
From: Erik Huelsmann <ehuels(a)gmail.com>
Subject: [ledgersmb-users] Re: Import Sales and purchases
To: joefrancois(a)gmail.com
Cc: users(a)lists.ledgersmb.org
Message-ID:
<CACOoB6gNun89qZjgBP-K+1pykoeU17L4-9SDs1HJTw8dd6T5YQ(a)mail.gmail.com>
Content-Type: multipart/alternative;
boundary="000000000000e7c4e905a4be9c8a"
--000000000000e7c4e905a4be9c8a
Content-Type: text/plain; charset="UTF-8"
Hi Joe,
On Sun, Apr 26, 2020 at 1:44 AM <joefrancois(a)gmail.com> wrote:
> I am testing Ledgersmb to see if it is a fit. I am currently using Shopify
> for shopping cart and I sell on Amazon. Therefore, I will need to sync my
> orders and inventory with each of the platform. I look around and I can't
> see how to upload data to Ledgersmb. I would also find it useful for
> migration. Any hints?
>
>
You have a very good point. There's little documentation around on how to
do the two things you mentioned: (1) initializing a database (e.g. from
another accounting system) and (2) keeping the database in sync with a
second administration (such as your shopping cart).
There are a few somewhat hidden import features; depending on your
use-case, that might be enough - or not.
* Import of a Chart of accounts - allows one to initialize all accounts
without creating them manually one-by-one
Can be found under "General Journal > Import Chart of Accounts"
* Import of a journal entry - allows one to import a (large) journal entry
without manually entering it
Can be found under "General Journal > Import"
* Import of Goods/Services/Overhead - allows one to bulk-define
goods(inventory-based parts)/services(non-inventory parts)/overhead
Can be found under "Goods and Services > Import"
Inventory can be imported through "Goods and Services > Import >
Inventory": it will set up the accounting correctly to account for the cost
of goods sold on sale and add to the inventory asset account. There's one
thing though: I've overhauled the code which does the inventory adjustments
through the UI, but from the first look at the code, it seems this code
wasn't part of that rewrite. I'd love to help you to address that problem
when you run into it though.
Regards,
--
Bye,
Erik.
http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
--000000000000e7c4e905a4be9c8a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div dir=3D"ltr"><div>Hi Joe,</div></div><br><div class=3D=
"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, Apr 26, 2020 at=
1:44 AM <<a href=3D"mailto:joefrancois@gmail.com">joefrancois(a)gmail.com=
</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
I am testing Ledgersmb to see if it is a fit. I am currently using Shopify =
for shopping cart and I sell on Amazon. Therefore, I will need to sync my o=
rders and inventory with each of the platform. I look around and I can'=
t see how to upload data to Ledgersmb. I would also find it useful for migr=
ation. Any hints?<br>
<br clear=3D"all"></blockquote></div><div><br></div><div>You have a very go=
od point. There's little documentation around on how to do the two thin=
gs you mentioned: (1) initializing a database (e.g. from another accounting=
system) and (2) keeping the database in sync with a second administration =
(such as your shopping cart).</div><div><br></div><div>There are a few some=
what hidden import features; depending on your use-case, that might be enou=
gh - or not.</div><div><br></div><div>* Import of a Chart of accounts - all=
ows one to initialize all accounts without creating them manually one-by-on=
e</div><div>=C2=A0 Can be found under "General Journal > Import Cha=
rt of Accounts"<br></div><div>* Import of a journal entry - allows one=
to import a (large) journal entry without manually entering it</div><div>=
=C2=A0 Can be found under "General Journal > Import"</div><div=
>* Import of Goods/Services/Overhead - allows one to bulk-define goods(inve=
ntory-based parts)/services(non-inventory parts)/overhead</div><div>=C2=A0 =
Can be found under "Goods and Services > Import"</div><div><br=
></div><div>Inventory can be imported through "Goods and Services >=
Import > Inventory": it will set up the accounting correctly to ac=
count for the cost of goods sold on sale and add to the inventory asset acc=
ount. There's one thing though: I've overhauled the code which does=
the inventory adjustments through the UI, but from the first look at the c=
ode, it seems this code wasn't part of that rewrite. I'd love to he=
lp you to address that problem when you run into it though.</div><div><br><=
/div><div>Regards,<br></div><div><br></div>-- <br><div dir=3D"ltr" class=3D=
"gmail_signature"><div dir=3D"ltr">Bye,<div><br></div><div>Erik.</div><div>=
<br></div><div><a href=3D"http://efficito.com/" target=3D"_blank">http://ef=ficito.com</a>=C2=A0-- Hosted accounting and ERP.</div><div>Robust and Flex=
ible. No vendor lock-in.</div></div></div></div>
--000000000000e7c4e905a4be9c8a--
------------------------------
Date: Mon, 4 May 2020 04:07:47 +0000 (UTC)
From: Ryle Zabate <ryle_23(a)ymail.com>
Subject: [ledgersmb-users] Re: Exporting Detailed Vendor List
To: Erik Huelsmann <ehuels(a)gmail.com>
Cc: "users(a)lists.ledgersmb.org" <users(a)lists.ledgersmb.org>, Paulo
Haneva <phaneva(a)multistylespecialist.com>
Message-ID: <721214468.500394.1588565267892(a)mail.yahoo.com>
Content-Type: multipart/alternative;
boundary="----=_Part_500393_105753376.1588565267890"
------=_Part_500393_105753376.1588565267890
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
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 sp=
readsheet 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 w=
hich each vendor like company name, email address, contact numbers, tin num=
ber 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=20
On Sunday, 3 May 2020, 08:43:57 pm GMT+8, Erik Huelsmann <ehuels(a)gmail.=
com> wrote: =20
=20
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.
=C2=A0
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 shoul=
d partially address this problem.
Maybe I can help you by telling you the query you need to retrieve the desi=
red fields? Please let me know which fields you'd want to include in the ex=
port.
Regards,
--=20
Bye,
Erik.
http://efficito.com=C2=A0-- Hosted accounting and ERP.Robust and Flexible. =
No vendor lock-in. =20
------=_Part_500393_105753376.1588565267890
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
<html><head></head><body><div class=3D"ydp12eea8yahoo-style-wrap" style=3D"=
font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><=
div><div dir=3D"ltr" data-setdir=3D"false">Greetings.</div><div dir=3D"ltr"=
data-setdir=3D"false">Hello Eric, Thank you for your response.</div><div d=
ir=3D"ltr" data-setdir=3D"false">Indeed, I cannot find any export button on=
the AP/Vendor Report.</div><div dir=3D"ltr" data-setdir=3D"false">My objec=
tive is to to generate an spreadsheet file either by copying and pasting it=
on file.</div><div dir=3D"ltr" data-setdir=3D"false">I am familiar with th=
e basic SQL command but i am not familiar with the table structure of the L=
SMB database.</div><div dir=3D"ltr" data-setdir=3D"false">The field that i =
want to extract are the basic information which each vendor like company na=
me, email address, contact numbers, tin number and other relevant details p=
ertaining vendor profile.</div><div dir=3D"ltr" data-setdir=3D"false"><br><=
/div><div dir=3D"ltr" data-setdir=3D"false">Hope you can help me on which t=
able i should refer to extract these details.</div><div dir=3D"ltr" data-se=
tdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=3D"false">Best Regard=
s and Keep Safe!</div><div dir=3D"ltr" data-setdir=3D"false"><br></div><div=
dir=3D"ltr" data-setdir=3D"false"><br></div><div dir=3D"ltr" data-setdir=
=3D"false"><br></div><div><br></div><div class=3D"ydp12eea8signature"><font=
class=3D"ydp12eea8Apple-style-span" face=3D"courier, monaco, monospace, sa=
ns-serif" color=3D"#0080ff">Ryle.Msinc/ITDept</font></div></div>
<div><br></div><div><br></div>
=20
</div><div id=3D"ydp1841c2a2yahoo_quoted_8851546141" class=3D"ydp18=
41c2a2yahoo_quoted">
<div style=3D"font-family:'Helvetica Neue', Helvetica, Arial, s=
ans-serif;font-size:13px;color:#26282a;">
=20
<div>
On Sunday, 3 May 2020, 08:43:57 pm GMT+8, Erik Huelsman=
n <ehuels(a)gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id=3D"ydp1841c2a2yiv8352600783"><div><div dir=3D"=
ltr"><div dir=3D"ltr"><div>Hi Ryle,</div><div><br clear=3D"none"></div></di=
v><br clear=3D"none"><div class=3D"ydp1841c2a2yiv8352600783gmail_quote"><di=
v class=3D"ydp1841c2a2yiv8352600783gmail_attr" dir=3D"ltr">On Fri, Apr 24, =
2020 at 10:27 AM Ryle Zabate <<a shape=3D"rect" href=3D"mailto:ryle_23@y=
mail.com" rel=3D"nofollow" target=3D"_blank">ryle_23(a)ymail.com</a>> wrot=
e:<br clear=3D"none"></div><blockquote class=3D"ydp1841c2a2yiv8352600783gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex;"><div><div style=3D"font-family:Helvetica Neue, H=
elvetica, Arial, sans-serif;font-size:16px;"><div>I am trying to export ven=
dor list but the reporting only displays a limited column.<div dir=3D"ltr">=
</div></div></div></div></blockquote><div> </div><blockquote class=3D"=
ydp1841c2a2yiv8352600783gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex;"><div><div style=3D"fo=
nt-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><di=
v><div dir=3D"ltr">My question is how can I export detailed vendor informat=
ion list either by extrating it to an spreadsheet or pdf format.</div></div=
></div></div></blockquote><div><br clear=3D"none"></div><div>To be honest, =
there's currently no standard way to do that from inside the application. Y=
ou'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 ad=
dress this problem.</div><div><br clear=3D"none"></div><div>Maybe I can hel=
p you by telling you the query you need to retrieve the desired fields? Ple=
ase let me know which fields you'd want to include in the export.</div><div=
class=3D"ydp1841c2a2yiv8352600783yqt2639244909" id=3D"ydp1841c2a2yiv835260=
0783yqtfd85895"><div><br clear=3D"none"></div></div><div><div class=3D"ydp1=
841c2a2yiv8352600783yqt2639244909" id=3D"ydp1841c2a2yiv8352600783yqtfd27636=
">Regards,</div><br clear=3D"none"></div><br clear=3D"none"></div>-- <br cl=
ear=3D"none"><div class=3D"ydp1841c2a2yiv8352600783gmail_signature" dir=3D"=
ltr"><div dir=3D"ltr">Bye,<div><br clear=3D"none"></div><div>Erik.</div><di=
v><br clear=3D"none"></div><div><a shape=3D"rect" href=3D"http://efficito.c=
om/" rel=3D"nofollow" target=3D"_blank">http://efficito.com</a> -- Hos=
ted accounting and ERP.</div><div>Robust and Flexible. No vendor lock-in.</=
div></div></div></div></div></div></div>
</div>
</div></body></html>
------=_Part_500393_105753376.1588565267890--
------------------------------
Subject: Digest Footer
_______________________________________________
users mailing list -- users(a)lists.ledgersmb.org
To unsubscribe send an email to users-leave(a)lists.ledgersmb.org
------------------------------
End of users Digest, Vol 34, Issue 4
************************************
