I am at a loss here.

 

I need to create a packing list that states how many packages have a certain quantity in them.

 

For example: there are 10 packages. Nine packages contain 1000 items, one package contains 750 items.

 

My packing list needs to state this information:

Total Quantity = 9750

Total packages shipped = 10

9 packages of 1000

1 package of 750

 

I can figure out how to list this using a self joining relationship and a portal but I need the individual values (9 at 1000 and 1 at 750).

 

help??

lynp,

 

The first thing that came to my mind was Execute SQL in a script;

 

For the current invoice, get a list of the package counts (in your example 1000 and 750)

In a loop for each package count,

find the number of packages

build a line (ex; 9 packages of 1000)

concatenate it to a variable to hold it till done.

Set the final value in a field.

 

I wrote a script in the Invoice demo.  Hope this helps.

 

Jerry

 

 

InvoicesCount.fmp12.zip

Thank you for your reply Jerry,

While the solution did not work for me it did lead me in the right direction and problem solved!