Invoice Matching Data

SUGGESTED

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

  • 0
    SUGGESTED

    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

  • 0 in reply to pnightingale

    Hi Pam,

    Thank you for your response. I need to create a report that shows all of the invoicing activity and when it was paid and what is still open. The difficulty is determining all of the records that are matched since the matching letter are reused depending on the BP and the Fiscal Year/Period (I think).

    Regards,

    Dave