Edit Posted Invoice?

slmaluwa
slmaluwa Member Posts: 366
edited 2007-05-07 in NAV/Navision Classic Client
Hi again
We ran into a trouble when we posted an order. By OUR mistake, NAV took the wrong invoice number and we are trying to find a way to EDIT the number of posted invoice?

The developer says it is NOT possible? but, our management insists on changing it otherwise we may have to answer lot of unnecessary questions from Auditors and TAX people.

Anyway to do this?
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."

Comments

  • upasanisandip
    upasanisandip Member Posts: 405
    Hi,

    I knows some tables which affects after posting.

    Sales Invoice Header
    Sales Invoice Line
    Customer Ledger Entry
    Detailed Customer Ledger Entry
    Tax Entry
    Value Entry
    G/L Entry

    You have to make change in these tables.
  • slmaluwa
    slmaluwa Member Posts: 366
    hi

    I tried opening the table in Designer and try to make the change. It gives the following error:
    The fild below must be included in the table's primary key.

    Field: Sell-to Customer Name
    Table: Sales Invoice header

    Any idea? I am not a NAV developer :shock:
    "A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."
  • Maarten_Gerritsen
    Maarten_Gerritsen Member Posts: 2
    'funny' how auditors 'force' you to mess with data.

    The error is caused by someone who messed with the objects before you try to 'fix' the data. Get a developer to solve this.

    Tip: to be sure which records to adjust, run the Navigate function with the Invoice number you want to change: you will get an overview of all entities (ledgers).
  • diptish.naskar
    diptish.naskar Member Posts: 360
    Changing the No. is not going to be an easy task, but yes it is possible to do the same.

    First you need to find out where the reference of the same are present in the system. To some extent yes, navigate function is going to tell you where the Invoice has hit, but not all the tables are displayed, there are some other table also which you need to consider like, posted document dimension.
    Diptish Naskar
    For any queries you can also visit my blog site: http://msnavarena.blogspot.com/
  • Maarten_Gerritsen
    Maarten_Gerritsen Member Posts: 2
    You are right. Not all tables are covered with the Navigate function, eg. the Document Dimension. Also the Invoice lines are not displayed directly by the Navigate function. It just gives you a rough idea of which tables are 'touched'.

Categories