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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

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

Thanks,

Girish S.

Was this reply helpful? Yes No