Problem with Receipt Accounting

There was an issue in the purchasing accounting rules, and this caused a Receipt Accrual account combination mismatch between purchase receipts and invoice matching. Basically, the COA has a project segment, and the receipt line distribution combination did not have a project number, whereas the invoice distribution did. This breaks Receipt Accounting functionality.

We can fix the issue manually, by searching for the receipt distributions and then performing a ‘Override Account’ transaction to change the account on the receipt.

The problem however is twofold:

a) There are an estimated 5000-6000 receipt lines to fix

b) The way they purchase is that they create annual POs, and then only do receipts throughout the year. Thus the POs have the bad accrual account, and all future receipts are also accounted incorrectly