Skip to main content
Business Central forum
Suggested answer

INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

editSubscribe (0) ShareShare
ReportReport
Posted on by

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

Categories:
Attachments
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    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 Profile Picture
    InaB on at
    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 Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    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 Profile Picture
    InaB on at
    RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

    Is your vendor set up with a payment method code?

  • InaB Profile Picture
    InaB on at
    RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

    The "on hold" field is blank

    pastedimage1660227290693v1.png

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    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 Profile Picture
    InaB on at
    RE: INVOICES NOT PULLING THROUGH TO PAYMENT JOURNAL

    Here is where I select the invoice and create the payment

    pastedimage1660225299652v1.png

    Here is the filter to select the batches:

    pastedimage1660225341902v2.png

    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 Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    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?

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,080 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,601 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans