After my upgrade from Emerald 2.2. to 2.5 there was no entry in the tax
table and i could not create a new invoice.
I already solved this problem by myself and created a tax named 'None' with
Tax 'None' but this only solved the problem that i cant create new invoices.
Now there was the problem when i create the second invoice item i get the
error message "Run-time error '10': This array is fixed or temporarily
locked".
I set the TaxID field of all invoice items with TaxID=NULL to this new tax
with this sql script:
Update InvoiceItems
Set TaxID = 3 (New Tax 'None')
Where TaxID IS NULL
but this did not solve my problem too.
After your reply i created a Tax named 'NoTax' with Tax value '0' as you
suggested and set the TaxID fields of all invoice items to this tax.
Update InvoiceItems
Set TaxID = 5 (New Tax 'NoTax')
Where TaxID = 3
and deleted the Tax 'None' with Emerald Administrator.
But the problem still persists.
Jeff - when do you think is a fix or upgrade available?
We need a fix very urgent because we can not make any invoices now.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of
jpresley@iea-software.com
Sent: Donnerstag, 4. Februar 1999 00:46
To: emerald@iea-software.com
Subject: Re: [Emerald] Cannot create second invoice item
There is a known bug mentioned last week about this menu item.
The problem occurs when the TAX is "none". The null causes an
error. The fix (assuming you don't have a default tax) is to create a
tax called notax in the Emerald Administrator and set the rate to
0% /(in other words, when it does the math it will come out zero
additional). Then use that tax until the next version of the client is
ready which resolves the problem.
On 3 Feb 99, at 16:58, Axel Drogoin wrote concerning:
[Emerald] Cannot create second invoice item
> Hi,
>
> i just tried to manually create an invoice with "Menu-->Master-->New
> Invoice". If i add more than one invoice item i get the error message
> "Run-time error '10': This array is fixed or temporarily locked" when
> adding the second item.
>
> I checked my database and the error logs and found nothing unusual.
> Can somebody please help me with this problem?
>
> We use Emerald 2.5.236.
>
> Thanks
>
> Axel Drogoin, Evolution Systems
>
> -----------------------------------------------------
> Evolution Systems GmbH Mobil-Oil-Str. 42
> Network Management 84539 Ampfing
> mailto:ad@esib.net Tel: +49 8636 9830 33
> WWW: http://www.esib.net Fax: +49 8636 9830 99
> -----------------------------------------------------
>
>
>
> For more information about this list, including removal,
> please see http://www.iea-software.com/maillist.html
>
- Jeff
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html