Chris Good Posted February 23, 2005 Posted February 23, 2005 I want to create a printable invoice. I think I should probably be using sub-summary parts, but I am having trouble figuring that out. I have an orders table and an invoices table that are related using a unique invoice number. The orders table has the individual line items that go on the invoices and then the invoices table does a lot of the calculations such as totals, tax, etc. I think the layout should be based on the orders table. But what type of section do I put the line item info into, and what section do I put the total calc fields into? Any help would be appreciated. Thanks
RalphL Posted February 23, 2005 Posted February 23, 2005 Your Invoice should be printed from the line items. You bring data from the Invoice table by the relaationship.
Chris Good Posted February 23, 2005 Author Posted February 23, 2005 Hi Ralph, I think I've got that much of it, but what type of section do I put the line items into? I want the totals to print on the last page of the invoice. I tried putting the line items in the body and that got some of the desired result, but then I am not sure where to put the totals.
Ender Posted February 23, 2005 Posted February 23, 2005 Put the line items in the Body part and the totals on the Trailing Grand Summary part.
RalphL Posted February 23, 2005 Posted February 23, 2005 Use a columnar list / report type layout so each record of the line items is a line in the report. Then use a Trailing Grand Summary as Ender suggests.
bruceR Posted February 24, 2005 Posted February 24, 2005 Actually the line items print requirement is outmoded advice based on limitations that no longer exist. It is still useful but no longer necessary. In FM7 you can break up portals and for instance place rows 1 thru 10 on page 1 and size your layout to 2 pages or whatever and then place rows 11 thru 30 (for example) on page 2.
Chris Good Posted February 25, 2005 Author Posted February 25, 2005 Thanks for all of the ideas guys. I decided to use the trailing grand summary idea and it is working really well for me now. The one question I came up with though was is there a way to have a field print at the bottom of the last page? I used the footer, but that prints at the bottom of all of the pages and the trailing grand summary prints directly under the body on the last page. Maybe I am being picky.
-Queue- Posted February 25, 2005 Posted February 25, 2005 Create a global number field and set it with the total number of pages using Enter Preview Mode [ ] Go to Record/Request/Page [Last] Set Field [globalnumber; Get(PageNumber)] Then use an unstored calculation field of Case( Get(PageNumber) = globalnumber; FieldToBePrinted ) and put it in the footer.
Recommended Posts
This topic is 7213 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now