On Monday, 4 May 2020, 12:19:19 pm GMT+8, <..hidden..> wrote:
Send users mailing list submissions to
To subscribe or unsubscribe via email, send a message with subject or
body 'help' to
You can reach the person managing the list at
When replying, please edit your Subject line so it is more specific
than "Re: Contents of users digest..."
Today's Topics:
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
Subject: [ledgersmb-users] Data Center Build Technician
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.
------------------------------
Date: Mon, 27 Apr 2020 16:49:46 +0000 (UTC)
Subject: [ledgersmb-users] LedgerSMB 1.7.12 released
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
The release can be downloaded from our download site at
The release can be downloaded from GitHub at
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
Subject: [ledgersmb-users] Re: Exporting Detailed Vendor List
Message-ID:
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 <
..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.
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="" href="mailto:ryle_23@ymail.c" rel="nofollow" target="_blank">ryle_23@ymail.c=
om">
..hidden..</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="" href="http://efficito.com/" rel="nofollow" target="_blank">http://efficito.com/" targ=
iv><div>Robust and Flexible. No vendor lock-in.</div></div></div></div>
--0000000000006cd5ab05a4bdc475--
------------------------------
Date: Sun, 3 May 2020 15:44:15 +0200
Subject: [ledgersmb-users] Re: Import Sales and purchases
Message-ID:
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 <
..hidden..> 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.
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="" href="mailto:..hidden.." rel="nofollow" target="_blank">..hidden..">
..hidden..=
</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="" href="http://efficito.com/" rel="nofollow" target="_blank">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)
Subject: [ledgersmb-users] Re: Exporting Detailed Vendor List
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@gmail.=
com> wrote: =20
=20
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.
=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.
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=
</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="" href="mailto:ryle_23@y" rel="nofollow" target="_blank">ryle_23@y=
mail.com" rel=3D"nofollow" target=3D"_blank">
..hidden..</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="" href="http://efficito.c=" rel="nofollow" target="_blank">http://efficito.c=
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
_______________________________________________
------------------------------
End of users Digest, Vol 34, Issue 4
************************************
