Skip to Content
author's profile photo Former Member
Former Member

Import into Sales Orders

I am trying to import into B1 Sales Orders from a third party and am having much difficulty in setting the document number. In order to track and follow up with a Delivery document that would be imported later on from the same third party I have created a special series to which I will import the Sales Orders. It works well in that I can import my data, but I am unable to insert the document number that I would like. The reason why I want to insert the document number is so that i do not have to send a confirmation back to the third party of what number i assigned to the Sales Order.

My question is this, how can I both set the Series (this I can do) and the Document Number in a Sales Order which is being imported through DTW?

Thank you in advance,

Richard.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2008 at 03:35 AM

    OK, so I can now write a Manual number, but can I do the same thing for a special series that I have created? Or if I send it to the series it will always be increamented by the system?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      <font color="#990000

      "size=3 > The setting handwritten = tYES does the magic. If you leave this blank or enter tNO, then the numbering would automatically populate from the Series</font>

      Suda <font size="6" color="red" face="wingdings"> J </font>

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2008 at 02:59 AM

    If you are talking about using DTW, then you can enter the DocNum in the DocNum column in the Document Header template and then enter tYES in the handwritten column.

    Let me know

    Suda

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.