Notifications
Announcements
Hi All,
May I know whether SalesParmTable and SalesParmLine is temporary table during sales posting only or it will store data permanently to these table even after posting?
Thank you.
*This post is locked for comments
Hi, These are not temp tables and records do not get deleted after sales order posting. These tables create records based on user sessions which is distinguished by ParmId.
"Parm" tables are not temporary tables. They are regular tables. However, once the posting is complete this data is not used any longer. You should develop a maintenance schedule to clean up these tables, so they don't get too large. AX provides clean up functionality to delete old parm records. Before using these clean up jobs make sure you check for relationships with or dependencies from custom tables, so that referential integrity is properly maintained.
Hope this helps. --Tom
Hi
The "PARM" tables aren't temporary, but contain all Posting data session.
Every session have a different ParmId value.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
TAHER Mehdi 3
Martin Dráb 2 Most Valuable Professional
Volodya 2
