Have a client on 2019.X Adv who was having some AP issues. While I was investigating, I found an invoice that needed to be adjusted off. When I tried to adjust if off, it kept telling me that it had already been paid (NOPE, had not). So I pulled it up in DFDM and saw that the DISCOUNT field had the invoice amount in it instead of the Invoice Amount field (although the Balance was still non-zero), so I made a change and tried to adjust off again.
Still got the same error. So back into DFDM and this time I started looking at ALL of the fields and then began to freak. All of the field names were incorrect compared to the data in them. The Update Date was in an Amount field, the Update time was in another Amount field, the Tax Code had the invoice amount in it, etc.
Now some of these invoices had been imported, so I figured it was an issue there, but then I checked a vendor who is not imported and same deal.
So the Data Dictionary is totally hosed in AP (found similar issues in the Transaction file).
I'm afraid to fix it, for fear all of the data ends up totally forked. Can someone talk me off the ledge and tell me how to correct the Data Dictionary?
------------------------------
Beth Bowers
Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
Beth Bowers
269-445-1625
------------------------------