Issue on confirming a purchase order

(0) Share

Report

Posted on by Finance and operations

Hi,
A user has created a Purchase requisition that was successfully converted to a PO.
We have a batch job that confirm automatically the POs.
For an unknow reason, the Batch stopped running and displays an error message.
I checked each single distribute amount from the PO lines and all seems good.
Can you please advise what should be done

Message details

Infolog for job Purchase order confirmation GEN. (5659642782)

Infolog for task Purchase order confirmation GEN. (5665974186)

No lines for posting or quantity = 0

Posting

Purchase order: GEN-PO008151

Item number: 210-AVJY - Non-Touch

The source document lines cannot be finalized until the status is Confirmed.

The state of the source document or source document line could not be updated.

Update completed

An error occurred during update

Batch task failed: Posting

An error occurred during update

End of task log
__________

Thank you !
kamel.

I have the same question (0)

All responses (6)

Answers (0)

Sort by

jannawangD365 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Kamel,

how about the document status?

Was this reply helpful? Yes No
Finance and operations on at

Like (0)

Report
Copy link

Link copied!

Hi,

The document status is None

.
In this PO there is 2 items, the message is pointing only one of the 2 items

I checked, all the same beside this attributes that is not completed for the item pointed.

Thank you !

Was this reply helpful? Yes No
Finance and operations on at

Like (0)

Report
Copy link

Link copied!

Hi,

Here is an additional information.

I created a similar purchase requisition that was converted to a PO and I confirmed successfully the PO manually.

I created another record but this time, I waited for the batch to confirm it. There I received the error message in the Batch job LOG

I opened the View tasks,
As soon as I clicked on the Log, I refreshed the PO then it has been confirmed automatically.
I still need to understand this behavior

Thank you !

Was this reply helpful? Yes No
jannawangD365 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Kamel,

Could you help to check the PR and PO line. go to the line, highlight it and click the line menu 'finance-> distribution amount'. in the new window, there is a filed 'the current document accounting status'. what's that status? 'in process'? it needs to be completed before you try to post PO confirmation.

Was this reply helpful? Yes No
Finance and operations on at

Like (0)

Report
Copy link

Link copied!

HI,
I checked, yes the "Current document accounting status" is In process status but there is no way how to update this status to show completed.

and when I try to confirm manually this PO

Thank you !
kamel.

Was this reply helpful? Yes No
jannawangD365 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

HI Kamel,

it needs manually data repair for the related tables:

--Update Accounting Distribution table
--Update SourceDocumentLine table
--Delete the SourceDocumentLine records in accounting status of 1
--Update SourceDocumentHeader table

since you are using D365, you may need ti submit a support ticket to let support team to run the data repair for your PROD.

Was this reply helpful? Yes No