How many packages of each quantity?

[lynp]

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??

[JerrySalem]

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

[lynp]

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!