Field "Source Type" in table "Reservation Ent

NizarNizar Member Posts: 61
Hello,

I have migrated my database from navision version 2.60 to 4SP1.
In navision 4SP1, values of field "Source Type" in table "Reservation Entry" is different in the version 2.60.
Exemple : In version 2.60, when the "Source Type" in table "Reservation Entry" is "Sales" , this value in version 4SP1 is 37.

I want to khnow all values of field "Source Type" in 4SP1.

Can you help me.

Thank you.

Comments

  • MbadMbad Member Posts: 344
    The migration should work since the field was changed from option to tableno(your reservation was from a sales line, hence the (table)37 in the entry).

    I assume you ran report 104026 when you upgraded?
  • NizarNizar Member Posts: 61
    Thanks for your reply,

    Yes I run the report 104026 where upgrated, but now i want to khow the values of the tableno of field "Source type" to do the correspondence with the option of the versionb 2.60
  • kinekine Member Posts: 12,562
    It is simple - in NF 2.60 are options like (I do not know exact english names, I have just Czech DB...):
    0=
    1=Sales
    2=Requisition Line
    3=Purchase
    4=Item Journal
    5=BOM Journal
    6=item Ledger Entry
    7=Production Order Line
    8=Production Order Component

    As you can see, each option can be assigned to one table in NAV.

    1 = Sales Line (tab 37)
    2 = Requisition Line (tab 246)
    3 = Purchase Line (tab 39)
    4 = Item Journal Line (tab 83)
    5 = BOM Journal Line (tab 89)
    6 = Item Ledger Entry (tab 32)
    7 = Prod. Order Line (tab 5406)
    8 = Prod. Order Component (tab 5407)

    It is simple, doesn't it? 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.