<?xml version="1.0" encoding="UTF-8"?>        <rss version="2.0"
             xmlns:atom="http://www.w3.org/2005/Atom"
             xmlns:dc="http://purl.org/dc/elements/1.1/"
             xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
             xmlns:admin="http://webns.net/mvcb/"
             xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
             xmlns:content="http://purl.org/rss/1.0/modules/content/">
        <channel>
            <title>
									Generic inquiry with information from Audit history(CT301000) - Acumatica Generic Inquiries &amp; Pivot Tables				            </title>
            <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/</link>
            <description>Acumatica User Group Forums</description>
            <language>en-US</language>
            <lastBuildDate>Mon, 09 Nov 2026 13:58:53 +0000</lastBuildDate>
            <generator>wpForo</generator>
            <ttl>60</ttl>
							                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-11624</link>
                        <pubDate>Tue, 02 Dec 2025 02:47:46 +0000</pubDate>
                        <description><![CDATA[@graemelm Just pulled it in as a Custom DAC fed by the SQL View. I didn&#039;t take it as far as separating the data out into columns.]]></description>
                        <content:encoded><![CDATA[@graemelm Just pulled it in as a Custom DAC fed by the SQL View. I didn't take it as far as separating the data out into columns.]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>Tim Rodman</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-11624</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-11620</link>
                        <pubDate>Sun, 30 Nov 2025 22:04:44 +0000</pubDate>
                        <description><![CDATA[@timrodman Hi Tim, hope you&#039;re well!
I&#039;m interested to know from the above, how you went on to &quot;work with it in Generic Inquiries&quot; ?Did you simply pull the data as is in the view? or were y...]]></description>
                        <content:encoded><![CDATA[<p>@timrodman Hi Tim, hope you're well!</p>
<p>I'm interested to know from the above, how you went on to <em>"work with it in Generic Inquiries"</em> ?<br />Did you simply pull the data as is in the view? or were you able to use the pipes to separate the data out into columns?</p>
<p>Appreciate any examples you can give to show how to use the PSV (pipe separated values) data.</p>
<p>Cheers</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>GraemeLM</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-11620</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-11052</link>
                        <pubDate>Thu, 07 Dec 2023 21:29:25 +0000</pubDate>
                        <description><![CDATA[Unfortunately, AugSQL (click here) doesn&#039;t support MySQL at this time which MYOB runs on, but I was able to do the following in an Acumatica SaaS environment (which runs on Microsoft SQL Ser...]]></description>
                        <content:encoded><![CDATA[<p>Unfortunately, <a href="https://www.augforums.com/augsql/" target="_blank" rel="noopener">AugSQL (click here)</a> doesn't support MySQL at this time which MYOB runs on, but I was able to do the following in an Acumatica SaaS environment (which runs on Microsoft SQL Server) using AugSQL.</p>
<p>Now, I know that there could be pipes in the data so this isn't perfect, but the following delimits the fields with pipes. You could use something other than pipes or maybe use multiple characters like two pipes together.</p>
<p>I don't understand why I had to use "COLLATE Latin1_General_BIN", but I found that in a Google search somewhere and it seemed to work so I used it.</p>
<pre contenteditable="false">SELECT TOP 100 ModifiedFields,
REPLACE(ModifiedFields COLLATE Latin1_General_BIN,NCHAR(0) COLLATE Latin1_General_BIN,'|') 'ModifiedFieldsWithPipe'
FROM AuditHistory
WHERE CompanyID=2</pre>
<p> </p>
3374
<p> </p>
<p>I'm using this technique to create a SQL View that is the <span style="text-decoration: underline">AuditHistory</span> table, but with the new version of my <span style="text-decoration: underline">ModifiedFields</span> column that has pipes for the delimiter. Then I'll be able to work with it in Generic Inquiries.</p>
<pre contenteditable="false">CREATE VIEW dbo.MyViewsAuditHistoryWithPipes AS
SELECT CompanyID,BatchID,ChangeID,ScreenID,UserID,ChangeDate,
Operation,TableName,CombinedKey,
REPLACE(ModifiedFields COLLATE Latin1_General_BIN,NCHAR(0) COLLATE Latin1_General_BIN,'|') 'ModifiedFields'
FROM AuditHistory</pre>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>Tim Rodman</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-11052</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-9951</link>
                        <pubDate>Mon, 30 May 2022 11:41:42 +0000</pubDate>
                        <description><![CDATA[OK, no luck, looks like the delimiter is stripped out before displaying the field in the GI, so there is really no way of working with that data in the GI.  Pity!]]></description>
                        <content:encoded><![CDATA[<p>OK, no luck, looks like the delimiter is stripped out before displaying the field in the GI, so there is really no way of working with that data in the GI.  Pity!</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>Marcia Walker</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-9951</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-9950</link>
                        <pubDate>Mon, 30 May 2022 10:52:44 +0000</pubDate>
                        <description><![CDATA[@roycelithgo Thanks, this is very useful to me.  I was wondering what the delimiter is here, and I&#039;m going to try a few things and see if they work.  I don&#039;t have access to do customisations...]]></description>
                        <content:encoded><![CDATA[<p>@roycelithgo Thanks, this is very useful to me.  I was wondering what the delimiter is here, and I'm going to try a few things and see if they work.  I don't have access to do customisations, so I can't try what I would like to, but I might attempt a GI using the delimiter.</p>
<p>I would imagine that the <span>PX.SM.AUAuditInquire code is just looping through the "modifiedfield" data to check field names (which you can also get from the PX.SM.AUAuditField table), and then looping through it again to get the data out.  So e.g. if the field that changed is 5th in the list of fields in the PX.SM.AUAuditField table, then you place the matching data under the fifth column.</span></p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>Marcia Walker</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-9950</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3284</link>
                        <pubDate>Sun, 16 Dec 2018 20:27:49 +0000</pubDate>
                        <description><![CDATA[When you said &quot;doesn&#039;t show any information if/when a row has been deleted&quot; I thought you meant that it doesn&#039;t Audit deletes, which it does. But the data from the deleted row isn&#039;t recorded...]]></description>
                        <content:encoded><![CDATA[<p>When you said "doesn't show any information if/when a row has been deleted" I thought you meant that it doesn't Audit deletes, which it does. But the data from the deleted row isn't recorded in the Audit table, which is what I think you were after. </p><p>You could try adding on to this idea:</p><p>https://feedback.acumatica.com/ideas/ACU-I-259</p><p> </p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>Royce Lithgo</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3284</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3278</link>
                        <pubDate>Fri, 14 Dec 2018 10:56:33 +0000</pubDate>
                        <description><![CDATA[HiAlso, the AuditHistory table doesn&#039;t show any information if/when a row has been deleted. This was one main point to be able to show. If that would have been included I think we could have...]]></description>
                        <content:encoded><![CDATA[<p>Hi</p><p>Also, the AuditHistory table doesn't show any information if/when a row has been deleted. This was one main point to be able to show. If that would have been included I think we could have used the somewhat "messy" information in the ModifiedFields-field. Either way, in this case now we will just use the Audit history(SM205530) screen to view the information. Thank you very much for your help and investigation! 🙂 </p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>VJW</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3278</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3272</link>
                        <pubDate>Thu, 13 Dec 2018 21:33:24 +0000</pubDate>
                        <description><![CDATA[Audit history is stored in AuditHistory table. Here&#039;s a simple query reflecting a change I made to vendor contact and address:The problem is that all of the changes are recorded in ModifiedF...]]></description>
                        <content:encoded><![CDATA[<p>Audit history is stored in AuditHistory table. Here's a simple query reflecting a change I made to vendor contact and address:</p><p><img src="https://i.imgur.com/REGiEu6.png" /></p><p><img src="https://i.imgur.com/NkyBgt6.png" /><img src="https://i.imgur.com/vvj2npB.png" /></p><p><img src="https://i.imgur.com/txM3AZv.png" /></p><p>The problem is that all of the changes are recorded in ModifiedFields field, which has the following structure:</p><p>RevisionID0x00&lt;Revision Number&gt;0x00&lt;FieldName&gt;0x00&lt;FieldValue&gt;*</p><p>In other words, Revision Id and then one or more field name &amp; value pairs. The delimiter used is unicode Null, or 0x00 (UTF-8 hex).</p><p>Here's an example string in JSON encoding:</p><p>"RevisionID\u00002\u0000Salutation\u0000Joe Blogs\u0000AssignDate\u000011/07/2014 00:34:05"</p><p>Decoded this would be: "RevisionID 2 Salutation Joe Blogs AssignDate 11/07/2014 00:34:05" - so you can see Salutation and AssignDate were updated, although I actually only modified Salutation. The system updated AssignDate. </p><p>The problem is, I can't find any way to replace unicode null with a whitespace in GI. On the Audit History page, the code is obviously parsing this string to assign the dynamic columns in the lower table on that page. I cant find the source code for the PX.SM.AUAuditInquire so I can't see how Acumatica are doing this. Find in Files also doesn't match "modifiedfield". Even if this issue can be resolved, you're still left with a string of fieldname value pairs which you'd need to decide what to do with as it's not exactly end user friendly.</p><p>Seeing as Report Designer has the same functions as GI, don't think you'd have any luck with that either. </p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>Royce Lithgo</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3272</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3267</link>
                        <pubDate>Thu, 13 Dec 2018 12:22:37 +0000</pubDate>
                        <description><![CDATA[Thanks for the reply! I investigated a bit more and found out that the columns in Audit history are created dynamically(which is logical as different screens/tables have different fields). S...]]></description>
                        <content:encoded><![CDATA[<p>Thanks for the reply! I investigated a bit more and found out that the columns in Audit history are created dynamically(which is logical as different screens/tables have different fields). So I'll need to check a bit more on which tables might be involved in this specific scenario and see if I somehow manage to get out the information needed. If anyone has some ideas or tips on what tables to look for I would appreciate any help=)</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>VJW</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3267</guid>
                    </item>
				                    <item>
                        <title>RE: Generic inquiry with information from Audit history(CT301000)</title>
                        <link>https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3263</link>
                        <pubDate>Wed, 12 Dec 2018 21:00:49 +0000</pubDate>
                        <description><![CDATA[Some of those DACs aren&#039;t actual tables - the trick unfortunately is going to be to workout which of the audit DACs exist in the database.AuditFilter is most definitely not a table (any DAC ...]]></description>
                        <content:encoded><![CDATA[<p>Some of those DACs aren't actual tables - the trick unfortunately is going to be to workout which of the audit DACs exist in the database.</p><p>AuditFilter is most definitely not a table (any DAC with Filter in the name isn't usually a table) - it's used for specifying criteria on the page. If you can access the database you can see which Audit tables really exist. Otherwise do some test queries looking at the data in each Audit table (or getting an error if it's a non-DB DAC).</p>]]></content:encoded>
						                            <category domain="https://www.augforums.com/forums/acumatica-generic-inquiries/">Acumatica Generic Inquiries &amp; Pivot Tables</category>                        <dc:creator>Royce Lithgo</dc:creator>
                        <guid isPermaLink="true">https://www.augforums.com/forums/acumatica-generic-inquiries/generic-inquiry-with-information-from-audit-historyct301000/#post-3263</guid>
                    </item>
							        </channel>
        </rss>
		