AP Create Accounting

[tariq1258]

I have Cancelled a Standard invoice the status of which is Accounted=No

When i create accounting message appers

On line Accounting could not be created plz submit create accounting program.

But when i submitt create accouting program , the status remains at

Accounted= No.

There is no related payment.


This also not allow to close AP Accounting period.

Plz guide me on this at ur earliest

[tgs100]

1. Is GL period open on the GL date of the invoice?
2. Is there any error in the view output file? (against the Create Accounting Concurrent Program)

Cheers,
Saravanan TG

[AmanKhan]

Delete invoice from database as accounting is not generated for the invoice then u close AP period.

thanks,

[hiszaki]

Hi tariq

Check for this invoice, is this invoice applied to prepayment or not?

Thanks
Hisham

[niletra]

Hi,

Can u plz tell me What is Staus in AP_INVOICE_DISTRIBUTIONS_ALL.

And What is the Staus

in XLA_EVENTS TABLE.


Thanks

Best Regards,
Niletra Desai

[vksharma]

Hi,
The Possible issue are:

Please check if this Standard Invoice was Validated or Not.

Any standard Invoice which is created and saved but not yet validated and Accounted cannot be cancelled.

Always Delete such invoices or validate and account them first and than cancell and account them.

In you have the issue because of the above way than please ask Oracle support to supply a script to Either reverse the cancellation flag and than follow the process above.

Thanks
V.K.sharma
Manger-ERP
+919810468878

[vksharma]

Hi,
The Possible issue could also be in case if the standard Invoice has Prepayments Applied:

Than please check all the Prepayments which you have applied in the Present Standard Invoice whether the Payment has been accounted or not.Generally while making the payments for prepayments End Users forget to do accounting and when these prepayments are applied on Standard Invoices than it does not allowaccounting.so first account the paymen of prepayments and than Account the Standard Invoice.

V.K.sharma
Manager-ERP
+919810468878

[AmanKhan]

Open SR with Oracle for the payments and require datafix to account the payment.

I have encountered and resolved create accounting errors related to such kinda payments. Only datafix is the right solution.

thanks,

Fahd