Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Another question regarding changing BUM
taher.bha
Member Posts: 48
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.
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.
0
Answers
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!
- 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.