200
HI all,
As part of some development , I need to know that whenever a transaction enters in the system in any type of module Is there a table available which stores the creation date of transaction.
Even when the transaction goes thorugh working -->open -->Histroy status this creation date should not change.
If possible ,Can you please let me know the table name for such date ?
*This post is locked for comments
It seems to me that you have already gone along with this task achieving a considerable progress. Your point is totally to the point, when a transaction is saved in certain open table such as PM10000, the timestamp field gets updated with the current date-time value as retrieved on the SQL server level. Upon posting, will be retrieved again and recorded along in PM20000 losing the original timestamp value.
To get back to the point of timestamp, it provides server-based timestamp to be recorded against each new "row" in the table.
The bottom line is, I don't believe that this information will be available once the record is moved from open to work, which is why you might be unable to get this piece of information for "Historical Transactions."
On the other hand, for future purposes, you can consider several approaches to save this timestamp somewhere else either by considering Dynamics GP Activity tracking, or creating your own stored procedures to keep this information somewhere else.
Your feedback is highly appreciated,
For the first problem use the Dex_ROW_TS field to get the transaction saved from work(PM10000) with using the SQL view. (eg. Select DEX_ROW_TS 'Created Date', * from PM10000).
For second, we can't track the created date flow from work to open then to hist.
But, you can do it by creating table trigger for feature transactions.
Hope this helps!!!
The problem is to do the vat calculation we have configured a Sql view in our system and we need to capture the date when the transaction was created in great plains system (becomes Working in pm10000) table.
the second problem is that the transaction moves from PM10000 table ot PM20000 and then to PM30200 table on changing the status from working -Open and History and it deletes the existing records when it was hold in PM10000 table
Could you please advise is this date get recorded in some TAX table.
The created data is not saved in separate GP tables. Some date field will be saved instead of created date in GP work, open and hist tables of the each module.
The DEX_ROW_TS field is available all the work, open and history table with holding the date and time of the record inserted. We can see this field in back end not GP.
For all the open and history tables has the date field called Posted Date this will hold the date value for the transaction posted/created.
Hope this helps!!!
hi Arpit
where the created date is stored it is stored on the data table with the transaction rather than on a separate table as you hope.
the dex row id may have a date time stamp on it, that is available only via sql / crystal (a reporting / querying tool)
also ponder what you mean by creation of a transaction.
in the general ledger there are;
last date edited
modified date
originating posted date
all three of those could be considered the creation date of the transaction depending on your perspective.
ian
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
