Thanks, Chris! That part is now working again and I see my error now. I
did encounter the following regression on 1.3.37-rc3 when I tried to view a
specific invoice.
>From the Apache error.log:
[Wed Jan 29 08:46:24 2014] [error] [client 192.168.1.108] Math::BigInt:
couldn't load specified math lib(s), fallback to Math::BigInt::Calc at
LedgerSMB/Form.pm line 61., referer:
http://192.168.1.127/ledgersmb/ap.pl?login=mpl&action=search&module=ap.pl&nextsub=transactions&;
[Wed Jan 29 08:46:26 2014] [error] [client 192.168.1.108] Math::BigInt:
couldn't load specified math lib(s), fallback to Math::BigInt::Calc at
LedgerSMB/Form.pm line 61., referer: http://192.168.1.127/ledgersmb/ap.pl
[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] DBD::Pg::st
execute failed: ERROR: column a.crdate does not exist, referer:
http://192.168.1.127/ledgersmb/ap.pl
[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] LINE 12:
a.on_hold, a.crdate, referer:
http://192.168.1.127/ledgersmb/ap.pl
[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108]
^ at LedgerSMB/Form.pm line 2630.,
referer: http://192.168.1.127/ledgersmb/ap.pl
[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] DBD::Pg::st
execute failed: ERROR: current transaction is aborted, commands ignored
until end of transaction block at LedgerSMB.pm line 833., referer:
http://192.168.1.127/ledgersmb/ap.pl
[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] 2014/01/29
08:46:27 - ERROR - LedgerSMB::dberror LedgerSMB.pm (1099) -- Logging SQL
State 25P02, error 7, string ERROR: current transaction is aborted,
commands ignored until end of transaction block, referer:
http://192.168.1.127/ledgersmb/ap.pl
[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] Can't use string
("LedgerSMB::Setting") as a HASH ref while "strict refs" in use at
LedgerSMB.pm line 941., referer: http://192.168.1.127/ledgersmb/ap.pl
[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] Compilation
failed in require at /usr/local/ledgersmb/ir.pl line 7., referer:
http://192.168.1.127/ledgersmb/ap.pl
[Wed Jan 29 08:46:27 2014] [error] [client 192.168.1.108] Premature end of
script headers: ir.pl, referer: http://192.168.1.127/ledgersmb/ap.pl
-Mark
On Tue, Jan 28, 2014 at 8:49 PM, Chris Travers <chris.trav...@gmail.com>wrote:
> On the AR/AP transaction reports, I see your bug report. This was fixed
> in 1.3.37-rc1 I think. I am getting 1.3.37-rc3 out today and am hoping for
> a full release on Monday if no other regressions are found.
>
> Best Wishes,
> Chris Travers
>
>
> On Tue, Jan 28, 2014 at 6:44 PM, Chris Travers <chris.trav...@gmail.com>wrote:
>
>>
>>
>>
>> On Tue, Jan 28, 2014 at 3:12 PM, M Lubratt <mplubr...@gmail.com> wrote:
>>
>>> Good afternoon!
>>>
>>> I'm trying to receive inventory. I used the Shipping | Receive screen.
>>> When I try to look at the current inventory, the received inventory
>>> doesn't show up.
>>>
>>
>> Correct. Inventory numbers are not adjusted until invoices are posted.
>> You have to invoice. Then the inventory will show up.
>>
>> This is necessary because otherwise, the old SQL-Ledger code can't handle
>> very well what happens when you combine an invoice for received goods with
>> line items for additional ones. In theory this shouldn't happen
>> frequently, but in practice it does and was throwing the onhand numbers off.
>>
>>
>>> Then I went to the Report | Inventory Activity report. That report
>>> shows all of the inventory I received is showing sold.
>>>
>>
>> I don't think that can happen. these reports only hit the invoice table.
>> If you click through you should get a list of ar or ap invoices with the
>> relevant portions.
>>
>>
>>> I'm at a loss for how this happened. I'm trying to run AP and AR
>>> reports to see if there's a weird transaction that happened, but those
>>> report aren't working for me under LSMB 1.3.36.
>>>
>>
>> What is happening there?
>>
>>>
>>> Does anyone have a suggestion?
>>>
>>> Thanks!
>>> Mark
>>>
>>> Perl 5.14.2
>>> LSMB 1.3.36
>>> Ubuntu 12.04.4
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> WatchGuard Dimension instantly turns raw network data into actionable
>>> security intelligence. It gives you real-time visual feedback on key
>>> security issues and trends. Skip the complicated setup - simply import
>>> a virtual appliance and go from zero to informed in seconds.
>>>
>>> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
>>> _______________________________________________
>>> Ledger-smb-users mailing list
>>> Ledger-smb-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>>>
>>
>>
>> --
>> Best Wishes,
>> Chris Travers
>>
>> Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
>> lock-in.
>> http://www.efficito.com/learn_more.shtml
>>
>
>
>
> --
> Best Wishes,
> Chris Travers
>
> Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
> lock-in.
> http://www.efficito.com/learn_more.shtml
>
>
> ------------------------------------------------------------------------------
> WatchGuard Dimension instantly turns raw network data into actionable
> security intelligence. It gives you real-time visual feedback on key
> security issues and trends. Skip the complicated setup - simply import
> a virtual appliance and go from zero to informed in seconds.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
------------------------------------------------------------------------------
WatchGuard Dimension instantly turns raw network data into actionable
security intelligence. It gives you real-time visual feedback on key
security issues and trends. Skip the complicated setup - simply import
a virtual appliance and go from zero to informed in seconds.
http://pubads.g.doubleclick.net/gampad/clk?id=123612991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
