Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.
thanks Barak - I already tried putting the clalev statement in my code (see below)
Can you help me with this problem?
I'm trying to add to the filter that is used to displays the components of a Work Order in the Production Tracking (Material) transaction. Basically when stock is received we enter a Pallet Id (PALNUM) and I want to incorporate this to filter the components displayed in production tracking so that only the components included on a given Pallet are available to be tracked. On the STOCK file, the STO1 index comprises FCY, PALNUM and ITMREF so I'm trying to use this at the entry point MFMFLT but it's not working. i don't know where to tell it to link the MFM table to STO table
$ACTION
Case ACTION
When "MFMFLT" : Gosub SPE_MFMFLT
Endcase
Return
$SPE_MFMFLT
if [M:MTK0]YPALNUM <> "" #screen field used to enter req'd Pallet ID
If clalev ([F:STO]) <= 0 : Local File STOCK [STO] : Endif
CRITERE -= "& [F:STO]STO1 = [F:MFM]MFGFCY;[M:MTK0]YPALNUM;[F:MFM]ITMREF"
sorry , I'm no femilier with the Production Tracking but according to help about it you can filter only MFM table and I don't think you can link to other table at that point...
I also think there is no way to filter on more then 1 value...