Gross Profit per line item by DTW

[johnson_paily]

Hi Experts,

Do you know if we are able to specify the GP or cost value on the lines of an invoice imported by DTW? For example, we will import an invoice with 2 lines, the cost of the items on the system is 0 but I want to import a GP of 30 for item 1 and 25 for item 2. Basically the same as entering a manual base price on the GP screen on the invoice (Ctrl+G) . Can this be done using DTW ? If so which are the templates and fields ?

Thanks

regards

Johnson

Edited by: Johnson Paily on Jul 27, 2010 3:13 PM

[Former Member · Accepted solution]

Hi Johnson,

If it can be done, the template would be Document_lines under oInvoice folder together with Documents. However, there is no such field could be found in the template.

Thanks,

Gordon

[johnson_paily · Accepted solution]

Thanks Gordon for your comments, It never worked. I believe there will not be a field in DTW which can populate this.

regards

Johnon

[Former Member]

Hi Johnson.......

Which Version and Patch Level you are using?

Regards,

Rahul

[johnson_paily]

Hi Rahul,

8.8 or 2007 the latest patch. I can try both. The client right now needs in 2007 and later on maybe 8.8

Will it work ?

Thanks for your update

Cheers

Johnson