- users - lists.freelock.com

Exporting Detailed Vendor List
by Ryle Zabate 04 May '20

04 May '20

Greetings,Hello Team,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. Your response is highly appreciated. Best Regards and Keep Safe Everyone! Ryle.Msinc/ITDept

2 2

LedgerSMB 1.7.12 released
by Erik Huelsmann 27 Apr '20

27 Apr '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.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

1 0

Data Center Build Technician
by udayfield03＠gmail.com 27 Apr '20

27 Apr '20

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

1 0

installing ledgersmb 1.7.11 on Ubuntu
by John O'Gorman 18 Apr '20

18 Apr '20

Hi After a fortnight of attempting to install Debian on a new Acer Aspire 3, we gave up. We have successfully installed Ubuntu and are now attempting to install LedgerSMB. Our 1st query is how to install liblocal-lib-perl and cpanminus. 1. apt install cpanminus worked fine . 2. we tried the same sort of thing with local::lib apt install liblocal-lib.perl installed without error but when we looked for where it had been installed we found it in /usr/share/local/lib.pm. Our reading of the instructions implied that it should be in my home directory in directory perl5. How do we do that? Regards John O'Gorman john(a)og.co.nz

2 1

LedgerSMB 1.7.11 released
by Erik Huelsmann 11 Apr '20

11 Apr '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.11 * Fix inventory adjustments failing to update balances (#4467) * Fix inability to delete individual vouchers from a batch (#4448) For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.7.11/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.7.11 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.11 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.7.11 These are the sha256 checksums of the uploaded files: 8df5172a1360e30ae8513766d3c42a2b0612c07f8e2810d0c55c59a9fe67dde2 ledgersmb-1.7.11.tar.gz 94417b9baedee37f76f5578e15e4fd8ce0a3a4870b174008d4c6bc987c1ce4ad ledgersmb-1.7.11.tar.gz.asc

1 0

Re: Adding parts
by fmiser 10 Mar '20

10 Mar '20

> Erik wrote: > Please find attached a replacement 'import_csv.pm' to be placed > in lib/LedgerSMB/Scripts/. > * Log into your company > After successful login, the URL will look something like: > http://localhost/login.pl?action=login&company=<your company>. > * Add '#import_csv.pl?action=begin_import&type=goods' at the end > of that URL > > The resulting page looks like a transaction upload page. Don't > mind that; simply select the CSV you want to upload and press > "Save". Should I ignore or fill in the other fields? Like "date", or "Reference", or "Description", or "Transaction"? I'm stumped. I'm not getting either the new "goods" import or the existing "inventory" import to work. Maybe the content or format of my files? Maybe something else missing in my Debian Buster (10) install? LedgerSMB is version 1.6.9 installed from package, with the content of "ledgersmb/old/bin" updated (per email of 2019-12-24) and a new "import_csv.pl" (per email of 2019-12-27). I sent a couple messages to the list with my .csv files attached. Maybe those didn't get through. Any help or hints or clues would be appreciated!! I'm getting two different errors when I try to use the new import_csv.pm. I'm not tracking down what I'm going different to get each message. A dialog box may open with this message: ******************************************* Error! Can't use an undefined value as a subroutine reference at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 517. dbversion: tester, company: 1.6.9 ******************************************** Or, I see the error "Internal Server Error" syslog reports this: ******************************************** Feb 18 01:15:03 host-smb starman[332]: Can't locate LedgerSMB/Template/UI.pm in @INC (you may need to install the LedgerSMB::Template::UI module) (@INC contains: /usr/share/ledgersmb/bin/../old/lib /usr/share/ledgersmb/bin/../lib /usr/share/ledgersmb/bin/.. lib old/lib /etc/perl /usr/local/lib/i386-linux-gnu/perl/5.28.1 /usr/local/share/perl/5.28.1 /usr/lib/i386-linux-gnu/perl5/5.28 /usr/share/perl5 /usr/lib/i386-linux-gnu/perl/5.28 /usr/share/perl/5.28 /usr/local/lib/site_perl /usr/lib/i386-linux-gnu/perl-base) at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 24. Feb 18 01:15:03 host-smb starman[332]: BEGIN failed--compilation aborted at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 24. Feb 18 01:15:03 host-smb starman[332]: Compilation failed in require at /usr/share/perl5/Module/Runtime.pm line 314. *************************************************************** #### #### #### #### #### #### #### #### #### #### Next I tried a different browser. Clean cache. Cookies reset. The error dialog box showed this: ******************************************* Error! Can't use an undefined value as a subroutine reference at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 517. dbversion: tester, company: 1.6.9 ******************************************** Syslog showed this: ******************************************** Feb 18 01:32:11 host-smb starman[332]: Req:C68BB800522011EAADB8D4835481929E 2020/02/18 01:32:11 - ERROR - LedgerSMB::PSGI::catch {...} /usr/share/ledgersmb/bin/../lib/LedgerSMB/PSGI.pm (134) -- Can't use an undefined value as a subroutine reference at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 517.\n Feb 18 01:32:11 host-smb starman[332]: Req:C68BB800522011EAADB8D4835481929E ::1 - - [18/Feb/2020:01:32:11 -0600] "POST /import_csv.pl HTTP/1.1" 500 244 "http://localhost:7777/login.pl?action=login&company=tester" "Mozilla/5.0 (X11; Linux x86_64; rv:72.0) Gecko/20100101 Firefox/72.0" ******************************************** I also tried the existing "import inventory" on the couple of items I added manually. It failed with ******************************************** Error! Can't use an undefined value as a subroutine reference at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 517. dbversion: tester, company: 1.6.9 ******************************************** Syslog reports ******************************************** Feb 18 01:44:36 host-smb starman[332]: Attempt to reload LedgerSMB/Scripts/import_csv.pm aborted. Feb 18 01:44:36 host-smb starman[332]: Compilation failed in require at /usr/share/perl5/Module/Runtime.pm line 314. ******************************************** The content of the two .csv file I'm using: ******************************************** "partnumber","description","unit","listprice","sellprice","lastcost","weight","notes","makemodel","assembly","alternate","rop","inventory_accno","income_accno","expense_accno","returns_accno","bin","bom","image","drawing","microfiche","partsgroup","avgcost","taxaccnos" "QTSm-RCAf","adapter - 1/4 inch TS plug to RCA jack","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNC75-TERM","adapter - BNC 75 ohm terminator","ea",,$2.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNC75f-BNCf","adapter - BNC barrel, 75 ohm","ea",,$4.25,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNC50f-BNCf","same as above, but 50 ohm","ea",,$2.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNCm-RCAf","adapter - BNC-m to RCA-f","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "RCAf-RCAf","adapter - RCA, barrel","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "YCm-RCAf","adapter - RCA jack to Y/C 4pin plug, signal converter","ea",,$7.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "RCAm-BNCf","adapter - RCA-m to BNC-f","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "RCAm-2RCAf-90Y","adapter - RCAm to two RCAf, 90 deg and 180 deg, wye","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "NA4LJ","adapter - Speakon to 1/4in jack","ea",,$8.25,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "YCf-YCf","adapter - Y/C 4pin barrel","ea",,$5.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "RCAm-YCf","adapter - Y/C 4pin jack to RCA plug, signal converter","ea",,$7.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "ZFSC-4-1-75","antenna - power splitter, 4-way, BNC, 75 ohm, 10-1000MHz","ea",,$140.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "PB25","box - 1/3 rack wide, project box, ProCo","ea",,$20.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1593KBK","box - 2.6x2.6x1.1 inch, black, with end panels, Hammond","ea",,$4.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "71886BK","box - 5.1x5.1x1.5, black, PacTec","ea",,$9.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "KY-BOX","box - keystone, use 1 or 2 modules, surface mount","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551ATS100","box - PCB mounting screws, #2 x 3/8 ","x100",,$15.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551NFLBK","box - tiny project box, flanged lid, short, 35x35x15 mm, black, Hammond","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551MFLBK","box - tiny project box, flanged lid, tall, 35x35x20 mm, black, Hammond","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551NBK","box - tiny project box, flush lid, short, 35x35x15 mm, black, Hammond","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551MBK","box - tiny project box, flush lid, tall, 35x35x20 mm, black, Hammond","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNCm-RCAm-06","cable assy - BNC to phono, 6ft","ea",,$8.15,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 ******************************************** ******************************************** "Part number","On hand","purchase price" "QTSm-RCAf",11,0.75 "BNCm-RCAf",22,1.50 "BNC50f-BNCf",23,5 "nl4fx",8,4.25 ******************************************** -- f

