ji8500
Technical User
- Jan 15, 2008
- 1
I am trying to find out where / if MAS90 stores the date that a sales order was closed out.
Thanks for the help...
John
Thanks for the help...
John
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date a Sales order was closed
- Thread starter ji8500
- Start date
- Status
John,
An order could be totally invoiced, partially invoiced, or deleted.
If you are on MAS 4.2, the you can look at the SO_SalesOrderHistoryHeader table (using Crystal, Access, ...)that will have some helful information.
OrderStatus: C=Complete, A=Active, X=Deleted
LastInvoiceDate: this is the last date it was invoiced
DateUpdated: last date it was updated
Prior to MAS 4.2 the file is SO_03. It doesn't have the DateUpdated field.
Andy
An order could be totally invoiced, partially invoiced, or deleted.
If you are on MAS 4.2, the you can look at the SO_SalesOrderHistoryHeader table (using Crystal, Access, ...)that will have some helful information.
OrderStatus: C=Complete, A=Active, X=Deleted
LastInvoiceDate: this is the last date it was invoiced
DateUpdated: last date it was updated
Prior to MAS 4.2 the file is SO_03. It doesn't have the DateUpdated field.
Andy
- Status
Similar threads
- Locked
- Question
- Locked
- Question