Invoice Matching Data

Question

Can anyone tell me where, in the database, I can find the invoice matching data? I am looking at the GACCENTRYD table but it seems to have some holes in the data. Any guidance would be much appreciated. 
 Regards, 
 Dave

pnightingale · Answer

Hi Dave, 
 GACCENTRYD should show all your posted invoice transactions. Have you gone to Manual Matching (LETTRAGE) to look at the invoice? This does reflect the data in the GACCENTRYD, but is easier to view than the tables. It has one screen for fully matched and another for partially or unmatched. It is easy to sort the data by matching letters. 
 What version and patch level are you on? What data seems to be missing? If you go to Accounting Tasks (VALPCE) do you have any values greater than 0 in the Journals on hold or Matching fields? This would indicate transactions that have possibly not gone through to the general ledger. To track this down see the the following blog for tips: In search of suspended matching transactions . Also, check out the blog Where are my journal entries? 
 Hope this helps. 
 Regards, 
 Pam

Sage X3

Invoice Matching Data

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING