Audit of Invoices posted for Inventory Accounts

Author
Messages
Sherry Shimek
Advanced Member
Posts: 43
Advanced Member

    Hello.  We have an finance audit underway that requires us to identify the invoices for all medical supply purchases that are received into our gl inventory accounts.  Our invoices post to the PO accrual accounts and the postings to the inventory accounts are po receipts.  MM280 shows the inventory account but not the invoice number.  Or shows the invoice number to the PO accrual account. 

    What is the best way to get the invoices for the inventory accounts?

    Sherry Shimek Catholic Health Initiatives Englewood CO
    Kat V
    Veteran Member
    Posts: 1020
    Veteran Member
      You'll need a custom query as far as I know. Invoices aren't what post to inventory. When the PO is received, IC130 posts that receipt to inventory. The invoice never touches it unless it's non-stock. The invoice hits the RNI and clears the liability.

      For our audits, we run IC220 - this shows the PO Receipt with the offset accounts and ties back to the gl entry for them.
      ---