Hi all
I've had an issue occur twice now with AP cheques. The client used the Edit/Select screen to compile the cheque run. When they tried to run the cheques they got an error saying that one of the cheques was out of balance. So in both cases, I deleted that vendor's detail from the Edit/Select screen, and then got the cheques to run fine in preview (logged in as SYSADMIN). I then chose Delete All from the update screen to re-release the batch for the client.
In both cases, the client then tried to run the batch, but was getting the same error message as before - even though the issue had been fixed. The only way we could get the cheques to run was to cut and paste the cheques into a new batch, and delete the old one.
I'm guessing there must be a temp table or a work table somewhere that was populated when the error occurred, and wouldn't let that user re-run the batch without referring to the work table and throwing the error. Does anyone have any idea what that table might be? Or any other resolutuion for this problem?
Client is running SL7 FP1.
Cheers, Allison.
Allison,
This might be bug 19606. I suspect it has to do with ADs or discounts on ADs.
Also, are any of your vendors set up for Separate Checks? That can cause an issue when an AD document is involved.
We have modified the procedure FindLastCheckNumber script to resynch the apcheck/apcheckdet records at the time the Next Check number is displayed in the Check printing screen. Run this against your application database.
**********************************************************************************************************
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
/****** Object: Stored Procedure dbo.FindLastAPCheck Script Date: 4/7/98 12:19:55 PM ******/
ALTER Procedure [dbo].[FindLastAPCheck] @parm1 varchar ( 10), @parm2 varchar ( 24) As
update apcheck set checklines = (select count(*) from apcheckdet where apcheck.checkrefnbr=apcheckdet.checkrefnbr)
from apcheck
delete from apcheck where checkrefnbr not in (select distinct checkrefnbr from apcheckdet)
Select ISNULL(MAX(refnbr) ,'0')
FROM APDoc a (NOLOCK)
Where a.DocClass = 'C'
AND a.Acct = @parm1
AND a.Sub = @parm2
AND
(a.DocType in ('CK', 'MC', 'SC', 'ZC')
OR
((a.DocType = 'VC')
AND NOT EXISTS (SELECT 1 FROM APDoc b (NOLOCK) WHERE a.refnbr = b.refnbr AND a.VendId = b.VendId and
a.Acct = b.Acct and a.Sub = b.Sub and b.DocType = 'HC')))
Elaine Rettig
Dynamics SL support - Financials