Importing Invoices (A/R) Through DTW

[Former Member]

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

[Former Member · Accepted solution]

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

[former_member583013]

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