2 2

instlling Debian on Acer Aspire 3
by John O'Gorman 09 Mar '20

09 Mar '20

Hi everyone We are trying to install Debian on a new Acer Aspire 3 17in laptop. We have in the past had no trouble installing Linux on Acer Aspire V Nitro. But the Acer Aspire 3 seems to have changed their BIOS. We have contacted our supplier and the Acer support people in the Phillippines, so far to no avail. Can anyone help us how to configure the BIOS or USFI to allow us to install Debian so that it can dual boot with Debian 10? Regards John O'Gorman

1 0

An error occurred
by kmstraker＠gmail.com 08 Mar '20

08 Mar '20

I see this question being asked frequently and being solved for some but I cannot see the solution. I installed from the Ubuntu repositories and I get this error when I try to add anything. I have setup chart of accounts and now am trying to set defaults but inventory and income will not give drop down lists like the other fields did. ver 1.6.9

3 5

LedgerSMB 1.7.10 released
by Erik Huelsmann 07 Mar '20

07 Mar '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.10 * Fix error displaying NULL exchange rates (#4438) * Fix incorrect receipt totals due to number formatting (#4441) * Prevent re-approval of approved inventory adjustment (#4458) * Fix NULL transaction dates in inventory adjustment (#4463) * Fix alignment of numbers in Inventory Activity report (#4454) * Fix variance calculation on reconciliation report (#4486) * Fix CSV import through explicit version on HTTP::Headers::Fast dependecy For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.7.10/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.7.10 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.10 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.7.10 These are the sha256 checksums of the uploaded files: 0f8293675dd0c03d54cee80e5e65cd078b7fcf58aeb6f6443911cec7c0eb21e6 ledgersmb-1.7.10.tar.gz 02a00420a5837375ab15332171eda7df15d3c0e19b9d0af950745661b9c480ee ledgersmb-1.7.10.tar.gz.asc

1 0

LedgerSMB 1.6.20 released
by Erik Huelsmann 07 Mar '20

07 Mar '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.20 * Prevent re-approval of approved inventory adjustment (Erik H) * Fix NULL transaction dates in inventory adjustment (Erik H) * Fix alignment of numbers in Inventory Activity report (Erik H) Erik H is Erik Huelsmann For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.6.20/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.6.20 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.6.20 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.6.20 These are the sha256 checksums of the uploaded files: 85176d09e9f9e4a7c37c60f28239be53ab0e036ba7dd6cb28e48c15bdc291ab5 ledgersmb-1.6.20.tar.gz ca1253f8f2c62825ffc0e75ed36fff682e48b6ac37aa4a96bfce96bbdbe8d58c ledgersmb-1.6.20.tar.gz.asc

1 0