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.30 Released

Submitted by LedgerSMB_Team on Sun, 03/21/2021 - 05:13

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

  • Fix Number not updated by 'Save as New' on order and quote (Erik H, #5356)
  • Performance improvements through added database indexes (Erik H)

Erik H is Erik Huelsmann

1.6.29 Released

Submitted by LedgerSMB_Team on Sun, 01/31/2021 - 11: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.29

  • Disable the broken-on-orders Schedule button on orders (Erik H, #5295)
  • Fix several LedgerSMB 1.3 migration issues (Erik H)
  • Fix dates on weekly-entry timecards (Richard W, #5336)

Erik H is Erik Huelsmann
Richard W is Richard T. Weeks

1.6.28 Released

Submitted by LedgerSMB_Team on Mon, 12/14/2020 - 22:43

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

1.6.27 Released

Submitted by LedgerSMB_Team on Sun, 09/27/2020 - 11:55

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

  • Fix sales person failing to save on AR/AP Transactions (Aung ZW, 5115)
  • Fix 'Manager' drop down not populated in employee page (Erik H, #5125)
  • Fix contact screen buttons populating customer on invoice/... (Erik H, #932)

Aung ZW is Aung Zaw Win
Erik H is Erik Huelsmann

1.6.26 Released

Submitted by LedgerSMB_Team on Fri, 09/18/2020 - 00: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.26

1.6.25 Released

Submitted by LedgerSMB_Team on Sun, 09/13/2020 - 12:18

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

1.6.24 Released

Submitted by LedgerSMB_Team on Fri, 09/04/2020 - 12:15

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

Does LedgerSMB support "sub-accounts"?

Submitted by ehu on Thu, 07/30/2020 - 09:50

Yes. LedgerSMB has a mechanism called "Account headings". The headings are the opposite of what Intuit explains about Quickbooks for their subaccount support: Quickbooks splits an account into multiple and aggregates those new accounts into the old one for reporting. To achieve the same in LedgerSMB, you create multiple accounts and one or more headings. LedgerSMB then aggregates the totals of the accounts per heading. The system used by LedgerSMB closely resembles what MYOB describes about their accounts and headers.

Subscribe to 1.6