GRPO

[Former Member]

HI FRIENDS ,

          BELOW  FMS query i need to add the GRPO qty. how do i add. actually this is automattically generate the batch number query

Select A.Code + A.Nos from (

Select max(Right(LEFT(Indicator,4),2)) as Code ,

(Select isnull(Right(MAX(BatchNum)+1,7),'000001')+'01' from OIBT where   InDate>=GETDATE()

and

LEN(Batchnum)=9 and

indate between (select Min(f_refdate) from OFPR where

Indicator = (Select MAX(Indicator) from OFPR where Convert(nvarchar(10),GETDATE(),101) between F_RefDate and T_RefDate )) and

(select Max(T_refdate) from OFPR where

Indicator = (Select MAX(Indicator) from OFPR

where Convert(nvarchar(10),GETDATE(),101) between F_RefDate and T_RefDate )))as Nos

from OFPR

Where Convert(nvarchar(10),GETDATE(),101) between F_RefDate and T_RefDate

) A

[former_member204969 · Accepted solution]

In the batch creation window you can not access the data from the originating document. So you can solve this problem only a complicated way.

At one of our customers I used a table to transmit the data to the batch creation window. To make the transferred data unique, I stored the value in a line identified by the $[USER].

- So you can create a user defined table with lines for every user and a field for the quantity.

- In the good receipt transaction line you can make an FMS which store the quantity in this table to the line identified by the $[USER] value.

- In the batch creation window you can retrieve this supplier reference using the $[USER] value to identify the appropriate entry.

[Johan_H]

Hi,

It is not entirely clear to me what you are asking. Do you want to add the GRPO quantity to the batch number that is created by this query ?

Regards,

Johan

[Former Member]

yes. above query only creating the batch number like (12100001 herewith i need grpo qty )

[Johan_H]

Hi,

Will you be using this FMS query in the GRPO lines ?

Regards,

Johan

[Former Member]

only using grpo lines qty for updating automatic batch number creation

[Johan_H]

Okay, please add $[PDN1.Quantity] to the query.

For example: Select A.Code + A.Nos + $[PDN1.Quantity]

Regards,

Johan

[Former Member]

kindly add the your query with my query

[Johan_H]

Please see my previous answer.

[Former Member]

It showing internal error

Internal error (-1004) occurred  [Message 131-183] while run the query as per your instruction

[KennedyT21]

Hi Ramesh...

This Is not Possible.. As i said multiple forms with FMS is not Possible...

Regards

Kennedy

[Johan_H]

Hi Ramesh,

Did you use this query ?

Select A.Code + A.Nos + $[PDN1.Quantity] from (
Select max(Right(LEFT(Indicator,4),2)) as Code ,
(Select isnull(Right(MAX(BatchNum)+1,7),'000001')+'01' from OIBT where   InDate>=GETDATE()
and
LEN(Batchnum)=9 and
indate between (select Min(f_refdate) from OFPR where
Indicator = (Select MAX(Indicator) from OFPR where Convert(nvarchar(10),GETDATE(),101) between F_RefDate and T_RefDate )) and
(select Max(T_refdate) from OFPR where
Indicator = (Select MAX(Indicator) from OFPR 
where Convert(nvarchar(10),GETDATE(),101) between F_RefDate and T_RefDate )))as Nos 
from OFPR
Where Convert(nvarchar(10),GETDATE(),101) between F_RefDate and T_RefDate
) A

Regards,

Johan

[Former Member]

any other idea is there if you have , share it

[KennedyT21]

Hi ramesh..

Try With SDK is only way...

Hope helpful..

Regards

Kennedy