Please add a validation to the allocation account delete function by checking if the allocation account has been used / posted in the PM30600 table. This is to prevent user accidentally delete an existing allocation account. It will have orphan DSTINDX number that does not exist in GL00100 table. It can result inaccurate data when user joins the PM30600 table in smartlist to get the invoice accounting distribution.
Comments
I just ran into this and it affected 822 records and they cannot get this information back in the sub ledger distribution tables for reporting. If they have been used and posted in any transaction - they should not be allowed to be deleted from GP - just made inactive, like posting accounts.
Category: Financials - Accounts Payable
Jodi Christiansen (administrator) on 4/30/2019 7:04:13 PM
Hi David,
Thank you for your suggestion, we will look into this for a future version.
Jodi Christiansen
PM, Microsoft