Finance | Project Operations, Human Resources, ...

Filter Sales Edit Lines with custom field

(0) Share

Report

Posted on by Community member

Hi everyone!

I have a question!

I added a field in the SalesEditLines that is connected to a custom field on the WMSShipment.

When I press the Post Packing Slip button on the WMSShipment I would like it to show me the header and the lines filtered on the custom field.

if I have two orders with the same custom field (example Ship01) i would like it to show me only one line in the header and all the lines of the two orders when opening the form... as if I were using the arrange button!

how can I do?

thank you very much

All responses (2)

Answers (0)

GirishS 27,823 Moderator on at

Like (0)

Report

Filter Sales Edit Lines with custom field

Sorry it's not customer field -It's a custom field like orders.

Thanks,

Girish S.
Suggested answer

GirishS 27,823 Moderator on at

Like (0)

Report

Filter Sales Edit Lines with custom field

Hi,

Try adding group by of the customer field on the header DataSource executeQuery method.

https://msddax.wordpress.com/2014/06/27/using-group-by-and-aggregate-function-in-execute-query-method-of-form-datasource/

Thanks,

Girish S.