Wednesday, January 10, 2018

PRC: Interface Invoices to Receivables Ends with Rejection 'Accounting flexfield could not be validated

Issue:

PRC: Interface Invoices to Receivables Ends with Rejection 'Accounting flexfield could not be validated

Resolution:-

1.  First you will need to figure out what account the system is trying to build. 
2.  Using the Project Billing Super User responsibility, Setup | Auto Accounting | Assign Rules => Query on function 'Revenue and Invoice Accounts'
3.  Put your cursor in the function 'Unbilled Retention Account' and go through each rule which will help you build the account, i.e., segment 0 is 'Company Rule' with a constant of 01, segment 1 is 'Cost Center Rule' with a constant of 000 and segment 2 is the 'Account Number Rule' with a constant of 1233.  Thus the account we are building is 01.000.1233.
4.  Using the General Ledger Super User responsibility navigate
5.  Setup | Accounts | Code Combinations => enter the account code combination generated in PA, i.e., 01-000-1233.
6.  Verify the 'Enable' box is checked.  If not, please enable. 
7.  Re-run the PRC:  Interface Invoices to Receivables process.


NOTE:  PRC: Interface Invoices to Receivables will end with rejection 'Accounting flexfield could not be validated' if current date is not in between code combination start date and code combination end date.
Validation for code combination while interfacing invoice does not depend on invoice date but Sys date.

If any cross validation or Security rules applied any one of the segment also this issue will occur.

1 comment: