Hide delivered or invoiced lines?

(0) Share

Report

Posted on by LL-10051122-0

Hi,

I have quite a few sales orderns that contains a lot of already delivered and invoiced lines but also one or two lines with back ordered quantity that has not yet been delivered/invoiced to the customer.

Is there a way to make these sales orders more easy to read, by hinding the already delivered lines?

Categories:

Development

All responses (6)

Answers (0)

Suggested answer

Saurav.Dhyani 10,187 User Group Leader on at

Like (0)

Report

Hide delivered or invoiced lines?

Hi,

If this is something that you want for all sales orders, then ask a developer to apply filter on the page.

Then it will work with all documents.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube
Suggested answer

Jun Wang 4,020 Super User on at

Like (0)

Report

Hide delivered or invoiced lines?

you could also send the lines to an excel and filter from there. Or you can open the lines in a new window as below then filter as needed,

Jun Wang
Suggested answer

Valentin Castravet 4,486 Super User on at

Like (0)

Report

Hide delivered or invoiced lines?

Just to add more information, you can also try using the Sales Lines Page. As this page is easier to filter and filters can be saved as well.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
Suggested answer

Yi Yong 190 on at

Like (0)

Report

Hide delivered or invoiced lines?

Hello,

You could do a filter on the field.

For example, set a filter on 'Qty. Shipped not Invoiced' with <> 0 or >0 will only show the pending invoice lines.
LL-10051122-0 4 on at

Like (0)

Report

Hide delivered or invoiced lines?

Thank you for your relpy, Yi Yong.

So, sorting on invoiced is possible but no way of hiding lines with total quality already shipped/invoiced?
Yi Yong 190 on at

Like (0)

Report

Hide delivered or invoiced lines?

Hello,

On the sales lines, there is 'Outstanding Qty' and 'Qty. Shipped not Invoiced' field.

You can perform sorting on them to have the relevant lines on top.

'Outstanding Qty' -> not shipped and not invoiced

'Qty. Shipped not Invoiced -> quantity pending invoice

You can only personalize them via role -> customize pages.

https://learn.microsoft.com/en-us/dynamics365/business-central/ui-personalization-manage

If you have 'Default Quantity to Ship' as Remainder (under Sales & Receivables Setup) then you can have the same result by sorting on 'Qty. to Ship' or 'Qty. to Invoice'.