cancel
Showing results for 
Search instead for 
Did you mean: 

Sales AR Item Type Invoice Print Layout Design "Sub Total" per Page

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Yes you are right. PageSum(Field_120) if the values you want to total is in field_120 in the repetitive area.

Former Member
0 Kudos

Hi Daan,

I am lost. The sub total formula field I added is Field_201. The Extension(amount) I want to add up for the page total is Field_025. Should the page total to be PageSum(Field_025) ?

Thanks again,

Kuni

Former Member
0 Kudos

Hi Dann,

I keep getting error message Field_201 errors were found in the forluma....

Kuni

Former Member
0 Kudos

The formula will be PageSum("Field_025").

I think your problem might be the missing double quotes.

Regards

Former Member
0 Kudos

Hi Dann, I added the doube quotes but still getting error message. The text field I added which labled as Sub Total will show up on the bottm of each page at where I want it to be but the formula field right next to it wont show up. What did I do wrong? Sorry for asking dum question.

Kuni

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Daan,

I deleted the current formula field and added a new one.

I then formulated it per your advice.

The Sub Total text field will only show up on the very last page at the bottom of the repetitive footer area. The formula field still wont show up anywhere on the document.

Kuni

Former Member
0 Kudos

Click on the repetitive area (footer) and in the field properties>General tab click Display repetitive area footer on All pages.

Regards

Former Member
0 Kudos

Hi Dann,

Many thanks to your advice.

The text field Sub Total now shows up on each page at where I needed it to be. However the formula field right next to the text field still wont show up....

Kuni

Former Member
0 Kudos

Hi Dann,

You made may day!!!

Many many thanks to your advice!

It is 10 pm in Tokyo so time to go home.

Did I rate your advice with 5 stars?

Have a great day ( not sure where you located)

Kuni

Edited by: furuya kunitomo on May 15, 2008 3:07 PM

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Daan,

Thank you very much for the advice.

Since there is no Sub Total data on the AR Invoice, where would you sugget to find the data i.e. sub total amount for (Field-No)?

Thanks again,

Kunitomo

Former Member
0 Kudos

Hi Daan,

Do you mean like this?

For example: PageSum(Field_120)

I keep getting error message by doing so...

Thanks again,

Kunitomo