Another question regarding changing BUM

taher.bha
taher.bha Member Posts: 48
edited 2008-08-19 in NAV/Navision Classic Client
Hi all,
I have one question concerning changing the base Unit of Measure for the Items.
I already searched mibuso, and the normal solution would be the use of negative adjustment to make inventory = 0 then change the BUM and use a positive adjustement to restore the inventory and the unit costs again.

Now, I have a particular situation :
None of the items has a BUM, and no BUM has been used when purchsing and buying the items. (This means that all the items are (virtually) purchased and sold as one unit).
MoreOver there are open purchase and sales orders. I can't invoice All of them.
The items are using average costing method. (Both + and - Adjustement sould be run on Sunday ?)
Many of the items use serial Numbers, so restoring the inventory won't be so easy.

My question is whether I can use an easier approch : Running a batch job (am aware that this not really recommended) to change the BUM (The same one UNI) on the following tables :
- Item
- Item Ledger Entry
- Phys. Inventory Ledger Entry
And insert the BUM in the Item Unit of Measure Table
Should I also update Sales Line and Purchase Line Tables

The OnValidate trigger won't be called by the batch when modifying all of these values.

Is this a correct way to resolve the problem, am I missing something (table, etc)

Thanks in advance for any suggestion/advice.

Answers

  • taher.bha
    taher.bha Member Posts: 48
    Any ideas ? Thank you all.
  • wic
    wic Member Posts: 96
    taher.bha wrote:
    Any ideas ? Thank you all.
    Did you try your own idea?
    Writing a batch that fills ALL BUM through the DB with the new one. As long as there is NO conversion and all item receive the same unit, it looks quite easy. If you make conversion (1 UNI = 0.5 "empty bum") then you'll have much more difficulties to gain success. Because you have to compute all "qty" and "qty. (base)" and you must know wether it's a qty or a qty (base) in appropriate fields.

    Naturally I give is NO WARRANTY that you won't have any problems...
    This is just a suggestion!

    Hope this will help! try and test!
    #### Only one can survive ######
  • taher.bha
    taher.bha Member Posts: 48
    I finally used a Batch report to update the following tables

    - Item ("Base Unit of Measure", "Sales Unit of Measure", "Purch. Unit of Measure)
    - Item Ledger Entry
    - Phys. Inventory Ledger Entry
    - Sales Line (setting )
    - Sales Shipment Line
    - Sales Invoice Line
    - Sales Cr.Memo Line
    - Purchase Line,Purch. Inv. Line
    - Purch. Cr. Memo Line
    - Purch. Rcpt. Line

    And make inserts into the Item Unit of Measure table

    Things seem to be alright.

    Thank you all for your help.

Categories