[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== creating new field to total cases in invoice file (AREV Specific) ====
=== At 21 JAN 1999 09:48:21PM manya barton wrote: ===
{{tag>"AREV Specific"}}
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 dsig@teleport.com 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?
dsig@teleport.com 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 dsig@teleport.com wrote: ===
Manya ..
It seems you are asking this question multiple times. If you click [url= "http://www.revelation.com/WebSite/discuss.nsf/f12696d31000b22a8525652b00831bb2/18aa228883819596852567010065fb28?OpenDocument
]HERE[/url] 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?
dsig@teleport.com onmouseover=window.status=you have seen the rest .. now try the best!;return(true)"
David Tod Sigafoos ~ SigSolutions
voice: 503-639-8080
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=41E7289584F56AD785256701000F6A01|View this thread on the forum...]]