96c499786c
Finally have a (slightly kludgy) fix for keeping the 'collected' grid from being rendered before ready.
abijah
2009-08-11 07:24:52 +00:00
9fe55bd782
Fixed bug with display on the bank deposit page, caused by reusing a class name in the edit tender page.
abijah
2009-08-11 07:21:34 +00:00
52e0181bfb
Fixed bug with display on the bank deposit page, caused by reusing a class name in the edit tender page.
abijah
2009-08-11 07:21:34 +00:00
f8cb1e2ef7
Added ability to rename columns on a case by case basis
abijah
2009-08-11 07:15:04 +00:00
b65c5c1dbf
Added ability to rename columns on a case by case basis
abijah
2009-08-11 07:15:04 +00:00
cbdce4f166
Added the gridview parameter, since we're not doing anything too complicated with grids. Updated the jqGrid css, some of which is just not longer needed, and some of which is broken by the move to jqGrid 3.5
jqgrid_3.5
abijah
2009-08-11 07:08:54 +00:00
e9b9bdc420
Preliminary move to jqGrid 3.5.1. It has proven troublesome to change over, although really, I've only found one compatibility break so far. The real problem has been the elimination of the jqGrid loader code. We now have to build the jqGrid package through a selection form on the jqGrid download page, and the errors made it difficult to determine that the package configuration was the problem (such as destroying the entire page content). It's working alright at the moment.
abijah
2009-08-11 04:43:33 +00:00
704412727d
Branch to roll up to the 3.5 version of jqGrid
abijah
2009-08-11 04:11:45 +00:00
baa737e628
Changed invoice generation to match the receipt changes in r521 (no more debug, transition to the lease after entry, etc).
abijah
2009-08-11 01:08:39 +00:00
72af3f3247
Changed invoice generation to match the receipt changes in r521 (no more debug, transition to the lease after entry, etc).
abijah
2009-08-11 01:08:39 +00:00
aa307150c8
Whitespace only change
abijah
2009-08-11 01:07:20 +00:00
f0693bdc05
Whitespace only change
abijah
2009-08-11 01:07:20 +00:00
0727d5f091
Fixed problem when effective_date is an empty string, as opposed to completely missing.
abijah
2009-08-11 01:07:01 +00:00
15f885ab8a
Fixed problem when effective_date is an empty string, as opposed to completely missing.
abijah
2009-08-11 01:07:01 +00:00
aa65c18c39
Renamed the menu items for invoice and receipt creation.
abijah
2009-08-11 01:06:28 +00:00
b1a7f41934
Renamed the menu items for invoice and receipt creation.
abijah
2009-08-11 01:06:28 +00:00
666df07a7c
Removed the debug portions of receipt entry, and added a checkbox to allow the user to either keep entering receipts, or have the page automatically transition to the customer page.
abijah
2009-08-10 23:57:20 +00:00
4f11e27a76
Removed the debug portions of receipt entry, and added a checkbox to allow the user to either keep entering receipts, or have the page automatically transition to the customer page.
abijah
2009-08-10 23:57:20 +00:00
452deb981f
Missed adding this file on the last checkin (r519)
abijah
2009-08-10 22:24:23 +00:00
f8aef6e794
Missed adding this file on the last checkin (r519)
abijah
2009-08-10 22:24:23 +00:00
29f6d1a717
Added the ability to edit a tender. I've locked this down to just editing the data1-4 fields at the moment, since there are accounting ramifications if we were to change the tender type.
abijah
2009-08-10 22:23:47 +00:00
e100c9a88f
Added the ability to edit a tender. I've locked this down to just editing the data1-4 fields at the moment, since there are accounting ramifications if we were to change the tender type.
abijah
2009-08-10 22:23:47 +00:00
025c3a555a
Added automatic grid reload, since the default grid load is inconsistent with the displayed settings. The solution here sucks, but at least it avoids the inconsistency.
abijah
2009-08-10 22:22:56 +00:00
1ce71a3936
Added automatic grid reload, since the default grid load is inconsistent with the displayed settings. The solution here sucks, but at least it avoids the inconsistency.
abijah
2009-08-10 22:22:56 +00:00
467387a581
Removed the two dangerous links from the Debug menu, as we're preparing to enter new data and don't want to zap it.
abijah
2009-08-10 19:20:29 +00:00
19f8c18ce9
Removed the two dangerous links from the Debug menu, as we're preparing to enter new data and don't want to zap it.
abijah
2009-08-10 19:20:29 +00:00
acb8fb44be
Added the ability to accept payments (or a write-off) on a closed lease, if there is a balance owing. Added the ability to do write off bad debt at the customer level, since some charges may not be on a lease, like the NSF fee.
abijah
2009-08-10 19:01:20 +00:00
eb28852b87
Added the ability to accept payments (or a write-off) on a closed lease, if there is a balance owing. Added the ability to do write off bad debt at the customer level, since some charges may not be on a lease, like the NSF fee.
abijah
2009-08-10 19:01:20 +00:00
fea21b3ea0
Added the close date to the leases grid, to make it clear which customer leases are still open. Perhaps we should exclude the field by default, and just add it into the customer view page.
abijah
2009-08-10 19:00:02 +00:00
98f3dd7688
Added the close date to the leases grid, to make it clear which customer leases are still open. Perhaps we should exclude the field by default, and just add it into the customer view page.
abijah
2009-08-10 19:00:02 +00:00
3a248fc1b4
Added Bad Debt as one of the accounts for the collected report
abijah
2009-08-10 18:58:41 +00:00
c33a823e50
Added Bad Debt as one of the accounts for the collected report
abijah
2009-08-10 18:58:41 +00:00
d49201211b
Added confirmation to the NSF functionality, as well as a timestamp field instead of forcing time=now.
abijah
2009-08-10 05:49:43 +00:00
1f97e8db35
Added confirmation to the NSF functionality, as well as a timestamp field instead of forcing time=now.
abijah
2009-08-10 05:49:43 +00:00
4358732878
Changed the Deposits menu item to be at the top level, instead of underneath the Accounts menu.
abijah
2009-08-10 05:48:49 +00:00
76df8c924f
Changed the Deposits menu item to be at the top level, instead of underneath the Accounts menu.
abijah
2009-08-10 05:48:49 +00:00
fdcdc94bec
Modified NSF to use positive amounts for the ledger entries (swapping credit/debit, of course). The statement entries remain using negative amounts, as they are negative disbursements.
abijah
2009-08-10 04:46:54 +00:00
598ce5784b
Modified NSF to use positive amounts for the ledger entries (swapping credit/debit, of course). The statement entries remain using negative amounts, as they are negative disbursements.
abijah
2009-08-10 04:46:54 +00:00
9a3a24ca0c
Preventing moved-out leases in sitelink data from being closed, since the security deposit hasn't been released. Added a temporary function to release the deposit, so I can manually release and close the few leases needed.
abijah
2009-08-10 01:27:12 +00:00
cdb7d4b15c
Preventing moved-out leases in sitelink data from being closed, since the security deposit hasn't been released. Added a temporary function to release the deposit, so I can manually release and close the few leases needed.
abijah
2009-08-10 01:27:12 +00:00
35f17ed1de
Added customer since/until fields. Changed the ledger entry grid on the customers page into a receipts grid, and added it to the lease page as well, even though it is for the customer in general, and may include receipts for leases other than the one being viewed. I may put more effort into this later, but for now it solves the problem of getting the receipt tenders visible when viewing the lease.
abijah
2009-08-10 00:56:41 +00:00
07a2be05f7
Added customer since/until fields. Changed the ledger entry grid on the customers page into a receipts grid, and added it to the lease page as well, even though it is for the customer in general, and may include receipts for leases other than the one being viewed. I may put more effort into this later, but for now it solves the problem of getting the receipt tenders visible when viewing the lease.
abijah
2009-08-10 00:56:41 +00:00
bc95b31521
Added transaction model writeOff function, and a new statement_entry WRITEOFF type. Not a big deal, but it makes presentation a bit more straightforward.
abijah
2009-08-09 15:11:51 +00:00
fd1a1f43d4
Added transaction model writeOff function, and a new statement_entry WRITEOFF type. Not a big deal, but it makes presentation a bit more straightforward.
abijah
2009-08-09 15:11:51 +00:00
bd26ec7218
Added mechanism to automatically assess late fees. This uses hardcoded assumptions, since our late fee table has not yet been implemented.
abijah
2009-08-08 16:37:12 +00:00
2e2147b238
Added mechanism to automatically assess late fees. This uses hardcoded assumptions, since our late fee table has not yet been implemented.
abijah
2009-08-08 16:37:12 +00:00
8df94e9c5f
Implemented a single function to assess rent across all leases.
abijah
2009-08-08 16:09:49 +00:00
a0c00f1a35
Implemented a single function to assess rent across all leases.
abijah
2009-08-08 16:09:49 +00:00
6f62d84818
Implemented mechanism for automatic assessment of monthly rent
abijah
2009-08-08 15:44:52 +00:00
868e23b982
Implemented mechanism for automatic assessment of monthly rent
abijah
2009-08-08 15:44:52 +00:00
b02a504abb
Add refund capability to the customer, and in fact only the customer, as we've revoked refund capability from the lease. This is to help work through various issues surrounding use of security deposits and general refund functionality. For example, a customer who has overpayed (customer surplus, with zero balance on lease), and then moves out. Where that security deposit surplus goes has been a bit of a thorn. Hopefully, this resolves the issue, although there may still be some bugs to flush out.
abijah
2009-08-08 04:27:02 +00:00
e6b0313523
Add refund capability to the customer, and in fact only the customer, as we've revoked refund capability from the lease. This is to help work through various issues surrounding use of security deposits and general refund functionality. For example, a customer who has overpayed (customer surplus, with zero balance on lease), and then moves out. Where that security deposit surplus goes has been a bit of a thorn. Hopefully, this resolves the issue, although there may still be some bugs to flush out.
abijah
2009-08-08 04:27:02 +00:00
bba3af8163
Some of the finer detail work, mostly around pre-populating the move-in invoice with useful and correct data, and allowing the lease rent and deposit to be set at movein.
abijah
2009-08-07 22:52:01 +00:00
654eb0960e
Some of the finer detail work, mostly around pre-populating the move-in invoice with useful and correct data, and allowing the lease rent and deposit to be set at movein.
abijah
2009-08-07 22:52:01 +00:00
011d1208e8
Initial thoughts on the charge reversal. It's obviously not working yet, or I wouldn't leave it hanging on a branch.
alt_reversal_20090806
abijah
2009-08-07 04:20:20 +00:00
9dd09c4d2e
Branch created to save some changes/thoughts on charge reversals. As of branch creation, we're just deleting the current disbursements on the charge, and deletion is never good, since we lose information by definition. For example, the collected rents report will be adversely affected. So, we need to figure out how to keep the disbursement, and yet still have everything work out correctly. That work will be started on this branch.
abijah
2009-08-07 04:18:13 +00:00
16f7de421f
Minor tweaks, a shame for checkin r500 :-(
abijah
2009-08-07 03:55:01 +00:00
2e36d46329
Minor tweaks, a shame for checkin r500 :-(
abijah
2009-08-07 03:55:01 +00:00
c3e60a65c1
More work with security deposits, reversals, and balances. I've tried to work many different corner cases, but know that not everything has been tested. I think the next steps for testing will be to put in some real data.
abijah
2009-08-07 00:10:28 +00:00
1dd0b14861
More work with security deposits, reversals, and balances. I've tried to work many different corner cases, but know that not everything has been tested. I think the next steps for testing will be to put in some real data.
abijah
2009-08-07 00:10:28 +00:00
f900853163
Added in internal error function, since the die() statements were hard to spot, and certainly not user friendly for the end user.
abijah
2009-08-06 20:17:02 +00:00
d75cd10f49
Added in internal error function, since the die() statements were hard to spot, and certainly not user friendly for the end user.
abijah
2009-08-06 20:17:02 +00:00
0de0c7d5d7
Fixed the button text for new customers
abijah
2009-08-06 18:08:55 +00:00
a69a56c715
Fixed the button text for new customers
abijah
2009-08-06 18:08:55 +00:00
a2aa612a5e
Fixed the customer selection update for receipts, and added a mechanism to automatically update the oustanding charges grid after entering the receipt.
abijah
2009-08-06 18:08:21 +00:00
8f7cf202e5
Fixed the customer selection update for receipts, and added a mechanism to automatically update the oustanding charges grid after entering the receipt.
abijah
2009-08-06 18:08:21 +00:00
b900e49f54
Added mechanism to do a full replacement of specified post parameters, instead of just merging.
abijah
2009-08-06 18:06:57 +00:00
58c4f28956
Added mechanism to do a full replacement of specified post parameters, instead of just merging.
abijah
2009-08-06 18:06:57 +00:00
ad4e194bf9
Added ability to edit a unit, except for sort/walk order. To handle those things we'll need to: save unit's old sort/walk position; adjust down (by one) all unit positions greater than the old position; adjust up (by one) all unit positions greater than or equal to the new unit position; update the unit's position. I'm not going to worry about it right now.
abijah
2009-08-06 09:27:09 +00:00
f3eaa40ea5
Added ability to edit a unit, except for sort/walk order. To handle those things we'll need to: save unit's old sort/walk position; adjust down (by one) all unit positions greater than the old position; adjust up (by one) all unit positions greater than or equal to the new unit position; update the unit's position. I'm not going to worry about it right now.
abijah
2009-08-06 09:27:09 +00:00
a5e7366cac
Implemented refund, at least for the most part. Minor testing, but looks promising. Because of this change the customer account entries grid appears odd, with a refunds showing up as a 'Charge'. So, I'm toying with the idea of having entries show up as customer 'Debits' and 'Credits'. I don't know if this will cause user confusion, but we'll play with it for a while and see. It actually reminds me a bit (coming full circle) of the earliest implementations, which kept track of a lease on its own account/ledger, in which credit/debit would be the exact correct terms.
abijah
2009-08-06 05:11:58 +00:00
e784931fa8
Implemented refund, at least for the most part. Minor testing, but looks promising. Because of this change the customer account entries grid appears odd, with a refunds showing up as a 'Charge'. So, I'm toying with the idea of having entries show up as customer 'Debits' and 'Credits'. I don't know if this will cause user confusion, but we'll play with it for a while and see. It actually reminds me a bit (coming full circle) of the earliest implementations, which kept track of a lease on its own account/ledger, in which credit/debit would be the exact correct terms.
abijah
2009-08-06 05:11:58 +00:00
bd85ce9f51
Added ability to format currency without a dollar sign (i.e. in raw numerical format).
abijah
2009-08-06 05:04:34 +00:00
5a7b087ddc
Added ability to format currency without a dollar sign (i.e. in raw numerical format).
abijah
2009-08-06 05:04:34 +00:00
c58183c965
More work on refund. I'm going to skip the whole voucher/credit_note bit and simply present a page that lets the user enter a date, an account, and the amount to refund, recording 1 payment transaction.
abijah
2009-08-06 02:52:45 +00:00
4d62d7da73
More work on refund. I'm going to skip the whole voucher/credit_note bit and simply present a page that lets the user enter a date, an account, and the amount to refund, recording 1 payment transaction.
abijah
2009-08-06 02:52:45 +00:00
adc901b7e7
Several changes in an effort to support charge reversals. I can't imagine this is all working flawlessly, as I'm not quite sure how it even _should_ work.
abijah
2009-08-05 07:54:57 +00:00
cca698d437
Several changes in an effort to support charge reversals. I can't imagine this is all working flawlessly, as I'm not quite sure how it even _should_ work.
abijah
2009-08-05 07:54:57 +00:00
a84655bcb7
Modified to use toggle for 'this' debug pr block, instead of independent show/hide
abijah
2009-08-05 02:59:09 +00:00
5247bb8db6
Modified to use toggle for 'this' debug pr block, instead of independent show/hide
abijah
2009-08-05 02:59:09 +00:00
6a7a784cb6
Discovered that the use of the term 'Payment' has been a misnomer. A company uses the term payment to indicate the monies it pays to _others_. Changing this leaves us without a good replacement term, but disbursement really seems to fit the bill. As comfortable as the term payment was, it was odd in many respects and disbursement does seem more appropriate. I'm sure there are several lingering bugs from this massive search/replace exercise, but this is a decent baseline for the change.
abijah
2009-08-05 01:00:09 +00:00
cb969ba340
Discovered that the use of the term 'Payment' has been a misnomer. A company uses the term payment to indicate the monies it pays to _others_. Changing this leaves us without a good replacement term, but disbursement really seems to fit the bill. As comfortable as the term payment was, it was odd in many respects and disbursement does seem more appropriate. I'm sure there are several lingering bugs from this massive search/replace exercise, but this is a decent baseline for the change.
abijah
2009-08-05 01:00:09 +00:00
7c9637ae35
Added a more descriptive fieldname for statement entry views. Instead of Transaction, it will be Receipt, Invoice, Deposit, etc.
abijah
2009-08-05 00:06:46 +00:00
094e15ddf9
Added a more descriptive fieldname for statement entry views. Instead of Transaction, it will be Receipt, Invoice, Deposit, etc.
abijah
2009-08-05 00:06:46 +00:00
5d934f756f
Brought the bad debt write-off functionality up to date. I'm not entirely convinced that calling it a receipt is such a good idea, but bad debt is certainly a non-normal case, and we can work on this later if need be.
abijah
2009-08-04 23:25:31 +00:00
670f0894ea
Brought the bad debt write-off functionality up to date. I'm not entirely convinced that calling it a receipt is such a good idea, but bad debt is certainly a non-normal case, and we can work on this later if need be.
abijah
2009-08-04 23:25:31 +00:00
6904320e4e
Modified lease and customer views to have the statement & ledger entries sorted in descending date order by default. May not prefer this in the end, but we'll give it a go for a while.
abijah
2009-08-04 22:12:32 +00:00
9e20473b3b
Modified lease and customer views to have the statement & ledger entries sorted in descending date order by default. May not prefer this in the end, but we'll give it a go for a while.
abijah
2009-08-04 22:12:32 +00:00
17297beb65
Undid the change from r401, since it wasn't being used and was interferring with the specification of sort_column. If we really want that functionality, we can add it in when needed and come up with a more general solution for view specific sorting as well.
abijah
2009-08-04 22:09:18 +00:00
11d5deac85
Undid the change from r401, since it wasn't being used and was interferring with the specification of sort_column. If we really want that functionality, we can add it in when needed and come up with a more general solution for view specific sorting as well.
abijah
2009-08-04 22:09:18 +00:00
e0ea50d142
Fixed bug when marking NSF of a tender that has only been used as a surplus and never applied to any charges. Modified the applyCredits algorithm to try and distinguish between surplus credits of a lease and general customer surplus. I don't know if it works completely, but I do know it creates an issue since a lease surplus can now never be utilized without additional lease charges, a refund (no yet implemented), or moving the surplus to the customer level (not intended to be implemented).
abijah
2009-08-04 21:19:20 +00:00
67280c89e7
Fixed bug when marking NSF of a tender that has only been used as a surplus and never applied to any charges. Modified the applyCredits algorithm to try and distinguish between surplus credits of a lease and general customer surplus. I don't know if it works completely, but I do know it creates an issue since a lease surplus can now never be utilized without additional lease charges, a refund (no yet implemented), or moving the surplus to the customer level (not intended to be implemented).
abijah
2009-08-04 21:19:20 +00:00
81b5bfed26
Made the link clearer that we'll only be waiving the balance of a charge, not the entire charge.
abijah
2009-08-04 20:26:33 +00:00
1afed6a6e0
Made the link clearer that we'll only be waiving the balance of a charge, not the entire charge.
abijah
2009-08-04 20:26:33 +00:00
2ddcdf9419
Even with all the effort put into getting the counts right on the customers grid, it still didn't work right. The root of the problem is the join to CurrentLease, which can result in multiple rows for the same customer. I can revisit this in the future to put some clever solution back in, but in the meantime, it was easiest just to add fields to the customers table, and simply update it whenever the customer lease situation changes. I don't like it... but it just made life much simpler.
abijah
2009-08-04 19:25:39 +00:00
0ff91bf4d8
Even with all the effort put into getting the counts right on the customers grid, it still didn't work right. The root of the problem is the join to CurrentLease, which can result in multiple rows for the same customer. I can revisit this in the future to put some clever solution back in, but in the meantime, it was easiest just to add fields to the customers table, and simply update it whenever the customer lease situation changes. I don't like it... but it just made life much simpler.
abijah
2009-08-04 19:25:39 +00:00
e0d15b7396
More work cleaning up and testing the use of charge waivers, as well as security deposit utilizations. Much of this was just around the concept of determining balances, which wasn't / isn't very straightforward. It's not hard to calculate a balance for a particular sitation, but it is difficult to generalize. I think it's reasonable as it now stands, but the StatementEntry::stats algorithm is certainly subject to change. Also, I didn't double check every case which called the stats() function, so I highly suspect we'll find cases where the code is not expecting the new return values, either symantically or logically.
abijah
2009-08-04 03:12:09 +00:00
4d4e96fe1c
More work cleaning up and testing the use of charge waivers, as well as security deposit utilizations. Much of this was just around the concept of determining balances, which wasn't / isn't very straightforward. It's not hard to calculate a balance for a particular sitation, but it is difficult to generalize. I think it's reasonable as it now stands, but the StatementEntry::stats algorithm is certainly subject to change. Also, I didn't double check every case which called the stats() function, so I highly suspect we'll find cases where the code is not expecting the new return values, either symantically or logically.
abijah
2009-08-04 03:12:09 +00:00
aa846de284
Continued waiver progress. At the moment, it works ok, but I don't like the way that security deposit balances work. It's probably a general issue, not just security deposits, but it's not clear whether stats from StatementEntry should be subtracting waiver totals from the overall charge reconciliation total. It should in some cases, and not in others. I'll tweak on it in later checkins.
abijah
2009-08-03 21:50:21 +00:00
32a98b4b6e
Continued waiver progress. At the moment, it works ok, but I don't like the way that security deposit balances work. It's probably a general issue, not just security deposits, but it's not clear whether stats from StatementEntry should be subtracting waiver totals from the overall charge reconciliation total. It should in some cases, and not in others. I'll tweak on it in later checkins.
abijah
2009-08-03 21:50:21 +00:00