Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K 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
- 272 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
Options
Importing Stock Take Figures from Excel to NAV
zimworxcode
Member Posts: 53
A stock was carried out and captured in Excel because there are many stock items so printing Stock Take Sheets was going to be a difficult task. Now i want to import the figures into the the Phys. Inventory Journal I get the error:
“Phys. Inventory must be Yes in Item Journal Line Journal Template Name=’PHYS . INV.’,Journal Batch Name=’DEFAULT’,Line No.=’0’
There has to be a way to import stock take figures from Excel to NAV, Please assist i may be missing out something.
“Phys. Inventory must be Yes in Item Journal Line Journal Template Name=’PHYS . INV.’,Journal Batch Name=’DEFAULT’,Line No.=’0’
There has to be a way to import stock take figures from Excel to NAV, Please assist i may be missing out something.
0
Comments
You have to vaildate the fields while importing in the same order as if you were manually entering it.
if you search the forum for "opening inventory" i'm sure you'll get some results
search.php
http://www.BiloBeauty.com
http://www.autismspeaks.org