Skip to main content

Hi All,

Need advice on solution to clear the below incorrect accounting error.
Can anyone help to advice a workaround to clear this incorrect posting so that accounting period can be closed? 

 

  • The PO for non inventory item is tied with a fixed asset ID and these PO’s and its PO receipt have been cancelled by user
  • The fixed asset object ID is currently active and there is no object transaction
  • Depreciation has been rollback

 

Please reset object status to Investment again (Deactivate). If receipt is cancelled - no need to have this object active until final receipt and invoice. 

In the project I am working on currently, we are using Automatic Posting Rules to activate expenses related to Fixed assets - we are not directing M92 nor M93 to FA acquisition account directly, but to clearing account, and then APR reclassing M92 to construction in progress, and M93 to Fixed Assets. 
This way, if there’s problem with invoice posting, we can deactivate APR and use manual vouchers to rectify balances.


Thanks Adam for your attention and advice.

So we have to deactivate it and then how do we clear the incorrect accounting which hanging in the distribution and manufacturing posting? 

Regards, Mirza


Once object is deactivated, you can push transfer purchase transactions to finance - these lines should get repaired


We managed to test as per your advice in our test environment and it worked

However, in our prod environment, when we do the same the incorrect posting remained.

One difference is that in our Prod environment, our user had created a manual supplier invoice separately and activate the object. It managed to capture the base value for the object. So when we want to cancel the invoice and rollback the object value, we had to deactivate the object and then reset investment first. Then we change it to investment status again

After performing all above, we tried to transfer purchase transaction and update our GL but incorrect posting remained with same error.

Can you advice what can we do now?


If object was in Investment status when Purchase transaction transfer was running in PROD, I have no idea what could be the reason for the same error. 
As per my understanding invoice should not be a problem here (well, if it was manually posted and not matched with PO receipt it should be cancelled and reprocessed against PO, but technically you can have multiple FA object transactions for Acquisition, coming from invoices and receipts).

Once again - PO receipts for non-inventory items are accruals only, reversed and replaced with final expense on invoice matching, and we should treat them accordingly, rather not direct them to FA Acquisition.


Did you rerun the job for erroneus transactions before trying to transfer?

 


Hi Ralph, yes we have rerun erroneous transaction and transfer purchase transaction and update GL but the issue remained


In purchase transaction details, I can see that M91 have status code transferred. Does this mean that we can no longer clear this incorrect posting using normal IFS function and we need to do data repair?

register arrival entry

cancel arrival entry

 


Reply