Extract Order Status and Order History - VB

[rorye]

I am trying to extract Order History and Order Status using Visual Basic 6 and ACCPAC.xapisession.

The Order History is to extract the history of the items bought by a customer for a six month period. I therefore would pass in their Customer number and the relevant periods and then want to get back all current and historical transactions per item they have purchased.

The order status is to just extract that information for current orders to show the client how their order is progressing through (i.e. shipped / back order / printed etc.)

Can anyone give me some same code.

Thanks in advance

 

[jayconverse]

Use either the Sales History Details (OESHDT) or the Posting Journal Details (OEAUDD) table. Your code depends on your output method.

Jay Converse
IT Director
Systemlink, Inc.

 

[rorye]

Thanks for that.

Do you have any sample code for something like this?

 

[jayconverse]

OESHDT.Browse "CUSTOMER = " & myCust & " AND YR = " & myYear & " AND PERIOD = " & mPeriod,True
Do While OESHDT.Fetch

{your output method}

Loop


Jay Converse
IT Director
Systemlink, Inc.