On Fri, Jan 24, 2014 at 5:14 AM, Klavs Klavsen <k...@vsen.dk> wrote:
> Chris Travers said the following on 01/24/2014 02:08 PM:
> > I will have to check but I think this was already corrected for 1.3.37.
> >
> I'll admit to not having search the existing bugs :)
>
> Now I'm trying to figure out what amounts were actually saved for my
> invoice - but I can't figure out how to search for the invoice (AP) just
> entered :(
>
I haven't been able to reproduce your problem. Steps to reproduce would be
appreciated. I did send you a patch based on the query involved that
should resolve it however. I am not quite sure though whether the changes
made for the outstanding report.
Hmmm as I review, it may need a slightly different patch. Don't apply the
other one (or if you did, reverse it and apply this one).
> --
>
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more.shtml
Index: LedgerSMB/AA.pm
===================================================================
--- LedgerSMB/AA.pm (revision 6613)
+++ LedgerSMB/AA.pm (working copy)
@@ -909,7 +909,7 @@
# detail report query can be inlined in the summary report query. -CT
my $p = $LedgerSMB::Sysconfig::decimal_places;
- my $cols = qq|a.id, a.invnumber, a.ordnumber, a.transdate, a.crdate,
+ my $cols = qq|a.id, a.invnumber, a.ordnumber, a.transdate,
a.duedate, a.netamount, a.amount::numeric(20,$p),
a.amount::numeric(20,$p) - (sum(acs.amount::numeric(20,$p)) * CASE WHEN '$table' = 'ar' THEN -1 ELSE 1 END) AS paid,
a.invoice, a.datepaid, a.terms, a.notes,
@@ -975,7 +975,7 @@
}
} else {
$query = qq|
- SELECT a.id, a.invnumber, a.ordnumber, a.transdate, a.crdate,
+ SELECT a.id, a.invnumber, a.ordnumber, a.transdate,
a.duedate, a.netamount, a.amount,
(a.amount - pd.due) AS paid,
a.invoice, a.datepaid, a.terms, a.notes,
------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
