Detail in PO not Working 1

[Confundido]

Hi,

I am trying to build a PO form for misc. products, I am using 3 tables Vendors, POH and POD, I got it working in the input of data, but now I need to print the actual PO, but it only prints one line item per PO number.

Can someone help me, I have tried everything.

Norm.

 

[TStriker]

Norm,

Your question is light on information but I'll make some assumptions based on Filemaker FAQs.

Most FM novices attempt to print their Purchase Orders (or the like) from the header table. The correct way is to print from the LINE ITEMS or DETAIL layout.

If you print from the header table the best you could ever do is print the same number of lines that your portal displays. If printed from the LINE or DETAIL table you will be able to print an unlimited number of lines and the header information can be included and it works out just fine because the header is exactly the same for each line.

Does this answer your question?

-Striker

 

[Confundido]

Striker thank you for responding so quickly.

Let me see if I understand what you are saying, On the layout where I am designing the the full PO, it should be driven by the POD and not the POH.

Norm.

 

[TStriker]

Yep. Design your print layout from the perspective of the details (POD in your specific case). You will be able to include POH fields in the header & footer sections.

Generally speaking, your users will do most of their work on a layout that is based on the header table. When it comes time you print you will create a script that first switches to the print formatted layout (based on the POD) and then find all records that are related to that particular PO. Finally you will print and then return to the original layout.

-Striker

 

[Confundido]

Striker:

It worked ok on the input but know I am want to print the PO with it's POD "detail", Ived designed the layout like so:

Layout is divided in three Header/Body/footer
on the header I have all of the POH info. on the footer the grand total and notes with is part of the POH, now the body has a portal and the POD fields so it will display multiple lines of the detail of the PO in question, it displays OK, but, if the PO has more de 13 lines of detail it should jump to a second page, which it does but the Grand total is in both pages, also if I only have 2 line items on the PO, it will still print 2 pages.

I hove my lengthy explanation will help you on helping me get out of this situation,
Norm.

 

[TStriker]

Norm,

You shouldn't need a portal at all on your print formatted layout. Remember, your layout should be based upon your PO Details table occurance. You can confirm this from the LAYOUT MODE by choosing:

Layouts > Layout Setup

In the "Show Records From" box you should see your PO Details table occurance.

You will also want to ensure that you view the layout as a list:

While in the BROWSE MODE pull down:

View > View As List

You should shrink the vertical dimension of the body section so that it is just slightly bigger than the fields that it contains.

Lastly, the only way to preview the results is to go into the PREVIEW MODE. Pull down:

VIEW > PREVIEW MODE

Fundamentially speaking, portals are for viewing *many* related records from the *one* side of the relationship. In your case you will probably have a portal on the layout that has your PO Header information because there can be many PO lines for 1 header. You would normally not have a portal on your line item layout because for any given line there is only one related PO header.

-Striker

 

[TStriker]

Oh yeah... I assume you are on FM version 7 or 8. If you are running an earlier version then my explanation *can* be confusing.

-Striker

 

[Confundido]

TStriker:

I agree with you, but I need to display and print the PO for a customer, not a report of PO's, "One to Many", is there a formula that I can use for this Like a FOR or an IF statement, at this point with your info. I see everything, when I need to see one PO and it's detail.

Thanks Again.

Norm.

 

[TStriker]

Norm,

I assume you have a PRIMARY KEY field in your PO header table. It is probably called PO_Number or something like that. You should also have a field in your details (aka lines) table also probably called PO_Number. This serves as the link between the header record and the detail (line) records. What you need to to is navigate to your print layout (which is based on the detail or line table occurance) and then do a find for all records that match your PO Number. For example, to do this manually you would jot down the PO number that you want to print. Let's say it is 1600 for instance. Then get yourself over to the print formatted layout. Go into the FIND mode. Type 1600 into the PO_Number field and then press enter to execute the find. It should now show a list of all PO lines that are related to PO 1600. If you go into PREVIEW MODE it should show you an example of what your printed PO should look like.

To script the whole operation there are a few ways it can be done. One way is to script the find using essentially the same steps that I explained. Another way is to use the GTRR (Go To Related Record) script step. You should see if you can do it manually first before attempting to script the whole process.

-Striker

 

[Confundido]

Striker:

It works on the Browse mode, but now I need to print the PO, if I move to the Preview mode I only see one line of the detail, and if I print from the Browse mode there are two options, RECORDS BEING BROWSE "It prints al of the PO not only the one I want, and CURRENT RECORD "it only prints one line.

PS: Thanks for all your help.

Norm.