# Problem with customers account balances

**URL:** <https://forum.manager.io/t/problem-with-customers-account-balances/34465>\
**Category:** Uncategorized\
**Created:** [April 24, 2021, 11:17am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465 "2021-04-24T11:17:37Z")\
**Posts on this page:** 18\
**Page:** 2

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [April 26, 2021, 10:00am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/21 "2021-04-26T10:00:23Z")

</div>

> [@Tut](#):
>
> So you cannot receive money from one defined customer against an invoice for another.

Ideally, but that wasn’t the case until just a few days ago.

> [@Tut](#):
>
> you cannot enter them in the `Paid by` field as a _Customer_, but must select _Other_.

OP never had this information before his work was ruined.

Anyway, @lubos the biggest issue facing manager right now is an update or a feature ruining virtually unlimited amount of work, and the perpetual setup is only making things worse in this regard.

I really feel for @ibdek right now. Regardless of whether his original entry was erroneous or not, no one should ever suffer for a mistake that didn’t use to be a mistake a day ago. Your government cannot illegalize cigarettes in 2021 and then lock you up for all the cigarettes you smoked since 2000, that’s unfair.

Anyway, I hope some measure are put in place such as:

- Preserving the integrity of user input (Cannot overstress this). The new validations should only work on the entry form level and **NO CHANGES should ever be made unless the user deliberately presses Update.** Manager needs to be more robust.
- If an update renders a previously entered transaction invalid, the transaction should remain invalid untill the user changes it themselves. Manager should only warn the users of existing invalid entries (something like Recurring Transactions notifications would do).
- Every update that changes the data structure, object relationships, validations or forms should come with an auto-backup. That should remain available untill all issues are fixed.
- Keep the columns or fields that should have been deleted as redundant backup for a while. They shouldn’t be used but they should be available just in case something goes wrong. Much like a recycle bin for columns.

In case manager cannot provide any data security measures, I believe the perpetual concept should be dropped in favor a periodic setup that allows the user to split and archive previous periods so they never have redo everything with every major update.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [April 26, 2021, 10:19am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/22 "2021-04-26T10:19:10Z")

</div>

The way I see it is that you should look into previous exports or batch update files and perform a batch update.

Another possible solution is to find most recent backup before this situation took place and download a compatible previous desktop version. You can correct for inconsistent customer discrepancies in the receipts and payments in that file and use them to batch update you live accounts. This should save you a great deal of time.

Idk if there’s any better solutions at the moment.

---

<div class="post-metadata">

**Author:** ![ibdek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibdek/32/21477_2.png) [@ibdek](https://forum.manager.io/u/ibdek)\
**Post date:** [April 26, 2021, 10:26am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/23 "2021-04-26T10:26:45Z")

</div>

Thanks. Back up is usually done at the month end. The one at hand is too far to be used now. Also there is no previous export to lay hand on now.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [April 26, 2021, 10:45am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/24 "2021-04-26T10:45:32Z")

</div>

Ok, so the exports are out of question, however, it’s not too late to use the backups.

What you should do step-by-step is this:

1. Download the previous desktop version that’s compatible with the last valid backup.
2. Open the backup using the old desktop app
3. Use batch update to correct all receipts that has different customers in the head and lines.
4. Verify the data in the desktop app.
5. If you’re happy with the data, use it to batch update your live version.

This will have no effect on any transaction entered in the live version, you will still have all your transactions post update.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [April 26, 2021, 10:47am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/25 "2021-04-26T10:47:23Z")

</div>

> [@ibdek](#):
>
> In the previous version, it was possible to select different customers in the line item. Now it is not possible but NOTE the previous transactions should not have been affected.

I’m thinking what should have upgrade script done differently. Change customer on receipt to `Other` where different customer is used on receipt and different on line items?

This way customer on receipt would not override customer on line items. Anyway, upgrade scripts are not deleting any information and everything is preserved and correctable.

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [April 26, 2021, 10:50am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/26 "2021-04-26T10:50:47Z")

</div>

> [@ibdek](#):
>
> Back up is usually done at the month end

This is probably a good time to review that policy.  
I backup my data files automatically every 15 minutes with intra daily backups keep for 2 weeks, daily backups for 1 month, weekly backup for 6 months, monthly backups indefinitely. Test data restore is done less often.

You will loose your data at some time. Work out how much it will cost you when it happens then spend wisely to minimise long term cost.

---

<div class="post-metadata">

**Author:** ![ibdek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibdek/32/21477_2.png) [@ibdek](https://forum.manager.io/u/ibdek)\
**Post date:** [April 26, 2021, 10:59am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/27 "2021-04-26T10:59:57Z")

</div>

Thanks. Please Is there a faster way to get the list of receipts with different customer in the receipt and on the line items? It is not easy to be opening every receipt and change to others for numerous customers with thousands of transactions from Aug. 2020! If I can generate only receipts entries with different customers in line, then I can possibly work it out.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [April 26, 2021, 11:01am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/28 "2021-04-26T11:01:39Z")

</div>

@ibdek do you have this issue in one business only or across multiple businesses?

---

<div class="post-metadata">

**Author:** ![ibdek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibdek/32/21477_2.png) [@ibdek](https://forum.manager.io/u/ibdek)\
**Post date:** [April 26, 2021, 11:07am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/29 "2021-04-26T11:07:25Z")

</div>

I have it on two businesses only.

---

<div class="post-metadata">

**Author:** ![ibdek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibdek/32/21477_2.png) [@ibdek](https://forum.manager.io/u/ibdek)\
**Post date:** [April 26, 2021, 11:22am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/30 "2021-04-26T11:22:07Z")

</div>

Please how do you do your auto backup every 15mins? I don’t even know the feature is on manager?

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [April 26, 2021, 11:42am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/31 "2021-04-26T11:42:09Z")

</div>

There are many more aspects to running a computer system than just installing user programs. A backup system is one component, contingency plan for when some thing fails, layers of malware protection is another.

To back up your data files you need back up software. Many packages are available depending if you run virtual of physical servers or a stand alone desktop system. Available software varies with operating system, operation complexity and required functionality. Local and off-site backup is strongly advised (three copies is the minimum).

An example is [ShadowProtect | Data Protection and Disaster Recovery Solutions | Arcserve](https://www.storagecraft.com/au/products/shadowprotect) but this may not be at all appropriate for your circumstances.

---

<div class="post-metadata">

**Author:** ![ibdek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibdek/32/21477_2.png) [@ibdek](https://forum.manager.io/u/ibdek)\
**Post date:** [April 27, 2021, 10:29am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/32 "2021-04-27T10:29:50Z")

</div>

Thank you all. The issue has been resolved now. Thanks to @lubos

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [April 27, 2021, 11:03am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/33 "2021-04-27T11:03:12Z")

</div>

> [@lubos](#):
>
> I’m thinking what should have upgrade script done differently.

Ideally the upgrade script should

1. Map old data to any new data structure in a manner which avoids (or at least minimises) any change to account balances

2. Alert the user where changes to existing record has been required (eg enter an error message in a custom field for that record).

3. Ideally historical results of published reports should be saved (static values) then the history tab on reports could then be used to display differences to the current dynamic data. So behave a bit like a reconciliation but for a report. I would mostly use this to quantify user changes but the mechanism would also pick up program changes.

A possible way of achieving that in this instance maybe

> [@Patch](#):
>
> If transaction and line item contacts don’t match
> 
> - if multiple different line item contacts then change transaction contact type to “Other”
> - if single line item contact then change transaction contact to line item contact
> - in both situations create an “Error” custom field of text type and put a descriptive message in it such as “Old receipt contract- … “ or “Contact type was customer”

In practice thinking of all potential changes, providing a translating to any new implementation and reporting all potential error for all program updates, is only ever going to be partially achievable. The difficulty of this task is exacerbated by the creative ways some uses will exploit program idiosyncrasies.

A difficult balance. Really to only way to be sure no changes adversely effect any user is to not make any program changes.

---

<div class="post-metadata">

**Author:** ![dalacor](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dalacor](https://forum.manager.io/u/dalacor)\
**Post date:** [April 27, 2021, 11:16am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/34 "2021-04-27T11:16:33Z")

</div>

How did you fix it?

---

<div class="post-metadata">

**Author:** ![ibdek](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ibdek/32/21477_2.png) [@ibdek](https://forum.manager.io/u/ibdek)\
**Post date:** [April 27, 2021, 11:22am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/35 "2021-04-27T11:22:11Z")

</div>

Lubos rendered the help.

---

<div class="post-metadata">

**Author:** ![dalacor](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dalacor](https://forum.manager.io/u/dalacor)\
**Post date:** [April 27, 2021, 11:24am UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/36 "2021-04-27T11:24:02Z")

</div>

Glad you got it working. Enjoy.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [April 27, 2021, 4:55pm UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/37 "2021-04-27T16:55:18Z")

</div>

> [@Patch](#):
>
> A difficult balance. Really to only way to be sure no changes adversely effect any user is to not make any program changes.

I don’t think that that would be possible because no one really wants to put a ceiling on manager’s growth. There’s going to be changes and there’s going to be incompatibilites.

However, you can help the users adapt as painlessly as possible by doing a few things:

1. Preserving user inputs as much as possible.

2. Ensuring backward compatibility for at least 1 month back. So users can reopen their data in previous version and make any necessary changes.

3. Manager should identify invalid data entered which clash with any default or calculated values or have been overriden. These invalid entries should be tracked and prompted to the user.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [July 5, 2026, 8:21pm UTC](https://forum.manager.io/t/problem-with-customers-account-balances/34465/38 "2026-07-05T20:21:24Z")

</div>

Closed on July 5, 2026, 8:21pm UTC

Uncategorized topics older than 3 years with no recent activity

[Previous page](https://forum.manager.io/t/problem-with-customers-account-balances/34465.md?page=1)
