value of Quantity field in sales line table

antoine

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

Savatage

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

plebeau

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.