Running Totals on Forms

DarrenBezzant
Member Posts: 13
OK. Here's what I would like to do. On the Sales Invoice Form, the client would like to see running totals for Amounts and Prices, for Example. I created the Flow Fields on the Sales Line Table pointing to the Appropriate Fields.
I understand that I cannot put the running Totals on the Sales Invoice Main Form, since the Field will not be updated on a run-time basis. So, I expanded the Sub Form area and added the Flow Field Control.
Problem: When I run the Sales Invoice the Sub Form Grid expands to fill the entire area, not showing the New Control that I have Added.
In Short <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" /> what am I missing? or is there an easier way to generate and display running Totals?
Cheers
Darren Bezzant NCPS, NCSD
Central Software
Ludlow, NB, CANADA
dbz@nb.aibn.com
I understand that I cannot put the running Totals on the Sales Invoice Main Form, since the Field will not be updated on a run-time basis. So, I expanded the Sub Form area and added the Flow Field Control.
Problem: When I run the Sales Invoice the Sub Form Grid expands to fill the entire area, not showing the New Control that I have Added.
In Short <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" /> what am I missing? or is there an easier way to generate and display running Totals?
Cheers
Darren Bezzant NCPS, NCSD
Central Software
Ludlow, NB, CANADA
dbz@nb.aibn.com
0
Comments
-
HorzGlue and VertGlue
On the Table box
Try Top and Both!
MindSource(UK)Limited
Navision Service Partner
info@mindsource.co.uk
www.mindsource.co.uk0 -
OK, Top worked, new Problem:
When I am on a Blank Sales Line Record, The Flow Field Resets to 0.00, when the cursor is on a populated line, it works fine (so far).
Is there a way around this?
Cheers
Darren Bezzant NCPS, NCSD
Central Software
Ludlow, NB, CANADA
dbz@nb.aibn.com0 -
Have you tried to set the blankzero property to Yes ?
tarek_demiati@ureach.com
<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by DarrenBezzant:
OK, Top worked, new Problem:
When I am on a Blank Sales Line Record, The Flow Field Resets to 0.00, when the cursor is on a populated line, it works fine (so far).
Is there a way around this?
Cheers
<HR></BLOCKQUOTE>0 -
I thought of that but What I would like to see in that field is the total of all lines in the Sales Invoice. I don't think that I can do this with a Flow Field since there really isn't a record created on a blank line
Any Ideas?0 -
I think that I've not fully understood your problem and what you're trying to achieve.
From your Sales Document press F9 (Statistics) maybe the flowfields you requires are already there ...
tarek_demiati@ureach.com0 -
What I am trying to Achieve is a modified Sales INvoice Screen that will show the end-user the Running Total of what they have entered. If they Modify the Quantity or the Unit Price, the Running Totals will be automatically recalculated. Similarly if they enter another item line this will update the totals as well.
Darren Bezzant NCPS, NCSD
Central Software
Ludlow, NB, CANADA
dbz@nb.aibn.com0 -
You need to force an update of your flowfield. In the form you need to add Calcfields("Running total") to the OnNewRecord trigger (keeps the total visible when moving to a new line), and in the table you have to add the same instruction to the OnInsert trigger. Depending on what you do after selecting type and item, you may need to add a few more calcfields instructions.
John0 -
Try this on the OnTimer() trigger of your form :
SELECTLATESTVERSION;
CALCFIELDS(YourField);
CURRFORM.UPDATE(FALSE);
Set the TimeInterval Property of the form so it fires up
the OnTimer() property every seconds.
I have not tried it but it might work, let me know the result
of your experimentation, thanks.
tarek_demiati@ureach.com
<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by DarrenBezzant:
What I am trying to Achieve is a modified Sales INvoice Screen that will show the end-user the Running Total of what they have entered. If they Modify the Quantity or the Unit Price, the Running Totals will be automatically recalculated. Similarly if they enter another item line this will update the totals as well.
<HR></BLOCKQUOTE>0 -
Look at the General Journal form that has a running total and a balance.
You should be able to restucture that code to give you a Balance as well as a running balance.
Tip:
Always look at the existing Navision Objects for the Solutions first.
MindSource(UK)Limited
Navision Service Partner
info@mindsource.co.uk www.mindsource.co.uk
[This message has been edited by Mr David Cox (edited 08-06-2000).]0 -
Hi Dave,
I agree with the tip <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />
However a Sales Invoice document consist of a main form
and a subform. So getting figures to update automatically on the Sales Header when your entering Sales Lines is not as straight forward as on the General Journal form which consits of one table and one form
tarek_demiati@ureach.com0 -
Hi Tarek
As I understand it the Running totals are on the subform not the header.
Thus the VertGlue and HorzGlue answer above!
Regards
<BLOCKQUOTE><font size="1" face="Verdana, Arial">quote:</font><HR>Originally posted by Tarek Demiati:
Hi Dave,
I agree with the tip <img border="0" title="" alt="" src="images/smiles/icon_smile.gif" />
However a Sales Invoice document consist of a main form
and a subform. So getting figures to update automatically on the Sales Header when your entering Sales Lines is not as straight forward as on the General Journal form which consits of one table and one form
tarek_demiati@ureach.com<HR></BLOCKQUOTE>
MindSource(UK)Limited
Navision Service Partner
info@mindsource.co.uk
www.mindsource.co.uk0 -
Yes it was. The other problem I had of being on a new line was solved by comparing the rec versus the xrec. If the rec was 0 then display the xrec for that flow field.
Cheers0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions