35
It would be very handy to have a new boolean in the Sales and Receivables Setup table named like "Don't create zero quantity lines on posted documents".

The setting would be good for Sales Orders and Sales Return Orders and would optionally prevent the system from creating a line if:

- Sales Order - posting a shipment and the Qty. to Ship = 0
- Sales Order - posting an invoice and the Qty. to Invoice = 0
- Sales Return Order - posting a receipt and the Return Qty. to Receive = 0
- Sales Return Order - posting an invoice and the Qty. to Invoice = 0
Category: Sales
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team

Comments

M

This is a pretty important flaw, and I am not sure why Microsoft doesn’t believe it is important.

The business case is that the customer creates a Sales Order with more than one line (let’s say 10 lines). They only shipped 2 lines and need to send the invoice to their respective customer for those 2 lines that got shipped. The invoice must be sent to their customers showing only 2 lines.

Currently, this doesn’t work, as each time a posted shipment and invoice are triggered, all the lines of the sales order will appear on the posted sales invoice with the blank quantity and amount and will also appear on the Invoice sent to the customer. Let’s break it down, each time we post one line of the sales order, all lines will also post to Posted Sales Line, Item Entry, VAT Entry, GL Entry, etc. In a high-volume environment where sales orders have many lines, the BC database will grow exponentially with invaluable data in multiple tables.

You may need to add a function to only post those sales lines that have qty to ship and qty to invoice and ignore all other lines if the item type is “Item”. I’m sure there might be other things to consider along with this function.

Category: Sales

M

Applicable only to document lines of a non blank type.

Category: Sales