The Outstanding section in PartsRec automatically calculates all of the reconciling items. A reconciling item is any transaction that has already affected the parts pad/inventory but has not been posted to the GL yet.
PartsRec tracks the following as reconciling items, each section is separated into two parts: invoices and un-matched transactions. As invoices are uploaded and matched, unmatched transactions from the bottom get matched to invoices in the top section.
The total calculated number of reconciling items includes the "Matched Total" from the top invoices section and the "Total" from the bottom un-matched transactions section. Adding up both sections in all tabs will equal your total outstanding balance on the Daily Reconciliation report.
*The orange AI Invoice button and white Run Match button are for admin only.
- Received
- Received Invoices (Matched Total) - The total dollar amount of invoices not yet posted to accounting. These include factory invoices uploaded, Pos imported from the DMS, and manual invoices created from the transactions below.
- Un-matched Transactions (Total) - The total dollar amount of parts received not billed/invoiced.
- Plus/Minus Adj.
- Plus/Minus Adjustment Memos (Total) - The total dollar amount of plus/minus adjustment memos not yet posted to accounting. These include manual invoices created from the transactions below.
- Un-matched Transactions (Total) - The total dollar amount of plus/minus transactions that have not been matched to a memo or posted to accounting.
- Cost Adj.
- Cost Adjustment Memos (Total) - The total dollar amount of cost adjustment memos (appreciation/depreciation) not yet posted to accounting. These include manual invoices created from the transactions below.
- Un-matched Transactions (Total) - The total dollar amount of cost adjustment transactions that have not been matched to a memo or posted to accounting.
- PNC
- Part Number Change Memos (Total) - The total dollar amount of PNC memos (part number changes with cost changes) not yet posted to accounting. These include manual invoices created from the transactions below.
- Un-matched Transactions (Total) - The total dollar amount of PNC transactions that have not matched to a memo or posted to accounting.
- Returns
- Return Invoices (Matched Total) - The total dollar amount of credit invoices not yet posted to accounting. These include factory credits uploaded, credit POs imported from the DMS, and manual invoices created from the transactions below.
- Un-matched Transactions (Total) - The total dollar amount of parts returned not credited or posted to accounting.
- Dirty Cores
- Core Return Invoices (Matched Total) - The total dollar amount of dirty core credit memos not yet posted to accounting. *Most dirty core credits are uploaded and matched in the returns tab.* These include manual invoices created from the transactions below.
- Un-matched Transactions (Total) - The total dollar amount of dirty cores on hand or returned not credited or posted to accounting.
- Overrides
- Cost Override Memos (Total) - The total dollar amount of cost override memos not yet posted to accounting. These include manual invoices created from the transactions below.
- Un-matched Transactions (Total) - The total dollar amount of cost override transactions that have not matched to a memo or posted to accounting.
- WIP
- WIP Invoices (Total) - The total dollar amount of open repair orders (work in process) not yet posted to accounting.
- Parts Billed Not Received
- Un-matched Transactions (Total) - The total dollar amount of offsetting transactions generated for parts billed not yet received.