illegal item reference

psyches
Member Posts: 2
Any idea on how to resolve this error? i'm currently trying to post in the following tables for AX: InventJournalTrans, InventJournalTable, InventTrans, InventSumLogTTS by using SQL and not thru AX. This is for the purpose of posting a Transaction for Items Inventory by means of issuing a PO and moving an item. I tried to mimic the posted values from AX in using storedprocedure. So far, this was the error that came out. I was able to code the same values to the tables but i don't know what is the source of this error. however, one thing that really confuses me is how to get the value of the RECID and RECVERSION. i am not sure if this is related to the error that i posted here.
Also, is it possible to use this kind of method because i read somewhere that this can only be done thru ax and not at the backend.
Can someone please enlighten me regarding this please. Many thanks in advance!!
Also, is it possible to use this kind of method because i read somewhere that this can only be done thru ax and not at the backend.
Can someone please enlighten me regarding this please. Many thanks in advance!!
0
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