Running Totals on Forms

DarrenBezzant · 2000-06-07

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

Mr_David_Cox · 2000-06-07

HorzGlue and VertGlue

On the Table box
Try Top and Both!

MindSource(UK)Limited
Navision Service Partner
info@mindsource.co.uk
www.mindsource.co.uk

DarrenBezzant · 2000-06-07

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.com

Tarek_Demiati · 2000-06-07

Have you tried to set the blankzero property to Yes ?

tarek_demiati@ureach.com

<BLOCKQUOTE>quote:<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>

DarrenBezzant · 2000-06-07

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?

Tarek_Demiati · 2000-06-07

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.com

DarrenBezzant · 2000-06-07

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.com

John_Tegelaar · 2000-06-08

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.

John

Tarek_Demiati · 2000-06-08

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>quote:<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>

Mr_David_Cox · 2000-06-08

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).]

Tarek_Demiati · 2000-06-08

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

Mr_David_Cox · 2000-06-08

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>quote:<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.uk

DarrenBezzant · 2000-06-08

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.

Cheers

Howdy, Stranger!

Quick Links

Categories

Running Totals on Forms

Comments