Order Entry update 2

[joelabine]

Hi,

I need to find a way to know if an order entry changed since the last time my software read the information. (Something like "last post date and time")
So what I did is to list all the fields in the OE0520 view. Copy all values in an Excel sheet. Then I updated the order entry and list all fields again. Put the new values in excel an compare each fields values. The only one that changed (except the "description" for my test) is SHIUNIQ (not sure what it is used for).
So unless SHIUNIQ is the field I should use to make my verification, I don't know how to do it.

Another solution would be to read directly in the database in OEORDH and compare the AUDTDATE and AUDTTIME to the one previously read... But that wouldn't be my favourite solution. I would rather get the information directly from a view.


So my question is : What is the best way to know if an order entry changed since the last time I read the information.

Regards

 

[ettienne]

AUDTDATE & AUDTTIME

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[joelabine]

Ok just to be sure, my only option is to read the database directly?

 

[Jay Converse]

Yes, or use the CS0120 view, which is the same thing.

 

[ettienne]

Use CS0120, you can run SQL queries.
select * from OEORDH where blah blah etc

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[joelabine]

Yeah this is what I'm going to do then.

Thanks for your help

 

[joelabine]

Another question.
How can I be sure which date format is going to be use by the AUDTDATE? Does it uses the system date format?

 

[Jay Converse]

It's yyyymmdd relative to GMT.

 

[joelabine]

Thanks,
you guys are blazing fast!