Error when invoicing partially shipped sales order after applying item tracking

robsor
Member Posts: 2
Hello,
When trying to invoice one of our sales orders, I get the error "Item Entry Relation does not exist. Identification fields and values: Item Entry No.='0' ".
I have figured this is due to item tracking. When opening item tracking for the sales line on the sales order, the unassigned qty = 1, which I read can lead to this specific error message. The problem is: The sales order was first shipped 1 (of 2) items, no item tracking -> later, item tracking was added to the item -> 2 new items received on purchase order, with serial number added > shipped the last item, with item tracking. 1 of the two items has then been invoiced (apparently the one with assigned serial number), but it appears NAV also requires me to assign a serial number for the first item shipped (without item tracking), which is not possible?

I also tried to undo shipment on the posted sales shipment for the first item, which has not been invoiced, but then the error "You must assign a serial number for item ...", with no way to assign serial number on the posted shipment (as far as I know?). It's also not possible to change item tracking policy on the item to none, since the item is "in an open document".

Have any of you encountered this problem before? Any help will be greatly appreciated!
When trying to invoice one of our sales orders, I get the error "Item Entry Relation does not exist. Identification fields and values: Item Entry No.='0' ".
I have figured this is due to item tracking. When opening item tracking for the sales line on the sales order, the unassigned qty = 1, which I read can lead to this specific error message. The problem is: The sales order was first shipped 1 (of 2) items, no item tracking -> later, item tracking was added to the item -> 2 new items received on purchase order, with serial number added > shipped the last item, with item tracking. 1 of the two items has then been invoiced (apparently the one with assigned serial number), but it appears NAV also requires me to assign a serial number for the first item shipped (without item tracking), which is not possible?

I also tried to undo shipment on the posted sales shipment for the first item, which has not been invoiced, but then the error "You must assign a serial number for item ...", with no way to assign serial number on the posted shipment (as far as I know?). It's also not possible to change item tracking policy on the item to none, since the item is "in an open document".

Have any of you encountered this problem before? Any help will be greatly appreciated!
0
Answers
-
Solved! If anyone encounters this problem in the future, the solution was quite simply to manually create a sales invoice, and get shipment lines. After posting, the sales order was fully invoiced and could be deleted.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