Sales Line table contains lines from Posted documents

aadams
aadams Member Posts: 19
in NAV Three Tier
Hello,

We've developed a Jet report that uses the Sales Line table (NAV 2015) to build a picking list for our shipping depot. Our users reported that old orders are reappearing on this list, which upon inspection turned out to be caused by the Sales Lines table including lines for documents that have been fully posted. It was my understanding that once a Sales Order was posted (entirely shipped/invoiced) the lines would be moved from the Sales Line table into the Sales Invoice Line table. Is this not the case? It appears to keep lines from random orders (only a few out of hundreds so far).

Any ideas? Could this be a NAV bug?

Answers

  • Fiddi
    Fiddi Member Posts: 46
    edited 2016-04-29
    Hello,

    this is not necessarily a bug, this may be a nomal behavior.

    Sales Lines are only automaticaly deleted when their Sales Order Header is completely shipped and completely invoiced and the Invoice is posted from the Sales Order. If you use Compine Shipments or post the invoice by a Sales Invoice with importing the posted shipments there, then you have to use the report "Delete Invoiced Sales Orders" to delete the completed orders.

    So in this case you should filter the Sales Lines on the field "Outstanding Quantity" <>0. This should only show not completely shipped order lines.

    In some NAV implementations automatical deletion is disabled, because their users need the old Sales Lines for statistics.

    regards

    Fiddi
  • aadams
    aadams Member Posts: 19
    Hi Fiddi,

    Thank you for your response. It makes a bit more sense now with your explanations.

Categories