Small and medium business | Business Central, N...

INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

(0) Share

Report

Posted on by InaB

Hi,

I am trying to create a payment journal based on invoices that I am selecting from my list of outstanding invoices. However, the invoices refuse to pull through to the journal. After I select my relevant batch and posting date, the journal that opens is empty. I am able to pull these invoices in manually on the journal lines, but using the method of selecting from the list of outstanding invoices does not want to work! I have checked and these invoices are not being used in any other journals.

Any ideas? I do not want to load everything manually, as there are multiple invoices and it would just take too long to load them all seperately. We are on D365 Business Central version 20.4

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

There must be something in you data that makes those invoices being out of scope when the data in the procedure is filtered.

Can you show a screenshot of the request page you use when you try to create the journal lines?

Was this reply helpful? Yes No
InaB on at

Like (0)

Report

Here is where I select the invoice and create the payment

Here is the filter to select the batches:

This worked perfectly up to now, and it is not on all invoices. I have managed to select other invoices in exactly the same way with exactly the same Create Payment criteria, and they pulled through.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Looks pretty clean to me.

Have you checked that you have nothing in the on hold field on the invoices ?

Was this reply helpful? Yes No
InaB on at

Like (0)

Report

The "on hold" field is blank

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Is your vendor set up with a payment method code?

Was this reply helpful? Yes No
InaB on at

Like (0)

Report

Yes, all the vendors have the same payment method code.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Very strange.

I was trying to looking at the code and really only found those two thing that should cause the invoice not to be pulled through.

But i looked for the code in my region, the code can be localized in your region.

What country specific version are you using?

Was this reply helpful? Yes No
InaB on at

Like (0)

Report

On a side note - I copied our production environment to a sandbox testing environment and there the invoices pull through just fine! No problem. I am a little mystified :-)

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

You have every reason to be :-)

Maybe there is someone holding a lock on something in your prod env?

I would check the database lock page and possible look at active sessions in the admin center to see if something suspicious shows up there.

Was this reply helpful? Yes No