Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Brad Slagowski]

We’ve had several invoices on our select checks that are being held for payment until we are paid by our customer. The new person did not completely unselect several invoices for payment and printed checks for these invoices. The invoices are in prior periods (i.e. January 2018 and February 2018). I voided the checks and the invoices reappeared in the vendor lookup as open invoices. We got paid by our customer, but when building a batch the open invoices will not show on the select check screen.

I tried opening the prior periods to see if that would help. It did not. I called our old A/P person and she said that we would have to void the invoices and reenter them. We did this but we had to keep the prior period dates on the invoices so as to not screw up our financials in those periods. When building a batch, the new invoices will not show on the select checks screen. I have attached a screen shot of the vendor transaction history that shows the voided invoices and the new invoices with an open status. Any suggestions?

——————————
Brad Slagowski
UELS, LLC
Vernal UT
——————————

[Shari Bruno]

?Hi

What is the criteria that is being used when you build the select checks batch? Also, what criteria is being used on the Select Payables Checks screen??

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————
——————————————-

[Brad Slagowski]

I have used many different criteria. The last I tried was to change the apply date to the date of one of the missing invoices, and to select only the specific vendor of the invoices involved. Nothing I do brings the open invoices into the batch when I build it and is unavailable to chose when you select edit check batch.

——————————
Brad Slagowski
UELS, LLC
Vernal UT
——————————
——————————————-

[Shari Bruno]

?If the apply date is in a closed period it won’t build the batch. But you can put any date when posting the vendor transaction as long as the Batch date is in an open period.

Is the Posting and Check Date on the Select Payables Checks batch the same as your GP system date? If not, are those dates in a closed period?

——————————
Shari Bruno
Accounting Operations Manager
Bible League International
Crete, IL
——————————
——————————————-

[Jo deRuiter]

?Hi

I would start with running reconcile in AP.  If that does not work, you may want to try Check Links on the Payables Open and History Transactions.

Make sure you get a backup before running these processes and make sure no one is entering AP or PO’s while you are doing this.

To Run Reconcile:

To Run Check Links:

I would also suggest that you may want to check with your GP Partner before performing these actions because if you may have something setup in your system that one or both of these processes could break.

?

——————————
Kindest Regards,

Jo deRuiter
“That GP Red Head”
Senior Financial Systems Consultant
Advanced Credentialed Professional-Dynamics GP
Heartland Business Systems, LLC
Milwaukee, WI
770-906-4504 (Cell)
——————————
——————————————-

[Renata Roles]

Have you checked to see if the invoices were put on hold? If they were put on hold they will not show up as available.

Purchasing>>Holds>>Hold Payables Transactions

——————————
Renata Roles
Controller
McCain, Inc.
Vista CA
——————————
——————————————-