Hello everyone:
There is a problem need to help! When I delete a PO line, sometime the record is deleted, but sometimes the record still showing up in the PurchLine table, the IsDelete field populated "Yes".
What's the reason, the purchase line are update: IsDelete = "Yes"
There are two records in PurchTable form.
But in the DB table, there are 10 records.
Thanks!
*This post is locked for comments
Hi Gertjan ,
As you said that if the PO is confimed then it will store PO lines in another tables also , So could i know the all related tables for PO lines .
Could you share me the all related tables list or share me any link ?
Thanks for your help!
Parker
Good evening,
The purchLine is only completely deleted when there is no versioning involved. If versioning is enabled for purchase orders (and you have for example confirmed the purchase order), the purchline has a 'soft delete', leaving the line in the database, but marking it as deleted.
If you are reporting on the purchLine table directly, you should include a filter on this isDelete field as well. When a line is deleted, the inventory transaction behind the purchase line is always deleted, preventing the purchase order line to be included in your master planning.
Hope this information helps,
Gertjan
There is no custom function for delete. Thanks!
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
