on 05-15-2008 11:19 AM
Dear Forum Team
We need some advice on how to modify, fomulate(?) [Sub Total] for each page's 'amount' on the Sales AR Item Type Invoice.
Currently the 'sub total amount' on each page is showing Grand Total instead of sub total.
Thanks
Hi
Yes you are right. PageSum(Field_120) if the values you want to total is in field_120 in the repetitive area.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Let's start from scratch. The field in the repetitive area which you want to total is Field_025.
Now insert a new field into the repetitive area (footer) of type formula. Click on this field and in the properties window>Contents tab click the Formula editor button. Select Pagesum from the dropdown list and click insert. Notice that the cursor is in between the double quotes in the formula. Click on Repetitive area (window in left of formula editor window) and double click on Field_025 in the drop down list. Update and save layout.
Regards
Hi,
In you PLD, In repetitive area, you might have linked the fields like Item name, Item Description, and so on. In these fields one of the field will be Total for line items. Am i right?
If it is so, then in repetitive area footer, Create one Formula field and give formula PageSum("Field_025") (in your case)
Ie., Field_201 = PageSum("Field_025")
Field_025 - contains the Line Total of Row items.
I hope this could help you.
Raja.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You can add any field in the rows of your document and have a subtotal of that in the document. Variable 82 in my version stores the total on row level excl tax.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
There is a formula PageSum(Field_No) that you can use. It has to be in the repetitive area(Footer) and will give a subtotal for each page.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.