* Changing items Quantities + cost + Unit of measure

taher.bhataher.bha Member Posts: 48
Hi everyone,
Once again I'm asking and not contributing. I'll try to not make this too much of a habit.
Am using Nav 5.0. All the items are using Average Costing Method.
I got some problems modelling CD + Licence. See
http://www.mibuso.com/forum/viewtopic.php?t=26688&start=0&postdays=0&postorder=asc&highlight=
for more information

We finally decided to use a kit to resolve this pb. The idea is to :
1. Receive and invoice the CD (Purchase Order1 for item AAA-CD).
2. Receive the Licence (Purchase Order2 for item AAA-LIC)
3. Use a Kit BOM and a BOM Journal to create the kit (Item AAA). This way an estimated cost is applied till the Licence is really invoiced (purchase)
4. Finally Invoice purchase order for AAA-LIC

My problem is the following :
- The composed items are already in the System. They were intially created as simple items with no Base unit of measure
Initial Costs and quantities were validated using an Item Journal (+ adj.).
- Orders for some of these items were already received. Some items were even sold.

What i'd like to do is to "remove" these Items and "create" new Ones with BOM KIT. I need also to specify a main unit of measure to the items.

What would be the right way to do this ?
- Negative adjustment to these items to set their quantities to 0
- Cancel Reception Lines ? it wouldn't be always possible as some items were already sold.
- How to remove the pending purchase orders ? These orders were received for item AAA (wich is currently considered as AAA-CD) not item AAA-CD


I found the following suggestion when searching mibuso, how to apply it in my case ?
1. Make sure all received items are invoiced
2. Make sure all shipped items are invoiced
3. Run revaluation journal as of the upcoming Sunday (to ensure no one is working with the sytem)
4. Post the revaluation and run adjust cost.

Hope I was clear enough, that's far from bying easy to explain.
Can anyone helpme ? Thx in advance.

Answers

  • ara3nara3n Member Posts: 9,256
    I suggest to receive/invoice all the outstanding orders. create new items.
    Block the old items.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • taher.bhataher.bha Member Posts: 48
    ara3n wrote:
    I suggest to receive/invoice all the outstanding orders. create new items.
    Block the old items.

    Thx Rashed i think that's the only realistic solution under these conditions.

    Thx again.
Sign In or Register to comment.