15 May
2020
15 May
'20
8:01 a.m.
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>rg>, 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>&gt; 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@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>rg>, 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 &lt;ehuels(a)gmail.com&gt; 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>&gt; 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
************************************