Duplicate invoice numbers - 3rd party AP software - import into D365

(0) Share

Report

Posted on by lmai

2,438

Hi All,

We need to import invoice transactions from the 3rd Party AP software into D365. There are 3 lines in 1 invoice. 1 line is shipping, the other line is tax. So we have to import the 3 lines into D365 as they are.

We want the Reject duplicate. We also don't want to put -1, -2, -3 at the end of each invoice number to differentiate them (screenshot 3) because we want to export them back into the 3rd Party AP software after the invoice is paid in D365. So, after we paid the invoice in D365, we have to sync this info back to the 3rd Party AP software to update the payment. So, we need to keep the original invoice # to allow sync back. Has anyone dealt with this issue before? How do you post these 3 lines of the same invoice number in D365 without Reject duplicate and without putting any dash or dot to the invoice number? I appreciate all feedback.

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

RE: Duplicate invoice numbers - 3rd party AP software - import into D365

Hello Kim,

Can you not keep the voucher number same for one invoice with multiple line, system should allow multiple lines with same invoice if the voucher is same for all lines.

What exactly the error you are getting?

Was this reply helpful? Yes No
lmai 2,438 on at

Like (0)

Report

RE: Duplicate invoice numbers - 3rd party AP software - import into D365

Thanks, Ramit, for your response.

I got the error, "There can be only one vendor transaction per voucher". Here is the voucher.

Let me know if you see something. Thanks

Was this reply helpful? Yes No
Verified answer

saurabh bharti 15,039 Moderator on at

Like (1)

Report

RE: Duplicate invoice numbers - 3rd party AP software - import into D365

You can post entry in following way :

Invoice Total =1500, Tax =500, Expense-1 =700, Expense -2 =300, Invoice number= XZW

Entry can be:

Do not use offset account type or offset account, Create entry using multiple line for same voucher

Line Voucher Account type Account Invoice Debit Credit

1 V1 Vendor ABC XZW 1500

2 V1 Ledger Tax XZW 500

3 V1 Ledger Exp-1 XZW 700

4 V1 Ledger Exp-2 XZW 300

Was this reply helpful? Yes No
lmai 2,438 on at

Like (0)

Report

RE: Duplicate invoice numbers - 3rd party AP software - import into D365

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

RE: Duplicate invoice numbers - 3rd party AP software - import into D365

Hello Kim,

Can you check your AP setup->> ap parameter->> posting profile has some profile added?

Can you also check the vendor you are using that is falling under any correct ledger account as per your posting profile setup.

Was this reply helpful? Yes No
lmai 2,438 on at

Like (1)

Report

RE: Duplicate invoice numbers - 3rd party AP software - import into D365

Thank you so much, Saurabh. That works!

Was this reply helpful? Yes No