
hi guys,
Our company seldom keep stock. For any new sales order entered in system, the user will raise a special order to purchase the item to fulfill the S/O
There is a lot of sales order will be generated in the system in daily basis.
How can i check is all my sales orders already raised a special purchase order ?
Currently i have to go into each sales order manually and check the field "special order number" at sales item line but this is too consuming .
Can have a listing to check ?
The sales lines don’t have a direct page to access so you can see them all. However, you can add a page for the sales lines as a web service and the access the data in excel or power bi. Special order field may not be available for filtering so a custom page with a scaled back selection of fields.
Resource for creating a page: docs.microsoft.com/.../devenv-page-object