- users - lists.freelock.com

LedgerSMB 1.7.16 released
by Erik Huelsmann 21 Jun '20

21 Jun '20

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.16 * Fix migration including NULL and zero exchange rate defaults (#4673) * Fix AR Outstanding report showing negative taxes (#4688) * Remove dev-mode server-killing /stop URL (#4705) * Fix GL journal creation silently inserting 2 'gl' records (#4719) * Fix sorting hierarchical balance sheet and income statement sections (#4740) * Update Dojo dependency to 1.15.4 * Add SameSite policy on session cookie to prevent being ignored (#4748) For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.7.16/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.7.16 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.16 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.7.16 These are the sha256 checksums of the uploaded files: cb07f541d7dcf9783617702ede423e6ae563b21d6b713357e9ba59208a73a577 ledgersmb-1.7.16.tar.gz 1c83342bac95b86bbb4826f4de881573c12e3dace8f3efd9cd8e7b1458aff68d ledgersmb-1.7.16.tar.gz.asc

1 0

LedgerSMB 1.6.22 released
by Erik Huelsmann 21 Jun '20

21 Jun '20

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.22 * Update Dojo toolkit dependency to 1.13.8 (Erik H) * Fix sorting of hierarchical income statement and balance sheet (Erik H) * Fix columns not being populated in AR/AP Outstanding report (Erik H) * Add SameSite policy on session cookie to prevent being ignored (Erik H) Erik H is Erik Huelsmann For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.6.22/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.6.22 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.6.22 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.6.22 These are the sha256 checksums of the uploaded files: 8a32c183432cdf655c536d521c6951e8e0e0265d0c1ec92d77c161061e354a9e ledgersmb-1.6.22.tar.gz ce8fa58f30a8fed180ffb41740fc6c33ec02214b06e70d31410c9206d8b62fc2 ledgersmb-1.6.22.tar.gz.asc

1 0

LedgerSMB 1.8 branched / 1.8.0-beta1 released
by Erik Huelsmann 12 Jun '20

12 Jun '20

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.

1 2

LedgerSMB 1.7.15 released
by Erik Huelsmann 31 May '20

31 May '20

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

1 0

LedgerSMB 1.6.21 released
by Erik Huelsmann 31 May '20

31 May '20

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

1 0

LedgerSMB 1.7.14 released
by Erik Huelsmann 23 May '20

23 May '20

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

1 0

Replacement of tokens in SQL files
by Pete Houston 18 May '20

18 May '20

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

3 9

Selecting my next bug to work on
by Erik Huelsmann 17 May '20

17 May '20

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.

1 0

Re: users Digest, Vol 34, Issue 4
by Ryle Zabate 15 May '20

15 May '20

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

1 0

docker-compose install process for LedgerSMB
by jronpaul＠gmail.com 09 May '20

09 May '20

hi all, i am trying to test out LedgerSMB.. im following the process for the docker-compose process.. i downloaded the docker-compose.yml file.. then ran docker-compose pull which seemed to work fine and then docker-compose up which seemed to work fine. this is on a linux mint 19 VM in virtualbox. i assume i missed something, but the docker image and ps commands show that it claims to be running on 5762 but if i do a lsof -i i dont see it running and if i do 127.0.0.1:5762 i get nothing. here is my pull output *docker-compose pull* Pulling postgres (postgres:9.6-alpine)... 9.6-alpine: Pulling from library/postgres aad63a933944: Pull complete a5b4c973b808: Pull complete 074a034a3a7a: Pull complete f0cc5c471b46: Pull complete 5b515caa102b: Pull complete ff417e23115a: Pull complete 15675b8430d7: Pull complete a92cb200dd03: Pull complete 056ca6be8aef: Pull complete Digest: sha256:aab62d85087bbd115c20c0dfb4b1e8dd4fcb4b66c2bbe914d91776f2121ec719 Status: Downloaded newer image for postgres:9.6-alpine Pulling lsmb (ledgersmb/ledgersmb:1.5)... 1.5: Pulling from ledgersmb/ledgersmb 02d147d36283: Pull complete 162568cc8531: Pull complete bb6b4d3a3590: Pull complete f6028461b82d: Pull complete 7dd471d87c20: Pull complete b30fa3988f1b: Pull complete Digest: sha256:23ff0d72c31132070f27e10228a136a033144da096c95e5605e2510aa7c29224 Status: Downloaded newer image for ledgersmb/ledgersmb:1.5 here is my "up" output *docker-compose up* Creating ledgersmb_postgres_1 ... Creating ledgersmb_postgres_1 ... done Creating ledgersmb_lsmb_1 ... Creating ledgersmb_lsmb_1 ... done Attaching to ledgersmb_postgres_1, ledgersmb_lsmb_1 postgres_1 | postgres_1 | PostgreSQL Database directory appears to contain a database; Skipping initialization postgres_1 | postgres_1 | LOG: database system was shut down at 2020-04-20 01:56:03 UTC postgres_1 | LOG: MultiXact member wraparound protections are now enabled postgres_1 | LOG: database system is ready to accept connections postgres_1 | LOG: autovacuum launcher started lsmb_1 | maybe: /usr/lib/perl5 lsmb_1 | Selected PERL5LIB=/usr/lib/perl5 lsmb_1 | 2020/04/20-02:00:45 Starman::Server (type Net::Server::PreFork) starting! pid(1) lsmb_1 | Resolved [*]:5762 to [::]:5762, IPv6 lsmb_1 | Not including resolved host [0.0.0.0] IPv4 because it will be handled by [::] IPv6 lsmb_1 | Binding to TCP port 5762 on host :: with IPv6 lsmb_1 | Setting gid to "33 33" lsmb_1 | Starting Worker on PID 1 Using Built Dojo other info * docker container ls* CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 092fd5beda65 ledgersmb/ledgersmb:1.5 "start.sh" 12 minutes ago Up 12 minutes 5762/tcp ledgersmb_lsmb_1 6dac19991470 postgres:9.6-alpine "docker-entrypoint.s…" 12 minutes ago Up 12 minutes 5432/tcp ledgersmb_postgres_1 *docker-compose images * Container Repository Tag Image Id Size -------------------------------------------------------------------------------- ledgersmb_lsmb_1 ledgersmb/ledgersmb 1.5 be467de7a19e 460 MB ledgersmb_postgres_1 postgres 9.6-alpine c0d2dcd3fa66 34.4 MB *docker-compose version* docker-compose version 1.17.1, build unknown docker-py version: 2.5.1 CPython version: 2.7.17 OpenSSL version: OpenSSL 1.1.1 11 Sep 2018 *docker version * Client: Version: 19.03.6 API version: 1.40 Go version: go1.12.17 Git commit: 369ce74a3c Built: Fri Feb 28 23:45:43 2020 OS/Arch: linux/amd64 Experimental: false Server: Engine: Version: 19.03.6 API version: 1.40 (minimum version 1.12) Go version: go1.12.17 Git commit: 369ce74a3c Built: Wed Feb 19 01:06:16 2020 OS/Arch: linux/amd64 Experimental: false containerd: Version: 1.3.3-0ubuntu1~18.04.2 GitCommit: runc: Version: spec: 1.0.1-dev GitCommit: docker-init: Version: 0.18.0 GitCommit: * docker info * Client: Debug Mode: false Server: Containers: 2 Running: 2 Paused: 0 Stopped: 0 Images: 2 Server Version: 19.03.6 Storage Driver: overlay2 Backing Filesystem: extfs Supports d_type: true Native Overlay Diff: true Logging Driver: json-file Cgroup Driver: cgroupfs Plugins: Volume: local Network: bridge host ipvlan macvlan null overlay Log: awslogs fluentd gcplogs gelf journald json-file local logentries splunk syslog Swarm: inactive Runtimes: runc Default Runtime: runc Init Binary: docker-init containerd version: runc version: init version: Security Options: apparmor seccomp Profile: default Kernel Version: 5.3.0-46-generic Operating System: Linux Mint 19.3 OSType: linux Architecture: x86_64 CPUs: 1 Total Memory: 1.941GiB Name: test-VirtualBox ID: 5RM6:BNRV:L7UR:PZSQ:RZUA:IAYP:J3GN:CFXV:SF5P Docker Root Dir: /var/lib/docker Debug Mode: false Registry: https://index.docker.io/v1/ Labels: Experimental: false Insecure Registries: 127.0.0.0/8 Live Restore Enabled: false WARNING: No swap limit support

3 2