Hi Chris, thanks.
Do you have a save button?
>
>
Yes, but it doesn't proceed the workflow to enable "Post as Saved" as I'm
used to seeing.
Hitting Save results in a request to the web server, and it populates the
Due Date field, but no Post buttons appear.
>
> If that s missing then the problem may be with books being inappropriately
> closed. I can help you with that, but let's check first.
>
>
After this comment of yours, I checked and I can't post anything - AP/AR/GL
etc. so it appears my books have indeed somehow become closed.
I've checked the Audit Control (no date set), and Year End (closed on
30-06-2014), and tried re-opening the books as of 01-07-2014 in my test
environment, but no change in behaviour.
Any guidance on how I can re-open the books much appreciated.
Regards,
Hilton.
On Sat, Feb 20, 2016 at 9:19 PM, Chris Travers <chris.trav...@gmail.com>
wrote:
>
>
> On Sat, Feb 20, 2016 at 10:21 AM, Hilton Day <hilton....@gmail.com> wrote:
>
>> Many thanks Erik for the speedy response.
>>
>> Upgrade completed to 1.4, and then subsequently to 1.4.24, and I can open
>> the accounts, so upgrade is considered successful.
>>
>> However, here's a question for the brains-trust of ledgersmb experts on
>> this list :)
>>
>> I still can't post an AR invoice - I don't get a Post button. This is
>> the issue which caused me to decide to upgrade from 1.3 to 1.4.
>>
>> The buttons I have are: Update, Save, Schedule, and Save Template, and
>> I'm unable to get a Post/Post as Saved/Post as Shown button to appear. I'm
>> also unable to see any saved drafts, so it seems they're not being created
>> either.
>>
>> This isn't just for my latest client, but also for clients I've
>> previously posted invoices for back in Dec. 2014..
>>
>
> Hi
>
> The missing post button should be replaced by a save button, and then you
> can post after saving.
>
> If that s missing then the problem may be with books being inappropriately
> closed. I can help you with that, but let's check first.
>
> Do you have a save button?
>
>>
>> To satisfy myself that it wasn't an issue with my host/webserver/postgres
>> configuration or old scripts on my usual installation, I downloaded the
>> Virtualbox image from sourceforge and upgraded that to 1.4.24 separately,
>> and even with a completely separate config, the same issue occurs, so its
>> something in my sqlledger config inside the database.
>>
>> Have also checked my yearend - its still closed as of 30-06-14 (I haven't
>> filed last tax year ending 30-06-2015 yet) so books are definitely open.
>>
>> The issue is consistent between my current 1.3.46 install (and also
>> 1.3.44 - tried downgrading slightly), and 1.4.24.
>>
>> Any ideas what might be causing this? I'm flummoxed!
>>
>> Thanksin advance,
>>
>> Hilton.
>>
>>
>>
>> On Fri, Feb 19, 2016 at 9:09 AM, Erik Huelsmann <ehu...@gmail.com> wrote:
>>
>>> Hi Hilton,
>>>
>>> On Thu, Feb 18, 2016 at 8:33 PM, Hilton Day <hilton....@gmail.com>
>>> wrote:
>>>
>>>> I'm trying to upgrade my old 1.3.46 database (started life as 1.1 from
>>>> memory - back at end of 2006), and have worked my way through a few issues
>>>> so far, like a few duplicate meta numbers, and missing GIFI accounts.
>>>>
>>>
>>> Ok. Then you have the hardest part behind you :-)
>>>
>>>
>>>> Now the upgrade is bombing out with this message:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *Error!Upgrade failed;logs can be found in
>>>> /tmp/ledgersmb/dblog_2016-02-18T191531_2606_stdout and
>>>> /tmp/ledgersmb/dblog_2016-02-18T191531_2606_stderr at
>>>> LedgerSMB/Scripts/setup.pm <http://setup.pm> line 1002.dbversion: 1.4.24,
>>>> company: *
>>>> Looking in the error log (full version of both the stdout and stderr
>>>> files attached), the problems look to me like:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> *psql:sql/modules/Fixes.sql:164: ERROR: duplicate key value violates
>>>> unique constraint "menu_node_pkey"DETAIL: Key (id)=(90) already
>>>> exists.psql:sql/modules/Fixes.sql:216: ERROR: duplicate key value violates
>>>> unique constraint "menu_node_pkey"DETAIL: Key (id)=(129) already exists.*
>>>>
>>>
>>> Errors from Fixes.sql are expected, so these two aren't a problem.
>>>
>>>
>>>>
>>>>
>>>>
>>>>
>>>> *psql:/tmp/ledgersmb/upgrade.sql:549: ERROR: column
>>>> "recurring_interval" is of type interval but expression is of type textLINE
>>>> 4: repeat || ' ' || unit as recurring_interval
>>>> ^HINT: You will need to rewrite or cast the expression.*
>>>>
>>>
>>> This is your problem. Fortunately, it's probably easy to work around.
>>> Try changing
>>>
>>> """
>>> repeat || ' ' || unit
>>> """
>>>
>>> to
>>> """
>>> (repeat || ' ' || unit)::interval
>>> """
>>>
>>> That should allow you to get past the current problem. I hope it's the
>>> last one on your route to 1.4! Anyway, I'll change this script for 1.4.26
>>> (We just released .25 today, but this problem isn't fixed in it).
>>>
>>>
>>>> The reason I'm trying ot upgrade is having recently picked up my
>>>> business again I'm doing consulting work, and have discovered that I can't
>>>> post an AR invoice any more in my current 1.3.46 - so I figured I'd upgrade
>>>> to 1.4.24 before getting into why (last invoices I posted were a year or so
>>>> ago).
>>>>
>>>
>>> That's weird. I'm using companies in both 1.3.46 and 1.4.22, but haven't
>>> heard about this problem before. Let me know if the upgrade fixed things!
>>>
>>>
>>>> Any help appreciated figuring out this upgrade for now.. I want to get
>>>> my database moved up to 1.4 successfully before I worry about the
>>>> functional issue.
>>>>
>>>>
>>> The advice above should allow you to continue onto the next upgrade
>>> steps.
>>>
>>> Regards,
>>>
>>>
>>> --
>>> Bye,
>>>
>>> Erik.
>>>
>>> http://efficito.com -- Hosted accounting and ERP.
>>> Robust and Flexible. No vendor lock-in.
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>>> Monitor end-to-end web transactions and take corrective actions now
>>> Troubleshoot faster and improve end-user experience. Signup Now!
>>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>>> _______________________________________________
>>> Ledger-smb-users mailing list
>>> Ledger-smb-users@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------------
>> Site24x7 APM Insight: Get Deep Visibility into Application Performance
>> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
>> Monitor end-to-end web transactions and take corrective actions now
>> Troubleshoot faster and improve end-user experience. Signup Now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
>> _______________________________________________
>> 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
>
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
