4 Replies Latest reply on Dec 20, 2011 7:27 AM by Xunilmndrc

    Portal Line Calculations



      Portal Line Calculations


      NewB I'm using FMpro & WinXP, trying diferent ways to make it work and no luck.... in the portal line i need to create the same equipment diferent times with diferent amounts and the lines dosn't update the way i need to.... here is a copy (http://dl.dropbox.com/u/50108905/Copy.fp7) of my dilema.


        • 1. Re: Portal Line Calculations

          which parts are you not having update?

          The Needed Qty is set to be WO::wo_qty * blin_quantity

          But the fields on your portal row are BOM_LINES::wo_quantitiy and WO::wo_quantity

          • 2. Re: Portal Line Calculations

            I see a number of issues. For start, Since "Allow Creation of Record via this relationship" is not enabled for the relationship between WO and BOM_lines, you cannot create new records directly in this portal and you don't seem to have any other method in place for adding lines to this portal.

            With "Allow creation..." enabled, I still cannot add new items to the list as the field in the Item column is a calculation field instead of a data field and behavior settings in the inspector deny access. After I clear those, I find that "do not modify" has been specified on the field and I have to remove that option.

            The errors and roadblocks keep popping up up from there...

            You may want to examine this simple invoiceing demo (Created by Comment), and just think of an Invoice as your WO table:  http://fmforums.com/forum/showpost.php?post/309136/

            • 3. Re: Portal Line Calculations

              I tried creating another layout to look at the BOM_LINES data and the WO::wo_qty is empty for every BOM_LINES record, suggesting that there is something not right in that relationship.

              It seems that if you are going to have work orders that pull materials from the BOM table through the BOM_LINES, the WO and BOM_LINES should be related by wo_number-id rather than bom_number_id  (along with the "allow creation of records via" that Phil indicated)

              Also you may want to change your id fields to be auto entered number fields rather than text fields.

              • 4. Re: Portal Line Calculations

                PhilModJunk & Mark Gores Thanks, I start changing all the issues and create another layout whit different options for testing purpose, will report back here later...... Smile