Re: [Ledger-smb-devel] Reconciliation in 1.3
On Mon, Dec 13, 2010 at 1:53 PM, Luke account...@lists.tacticus.com wrote: Why first X and not entire thing? I would definitely like to see the payee name, or at least some of it. The 1.3 recon screen has a lot of data on it, and I'd be worried about things getting harder to follow if the screen space is not sufficient. Making the values here truncated at an admin-specified value would seem to avoid this. Best Wishes, Chris Travers -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Reconciliation in 1.3
Hi John; That might not be a bad idea. Let me think about this and see what the best way to do this would be. The original thinking was to keep this as close to the bank format as possible. But maybe an option to display first x characters of payee name might be a good thing? Best Wishes, Chris Travers -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Reconciliation in 1.3
Hi, Chris, I think the best way would be to add a payee column to cr_report_line , and modify reconciliation__pending_transactions to load it with either entity.name (with the joins on eca) or gl.description. I guess I had already modified the UI to show the payee column. I can put together a patch if you'd like... I think my other two issues were related to imported data, not bugs -- it turns out one of the AP transactions was coded to the wrong account... Cheers, John Chris Travers wrote: Hi John; That might not be a bad idea. Let me think about this and see what the best way to do this would be. The original thinking was to keep this as close to the bank format as possible. But maybe an option to display first x characters of payee name might be a good thing? Best Wishes, Chris Travers -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Reconciliation in 1.3
On Mon, 13 Dec 2010, Chris Travers wrote: That might not be a bad idea. Let me think about this and see what the best way to do this would be. The original thinking was to keep this as close to the bank format as possible. But maybe an option to display first x characters of payee name might be a good thing? Why first X and not entire thing? I would definitely like to see the payee name, or at least some of it. Luke -- Lotusphere 2011 Register now for Lotusphere 2011 and learn how to connect the dots, take your collaborative environment to the next level, and enter the era of Social Business. http://p.sf.net/sfu/lotusphere-d2d ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
[Ledger-smb-devel] Reconciliation in 1.3
Hi, My bookkeeper is making headway on reconciling in LSMB 1.3, and we've hit a couple issues. 1. No payee on reconciliation detail Direct feedback from my bookkeeper, that it can be quite difficult to match up transactions to statements when there's no payee listed on the reconciliation detail. I think the real fix is to change the schema of the cr_report_line table to include Payee, and change reconciliation__pending_transactions to insert payee data into the report. Since we're actively using this, rather than messing with cascade deletes/re-inserts, I added a view to do the heavy lifting: CREATE VIEW recon_payee AS SELECT n.name AS payee, rr.id, rr.report_id, rr.scn, rr.their_balance, rr.our_balance, rr.errorcode, rr.user, rr.clear_time, rr.insert_time, rr.trans_type, rr.post_date, rr.ledger_id, rr.voucher_id, rr.overlook, rr.cleared FROM (((cr_report_line rr LEFT JOIN acc_trans ac ON ((rr.ledger_id = ac.entry_id))) LEFT JOIN gl ON ((ac.trans_id = gl.id))) LEFT JOIN ((SELECT ap.id, e.name FROM ((ap JOIN entity_credit_account eca ON ((ap.entity_credit_account = eca.id))) JOIN entity e ON ((eca.entity_id = e.id))) UNION SELECT ar.id, e.name FROM ((ar JOIN entity_credit_account eca ON ((ar.entity_credit_account = eca.id))) JOIN entity e ON ((eca.entity_id = e.id UNION SELECT gl.id, gl.description FROM gl) n ON ((n.id = ac.trans_id))); ... then created a reconciliation__pending_transactions_payee that returned a row of this view instead of cr_report_line, and modified the Perl code to use this function instead of the original. Perhaps something along these lines can be integrated into the original function? 2. Reconciliation of transactions that pay for multiple AP transactions only show one. e.g. Bookkeeper enters several AP transactions, with different dates and different amounts. Then pays them all with one check. Only one of the AP transactions appears in the reconciliation report. That's my task for today -- figure out how to get all the appropriate lines to show up in the reconciliation report. Chris, do you have a quick fix for this? oh, and here's one more issue: 3. Reconciliation of one account marks other side of transaction reconciled. E.g. a payment from a cash account to a credit card account, after being reconciled in the cash account, no longer shows up in pending transactions to reconcile on the credit card account. Not sure if this is an issue with imported data, or if this is a bug in 1.3. Cheers, -- John Locke Open Source Solutions for Small Business Problems published by Charles River Media, June 2004 Follow me on Twitter: http://twitter.com/freelock http://www.freelock.com -- Oracle to DB2 Conversion Guide: Learn learn about native support for PL/SQL, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, data movement tools, best practices and more. http://p.sf.net/sfu/oracle-sfdev2dev ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel