cancel
Showing results for 
Search instead for 
Did you mean: 

Associate Payment with existing Invoice

Former Member
0 Kudos

I have followed the steps in filling out the templates to associate payments with existing invoices. I have the Payments, Payments_Checks, and Payments_Invoices templates completed. I continue to receive an error indicating Invalid document number RCT2.DocEntry... I have even imported a new invoice successfully with a unique DocEntry number and attempted to match the payment to that. I still continue to receive the same error.

Is there any place that I can confirm the DocEntry for an invoice within SAP?

Could someone confirm that RCT2 relates to the Payments_Invoices template?

Any additional insight would be greatly appreciated.

Edited by: Andrew sherwood on Aug 13, 2008 3:35 PM

Edited by: Andrew sherwood on Aug 13, 2008 3:36 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Andrew,

I can assume you are referring DTW template to upload, right?

RCT2 is indeed relates to the Incoming Payments - Invoices. Field Docentry in RCT2 is linked to DocEntry in OINV.

Have you been trying to upload incoming payments?

Thanks,

Gordon

Former Member
0 Kudos

That is correct, the DTW templates.

Also correct that I have been attempting to import the incoming payments. I have imported fresh sample invoices with unique DocEntry numbers, and I am still not able to have the incoming payments tied to those invoices due the error message received above.

Former Member
0 Kudos

Could you post sample data from your Payments_Invoices template?

Thanks,

Former Member
0 Kudos

RecordKey LineNum AppliedFC DiscountPercent DocEntry DocLine InstallmentId InvoiceType SumApplied

1 x x x 9999 x x x 318

The x's are blank cells in my import file.

Former Member
0 Kudos

It seems 9999 is the Invoice number you created. To confirm it, you can run query by

select t0.docentry, t0.docnum from oinv t0 
where t0.docentry like '9999%' 
or t0.docnum like '9999%' 

Also try only left RecordKey, LineNum, DocEntry and SumApplied in the template to reduce additional potential errors.

former_member583013
Active Contributor
0 Kudos

Andrew,

Please take a look at this thread where this has been discussed

Suda