Initial Inventory Unit Cost with WMS
WUFUQIANG
Member Posts: 42
](*,) I am new in using Warehouse Management System with Navision,
Got problems when transferring beginning inventory (qty and unit cost) from legacy system at the beginning of the project, If we arent usng WMS, we can use Item Journal to set them up ( qty + unit cost ), with WMS ? ??????? does anyone can do me a favour ?
Thanks beforehand
Got problems when transferring beginning inventory (qty and unit cost) from legacy system at the beginning of the project, If we arent usng WMS, we can use Item Journal to set them up ( qty + unit cost ), with WMS ? ??????? does anyone can do me a favour ?
Thanks beforehand
0
Comments
-
with wms you need to load the initial inventory into warehouse journal. THen in Item journal run Function->calc whs. Adjustment.
This will create the item journals. The cost comes from Item card Last Direct Cost I believe, depends on costing method. SO you need to fill that field on item card. Once the item journal is field in, you can clear the last direct cost from item card. Then post the journal.
You could write a dataport that would update the unit cost on journal as well that way you don't have to change the item card, but you can't do it for certain costing method.0 -
The WHM has nothing to do with the cost of the item. It only concerns with the quantity stored in the bins.
So using the item journal will not affect the quantities in the bins.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
Thanks for all of your directions and ideas, it worked,0
-
you are welcome.0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
