creating new field to total cases in invoice file (AREV Specific)
At 21 JAN 1999 09:48:21PM manya barton wrote:
I have been to the dictionary and tried to add a row to my invoice file that would put the total cases ordered at the bottom of my invoice but I have had no luck. Can you tell me exactly what I need to do to get this done?
At 22 JAN 1999 01:33PM [email protected] wrote:
Manya,
Here is a best guess without seeing your data structure ..
If you are trying to create a 'symbolic' dictionary item to 'sum' the total number of cases in an invoice file let me make some assumptions.
1) In the dictionary of Invoice you have a field called QTY which contains the number of things sold
Create a new dict item called 'total_sold'.
"DICT TYPE"=S"
Single/Multi=Single"
Data Type=Integer
Formula=@ANS=SUM({QTY})
This item will take the 'qty' field in the record and sum the values and display that sum.
Is this any help?
[email protected] onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"
David Tod Sigafoos ~ SigSolutions
voice: 503-639-8080
At 22 JAN 1999 01:41PM [email protected] wrote:
Manya ..
It seems you are asking this question multiple times. If you click HERE you should get my first answer.
Could you give us some more information .. Do you actually want this information to be entered OR do you want the information to be calculated (as i suggest in the other post).
What are you actually trying to accomplish?
[email protected] onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"
David Tod Sigafoos ~ SigSolutions
voice: 503-639-8080