I dont't think this reply will help the original poster (who posted
his message a month ago) but since I hit the same problem and found
the cause of it I post this reply for future reference.
The error is caused by bad records in SpecTrans. More specifically
records that are expected to mark customer settlements to void but do
not in fact refer to any CustSettlement (via the refId field). You can
find the offending records using this query (change 'dat' to another
firm when appropriate) :
select * from spectrans where
dataareaid = 'dat' and
spectableid = 77 and
specrecid in (select recid from custtable where dataareaid = 'dat') and
not exists (select 'x' from custsettlement where dataareaid = 'dat'
and recid = refid)
Just delete the records and you should be fine. I don't know where
these are coming from (suspect a bug in Axapta code). I'm going to
investigate if I have time.
--
Wojciech Lewicki
--- In [email protected], roberto pineda
<[EMAIL PROTECTED]> wrote:
>
> I am getting an error when trying to void a check that
> had been posted.
>
> I get the following error message:
> Error:
> Error executing code: Division by zero.
>
> Stack trace:
> (s) \Classes\CustVendReversePosting\reversePennyDiff
> �line4
> (s)
> \Classes\CustVendReversePosting\restoreCustVendTrnas �
> line 28
> (s) \Classes\CustVendReversePosting\updateNow � line
> 39
> (s) \Data Dictionary\Tables\VendTrans\Methods\reverse
> Transact � line 40
> (s) \Classes\BankChequeCancel\reverseSettlement � line
> 20
> (s) \Classes\BankChequeCancel\cancelCheque � line 46
> (s) \Classes\BankChequeCancel\run � line 15
> (s) \Classes\BankChequeCancel\serverRun � line 8
> (s) \Classes\BankChequeCancel\main � line 21
> (s) \Classes\FormFunctionButtonControl\Clicked
>
> I checked data in bankchequetable, ledgerjournaltrans,
> ledgertable, and everything appears to be find.
> Amounts and exchage rates are present.
>
> Anyone knows why I am getting this error? Any ideas on
> how to solve? I still need to reverse (void) the
> check.
>
> Thanks in advance for your help.
>
> Roberto
>
>
>
> ______________________________________________
> Renovamos el Correo Yahoo!: �250 MB GRATIS!
> Nuevos servicios, m�s seguridad
> http://correo.yahoo.es
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
