Query Required

[Former Member]

Hi,

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

Shashi

[former_member187989 · Accepted solution]

shashi,

Test this query

SELECT LEFT(T0.CardName,3) FROM OPDN T0
WHERE T0.CardCode = $[$4.0.0]

Jeyakanthan

[Former Member]

Hi Shashi

There is a function under adding batches called Automatic creation that allows you to add a prefix and suffix to build the batch numbers.

Let me know if you need assistance with this.

Kind regards

Peter Juby

[Former Member]

Hi Peter,

Thanks for the reply. Actually client want the batch numbers vendor wise. for example

If client does GRN from Vendor ABC and add document Batch creation document will popped up over there clilent want ABC to be popped up automatically in batch.

If client does GRN from XYZ then in the batch document XYZ should get popped up..

I think this can be done trough FMS

Regards

Shashi

[Former Member]

Hi,

Any inputs?

Regards

Shashi