1.6

How do I restore my data?

Submitted by ehu on Mon, 05/13/2013 - 13:04

Assuming you have followed the How Do I Backup My Data instructions, you can restore your database as follows...

1) Restore the roles

$ psql -h [database host] -U [database admin user] < [roles backup file]

For example:

$ psql -h localhost -U lsmb_dbadmin < lsmb-roles.sqlc

2) Create a new database to restore into

$ psql -h [database host] -U [database admin user] -c 'CREATE DATABASE [new company name]'

For example:

How do I backup my data?

Submitted by Anonymous (not verified) on Tue, 11/29/2011 - 19:44

Log in to the the 'setup.pl' administrative interface, using your ledgersmb database admin user (usually "lsmb_dbadmin" or "postgres"). The default address for setup.pl is http://localhost/ledgersmb/setup.pl.

There are 2 buttons:

  • Backup database (parts, customers, accounting records, etc)
  • Backup roles (your login accounts and rights)

One creates a backup of the content of your database. The other creates a backup of the roles.

1.6.23 Released

Submitted by LedgerSMB_Team on Mon, 06/29/2020 - 02:10

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.23

  • Fix reversals of purchases failing to post due to COGS error (Erik H)

Erik H is Erik Huelsmann

For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.6.23/README.md

1.6.22 Released

Submitted by LedgerSMB_Team on Sun, 06/21/2020 - 14:03

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

Installing latest LedgerSMB using Docker Compose

Submitted by ehu on Sat, 06/20/2020 - 04:48

By far the fastest procedure for installing LedgerSMB is by using the published Docker images: Being an ERP, there are many dependencies to be installed and all of them are included in the images, with the exception of the required PostgreSQL database. There are two ways to provide the PostgreSQL functionality: by setting up a separate PostgreSQL server or by using a PostgreSQL-providing Docker container.

1.6.21 Released

Submitted by ehu on Sun, 05/31/2020 - 13:54

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

1.6.20 Released

Submitted by LedgerSMB_Team on Sat, 03/07/2020 - 07:04

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

1.6.19 Released

Submitted by LedgerSMB_Team on Mon, 02/10/2020 - 12:38

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.19

  • Fix authentication issue due to inconsistent cookie handling (Erik H)

Erik H is Erik Huelsmann

For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.6.19/README.md

1.6.18 Released

Submitted by LedgerSMB_Team on Wed, 01/22/2020 - 13:46

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.18

  • Upgrade Dojo dependency to 1.13.5 (Erik H)
  • Prevent dead-locks in response to request from timed out session (Erik H)

Erik H is Erik Huelsmann

1.6.17 Released

Submitted by LedgerSMB_Team on Thu, 12/26/2019 - 09:59

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.17

  • Allow uploading of attachments with unknown mime-types (Erik H)
  • Fix formatting on-hand (OH) column on orders to follow user settings (Erik H)
  • Fix migration of assembly data from SQL Ledger 3.2 (Yves L)

Erik H is Erik Huelsmann
Yves L is Yves Lavoie