Resetting Dimensions on posted transactions

Datapac
Datapac Member Posts: 97
edited 2006-03-16 in NAV/Navision Classic Client
Navision 4.0. Our Global Dimension 1 is Division.
Some of our Customer records have only had the Division dimension set recently, so any of the historical transactions for these customers cannot be analysed by dimensions.
The dimension values on the Customer have been set to Code Mandatory, so any orders created before the Dimension values were set are now giving errors that the DIVISION dimension is not set when trying to post shipments.
We have similar problems trying to Apply Entries on Customer Ledger Entries.

I'd like to correct the historical transactions to set the Division equal to the value currently associated with the Customer.

Any thoughts or tips on what I need to look out for & what files I need to update?
Thanks

Comments

  • ara3n
    ara3n Member Posts: 9,258
    I've done this a lot. The thing that you have to pay attention, the relationship between items that were sold to a customer. Make sure you populate the
    Posted dimension tables and posted tables as well.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Datapac
    Datapac Member Posts: 97
    Thanks Rashed,
    Do you normally call standard code to update the dimension values (something like the Dimension Management codeunit) or do you write your own?
    I've managed to correct the data in the Sales Header, Sales Line and Document Dimension table by validating the Shortcut Dim 1 value on the Sales Header, but I don't think the rest of the Dimensions (Ledger Entry and Posted Doc) are going to be as straightforward to fix.
    Regards,
    Richie

Categories