Reconciliation Report

[arthur-aguilera]

Documentation for current reconciliation process: https://docs.google.com/document/d/1ARNO46P3PNWBxWM5f91kgQvp1bMOFRZmQ2Z4J6AlMuI/edit

Materials Budget Reconcilliation Working - October.xlsx

Fields Needed

• [ ] Invoice Number
• [ ] Paid Date
• [ ] Invoice Date
• [ ] Paid Amount
• [ ] Credit Memo Applied
• [ ] Credit Amount
• [ ] Revised Materials Budget Amount [calculated field]

[arthur-aguilera]

In Sierra, Rebecca runs a create list of orders that have a paid date.

order paid date between "" and "" (usually the previous month)

Rebecca applies the saved export "#63 ACQ-order-payment-xport which has:

• record number
• marc tag 245 / order name
• order fund
• order fund name
• order vendor name
• order paid (limited to the range that was used to create the list)
• budget name
• ledger name
• invoice number
• invoice date
• receiver (who received this item)
• item title/name
• invoice account code

In FOLIO, each payment or credit on that order should be on it's own separate line

Order by fund

Example of orders with multiple order lines:

https://cu-test.folio.indexdata.com/orders/lines/view/c3e5863a-e10c-40e5-a53c-d468f7010150?limit=50&offset=0&qindex=titleOrPackage&query=2223%20posmo%20mono%20funds

order record for the link above: o9929678

[arthur-aguilera]

Sent sample out to Rebecca 5/2/23. Need to add budget once we get folio_derived.finance_funds table back.