Skip to Content
0

Alert for Due Documents After Specific Days

Apr 13 at 08:49 AM

14

avatar image
Former Member

Hello everyone,

we started to use SAP B1 HANA since this January. We have very basic knowledge on queries, and we wanted to develop the following conditions in order to trigger some alarms:

- List of Purchase Orders that were created 6 days ago from "today" and with a user field value of "NO".

- List of Purchase Orders due to delivery in 7 days based on the delivery date

- Finally, we would like to know when the "delivery date" has been modified after the creation of a document.

Any suggestions on doing this?

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers