item cannot be deleted eventhough transaction is all cleared.(help)

(1) Share

Report

Posted on by Adrian1234

657

hi, i want to delete an item that is already in a PO, but i have removed that particular item in the PO lines, and when i hit the manage inventory tab and press transaction button is all cleared. Yet when i tried to delete it, the following infolog still occured:

"Items cannot be deleted while dependent Inventory transactions exist. Delete dependent Inventory transactions and try again."

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

faiz7049 2,382 on at

Like (1)

Report

Dear Adrian,

In AX there are to many table interconnected each other.First check does you assign any financial dimension to item which you want to delete.

Please remove it and try to delete and if not than go to On Hand Inventory check on order and in order field should be none for that item.

Hope this will help you.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

Hi Adrian,

Like faiz7049 mentioned, check if you have financial dimension values based on item numbers. There might be some records in the InventSum table (on hand informaton) that could also block deleting the item.

Was this reply helpful? Yes No
Suggested answer

vijaysharma 2 on at

Like (1)

Report

Hi,

It can not be possible until you customize the code.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (2)

Report

Hi,

Apart from other replies,

1. please check the delete actions with PurchLine table.

2. do check in other purchase order lines may exits with the same item.

Was this reply helpful? Yes No
Adrian1234 657 on at

Like (0)

Report

nope its left blank.

Was this reply helpful? Yes No
faiz7049 2,382 on at

Like (0)

Report

Did you check on hand inventory ?

Was this reply helpful? Yes No
Adrian1234 657 on at

Like (0)

Report

yes, its none, null, 0

Was this reply helpful? Yes No
Suggested answer

Ismail Tako 7 on at

Like (1)

Report

Thanks, working fine after deleting actions with the PurchLine table in AOT.

Was this reply helpful? Yes No
HalfTheWorld 5 on at

Like (0)

Report

I've seen this happen if the purchase order is created and confirmed (po confirmation record created for that item). Even deleting the PO line and cancelling the purchase order will not resolve it. Just throwing that out there as a place to look if there is a record for that item not allowing the item to be deleted.

Was this reply helpful? Yes No