sales shiplines with quantity = 0

ara3n

Is there any reason why these lines are transfered from sales line to sales shipment line and sales invoice lines. Some of our customers have Large Sales Orders with 100's or even 1000 of lines and everytime they post the sales order it takes for ever.

I can write the code in Cu 80 and 90 to not transfer these lines, have to remove the document lines dimensions for those lines. I wish it was a setup so that you could check and uncheck them.

Another setup feature that should be added as a setup for sales lines that have complety been shipped and invoiced to be deleted from sales line.

kriki

ara3n wrote:

Is there any reason why these lines are transfered from sales line to sales shipment line and sales invoice lines.

There is a very good reason: in general you want to send an invoice to your customers.
Shipping is optional. If you don't need to ship, there is a toggle in the sales setup that you can untoggle so Navision doesn't make shipments.

If you are working on SQL, you can do some work on the indexes. A lot of indexes SQL doesn't need (or doesn't even use). For these you can put in the properties of the index to not maintain them.
If you do this well, posting in SQL goes faster than posting in Navision!

If you are working on Navision-DB, you can decide to not create the the lines in the definitive posting but do it at a later moment (a long time ago I had a customer that wanted the shipment-lines ASAP but he didn't care about the item ledger entries). This will speed up a lot.
In this case you must make a report that transfers the lines to the definitive tables (With this report I fixed the item ledger entries).
This report you can run all the time and in Navision DB you can make it so that it 100% occuppies the disks without overloading the system. See Use DB at 100% without filling the COMMIT-cache

Same thing for deleting sales lines that are finished. Or this you can also put in codeunit 80 (but this slows down again).

Savatage

Our customers want to also know what they DIDN'T get too. So they can make other arrangements if necessary. We have some super large orders too, we have learned it's alot, ALOT faster to post the biggest of them from the Client located ON the server.

Alex_Chow

The reason is so the customer knows exactly what's been shipped and what has not been shipped.

I understand your concern and they definately should make a button that transfers over 0 quantities or not. We've made that modification to a few clients of ours that requested it.

kriki

:oops: Ahum, it seems I didn't read the title well. :oops:
So don't read most of my answer is nonsense.
:oops: :oops: :oops: