In the example below Auditing has been turned on for table SORDERQ \u2013 field QTY \u2013 Modification only. This will tell us who changed and when a Quantity Ordered was changed on a Sales Order.<\/p>\n\n\n\n
- \n
- To turn on an audit trail on a table, go to Development, Data and Parameters, Tables, Table<\/li>\n\n\n\n
- Select the table from the left list \u2013 SORDERQ \u2013 the Sales Order Quantity table.<\/li>\n\n\n\n
- On Audit tab, under Type of Audit, select Modification<\/li>\n\n\n\n
- Under Fields audited, enter QTY, click Save and Validation<\/li>\n<\/ul>\n\n\n\n
Step 1:-First, set the conditions for the product as shown in Fig. 1. Navigate to> Common Data > Product > Management tab, and check the “Stock < 0 authorized” checkbox. If you select the checkbox as shown in Fig. 1, we are able to proceed with (negative stock)all processes, including sales order, delivery, and invoice posting, even with negative stock, without facing any errors.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/09\/Fig1.-Table.png\")
<\/figure>\n\n\n\nFig1. Table<\/strong><\/p>\n\n\n\n
Step.2:-<\/strong><\/h2>\n\n\n\n
Go to a Sales Order and change the Quantity on a Line item \u2013 see Line item 2, the quantity Ordered is 16.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/09\/Fig2.Sales-order-screen.png\" "\\"Sales")
<\/figure>\n\n\n\nFig2. Sales order screen<\/strong><\/p>\n\n\n\n
Step.3:-<\/strong><\/h2>\n\n\n\n
Change the Quantity Ordered to 17 and Save.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/09\/Fig3.Quantity.png\")
<\/figure>\n\n\n\nFig3. Quantity<\/strong><\/p>\n\n\n\n
Step.4:-<\/strong><\/h2>\n\n\n\n
View Audit log, go to Usage, Audit, Fields, enter Table SORDERQ and Field QTY and search.<\/p>\n\n\n\n
Here you will be able to view the User, previous value and new value.<\/p>\n\n\n\n
You can see that the previous Quantity was 16 and the new value is 17, the user is admin.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2025\/09\/Fig4.-Audit.png\")
<\/figure>\n\n\n\nFig4. Audit<\/strong><\/p>\n\n\n\n
Run the audit log to confirm the change is accurate.<\/p>\n\n\n\n
Thus this blog help us to know about the use By ‘How to used auditing’ in sage x3.<\/p>\n","protected":false},"excerpt":{"rendered":"
In Sage x3 many times you may want to know when and who changed, deleted or added a record to a table. This is possible using the Auditing feature in X3. You can turn Auditing on for select tables and fields and then see who modified, added or deleted from this table. We do suggest\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,4,5,3162,6,13,7,8,3642,10,2796,11],"tags":[162,4414,1590,1780,1822,1839,3211,2871,1938,1942,1943,1945,1947,1977,2225,3735],"class_list":["post-31214","post","type-post","status-publish","format-standard","hentry","category-configuration","category-debug","category-faq","category-features","category-greytrix","category-installation","category-integration","category-miscellaneous-tables","category-sage-erp-x3","category-sage-x3","category-standard","category-technical","category-tips","tag-audit","tag-auditing","tag-quantity","tag-sage-erp-x3","tag-sage-x3","tag-sage-x3-blogs","tag-sage-x3-functional-blog","tag-sage-x3-functional-blogs","tag-sage-x3-techhnical","tag-sage-x3-technical-assistance","tag-sage-x3-technical-blog","tag-sage-x3-technical-blogs","tag-sage-x3-technical-issues","tag-sales","tag-table","tag-x3-blogs"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=31214"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31214\/revisions"}],"predecessor-version":[{"id":31237,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31214\/revisions\/31237"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=31214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=31214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=31214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}