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

All responses (9)

Answers (0)

Suggested answer

Inge M. Bruvik 999 Moderator on at

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

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.
InaB on at

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

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 :-)
Suggested answer

Inge M. Bruvik 999 Moderator on at

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

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?
InaB on at

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

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

Inge M. Bruvik 999 Moderator on at

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

Is your vendor set up with a payment method code?
InaB on at

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

The "on hold" field is blank
Suggested answer

Inge M. Bruvik 999 Moderator on at

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

Looks pretty clean to me.

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

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

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.
Suggested answer

Inge M. Bruvik 999 Moderator on at

Like (0)

Report

RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

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?