How to select only new Goods Receipt PO documents added, EFM (GEP) SAP B1 9.1 or 9.2?.
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.
Andy Grootens replied
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?