Hi,

I have a related table called Po lines. What happens, is that customers place orders for goods not released yet ( we are selling CD's; DVD's-etc). We put all these orders in this table, then when we have enough orders for a particular supplier, we create a purchase order. However, in the PO lines table, you can have 6 different customers ordering the same product, for differing quantities. At present I create a Po and assign the Po number to all the records chosen in the PO lines table. Then in a portal layout i can view by po number, the order and its related lines and produce a summary report by catalogue number and total quantity for each item being ordered. However, in the portal layout, it shows the individual customer orders, so for instance, it could show

Catalogue number Qty

TCD2586 3

ECD195 5

TCD2586 7

Although I can produce the definitive PO via a summary report, I want to use the portal that lists the order, to allocate sales quantities, as the goods are sold. This part, I can do easily, using a sales database and relating to the Po lines. However, I need to see consolidated totals in the portal. So Cat no TCD2586 would show a total of 10, not 3. If anyone has any ideas, i would be grateful. At present, my only solution, is to have 1 table for all the initial Po order lines and another for the consolidated PO orders, then use a script to consolidate and import the orders from Po lines to Po lines consolidated.

Sorry if this post seems to go on. However, in order to find a different solution, if one exists, I do need to explain in detail my problem.

regards,

Sdig

You do need a table of Items.

Items

-------

PO number

Item description

totalQty (unstored calc) =Sum(items_SALES::Qty)

Display a portal of Items and include the totalQty field.

Each PO will appear only once in the list along with the total.

Alternatively:

If you really wanted to add the total onto your current portal and have the list become

Catalogue number Qty TotQty

TCD2586 3 10

ECD195 5 5

TCD2586 7 10

Then you can create another TO of the table depicted in the portal and match on the Po number. Then make a calc to sum the Qty of all records in that table with the same Po. Display this calc in the portal.

Edited March 28, 201015 yr by Guest