General information
Category:
Coding, syntax & commands
>Hi again:
>
>I have one more instance that I am racking my brain over and cannot seem to modify the procedure that I currently have in my system. I do not even know if this is possible.
>
>Currently I import a lot of data from different sources, but I will choose one client for this instance.
>
>Lets say the initial import of the data is (this goes into the main table):
>
try changing your IMPORT DBF file layout to be this:
customer id, quote no, quote date, quote due, quote status, quote price, pid
seed the first record with pid value = 1
then after you import -
locate for empty(pid)
skip -1
m.pid = pid
skip 1
scan rest
m.pid = m.pid + 1
replace pid with m.pid next 1
endscan
that will give you a unique identifier for each record pid - make it integer data type
then ? if you get in a record with everything else the same but the dollar amounts and the pid ? the record with a higher PID value will have the 'latest' data and you can do some math with a prior record and the 'latest' record [for example ! but - you can code up anything you want for *your* inhouse processing, right? ]
you are mentioning QUOTE system and speaking of INVOICE data to somehow
reformulate remaining payments
I think you need some other business process , but I don't want to hammer that concept too much .
In other systems that I've been elbow deep a coding - the QUOTE system was seperate from the INVOICE system, with some linkages when a QUOTE was turned into an ORDER, an INVOICE was generated with the info from the quote.
BUT ? perhaps this is some quote tracking system and you are measuring DIFF's for some other reason ?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only