Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

2

Delivery date on Sales Order ?

By
Jan Pompe
on 5/10/13, 2:13 PM 5,161 views

Hi,

How to place the delivery date on the sales order report, and what's the code to place in the sxw file?

Do I have to use [[stock_move.date]] or...?

thanks in advance. Jan

2
Michael Bos
On 5/29/13, 5:01 PM

First Solution:

There are 2 options for this, as I found out.

You need to have the module sale_order_dates installed (basic module)

With the Openoffice Writer Plugin you can edit and create sales order documents to be printed.
(To do this follow instructions in OpenERP after installing it through Applications).

After Creating a Copy of your Original SO, you can edit it through OpenOffice Writer.

One option is setting it for the entire Sales order(3a), the other is per product line(3b).

  1. When in editor mode press the "Convert Brackets to Fields" button in the openerp toolbar.
  2. Then add "Delivery date" as tekst followed with "Add Field" (Place this accordingly to option 3a or 3b wherever you like)
  3. a. o(Sales order) And Choose Commitment Date

    b. line (Sales order line) and choos Order Reference/ Commitment Date

  4. Save and user the plugin to send the report to the server

Hope this helps you.

Second Solution is added a custom field and a custom view and then adding this custom field to the report.

  1. Make sure you are logged in as the Administrator account or an account with the same rights.
  2. Go to Settings -> Database Structure -> Model
  3. Search for Sale.order
  4. Add custom Field to Sales order by clicking on the "Edit" button, then scrolling down and click on the link "Add Item"
  5. Give it the name you want ( e.g. x_scheduled_date). All custom fields start with x_
  6. Fieldlabel is how you want it to show up on your custom view.
  7. Then under heading "Properties" choose "date" as Field Type
  8. Then Press Save. Your custom field is now created.
  9. Now go to Settings -> User Interface -> Views and search for sale.order.form
  10. Then after you press edit, you can position the date where ever you want by pasting this :
    <field name="x_scheduled_date"/> and then saving it.
  11. Then you can use the same steps as in the First Solutions, only now you add the field x_"field name given in step 5)

If you have any more questions, please let me know and I will try to answer them!

0
Luis Felipe
On 5/13/13, 1:39 AM

bazaar.launchpad.net/~openerp/openobject-addons/7.0/files/head:/sale_order_dates/

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 5/10/13, 2:13 PM
Seen: 5161 times
Last updated: 3/16/15, 8:10 AM