You’re offline. This is a read only version of the page.
80
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:
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:
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
Tracking Specification Entry No. '1' does not exist
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
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.
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?
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (