Dynamics Community Forum Thread Details

I'm trying to add item tracking to a purchase order using a webservice (api pages).

After some digging and searching I found that this is done through adding a record to Table 337 (Reservation Entry)

So I exposed this table to the webservice using an api page in AL, and now I could send the following request to my webservice:

POST /itemTrackingReservations? HTTP/1.1
Host: 
Content-Type: application/json

{
    "@odata.etag": "W/\"JzQ0O0VBcmk1K0h6cVBLR3BpWDl4UldaZzV5eHc4TzNWRW9ZSStjWWJHaTVvbXM9MTswMDsn\"",
    "itemNo": "1000",
    "locationCode": "STD-MAG",
    "quantityBase": 2,
    "reservationStatus": "Surplus",
    "creationDate": "2020-04-06",
    "sourceType": 39,
    "sourceSubtype": "1",
    "sourceID": "106006",
    "sourceRefNo": 10000,
    "sourceBatchName": "",
    "expectedReceiptDate": "2020-05-01",
    "serialNo": "SN1",
    "Quantity": 1,
    "lotNo": ""
}

At first glance and testing this worked fine.

However, things started going wrong when I did not complete all items on the line in one go, but in multiple goes (for example, add 2 of the 5 serial numbers and then post the line).

After posting a partial line, the tracking information shows the following:

Which for serial numbers should be impossible. As expected, BC does not allow me to post the purchase order in this state.

So now I'm looking for some other way to add the serial numbers to the purchase order. I already found https://community.dynamics.com/nav/f/microsoft-dynamics-nav-forum/186214/how-to-create-item-tracking-line-from-c-al and I tried the code in there as follows for testing:

action(AddItemTracking)
            {
                ApplicationArea = All;
                Image = Track;
                Caption = 'Add Item Tracking';

                trigger OnAction()
                var
                    reservationManagement: Codeunit "Reservation Management";
                    purchLineReserve: Codeunit "Purch. Line-Reserve";
                    reservationEntry: Record "Reservation Entry";
                    trackingSpecification: Record "Tracking Specification";
                    doFullReserve: Boolean;
                begin
                    reservationManagement.SetReservSource(Rec);
                    reservationManagement.AutoReserve(doFullReserve, Rec.Description, WorkDate(), 1, 1);
                    reservationManagement.SetSerialLotNo('SN1001', '');
                    Message('%1', trackingSpecification.Count);
                    Rec.SetReservationFilters(reservationEntry);
                    Message('%1', reservationEntry.Count);
                end;

            }

However, no reservation lines are created. What is the correct way to add item tracking to a purchase order using the webservice? What code units and functions should I use?

If I want to also correctly implement this for Sales Orders, what are the important differences in my code?

Community site session details

Add item tracking to purchase order via webservice

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates