Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Sales Booking History and OnInsert,OnModify, OnDelete

Posted on by Microsoft Employee
Now I want to log sales order insert/update/deletion log into a customized table named Sales Booking Table. My NAV version is NAV 4.0 SP1. For example, May 1Action: Create SO-001, Item A, Qty=10, Price=100 Expection: Booking Entry 1 to record the booking of Item A, Qty=10, Price=100  May 2 Action: Qty is changed from 10 to 20Expection: Booking Entry 2 to record the debooking of Item A, Qty=-10, Price=100                Booking Entry 3 to record the booking of Item A, Qty=20, Price=100  May 3Action: Price is changed from 100 to 200Expection: Booking Entry 4 to record the debooking of Item A, Qty=-20, Price=100                Booking Entry 5 to record the booking of Item A, Qty=20, Price=200   Actually what we need is the sales order booking change log.  In the case, as you know, in sales header the order date is never changed. Originally I think of table 405 change log entry, but the table structure is too complex to output the record format what I need. So I give up the idea to get the information from table 405 to output SO booking report. Now I create a customized table named SO booking table to record the history. I add new record trigger for my customized table in OnInsert(), OnModify(), OnDelete() of table 37 sales line. My test result is ok with manually create/update/delete SO. But the trigger to insert customized table record don't work if I convert sales quotation into sales order, or I use DataPort to import sales lines in Sales Order. So my questions is why OnInsert(), OnModify(), OnDelete() of table 37 sales line is not triggered on the system event occurrence to insert booking entry, i.e. DataPort import or Make Order in Sales Quotation. Could you please have a look at my issue. Or do you guys has some better solution to help me to output a report of sales order booking? Thanks in advance!!            

 

*This post is locked for comments

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans