Copy Portal to Portal 
Author Message
 Copy Portal to Portal
i need to be able to copy the entire contents of one portal into another
portal. anybody know a good script or workaround for this?


Tue, 10 Aug 2004 02:41:30 GMT
 Copy Portal to Portal

Quote:

> i need to be able to copy the entire contents of one portal into another
> portal. anybody know a good script or workaround for this?

1. isolate the child records in file 1. Import into file 2.
2. Use global fields and a looping script to go to each portal row, set
the values into the globals, then go to the second portal, last row, and
move the values from the globals into the portal fields.  Using Set
Field directly from portal to portal does not work, as focus is lost
during each Set Field step. The globals are a necessary intermediate
step.

The first method is generally faster for more than a couple of portal
records.

However, if what you're trying to do is something like making order line
items into an invoice, ask yourself why you can't just mark the records
in file 1 as invoice line items and use the same records, just with a
different relationship, in the second portal.
--
Lynn Allen              Allen & Allen Semiotics
FSA Associate           Filemaker Consulting & Training



Tue, 10 Aug 2004 03:18:51 GMT
 Copy Portal to Portal
While possible, it seems pointless to try to populate a portal with the
identical contents of another portal in the same file, so I am assuming
there is something more to this than meets the eye. Is the target portal in
another file?  What is its purpose? How does it differ from the first
portal?  What is the relationship between the files?

--
Bridget Eley



Quote:
> i need to be able to copy the entire contents of one portal into another
> portal. anybody know a good script or workaround for this?



Tue, 10 Aug 2004 03:31:12 GMT
 Copy Portal to Portal
There is one slightly simplier variation on this (?): use a single global to
pass a common uinique identifier , and lookup fields in the passed identifier
file:

file A origin
file B transfer file (rel.1 item::item, A)  (rel.2 g.hold UID::UID, C, allow
create new record) (rel.3 item::item,A)
file C destination (rel.1 UID::UID, A)

using the routine loop script
portal in B (rel.1) shows items to transfer, 2nd portal shows (rel 3) shows
transfered items
just set a single global in file B to the unique identifier (rel.1 , file A)
of the portal row, and use the script to set the UID field in file C using
rel 2, UID::UID, fileC. Create a rel in file C, rel UID::UID, fileA, and
option the required data fields as lookups using the rel to A

regards

Chris

Quote:


> > i need to be able to copy the entire contents of one portal into another
> > portal. anybody know a good script or workaround for this?

> 1. isolate the child records in file 1. Import into file 2.
> 2. Use global fields and a looping script to go to each portal row, set
> the values into the globals, then go to the second portal, last row, and
> move the values from the globals into the portal fields.  Using Set
> Field directly from portal to portal does not work, as focus is lost
> during each Set Field step. The globals are a necessary intermediate
> step.

> The first method is generally faster for more than a couple of portal
> records.

> However, if what you're trying to do is something like making order line
> items into an invoice, ask yourself why you can't just mark the records
> in file 1 as invoice line items and use the same records, just with a
> different relationship, in the second portal.
> --
> Lynn Allen              Allen & Allen Semiotics
> FSA Associate           Filemaker Consulting & Training




Tue, 10 Aug 2004 07:38:50 GMT
 Copy Portal to Portal
thank you all for your input...it has been extremely helpful, but from the
sound of it, i think there is an easier solution to my problem. this is what
i have thus far:

order.fp5
-Purchase Order No.
-Address & Contact Information
-portal to order line item containing the order details(part number,
quantity ordered, price, etc)

order line item.fp5
-Purchase Order No.
-Product Part Number
-Product Description
-Quantity Ordered
-Unit Price (this price varies from customer to customer for the same
product...this poses a problem because when i go to make a packing
list/invoice, i can't just simply take it from a products database. i nned
to use what was entered into the order line item.fp5 database).

packing.fp5
-Purchase Order No.
-Packing List/Invoice No.
-Lookup to Address & Contact Information (order.fp5)
-Quantity Shipped
-Unit Price
-I need a portal in here that will allow me to view the quantity ordered and
at the same time input a new entry for quantity shipped. This will allow me
to deduct the two and obtain a remaining balance. However, if our company
again ships a partial order then i will need to again draw up the original
quantity ordered and the previous partial shipment and then again enter a
new quantity in. If i haven't confused you by now, it's a miracle. =)

If you have a simpler workaround, please help. THANK YOU ALL.

Quote:
> While possible, it seems pointless to try to populate a portal with the
> identical contents of another portal in the same file, so I am assuming
> there is something more to this than meets the eye. Is the target portal
in
> another file?  What is its purpose? How does it differ from the first
> portal?  What is the relationship between the files?

> --
> Bridget Eley



> > i need to be able to copy the entire contents of one portal into another
> > portal. anybody know a good script or workaround for this?



Wed, 11 Aug 2004 05:21:26 GMT
 Copy Portal to Portal
It certainly does seem to  be a thorny one, and one that is not exactly in
my area of expertise. However, I will give it a shot.

In all the solutions I  have seen  or worked on of this nature (not many,
and none that dealt with residual orders), order information was  subsumed
under the invoice file, that  is, while the invoice contained information
about what was ordered, its main emphasis was on what was actually shipped
and  therefore what was actually billable. Usually,  qty ordered  = qty
shipped.

When I tried to imagine what I would  do in that kind of  a solution if the
qty shipped was less than the qty ordered, my first instinct  was to create
a script that would automatically generate a new invoice for the unfilled
quantities by recreating the order and any of its line items that  contain
unfilled amounts.

In order to  tackle it this way, you would need to add a few fields to the
line items:  

ProductID:   Text
Product:   Calc (text result) = Products::Product Name
Order ID:   Text
Orignanl Qty:   Number
Price Per Unit:   Number   Lookup
Original Qty Total:   Calc (number result) = Original Qty * Price
Previously Shipped:   Number
New Qty:   Calc (number result) = Original Qty - Previously Shipped
Shipped Qty:   Number
Shipped Total:   Calc (number result) = Shipped Qty * Price
Outstanding Qty:   Calc (number result) = New Qty - Shipped  Qty
gOrderID: global number
gCounter: global number

The scripts would look something like this:

Order file:

Exit Record/Request
If [Sum(LineItems::Outstanding Qty) ? 1]
Find All
Omit
Find Omitted
Set Field [gCustomerID, CustomerID]
New Record/Request
Set Field [CustomerID, gCustomerID]
Set Field [LineItems":::gOrderID, OrderID]
Go to Record/Request/Page [First]
Go to Related Record [Show, LineItems]
Perform Script [Sub-script, External, LineItems]
Go to Record/Request/Page [Last]
Else
Beep
Show Message ["There are no more outstanding Qtys for this order."]
End If

External Sub-script:

Go to Record/Request/Page [First]
Set Field [gCpounter, 1]
Loop
If [Outstanding Qty >=  1]
Dulicate Record/Request
Set Field [OrderID, gOrderID]
Set Field [Previously Shipped, Original Qty - Outstanding Qty]
Set Field [Shipped Qty, ""]
Omit
End If
Set Field [gCounter, gCounter + 1]
Go to Record/Request/Page [gCounter]
Exit Loop If [gCounter = Stat

Even though you would no longer have a single order, but rather several
invoices, you would be able to track the history of a particular order  in
the customer file where you would have two portals: one to  show all orders
for the customer with a button to set a global field to the order number.
Make this global field the basis of a relationship for a second portal to
the line items file.  Click  the button for an order, and the second portal
will fill up with line items for each order.

Having  said all this,  I warn you that I have no idea whether this would
conform to common business practice.  Others in the group might have a
totally different take on the problem.

--
Bridget Eley



Quote:
> thank you all for your input...it has been extremely helpful, but from the
> sound of it, i think there is an easier solution to my problem. this is what
> i have thus far:

> order.fp5
> -Purchase Order No.
> -Address & Contact Information
> -portal to order line item containing the order details(part number,
> quantity ordered, price, etc)

> order line item.fp5
> -Purchase Order No.
> -Product Part Number
> -Product Description
> -Quantity Ordered
> -Unit Price (this price varies from customer to customer for the same
> product...this poses a problem because when i go to make a packing
> list/invoice, i can't just simply take it from a products database. i nned
> to use what was entered into the order line item.fp5 database).

> packing.fp5
> -Purchase Order No.
> -Packing List/Invoice No.
> -Lookup to Address & Contact Information (order.fp5)
> -Quantity Shipped
> -Unit Price
> -I need a portal in here that will allow me to view the quantity ordered and
> at the same time input a new entry for quantity shipped. This will allow me
> to deduct the two and obtain a remaining balance. However, if our company
> again ships a partial order then i will need to again draw up the original
> quantity ordered and the previous partial shipment and then again enter a
> new quantity in. If i haven't confused you by now, it's a miracle. =)

> If you have a simpler workaround, please help. THANK YOU ALL.


>> While possible, it seems pointless to try to populate a portal with the
>> identical contents of another portal in the same file, so I am assuming
>> there is something more to this than meets the eye. Is the target portal
> in
>> another file?  What is its purpose? How does it differ from the first
>> portal?  What is the relationship between the files?

>> --
>> Bridget Eley



>>> i need to be able to copy the entire contents of one portal into another
>>> portal. anybody know a good script or workaround for this?



Wed, 11 Aug 2004 08:37:02 GMT
 Copy Portal to Portal
Correction:

I accidentally cropped the last two lines of the external script. They
should read:

Exit Loop If [gCounter = Status(CurrentFoundCount) + 1 ]
End  Loop

--
Bridget Eley



Quote:
> It certainly does seem to  be a thorny one, and one that is not exactly in
> my area of expertise. However, I will give it a shot.

> In all the solutions I  have seen  or worked on of this nature (not many,
> and none that dealt with residual orders), order information was  subsumed
> under the invoice file, that  is, while the invoice contained information
> about what was ordered, its main emphasis was on what was actually shipped
> and  therefore what was actually billable. Usually,  qty ordered  = qty
> shipped.

> When I tried to imagine what I would  do in that kind of  a solution if the
> qty shipped was less than the qty ordered, my first instinct  was to create
> a script that would automatically generate a new invoice for the unfilled
> quantities by recreating the order and any of its line items that  contain
> unfilled amounts.

> In order to  tackle it this way, you would need to add a few fields to the
> line items:  

> ProductID:   Text
> Product:   Calc (text result) = Products::Product Name
> Order ID:   Text
> Orignanl Qty:   Number
> Price Per Unit:   Number   Lookup
> Original Qty Total:   Calc (number result) = Original Qty * Price
> Previously Shipped:   Number
> New Qty:   Calc (number result) = Original Qty - Previously Shipped
> Shipped Qty:   Number
> Shipped Total:   Calc (number result) = Shipped Qty * Price
> Outstanding Qty:   Calc (number result) = New Qty - Shipped  Qty
> gOrderID: global number
> gCounter: global number

> The scripts would look something like this:

> Order file:

> Exit Record/Request
> If [Sum(LineItems::Outstanding Qty) ? 1]
> Find All
> Omit
> Find Omitted
> Set Field [gCustomerID, CustomerID]
> New Record/Request
> Set Field [CustomerID, gCustomerID]
> Set Field [LineItems":::gOrderID, OrderID]
> Go to Record/Request/Page [First]
> Go to Related Record [Show, LineItems]
> Perform Script [Sub-script, External, LineItems]
> Go to Record/Request/Page [Last]
> Else
> Beep
> Show Message ["There are no more outstanding Qtys for this order."]
> End If

> External Sub-script:

> Go to Record/Request/Page [First]
> Set Field [gCpounter, 1]
> Loop
> If [Outstanding Qty >=  1]
> Dulicate Record/Request
> Set Field [OrderID, gOrderID]
> Set Field [Previously Shipped, Original Qty - Outstanding Qty]
> Set Field [Shipped Qty, ""]
> Omit
> End If
> Set Field [gCounter, gCounter + 1]
> Go to Record/Request/Page [gCounter]
> Exit Loop If [gCounter = Stat

> Even though you would no longer have a single order, but rather several
> invoices, you would be able to track the history of a particular order  in
> the customer file where you would have two portals: one to  show all orders
> for the customer with a button to set a global field to the order number.
> Make this global field the basis of a relationship for a second portal to
> the line items file.  Click  the button for an order, and the second portal
> will fill up with line items for each order.

> Having  said all this,  I warn you that I have no idea whether this would
> conform to common business practice.  Others in the group might have a
> totally different take on the problem.

> --
> Bridget Eley



>> thank you all for your input...it has been extremely helpful, but from the
>> sound of it, i think there is an easier solution to my problem. this is what
>> i have thus far:

>> order.fp5
>> -Purchase Order No.
>> -Address & Contact Information
>> -portal to order line item containing the order details(part number,
>> quantity ordered, price, etc)

>> order line item.fp5
>> -Purchase Order No.
>> -Product Part Number
>> -Product Description
>> -Quantity Ordered
>> -Unit Price (this price varies from customer to customer for the same
>> product...this poses a problem because when i go to make a packing
>> list/invoice, i can't just simply take it from a products database. i nned
>> to use what was entered into the order line item.fp5 database).

>> packing.fp5
>> -Purchase Order No.
>> -Packing List/Invoice No.
>> -Lookup to Address & Contact Information (order.fp5)
>> -Quantity Shipped
>> -Unit Price
>> -I need a portal in here that will allow me to view the quantity ordered and
>> at the same time input a new entry for quantity shipped. This will allow me
>> to deduct the two and obtain a remaining balance. However, if our company
>> again ships a partial order then i will need to again draw up the original
>> quantity ordered and the previous partial shipment and then again enter a
>> new quantity in. If i haven't confused you by now, it's a miracle. =)

>> If you have a simpler workaround, please help. THANK YOU ALL.


>>> While possible, it seems pointless to try to populate a portal with the
>>> identical contents of another portal in the same file, so I am assuming
>>> there is something more to this than meets the eye. Is the target portal
>> in
>>> another file?  What is its purpose? How does it differ from the first
>>> portal?  What is the relationship between the files?

>>> --
>>> Bridget Eley



>>>> i need to be able to copy the entire contents of one portal into another
>>>> portal. anybody know a good script or workaround for this?



Wed, 11 Aug 2004 08:42:31 GMT
 Copy Portal to Portal
Some further  thoughts:  the script could be incorporated with the print
script  so that whenever an invoice is printed and sent, the order is
checked for residual amounts and, if there are any, a new invoice created
ready for residual order to be filled and the new invoice printed.  By
setting the Shipped Date field at the same  time and using this as  the test
for how to proceed with script, it would prevent accidentally creating a
second new invoice for the same previous invoice.

If [IsEmpty (Ship Date)]
   Set Field [Ship Date, Status (currentDate)]
   Perform Script [Sub-script, Sub:Print)]
   Exit Record/Request
   If [Sum(LineItems::Outstanding Qty) ? 1]
      Find All
      Omit
      Find Omitted
      Set Field [gCustomerID, CustomerID]
      New Record/Request
      Set Field [CustomerID, gCustomerID]
      Set Field [LineItems":::gOrderID, OrderID]
      Go to Record/Request/Page [First]
      Go to Related Record [Show, LineItems]
      Perform Script [Sub-script, External, LineItems]
      Go to Record/Request/Page [Last]
      Beep
      Show Message ["Invoice  printed.  A new invoice has been
      generated for all line items with outstanding qty."]
   Else
      Beep
      Show Message ["Invoice  printed."]
   End If
Else
   Beep
   Show Message ["This invoice has already been sent."]
End  If

--
Bridget Eley



Quote:
> Correction:

> I accidentally cropped the last two lines of the external script. They
> should read:

> Exit Loop If [gCounter = Status(CurrentFoundCount) + 1 ]
> End  Loop

> --
> Bridget Eley



>> It certainly does seem to  be a thorny one, and one that is not exactly in
>> my area of expertise. However, I will give it a shot.

>> In all the solutions I  have seen  or worked on of this nature (not many,
>> and none that dealt with residual orders), order information was  subsumed
>> under the invoice file, that  is, while the invoice contained information
>> about what was ordered, its main emphasis was on what was actually shipped
>> and  therefore what was actually billable. Usually,  qty ordered  = qty
>> shipped.

>> When I tried to imagine what I would  do in that kind of  a solution if the
>> qty shipped was less than the qty ordered, my first instinct  was to create
>> a script that would automatically generate a new invoice for the unfilled
>> quantities by recreating the order and any of its line items that  contain
>> unfilled amounts.

>> In order to  tackle it this way, you would need to add a few fields to the
>> line items:  

>> ProductID:   Text
>> Product:   Calc (text result) = Products::Product Name
>> Order ID:   Text
>> Orignanl Qty:   Number
>> Price Per Unit:   Number   Lookup
>> Original Qty Total:   Calc (number result) = Original Qty * Price
>> Previously Shipped:   Number
>> New Qty:   Calc (number result) = Original Qty - Previously Shipped
>> Shipped Qty:   Number
>> Shipped Total:   Calc (number result) = Shipped Qty * Price
>> Outstanding Qty:   Calc (number result) = New Qty - Shipped  Qty
>> gOrderID: global number
>> gCounter: global number

>> The scripts would look something like this:

>> Order file:

>> Exit Record/Request
>> If [Sum(LineItems::Outstanding Qty) ? 1]
>> Find All
>> Omit
>> Find Omitted
>> Set Field [gCustomerID, CustomerID]
>> New Record/Request
>> Set Field [CustomerID, gCustomerID]
>> Set Field [LineItems":::gOrderID, OrderID]
>> Go to Record/Request/Page [First]
>> Go to Related Record [Show, LineItems]
>> Perform Script [Sub-script, External, LineItems]
>> Go to Record/Request/Page [Last]
>> Else
>> Beep
>> Show Message ["There are no more outstanding Qtys for this order."]
>> End If

>> External Sub-script:

>> Go to Record/Request/Page [First]
>> Set Field [gCpounter, 1]
>> Loop
>> If [Outstanding Qty >=  1]
>> Dulicate Record/Request
>> Set Field [OrderID, gOrderID]
>> Set Field [Previously Shipped, Original Qty - Outstanding Qty]
>> Set Field [Shipped Qty, ""]
>> Omit
>> End If
>> Set Field [gCounter, gCounter + 1]
>> Go to Record/Request/Page [gCounter]
>> Exit Loop If [gCounter = Stat

>> Even though you would no longer have a single order, but rather several
>> invoices, you would be able to track the history of a particular order  in
>> the customer file where you would have two portals: one to  show all orders
>> for the customer with a button to set a global field to the order number.
>> Make this global field the basis of a relationship for a second portal to
>> the line items file.  Click  the button for an order, and the second portal
>> will fill up with line items for each order.

>> Having  said all this,  I warn you that I have no idea whether this would
>> conform to common business practice.  Others in the group might have a
>> totally different take on the problem.

>> --
>> Bridget Eley



>>> thank you all for your input...it has been extremely helpful, but from the
>>> sound of it, i think there is an easier solution to my problem. this is what
>>> i have thus far:

>>> order.fp5
>>> -Purchase Order No.
>>> -Address & Contact Information
>>> -portal to order line item containing the order details(part number,
>>> quantity ordered, price, etc)

>>> order line item.fp5
>>> -Purchase Order No.
>>> -Product Part Number
>>> -Product Description
>>> -Quantity Ordered
>>> -Unit Price (this price varies from customer to customer for the same
>>> product...this poses a problem because when i go to make a packing
>>> list/invoice, i can't just simply take it from a products database. i nned
>>> to use what was entered into the order line item.fp5 database).

>>> packing.fp5
>>> -Purchase Order No.
>>> -Packing List/Invoice No.
>>> -Lookup to Address & Contact Information (order.fp5)
>>> -Quantity Shipped
>>> -Unit Price
>>> -I need a portal in here that will allow me to view the quantity ordered and
>>> at the same time input a new entry for quantity shipped. This will allow me
>>> to deduct the two and obtain a remaining balance. However, if our company
>>> again ships a partial order then i will need to again draw up the original
>>> quantity ordered and the previous partial shipment and then again enter a
>>> new quantity in. If i haven't confused you by now, it's a miracle. =)

>>> If you have a simpler workaround, please help. THANK YOU ALL.


>>>> While possible, it seems pointless to try to populate a portal with the
>>>> identical contents of another portal in the same file, so I am assuming
>>>> there is something more to this than meets the eye. Is the target portal
>>> in
>>>> another file?  What is its purpose? How does it differ from the first
>>>> portal?  What is the relationship between the files?

>>>> --
>>>> Bridget Eley



>>>>> i need to be able to copy the entire contents of one portal into another
>>>>> portal. anybody know a good script or workaround for this?



Wed, 11 Aug 2004 09:36:27 GMT
 Copy Portal to Portal
thank you, thank you, thank you...
i'm gonna spend this morning deciphering your code. i haven't spent too much
time scripting in fmp, but i'm gonna try to make it work. thanks again for
everything.
daniel


Quote:
> Some further  thoughts:  the script could be incorporated with the print
> script  so that whenever an invoice is printed and sent, the order is
> checked for residual amounts and, if there are any, a new invoice created
> ready for residual order to be filled and the new invoice printed.  By
> setting the Shipped Date field at the same  time and using this as  the
test
> for how to proceed with script, it would prevent accidentally creating a
> second new invoice for the same previous invoice.

> If [IsEmpty (Ship Date)]
>    Set Field [Ship Date, Status (currentDate)]
>    Perform Script [Sub-script, Sub:Print)]
>    Exit Record/Request
>    If [Sum(LineItems::Outstanding Qty) " 1]
>       Find All
>       Omit
>       Find Omitted
>       Set Field [gCustomerID, CustomerID]
>       New Record/Request
>       Set Field [CustomerID, gCustomerID]
>       Set Field [LineItems":::gOrderID, OrderID]
>       Go to Record/Request/Page [First]
>       Go to Related Record [Show, LineItems]
>       Perform Script [Sub-script, External, LineItems]
>       Go to Record/Request/Page [Last]
>       Beep
>       Show Message ["Invoice  printed.  A new invoice has been
>       generated for all line items with outstanding qty."]
>    Else
>       Beep
>       Show Message ["Invoice  printed."]
>    End If
> Else
>    Beep
>    Show Message ["This invoice has already been sent."]
> End  If

> --
> Bridget Eley



> > Correction:

> > I accidentally cropped the last two lines of the external script. They
> > should read:

> > Exit Loop If [gCounter = Status(CurrentFoundCount) + 1 ]
> > End  Loop

> > --
> > Bridget Eley



> >> It certainly does seem to  be a thorny one, and one that is not exactly
in
> >> my area of expertise. However, I will give it a shot.

> >> In all the solutions I  have seen  or worked on of this nature (not
many,
> >> and none that dealt with residual orders), order information was
subsumed
> >> under the invoice file, that  is, while the invoice contained
information
> >> about what was ordered, its main emphasis was on what was actually
shipped
> >> and  therefore what was actually billable. Usually,  qty ordered  = qty
> >> shipped.

> >> When I tried to imagine what I would  do in that kind of  a solution if
the
> >> qty shipped was less than the qty ordered, my first instinct  was to
create
> >> a script that would automatically generate a new invoice for the
unfilled
> >> quantities by recreating the order and any of its line items that
contain
> >> unfilled amounts.

> >> In order to  tackle it this way, you would need to add a few fields to
the
> >> line items:

> >> ProductID:   Text
> >> Product:   Calc (text result) = Products::Product Name
> >> Order ID:   Text
> >> Orignanl Qty:   Number
> >> Price Per Unit:   Number   Lookup
> >> Original Qty Total:   Calc (number result) = Original Qty * Price
> >> Previously Shipped:   Number
> >> New Qty:   Calc (number result) = Original Qty - Previously Shipped
> >> Shipped Qty:   Number
> >> Shipped Total:   Calc (number result) = Shipped Qty * Price
> >> Outstanding Qty:   Calc (number result) = New Qty - Shipped  Qty
> >> gOrderID: global number
> >> gCounter: global number

> >> The scripts would look something like this:

> >> Order file:

> >> Exit Record/Request
> >> If [Sum(LineItems::Outstanding Qty) " 1]
> >> Find All
> >> Omit
> >> Find Omitted
> >> Set Field [gCustomerID, CustomerID]
> >> New Record/Request
> >> Set Field [CustomerID, gCustomerID]
> >> Set Field [LineItems":::gOrderID, OrderID]
> >> Go to Record/Request/Page [First]
> >> Go to Related Record [Show, LineItems]
> >> Perform Script [Sub-script, External, LineItems]
> >> Go to Record/Request/Page [Last]
> >> Else
> >> Beep
> >> Show Message ["There are no more outstanding Qtys for this order."]
> >> End If

> >> External Sub-script:

> >> Go to Record/Request/Page [First]
> >> Set Field [gCpounter, 1]
> >> Loop
> >> If [Outstanding Qty >=  1]
> >> Dulicate Record/Request
> >> Set Field [OrderID, gOrderID]
> >> Set Field [Previously Shipped, Original Qty - Outstanding Qty]
> >> Set Field [Shipped Qty, ""]
> >> Omit
> >> End If
> >> Set Field [gCounter, gCounter + 1]
> >> Go to Record/Request/Page [gCounter]
> >> Exit Loop If [gCounter = Stat

> >> Even though you would no longer have a single order, but rather several
> >> invoices, you would be able to track the history of a particular order
in
> >> the customer file where you would have two portals: one to  show all
orders
> >> for the customer with a button to set a global field to the order
number.
> >> Make this global field the basis of a relationship for a second portal
to
> >> the line items file.  Click  the button for an order, and the second
portal
> >> will fill up with line items for each order.

> >> Having  said all this,  I warn you that I have no idea whether this
would
> >> conform to common business practice.  Others in the group might have a
> >> totally different take on the problem.

> >> --
> >> Bridget Eley



> >>> thank you all for your input...it has been extremely helpful, but from
the
> >>> sound of it, i think there is an easier solution to my problem. this
is what
> >>> i have thus far:

> >>> order.fp5
> >>> -Purchase Order No.
> >>> -Address & Contact Information
> >>> -portal to order line item containing the order details(part number,
> >>> quantity ordered, price, etc)

> >>> order line item.fp5
> >>> -Purchase Order No.
> >>> -Product Part Number
> >>> -Product Description
> >>> -Quantity Ordered
> >>> -Unit Price (this price varies from customer to customer for the same
> >>> product...this poses a problem because when i go to make a packing
> >>> list/invoice, i can't just simply take it from a products database. i
nned
> >>> to use what was entered into the order line item.fp5 database).

> >>> packing.fp5
> >>> -Purchase Order No.
> >>> -Packing List/Invoice No.
> >>> -Lookup to Address & Contact Information (order.fp5)
> >>> -Quantity Shipped
> >>> -Unit Price
> >>> -I need a portal in here that will allow me to view the quantity
ordered and
> >>> at the same time input a new entry for quantity shipped. This will
allow me
> >>> to deduct the two and obtain a remaining balance. However, if our
company
> >>> again ships a partial order then i will need to again draw up the
original
> >>> quantity ordered and the previous partial shipment and then again
enter a
> >>> new quantity in. If i haven't confused you by now, it's a miracle. =)

> >>> If you have a simpler workaround, please help. THANK YOU ALL.


> >>>> While possible, it seems pointless to try to populate a portal with
the
> >>>> identical contents of another portal in the same file, so I am
assuming
> >>>> there is something more to this than meets the eye. Is the target
portal
> >>> in
> >>>> another file?  What is its purpose? How does it differ from the first
> >>>> portal?  What is the relationship between the files?

> >>>> --
> >>>> Bridget Eley


at

> >>>>> i need to be able to copy the entire contents of one portal into
another
> >>>>> portal. anybody know a good script or workaround for this?



Sat, 14 Aug 2004 01:09:25 GMT
 
 [ 9 post ] 

 Relevant Pages 

1. Oracle Portal vs Novell Portal

2. To Portal or not to Portal

3. Add item in line item portal from another portal

4. FILTER PORTAL RECORDS - DISABLE ADDING NEW RECORDS IN A PORTAL

5. Displaying a portal based on a portal

6. Portal for line of data in a portal?

7. Simulate a Portal within a Portal...

8. Portal Within A Portal (Heirarchical Listings)

9. portal within portal?

10. portal in a portal?

11. Goto related from portal --how do I get the selected portal row

12. Conditional portal displays with criteria from another portal


 
Powered by phpBB® Forum Software