Information générale
Catégorie:
Codage, syntaxe et commandes
>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 ?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement