DMT GRNI Clearing

Hello, Is anyone using DMT to clear GRNI? Would you like to share the process? We have thousands of lines to clear.

It should be a DMT to import AP Invoices. Path would be Financial, AP invoices combined. Make sure to add the linetype on the ApInvDtl with the proper code :

How do you find the proper code ?
Make a manual invoice with one line of type GRNI clearing, see what you have on APINvDtl (BAQ/SQL) and use same code here.

There is actually no process of DMT-ing GRNI clearing, normally you enter / import AP invoices which link to PO Receipts and the GRNI gets cleared automatically.

Hi MihaiDorin,

Thank you for the suggestion. I tried using AP invoice combined using an InvoiceNum TEST123, but I got an error message saying InvoiceNum =TEST123 APInvHed recod not found. Any idea why.

Hi MihaiDorin, Forget my previous silly question, I didn’t click add new in the DMT menu.
Now I have another error message saying: Invalid Uninvoiced Receipt. I saw the AP invoice got created, but the line did not get selected.

Some DMTs are a bit crazy in a sense that you need to run them twice :
first to create the invoice and save it and second run same data (with create and update) to add the lines which failed to be added since there was no invoice to be added in the first place.

Thanks a lot @MihaiDorin I have tried so many times with different possibilities. but still not working. If you have a template, is it possible to share?

Otherwise, I will probably try with an Epicor consultant.