APP-SQLAP-97038

[AIMAM]

hello,

We have a PO 108 that was partially matched to an invoice in an organization to it's chart of accounts. The PO was moved to a new organization according to requirements of new set of books and new charts of accounts to be created. A new invoice was created in the new set of books and matched to PO 108. After the attempt of changing the distribution account, the invoice was held by the system with hold name: "Dist Acct Invalid", with hold reason:"Distribution account is invalid".The invoice staus was changed to "Needs Revalidation".
The user tried to unrelease the hold but the following error shows up :

APP-SQLAP-97038:This invoice has at least one hold that you cannot manually release. For holds you cannot manualy release, you need to resolve the exception that caused the hold to be applied and then resubmit Validation to release hold.

How can I check what caused the problem and how to solve it?

The user have enterd 2 new invoices later and matched it to po 108, with the same distribution account .One of them is validated and the other one is never validated by the system.

Any ideas will be very helpful...

[roopeshpdit]

DO you have any other POs other than 108, can you try doing the full matching to the PO other than 108?

Is it giving the same error?

[yramesh77]

Hi,

The error you have got I assumes that if the distribution line is not mathed with Invoice amount then there would be an system hold if we want to remove that hold u need to match the distribution line with Invoice amount. Please verify once again and try to match with distribution total. I think it is not the problem with PO..


Thanks,
Ramesh.

[AIMAM]

hello:

I want to redecribe the problem below,please advise upon:

We have a PO (108) that was partially matched to an invoice in an organization to it's chart of accounts.
The PO was moved to a new organization according to requirements of new set of
books and new charts of accounts to be created. A new invoice was created in
the new set of books and matched to PO 108. After the attempt of changing the
distribution account, the invoice was held by the system with hold name: "Dist
Acct Invalid", with hold reason:"Distribution account is invalid".The invoice
staus was changed to "Needs Revalidation".
The user tried to unrelease the hold but the following error shows up :

Error1:APP-SQLAP-97038:This invoice has at least one hold that you cannot manually release. For holds you cannot
manualy release, you need to resolve the exception that caused the hold to be
applied and then resubmit Validation to release hold.

The user have reversed and matched the Invoice transactions multiple times and Finally tried to cancel
the invoice .Then invoice showed up with distribution amount 0.00.
The user attempts to revalidate the invoice which results in Error2
below:

APP-PLSQL-97634:The invoice ********XX has an accounting hold and is pending cancellation so you can no longer submit for validation.To have the
system automatically validate the invoice and complete cancellation, please
either manually release the hold, or correct the errors that caused the hold,
then cancel the invoice.


The user have enterd 2 new invoices later and matched it to po 108, with the same distribution account1 as above and validated.

Please help, the users need to close the period of August 08...