Incoming Cash Payments

[Former Member]

Hi Experts,

Iam importing Incoming Cash Payments with following format in .CSV

RecordKey CardCode DocDate DocTypte CashAccount CashSum

1,C00001, 20090206, rCustomer,161000,100

Here 161000 is the Cash G/L Ac .

But The System throws an Error

No Matching Records Found (ODBC-2028)

The Same Entry is successfully added from frontend with no issue and all the G/L determinations are aslo complete .

I have no clue where is the issue.

Plz help me with ur kind suggestions.

[former_member583013 · Accepted solution]

Query OACT table and check what your AccountCode is?

SELECT AcctCode, AcctName FROM OACT

[Former Member]

Try delimited text format first. If the problem still, check your account code. For segmentation CoA, the account code is in _SYSxxxxxxxx format.

Thanks,

Gordon

[Former Member]

Pooja,

Make sure you have the setting 'Import New Object' set in Step 4 of DTW.