The website and control panel are now one application

Until now, ledger123.com and the hosting control panel were two separate applications. The website lived in one place and the panel where you created datasets, took backups and managed your logins lived in another, at account.ledger123.com.

They are now one application, at ledger123.com.

If you already have a hosting account

Nothing to do. Your account came across with your company datasets, and your existing email address and password still work.

Sign in at ledger123.com/signin and you will find your datasets on the dashboard, along with backups and the link through to SQL-Ledger, exactly as before.

The one thing that has changed is the address. If you had account.ledger123.com bookmarked, that address is no longer in service — use ledger123.com instead, and update the bookmark while you are there.

If something does not look right

Please tell us rather than working around it. Email [email protected] — with your account email address and, if it is dataset-specific, the dataset name — and we will sort it out.

Why we did it

One application instead of two means one place to sign in, one set of sessions, and one codebase to keep secure and up to date. It also means the things we improve — the signup flow, the dashboard, backups — reach everyone at once instead of being fixed twice or, more honestly, once.

Issue with Editing Assemblies in SQL-Ledger

Original Question by arblake (November 9, 2009):

I have many assemblies and sub-assemblies. I created a new assembly, added items, and saved it. Now I wish to add more items. After adding, updating, and saving, the assembly shows the correct dollar value, but when I open the assembly, the added parts are not listed. Why is this happening, and how do I resolve the problem?


Response by dws (November 17, 2009):

You cannot change an assembly which has been sold or stocked by simply editing it. You have to use the Changeup function to make the changes.


Summary and Solution

Understanding the Issue

  • Problem: After adding new items to an existing assembly and saving it, the assembly’s dollar value updates correctly, but the newly added parts do not appear when reopening the assembly.
  • Cause: This issue occurs because the assembly has already been sold or stocked, and direct edits to such assemblies are not permitted in SQL-Ledger’s standard editing mode.

Solution: Use the Changeup Function

  • Changeup Function: SQL-Ledger provides a Changeup function specifically designed to modify assemblies that have already been sold or stocked.
  • Steps to Resolve:
    1. Access the Changeup Function:
      • Navigate to the assembly you wish to modify.
      • Look for the Changeup option, which may be located in the assembly’s menu or toolbar.
    2. Modify the Assembly:
      • Use the Changeup interface to add or remove items from the assembly.
      • Update quantities, descriptions, or other relevant details as needed.
    3. Save Changes:
      • After making the necessary adjustments, save the changes through the Changeup function.
      • This ensures that all changes are properly recorded and reflected in the system.

Why Direct Editing Doesn’t Work

  • Integrity of Historical Data: SQL-Ledger prevents direct edits to sold or stocked assemblies to maintain the integrity of historical transaction data.
  • Proper Tracking: Using the Changeup function allows the system to track changes over time, ensuring accurate inventory management and accounting.