Skip to Content
0
Former Member
May 12, 2015 at 04:11 PM

Record Selection

20 Views

Hi,

I have a canned report in Sage 300 2014 for a third party product. Bin Tracking.

I am trying to change the record selection to change the OYBINDD.ITEMNO to OYBINDD.FMTITEMNO

({OYBINH.LOCATION} >= "") AND ({OYBINH.LOCATION} <= "ZZZZZZ") AND

({OYBINDD.ITEMNO} >= "SPSPCRB") AND ({OYBINDD.ITEMNO} <= "SPSPCRB") AND

({OYBIND.BIN} >= "") AND ({OYBIND.BIN} <= "ZZZZZZZZZZ")

Everytime I change the record selection to the following:

{OYBINH.LOCATION} >= {?StartLocation} and

{OYBINH.LOCATION} <= {?EndLocation} and

{OYBINDD.FMTITEMNO} >= {?StartItem} and

{OYBINDD.FMTITEMNO} <= {?EndItem} and

{OYBIND.BIN} >= {?StartBin} and

{OYBIND.BIN} <= {?EndBin}

It reverts back to OYBINDD.ITEMNO when I print....I tried 'find in formulas' on this field but I am unable to locate where to change this so it does not keep looking for the ITEMNO.

Thanks,

Debie