Item Tracking Lines

(0) Share

Report

Posted on by Joris Jacobs

Hello,

I'm currently editing the purchase lines from a purchase order. This already works with the web service, but adding item tracking is proving to be tricky. I want to be able to add a Lot No to one purchase line like in the 'Edit - Item Tracking Lines' page.

I've made a web service of the page and created the ItemTrackingLines object with web services. A new object is created with the following values:

stdClass Object ( [Key] => 300;UAEAAACHAQAAAAAAA.....
[LotSnAvailable_Rec_x002C_0] => 1
[LotSnAvailable_Rec_x002C_1] => 1
[Expiration_Date] => 0001-01-01
[New_Expiration_Date] => 0001-01-01
[Warranty_Date] => 0001-01-01
[Quantity_Base] => 0
[Qty_to_Handle_Base] => 0
[Qty_to_Invoice_Base] => 0
[Quantity_Handled_Base] => 0
[Quantity_Invoiced_Base] => 0
[Appl_from_Item_Entry] => 0 ) )

After editing and adding other fields like:

Lot_No,
Item_No,
Location_Code,
Quantity_Base,
Qty_to_Handle_Base,
Qty_to_Invoice_Base,
Quantity_Handled_Base
Quantity_Invoiced_Base

I update the object and get the following error:

[SoapFault exception: [a:Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideDataException] Tracking Specification Entry No. '1' does not exist. in ...

This is because the "Appl_from_Item_Entry" field is invalid. Which web service can I use to get the right Item entry number?

The Appl_from_Item_Entry field links to:

Item Ledger Entry.Entry No_
Item Entry Relation.Item Entry No_

But because that Item isn't received, it doesn't exist in these tables.
I'm looking for a solution to find the correct Appl_from_Item_Entry via web services and not code Units.

Many Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

Hi Joris,

I'm not sure if this can work... the Item Tracking page has a temporary table as sourcetable, which is generated from several sources when the page is opened. Please have a look at the white paper from Microsoft on how it is intended to work. Accessing it with a page webservice could prove pretty tricky, as you're writing all lines in one service call. @Everybody: Any ideas? Except from adding a codeunit for single-line manipulation?

with best regards

Jens

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

The information entered in the item tracking lines page is stored in the reservation entry table when the page is closed.

To insert this through a web service I would suggest creating a new page based on the reservation entry table and insert the records with the lot numbers that way.

If you manually enter a lot number against a purchase order line and then run the reservation entry table you will see how the record should be inserted.

Was this reply helpful? Yes No
Joris Jacobs 80 on at

Like (0)

Report

Thanks for answering Olof,

You suggest creating a new page based on the reservation entry table and inserting the records. Isn't this what I did in the code above?

I've created a web service based on the page "Item Tracking Lines (id 6510)" and called the create function and added the Lot_No. When calling the update function I get the following soap error: SoapFault exception: [a:Microsoft.Dynamics.Nav.Types.Exceptions.NavCSideDataException] Tracking Specification Entry No. '1' does not exist

Any ideas?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

The Item Tracking Lines page is based on a temporary table called Tracking Specification. My suggestion is to create a new page based on the Reservation Entry table, then publish this new page as a web service.

Was this reply helpful? Yes No
Joris Jacobs 80 on at

Like (0)

Report

What if the web service of the Reservation Entry table hasn't got a create function to add my item, only a read and update.

Joris

Was this reply helpful? Yes No
Aleia Stickley 60 on at

Like (0)

Report

Tracking Specification Entry No. '1' does not exist

Was this reply helpful? Yes No