Enter serial no. through code

new_to_cal

Hi folks,

I would like to enter given serial numbers for a purchase order through code. Could anybody tell me, how this is done?

vijay_g

Then insert the reservation entry by code with required field detail. You can also search the forum for same.

Alex_Chow

I believe ara3n posted some code on here that works wonderfully. Search!

ara3n

Here is an example

SalesLine.get(SalesLine."Document type"::Order,'1532',20000);
SalesHeader.get(SalesHeader."Document type"::Order,'1532');

CreateReservEntry.SetDates(
  0D, 0D);

CreateReservEntry.CreateReservEntryFor(
  DATABASE::"Sales Line",
  SalesLine."Document type",
  SalesLine."document No.",
  '',
  0,
  SalesLine."Line No.",
  SalesLine."Qty. per Unit of Measure",
  1,
  'YOURSERIALNO',
  '');

CreateReservEntry.CreateEntry(
  SalesLine."No.",
  SalesLine."Variant Code",
  SalesLine."Location Code",
  SalesLine.Description,
  SalesHeader."Posting date",
  SalesHeader."Document Date",
  0,
  2);

ara3n

CreateReservEntry is cu Create Reserv. Entry

new_to_cal

Amongst others I found this post. The Code

CreateReservEntry.SetDates(
  0D, 0D);

CreateReservEntry.CreateReservEntryFor(
  DATABASE::"Sales Line",
  SalesLine."Document Type",
  SalesLine."Document No.",
  '',
  0,
  SalesLine."Line No.",
  SalesLine."Qty. per Unit of Measure",
  ABS(SalesLine.Quantity),
  'RANDOMSNR',
  '');

CreateReservEntry.CreateEntry(
  SalesLine."No.",
  '',
  SalesLine."Location Code",
  SalesLine.Description,
  0D,
  SalesLine."Shipment Date",
  0,
  3);

does create a reservation entry with the correct serial no. but the reservation status is Prospect instead of Reservation. Is that correct?

gerrykistler

It should be Surplus. If you manually create a Purchase Order for a Serial Tracked item and manually create the tracking line - you can then go to the Reservation Entry table and see how the reservation entry should be populated.

new_to_cal

gerrykistler wrote:

It should be Surplus. If you manually create a Purchase Order for a Serial Tracked item and manually create the tracking line - you can then go to the Reservation Entry table and see how the reservation entry should be populated.

I don't want to be seen near a Purchase Order :P
I was talking about Sales Orders!

Luc_VanDyck

new_to_cal wrote:

I was talking about Sales Orders!

Reread your first posting.

gerrykistler

new_to_cal wrote:

gerrykistler wrote:

It should be Surplus. If you manually create a Purchase Order for a Serial Tracked item and manually create the tracking line - you can then go to the Reservation Entry table and see how the reservation entry should be populated.

I don't want to be seen near a Purchase Order :P
I was talking about Sales Orders!

It is the same for Sales Orders as it is for Purchase Orders - the only difference is the sign on the quantity. Just take my response above and replace Purchase with Sales.

vijay_g

gerrykistler wrote:

It is the same for Sales Orders as it is for Purchase Orders - the only difference is the sign on the quantity. Just take my response above and replace Purchase with Sales.

what about "Source type" and Positive field? both are also differ for sale/purchase.

dans

vijay_g wrote:

what about "Source type" and Positive field? both are also differ for sale/purchase.

there should be no problem. the codeunit will handle it.

ara3n

new_to_cal wrote:

Amongst others I found this post. The Code

CreateReservEntry.SetDates(
  0D, 0D);

CreateReservEntry.CreateReservEntryFor(
  DATABASE::"Sales Line",
  SalesLine."Document Type",
  SalesLine."Document No.",
  '',
  0,
  SalesLine."Line No.",
  SalesLine."Qty. per Unit of Measure",
  ABS(SalesLine.Quantity),
  'RANDOMSNR',
  '');

CreateReservEntry.CreateEntry(
  SalesLine."No.",
  '',
  SalesLine."Location Code",
  SalesLine.Description,
  0D,
  SalesLine."Shipment Date",
  0,
  3);

does create a reservation entry with the correct serial no. but the reservation status is Prospect instead of Reservation. Is that correct?

Yes. try and insert through ui manually and then compare the records

new_to_cal

Luc Van Dyck wrote:

Reread your first posting.

Aaw crap. That's what you get from trying to do multitasking :roll:

Nevertheless - Thanks @all for the support.