1.7

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

Submitted by LedgerSMB_Team on Fri, 11/15/2019 - 12: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.7.3

1.7.2 Released

Submitted by LedgerSMB_Team on Sat, 11/02/2019 - 11:07

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

1.7.1 Released

Submitted by LedgerSMB_Team on Fri, 10/18/2019 - 06:11

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

1.7.0 Released

Submitted by LedgerSMB_Team on Fri, 10/04/2019 - 10:18

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.

This release brings support for multiple exchange rates per currency
per day -- before, only a single rate per currency was supported.
Additionally, a lot of effort went into quality assurance and code
cleanup.

Why does the acc_trans table have fewer lines after upgrading to 1.7?

Submitted by ehu on Tue, 08/27/2019 - 13:11

Short answer: Due to differences in the database schema in relation to storing foreign currency transactions.

Long answer: The database schema before 1.7 required 2 database rows in the acc_trans table to store functional currency and foreign currency amounts. As of 1.7, the schema stores these two amounts - which relate to the same journal line - into one database row. When migrating data from the old schema to the new one, the migration routine tries hard to identify pairs of rows which can be combined into a single row in the new schema.

Installing LedgerSMB 1.7

Submitted by ehu on Tue, 08/27/2019 - 12:37

Installation from tarballs

This page contains the comprehensive version with the installation instructions for LedgerSMB 1.7 targetting a production installation from release tarballs and deals with these steps:

  • Installing the LedgerSMB Perl module dependencies
  • Configuring the PostgreSQL server
  • Configuring a webserver
  • Configuring LedgerSMB

If you already have all of the above, please proceed to the "Preparing for first use" guide.

1.7 release notes

Submitted by ehu on Tue, 08/27/2019 - 06:45

What's new in LedgerSMB 1.7

  • Multiple exchange rates per currency per date
  • Deletion of template transactions
  • Transaction date now part of the purchase history report
  • UI allows addition and removal of custom `account_link` flags

New features

Multiple exchange rates per currency per date

Before 1.7, for every currency, there would be a single associated 'buy' rate (used for sales transactions) and a single associated 'sell' rate (used for puchase transactions) and some half-baked solution for foreign currencies in GL