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
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
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
Thanks Andrew, we'll do our update for AP soon!

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 82 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14459 Topics
70635 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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