Adding Contacts to OCPR using DTW

[JeffWill]

I am trying to ADD contacts to the OCPR table. I have code that gets the LineNum I need to insert a new contact in the table. Instead of creating a new contact it is overwriting an existing contact which is not what I want.

In the example below there are 8 existing contacts for the BP so with the LineNum starting at 0 the LineNum I am using in the DTW template is 8 (see attached).

Query:

select COUNT(cardcode) As Newline, CardCode

from ocpr

where CardCode = '802399'

group by cardcode

Results:

Newline CardCode

8 802399

What am I missing or doing wrong??

Thank you, Jeff

[ANKIT_CHAUHAN · Accepted solution]

Hi jeff.will,

Kindly refer to SAP KBA 3362774 for the same.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[JeffWill · Accepted solution]

I have seen this and am using the query to get the LineNum but it still isn't working. I am going to open a ticket with SAP and have them look at it with me.

Thank you very much.

[JeffWill]

It turns out I have to use the full OCPR import template, not an abbreviated one I was trying to use.