Accpac 5.6 (200) - question on systen dates

[Stephensmith]

Hi everyone. I have just arrived in a new company, who use ACCPAC as their ERP system. I am not a tecky but rather an operation leader, trying to understand more about the process flow across the company. I have asked our outsourced support company to help build some reports. One of the critical bits of information relates to dates, or more specifically transaction dates. I wanted to find out when a sales order transaction was created in the system so i could start looking at operational cycle times. I was told that ACCPAC doe not store any system dates at order entry but only those that are keyed in. I am a little puzzled (I know every system is different), as the dates available are already used for their intended purpose (customer order date, etc) and I do not want to change them. For all you experts out there, is this true? I need to be able to track the date and time an order was entered into the system, preferably by the user.

 

[Jay Converse]

They are partially correct. There are fields in every table called AUDTDATE and AUDTTIME, which capture the last time the record was touched. But, they can change, for example, it will have one date when it's entered, and another when day-end is run. And, if you do a Dbdump/Dbload, they all get wiped out.

But if you really need those exact dates and times, get the Audit Logger add-on.

http://www.pacifictechsol.com/?q=pts-solutions/sage-accpac-erp-products/audit-logger

 

[ramam1]

You might checkout Sage KB 210-30254

 

[Jay Converse]

No, ramam1, having the AOM won't help. There are no times in OE tables.

 

[Stephensmith]

Thanks to Ramam1 and tuba2007.

A stupid question, how best to find and look at Sage KB 210-30254 (i am assuming its a knowledgebase article)? I did try to google it but didnt get anything useful back.

May I aslo know, if only dates were important (and not time) would option come into play?

Regards
Stephen

 

[Jay Converse]

To see that KB number, you need to go to the Sage website and hit their KB. I use partners.sagenorthamerica.com, but if you're a customer, I don't know what the URL is.

And no, if only dates were important, it's still not good enough. Like I said before, AUDTDATE changes, and any other dates like ORDDATE or SHPDATE can be changed by the users during data entry.

 

[ettienne]

Customer portal is here:

https://customers.sagenorthamerica.com/irj/portal/kbsearch