I have made an sales invoice. I dont need to explain everything but, its an general sales invoice. with header and the details. Now for a one sales number there are some items and their prices. at the end there is total. Now as soon as the items end the total are printed. But i dont want that , i want to print total at the footer of the page always. I am using navision 3.7. is it possible?
see example of report details
SrNo.| Item Desc | Unit Price |Disc | Total
1 | Blah Blah | 23 | 0 | 23
Grand Total 23
So as soon as the record comes to an end the Total is printed and horizontal lines are also shown once.
this is what i want
SrNo.| Item Desc | Unit Price |Disc | Total
1 | Blah Blah | 23 | 0 | 23
| | | |
…Continue the lines to end of page and then Total is printed. This should be automatic. if the records are more than 1 , the total must come at the end also. Should not go to next page. Its like real invoice format.
The Problem is simple. I am making a report of sales invoice. i have sales header and sales lines. This is not the problem. My problem is that , i want to print the total of items at the bottom of the page as fix position. even if my items is 1 or many. if the items are more and cant be fit on one page than , the remaining items can go to next page. But on next page the total should be also printed at the bottom and so on.
To understand this problem is simple. but solution can be difficult. My navision version is 3.7
I am sure its “To understand this problem is simple.” when you have the report printed or prototyped in front of you, but for me its not [;)] Can you try to post some form of a layout of what you are trying to do. The easiest is to attache an Excel spread sheet sample. I still see that the standard report does EXACTLY what you have asked.
This is what it looks. Total is printed as soon as the items in the invoice end. I dont want this. I want the total to be print at the footer of page. Even if its 2 items or 3 or more. any case the total should be at footer . this is what i want.
Actually this is exactly what I assumed. SO back to my first question. Which report number are you working with? This could be a country specific thing. The standard US invoice 10074 prints like this, but I see that report 206 does not. (Which country version are you using?)
Try going to the section designer, find the footer section (or sections) and in properties, set P****laceInBottom = Yes
this will probably do what you want.
I am in Saudi Arabia, could u give me code from 10074 for the bottom section? if i have lines between each column. The lines will stretch down even i have no records?
Its not code. As babrown (and then I a few minutes later) said, its a property.
Go to the Section designer for the Sales Line table, find the FOOTER section(s) and set the property PlaceInBottom to yes.
I don;t know which version of Navision they have in Saudia Arabia, but its probably W1, in which case you are probably working with report 206. This report does not have the property set.
You are welcome, also I see the post marked as Resolved, thanks for that, and could you also give it a star rating.
PS it would also help to get faster solutions, if you could update your profile with some information about your location, Navision version, and whether you are an enduser or a partner.
I am facing the same issue in sales invoice report,. In my case i am putting vertical lines in the report. However these lines are displaying only till the no: of items in the body. I want these line to be displayed till the bottom, if at all no items are there in the body .
I am facing the same issue in sales invoice report,. In my case i am putting vertical lines in the report. However these lines are displaying only till the no: of items in the body. I want these line to be displayed till the bottom, if at all no items are there in the body .