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

Importing Invoices (A/R) Through DTW

Dear All,

We need to upload Invoices (A/R inovice in that fields like discount , amount , customer, item no , item name, serial no. )

Some one has suggested us to do this by defining Service type invoice and Use UDF's to upload Item name , no, serial no and amount.

As we have never work on this pls do suggested the procedure to follow which are the mandatory fields in templates , what tax codes , what is G/L account (in case of service invoice its reqd.)

and in document lines what are the mandatory fieds.

Regards.

Satish

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 Jul 25, 2008 at 09:02 AM

    Hi Satish

    Besides the example template files that SAP supplies, you can also have a look under SDK > Help in you SAP installation folder for a file called REFDI.CHM. Open this file and under contents expand the Objects section. Here you will find all the DI API objects that the DTW also uses (template files). When you click on an object such as Documents you will see a section on the right hand window at the bottom called See Also. Click on the member list to get a list of all the fields. Here you will find details on what the object member's name is and the SAP Business One field name as well as which are mandatory, read only, etc.

    You will need to look at Documents, Document_Lines and under Document_Lines you will find a member called SerialNumbers.

    Hope this helps

    Kind regards

    Peter Juby

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2008 at 03:33 PM

    Hello Satish,

    Couple of things to be considered before deciding on the type of Invoice to be used?

    Are these Open Invoices from a legacy system? Which also means Inventory was already reduced for these invoices?

    ...............If this is the case then then importing them as a Service Invoice is correct

    Please throw more light on the scenario.

    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.