Relation between Sales Quote and Sales Order

selece28

Hi all,
I have a problems
My client want me to show which Sales Order is created from Sales Quote
When we open Sales Quote form and click Make Order
The sales quote record in Sales Header table is replaced with Sales Order record right?
Then how can i know which Sales Order is created from Sales Quote?
I can only think of adding a new column in sales header to keep Sales Quote number.

Is there any other way? Am i missing something?

Thanks in advance

Albertvh

I think that you would have to add the extra field to the sales header
table but also remember to add this field to the posted sales tables
ie Shipment and Invoice


Albert

themave

There is a field in the sales header table, called Customer Quote No., I believe it would be used if you were using commerce server, so if you are not, then I would use that field, as it already exist, and will provide what you need without adding new fields to serveral tables. You would have to modify the qoute to order function to copy the quote number.

lakshmivalluru

USE "Customer Quote No." field. when u create a sales quote, populate "Customer Quote No." as well, then when u create an order it tansfer to order.

Alex_Chow

You'll need to modify codeunit 86 in order to do this.

Waldo

If you want to 'save' the Sales Quote, I would try to use the Sales Archive.

themave

Sorry, I didn't get this early, but I just remembered, the sales quote number carries over to the sale order line, in the field Sales Order No.

this also carries over to the sale invoice line when it is invoiced

so the info isn't in the header but it is on the sales line. all the way through to the sale invoice line

Mbad

Never use standard fields for something they arent meant to be used for.

selece28

Yes Thanks, this mean that the best way is to add a new field and customize codeunit 86

If you want to 'save' the Sales Quote, I would try to use the Sales Archive.

Waldo what do you mean by this. Can i keep the old Sales Quote that has been made to Sales Order? How?

Thanks in advance

Waldo

By using Sales Archive.
This sales archive is automatically filled when printing the quote and using CRM. In this report, you find the code to "copy" the records to the sales archive.

Something like:
ArchiveManagement.StoreSalesDocument("Sales Header",FALSE)