DAF CICPs send 846P and 846R transactions into ELMS each day and month for a two-part reconciliation.  First part consists of 846P transactions providing an end of day transaction count.  The second part consists of 846R transactions providing an end of day inventory report.  If either part fails reconciliation, ELMS flags with a red indicator.  The reconciliation depends on users to trigger follow-up actions to correct situations causing the failure.  DAF recommends automating those follow-up actions to enable a system-to-system reconciliation that removes user intervention.  This will enable more accurate and complete inventory balances and their supporting transactions in ELMS.  This will improve financial reporting accuracy for the DAF.

 

Recommend that ELMS ICP module adds automated follow-up actions for reconciliation failures.  For the end of day transaction counts: if the reconciliation fails, ELMS should send a transaction history request to the CICP’s system for the failed transaction set.  The CICP’s system will return all the transactions for the failed transaction set for that day (marked with W1 in the appropriate action code field).  ELMS will identify the missing transaction(s) and process those as if they were received that day.  This will clear the reconciliation failure and potentially reduce the number of end of day/end of month inventory balance mismatches.  For the end of day/end of month inventory balances: if the reconciliation fails, ELMS will send inventory request transaction(s) to the CICP’S system for the mismatched stock numbers.  The CICP’s system will return the end of day/end of month inventory position by stock number.  ELMS will use those inventory balances to create 947I Inventory Adjustment transactions to update the balances to match the CICP’s system balance.  

 

 

Frequency: Daily

 

Users: This requirement improves the end of day/end of month reconciliation for the 100+ DAF CICPs