Need to have DISTINCT records printed during packing slip using CR

33 Views

Dear Experts,

I have managed to achieve a ship label print out. However, I am facing a difficult situation.

I have 3 packages. Box, Pallet Container.

Box has 1 Item. Pallet has 2 and Container has 1.

I need to print 1 ship label per package type - expected 1/3, 2/3, and 3/3.

However I end up getting four ship labels 1/4, 2/4, 3/4 and 4/4. This is because it is repeating by the items in package.

How could I resolve this please.

I tried including packagenum field in my detail area both from DLN8 or DLN7. In either case the items in package get repeated twice.

The records in DLN8 are :

DocEntry     PackageNum
252             1 
252              2
252              2
252              3

The records in DLN7 are:

DocEntry     PackageNum   PackageType
252              1                        Box
252              2                        Pallet 
252              3                        Container

The parameters going in are default ones :

DocKey@ and ObjectID@

I also tried creating my own formula field.

Eg., DistinctPackNum. I formula editor does not let me use DISTINCT.

If it was allowed this might have worked : SELECT DISTINCT ({DLN8.PackageNum})

Since above is not allowed, I am not sure what to do? is there some alternative? May be Basic Syntax?

Look forward to your input. Thank you.

Edited by: Syed Aleem on Aug 26, 2011 1:55 PM

I am wondering if something could be done with distinctcount function? I tried a few things, but did not succeed!