How to select only new Goods Receipt PO documents added, EFM (GEP) SAP B1 9.1 or 9.2?.

[former_member183402]

Hi all,

I want to ask one question.

If you want to export XML file of new Goods Receipt PO documents added, how can I do that by using GEP format without exporting all data of stock?

I have no idea of how I can put condition in the query of crystal report which will select only new documents.

Is there someone who has an idea to this question?

Please anyone can help me.

[a_grootens · Accepted solution]

Hello Rurangwa,

I don't know how you make your export, but I think a simple UDF with Y/N values should do the trick. When the document  is exported you give it a value Y and if not then N. In your export proces you could update this UDF with a Stored Procedure.

Does that make sence to you?

Kind regards,

Andy Grootens

Asecom

[former_member183402 · Accepted solution]

Thank you Andy.