My customer uses batch transaction they get the same material from different vendors. to keep track of vendor wise items they are using batch in every transaction.
They need prefix for batch number should start based on vendor code.
i.e If they purchase material from vendor ABC in batch number ABC should come automatically and they will enter some suffix.
I think this is possible through FMS. Can any one tell me the query for the above mentioned scenario?
Thanks in Advance
Test this query
SELECT LEFT(T0.CardName,3) FROM OPDN T0 WHERE T0.CardCode = $[$4.0.0]