Topic Options
#54676 - 08/18/17 04:53 AM Datacare data integrity error
KNoel Offline
Adagio Guru

Registered: 02/01/07
Posts: 110
Loc: Ottawa ON Canada
(216.191.120.2)
Using DC 9.2A (150916)

We've been having minor data integrity errors over the last few months related to open sub-ledgers. This one below relates to an unposted AP batch with an invoice that has only been partially entered as it's a long one that was not completed before the DIC. The error that appears is:

Checking non-posted applied payments ... ... Checked OK
Vendor VISADT open batch invoice computed total 9,973.24 does not match stored total 11,336.65
Checking Open Batch Vendor Totals ... ... 1 error(s) found

I'm not sure where it's getting the "stored" total to compare it with because the current total is 9973.24? Does it perhaps keep a temp total to do a comparison?

The error disappears once the AP batch is posted but I'm curious as to why it is checking non-posted sub-ledgers.

Karin

Top
#54679 - 08/18/17 08:21 AM Re: Datacare data integrity error [Re: KNoel]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
(23.16.30.130)
Hello Karin,

This error is generated when changes an invoice is added and deleted to a batch without the batch being saved.

It is fixed in Adagio Payables 9.3A.
_________________________
Andrew Bates

Top
#54685 - 08/21/17 01:17 PM Re: Datacare data integrity error [Re: Retired_Guy]
KNoel Offline
Adagio Guru

Registered: 02/01/07
Posts: 110
Loc: Ottawa ON Canada
(216.191.120.2)
Thanks Andrew, we'll do our update for AP soon!

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 120 Guests and 8 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14567 Topics
71092 Posts

Max Online: 1148 @ 11/22/25 01:55 AM
November
Su M Tu W Th F Sa
1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30