value of Quantity field in sales line table

antoine
antoine Member Posts: 2
edited 2005-07-25 in Navision Attain
Hi,

I'm filling in and validating/posting (with invoicing) orders in Navision 3.01.
Does anyone know where I can still find the value of the Quantity field of the sales line table for a record concerning an order once that order is completly delivered and invoiced ?

When an order is completly delivered and invoiced, all the lines concerning that order are gone of the "sales line" table
but I'd like to keep/find of a trace of the quantities originally ordered ?
Are these values written somewhere else in a table during the posting process ?

Any ideas ?

Thanks. Antoine

Comments

  • Savatage
    Savatage Member Posts: 7,142
    The original qty ordered is not available - just what was shipped.

    You can add an "Original Qty" field and populate it during order entry.

    ref1: http://www.mibuso.com/forum/viewtopic.php?t=6999

    How we did it
    Sales Line Table & Sales Invoice Line Table:

    50001 - "Qty. Ordered" - Decimal (Note Same #)


    [Sales line table]
    "Qty. Ordered" - OnValidate()
    If Type = Type ::Item THEN
    BEGIN
    Validate(Quantity,"Qty. Ordered");

    blah blah blah
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • plebeau
    plebeau Member Posts: 4
    we had the same problem and started with one new field. that was ok for three months, but after that sales wanted a complete history of requested and promised quantity and shipment dates.

    we solved it via a new table and saved order-no., item-no and so on into the table. now we´re able to reach that table from t27, t18 and the sales header archive.

    the sales header archive is another possibility, cause you´re able to save versions of your order with each print.

Categories