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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Peak Data Commission enhancement

Status
Not open for further replies.
Zbob

Zbob

MIS
Apr 25, 2002
94
US
Anyone know where the commission percent is stored.

When you enter a commission in the price file. It accepts and saves the percentage. I need to write a report to pull this field.

Peak Data told me there was a table called OEPDSCOM, but its not in there.

Thanks

Bob Zaback
 
Sort by date Sort by votes
Zbob,

Are you on the SQL version or the pervasive version? Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
Upvote 0 Downvote
Zbob,

Assumming you can access the data when no one else in actively using Macola, go into your price code fiel and make a change to a record. The go to windows explorer, browse to your data directory, and sort the files by date.

This should indicate which file was most recently written to.

I hope this helps. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
Upvote 0 Downvote
I tried this already and the only file updated is the oeprcfil.

I know its updating somewhere. Peak data is being of no help.

We installed the update about 5 years ago and have never had a need to use any of there upgrades

It works great, I just can't find the data being changed.
 
Upvote 0 Downvote
How do you know that the OEPRDFIL is not the right answer?
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
Upvote 0 Downvote
its not in there. No Commission percentage, I looked in all the fillers and another field that combines custnum and itemnum.
 
Upvote 0 Downvote
If the developer's app doesn't update the DDF's to reflect table changes he has made your not going to see the field if you are using a tool that depends on the DDF's to access the data, such as Access or Crystal. This is a common failing of Btrieve "enhancement" developers. Most do it on purpose to shroud their apps in mystery. Contact them to see if they will supply a set of DDF's that are correct.
 
Upvote 0 Downvote
Zbob,

Shoot me an email and I will email you the .ddfs that contain this table. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J G PM
  • Locked
  • Question
Sales Person Data
Replies
2
Views
189
J G PM
J G PM
Knick
  • Locked
  • Question
Macola 7.9.300 link in database of MRP to Job created to fulfill the MRP Requirement
Replies
1
Views
131
NEmacGuy
NEmacGuy
Purafil
  • Locked
  • Question
Data upload program for Macola
Replies
1
Views
114
dgillz
dgillz
ActiveRad
  • Locked
  • Article
Data in use for AR / AP dept when trying to enter or rec payments 1
Replies
1
Views
110
crystalreporting
crystalreporting
ndininno
  • Locked
  • Question
Print Duplicate Invoice (No data which meets the current criteria)
Replies
10
Views
300
crystalreporting
crystalreporting

Part and Inventory Search

Sponsor

Back
Top