Not able to invoice sales order after applying item tracking (Item entry relation does not exist)

(0) Share

Report

Posted on by Community Member

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. I was only able to invoice 1 of the two items (apparently the one with assigned serial number), but it appears NAV also requires me to assign a serial number for the first item shipped also, which is not possible?

I also tried to undo shipment on the posted sales shipment for the first item, 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?)

Have any of you encountered this problem before? Any help will be greatly appreciated!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

KTA 1,200 on at

Like (0)

Report

It's hard to understand an item that change it's behaviour in the item tracking matter; I don't see standard works with that idea.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
joshua2310 40 on at

Like (0)

Report

I have the same error how to do this manually ?
[quote user="Robin Sorensen"]
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. I was only able to invoice 1 of the two items (apparently the one with assigned serial number), but it appears NAV also requires me to assign a serial number for the first item shipped also, which is not possible?

I also tried to undo shipment on the posted sales shipment for the first item, 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?)

Have any of you encountered this problem before? Any help will be greatly appreciated!
[/quote]

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Have you tried the solution Robin used to solve his case?

Care a sales invoice and use the get shipment line function?

Was this reply helpful? Yes No
joshua2310 40 on at

Like (0)

Report

Item ledger Entry Does not exist pops up when I do this

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

[quote user="joshua2310"]
Item ledger Entry Does not exist pops up when I do this
[/quote]
Then i would recommend you contact your partner and have them debug this together with you.

Was this reply helpful? Yes No