Special Orders Received Shipped on wrong Sales Order

SarahSoltec wrote:

I may be missing something but had understood the idea of the special order was that when that item came in on the Purchase Order it didnt go into Inventory and was only available to be sold on the linked Special Sales Order.

If the item doesn't go into inventory when you receive it then where do you think it's supposed to go?

I dont use RTC but we do use Special Orders & Req Worksheets everyday. I have never seen it update the sales order by itself. In fact I created a report called "Update Special Order Sales Lines" which I have added to one of the Functions->menu items on the po form.

ONPush of the menu item it calls the report already filling the Document type & Document No of the po.
The report has two dataitems Purchase Line with Sales Line indented.

ON the salesline dataitem
OnAfterGetRecord()
//Get the Matching Po & Sales Line
if Purchline.GET("Document Type","Special Order Purchase No.","Special Order Purch. Line No.")
then begin
Salesline.Quantity := Purchline.Quantity / Salesline."Qty. per Unit of Measure";

//Copy Descriptions
Salesline.Description := Purchline.Description;
Salesline."Description 2" := Purchline."Description 2";

//Validate & Modify
Salesline.VALIDATE(Quantity);
Salesline.MODIFY;
end;
**We have it do other things too like update the sales header with info n such - but I edited it down.
So basically what we do it when one of these "special order" po's is received we then run the "Update sales line" report. We have many mods on our sales lines so perhaps it does it automatically in unmodified nav versions, but I haven't seen it myself.

Ahh, On the item card what do you have the "Reserve Field" maked as Never, Optional Or ALWAYS?

When you enter the item on a journal or requisition line, the contents of this field will be copied to the Reserve field on the line.

When you enter the item on a sales line, the contents of this field, in combination with the contents of the Reserve field on the sales header, determine the contents of the Reserve field on sales lines in the document. The reserve option on the item card will be copied to the line (thereby overriding the reserve option from the customer card) except in one case: if you select Optional in this field and you enter the item on a document where the Reserve field in the sales header contains Always, the sales line will be assigned the option Always.

We don't use the reserve option either - our's is set to optional but that post above is from the F1 help on the field Reserve so I can only assume if you set it as stated above it will do what you are looking for. We use the report because we need other things to happen like updating sales headers and updating at specific times of the day. So we have more control.

But It's Your call.