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@lists.ledgersmb.org> wrote: Send users mailing list submissions to     users@lists.ledgersmb.org To subscribe or unsubscribe via email, send a message with subject or body 'help' to     users-request@lists.ledgersmb.org You can reach the person managing the list at     users-owner@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@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@gmail.com Subject: [ledgersmb-users] Data Center Build Technician To: users@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@efficito.com> Subject: [ledgersmb-users] LedgerSMB 1.7.12 released To: announce@lists.ledgersmb.org, users@lists.ledgersmb.org,     devel@lists.ledgersmb.org Message-ID: <20200427164946.6DEF2103009F@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@gmail.com> Subject: [ledgersmb-users] Re: Exporting Detailed Vendor List To: Ryle Zabate <ryle_23@ymail.com> Cc: "users@lists.ledgersmb.org" <users@lists.ledgersmb.org>, Paulo     Haneva <phaneva@multistylespecialist.com> Message-ID:     <CACOoB6ihqwzmsVCpjZ++vS2+noN0pajDGL7GRy8Pgv6z_JVx-w@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@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@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@gmail.com> Subject: [ledgersmb-users] Re: Import Sales and purchases To: joefrancois@gmail.com Cc: users@lists.ledgersmb.org Message-ID:     <CACOoB6gNun89qZjgBP-K+1pykoeU17L4-9SDs1HJTw8dd6T5YQ@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@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?

* 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=

</div></div></blockquote><div><br clear=3D"none"></div><div>To be honest, =

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= 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@ymail.com> Subject: [ledgersmb-users] Re: Exporting Detailed Vendor List To: Erik Huelsmann <ehuels@gmail.com> Cc: "users@lists.ledgersmb.org" <users@lists.ledgersmb.org>, Paulo     Haneva <phaneva@multistylespecialist.com> Message-ID: <721214468.500394.1588565267892@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@gmail.= com> wrote: =20 =20 Hi Ryle, On Fri, Apr 24, 2020 at 10:27 AM Ryle Zabate <ryle_23@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@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@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= 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@lists.ledgersmb.org To unsubscribe send an email to users-leave@lists.ledgersmb.org ------------------------------ End of users Digest, Vol 34, Issue 4 ************************************