Item Adjustment
bangi
Member Posts: 11
I have a dataport for item adjustment to which I am supplying cost totals for qty involved.
On the negative adjustments where the location has items in stock it accepts the Value from the dataport but on positive adjustments where there was no stock it overrides the value supplied with value from sku.
How can I prevent this from happening without having to edit all entries again in the form.
Also another question is on Create SKU function why does it pick the latest cost and how can I get it to pick the average cost.
On the negative adjustments where the location has items in stock it accepts the Value from the dataport but on positive adjustments where there was no stock it overrides the value supplied with value from sku.
How can I prevent this from happening without having to edit all entries again in the form.
Also another question is on Create SKU function why does it pick the latest cost and how can I get it to pick the average cost.
0
Comments
-
On your first question, when you import the positive adjustment, put in the code:
VALIDATE("Unit Amount",YourValue)
This will allow the positive adjust to be whatever cost you choose.
On your second question, it uses the Unit Cost, which is your Average cost. Make sure you run Adjust Cost process first.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
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions