Skip to main content

Hello,

Been here multiple times with this same report, I’d like to ask how it’s possible for me to NOT display the qty and uom of an item that lists down multiple serial numbers every time SN is displayed?

I originally used this Prev statement:

IIf(Prev(rSOShipLine.OriginalShippedQty])=ySOShipLine.OriginalShippedQty], '', 'SOShipLine.OriginalShippedQty]

And offourse, the result is, I’ll never get the same QTY or same UOM, though it’s another Item in the list. I do not wish that to happen, what formula can I use? I appreciate any help!

 

Paula

Tried using the logic that if NEXT uom is not null, then that UOM should display instead of being blank. But I got an error that says “Exception has been thrown by the target of an invocation.”

=IIf(Prev(reSOShipLine.UOM])=MSOShipLine.UOM] and Next(eSOShipLine.UOM])<>Null, '', SOShipLine.UOM])

 

Whatelse can I try? Somebody please, thank you!


try
 

=IIf(IsNull((SOShipLineSplit.LotSerialNbr], '')<>'', IIf(Prev((SOShipLine.TranDesc])==SOShipLine.TranDesc], '',,SOShipLine.UOM]), SOShipLine.UOM])

 

or compare previous and current SOShipLine.InventoryID instead of TranDesc


try
 

=IIf(IsNull((SOShipLineSplit.LotSerialNbr], '')<>'', IIf(Prev((SOShipLine.TranDesc])==SOShipLine.TranDesc], '',,SOShipLine.UOM]), SOShipLine.UOM])

 

or compare previous and current SOShipLine.InventoryID instead of TranDesc

Thank you sir, but this error came up

The expression contains the 'SOShipLine' object that is not defined in the current context.

What does this mean?


try
 

=IIf(IsNull((SOShipLineSplit.LotSerialNbr], '')<>'', IIf(Prev((SOShipLine.TranDesc])==SOShipLine.TranDesc], '',,SOShipLine.UOM]), SOShipLine.UOM])

 

or compare previous and current SOShipLine.InventoryID instead of TranDesc

Thank you sir, but this error came up

The expression contains the 'SOShipLine' object that is not defined in the current context.

What does this mean?

Oh I just missed some m]. This worked! Really thank you so much for the quick and effective assistance sir @aaghaei !


Reply