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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Customer History

Status
Not open for further replies.
jay4linux

jay4linux

IS-IT--Management
Nov 29, 2007
1
0
0
US
I need to export customer history to a linked mysql database.

I need the customer balance and all transactions history for each customer. I have the linked mysql database setup and working. I just need to know how to figure out how what the SQL query for customer history would be.

Can anyone point me in the right direction.

Thanks,
Jay
 
Status
Not open for further replies.

Similar threads

mbogdanoff
  • Locked
  • Question
Deleting Customer Accounts (cards) - Are there any problems?
Replies
3
Views
60
slantsix
slantsix
MBresnan
  • Locked
  • Question
Linking POP30310 (Receipt Line History) and the GL Account number (POP30390?)
Replies
1
Views
61
VictoriaYudin
VictoriaYudin
Luvsql
  • Locked
  • Question
Apply return from one customer to another using national accounts
Replies
0
Views
37
Luvsql
Luvsql
LyleU
  • Locked
  • Question
Export to Package File - Memory Error
Replies
0
Views
42
LyleU
LyleU
1128
  • Locked
  • Question
SOP Credit Holds if customer past due after 61 days
Replies
0
Views
22
1128
1128

Part and Inventory Search

Sponsor

Back
Top