Sales Order Archive vs Sales Order History

pjfilipe
pjfilipe Member Posts: 10
edited 2004-09-02 in NAV/Navision Classic Client
I need to keep an history of sales orders.

I know that when I print a sales order this version is archived and a new one is created. This keeps the archive updated.

But if I want to list the sales order archive the same order can be displayed several times with different version numbers, is there anyway to solve this, something similiar with grouping by sale order number and displaying only the "top" version number.

As anyone had the same problem?
What solution did you use, sales header archive table or did you created a new history table for sales headers.

Thank you very much

Paulo

Comments

  • naveenjain
    naveenjain Member Posts: 7
    Create two new flow fields in the Sales Header Archive table.

    1) 50000 Max Version No. Integer
    Property:
    Editable = No
    CalcFormula = Max("Sales Header Archive"."Version No." WHERE (Document Type=FIELD(Document Type),No.=FIELD(No.)))


    2) 50001 Max Exist Boolean
    Property:
    Editable = No
    CalcFormula = Exist("Sales Header Archive" WHERE (Document Type=FIELD(Document Type),No.=FIELD(No.),Max Version No.=FIELD(Version No.)))

    Save the table. Now open the form Sales List Archive and on the form property

    SourceTableView = WHERE(Max Exist=CONST(Yes))


    Hope this will Help. 8)

    Naveen Jain
  • pjfilipe
    pjfilipe Member Posts: 10
    Worked perfectly, thank you very much for the shared knowledge

    Best regards

    Paulo

Categories