RE: Problem with Select Payable Checks
After extensive testing and research, I have determined the following:
Dynamics GP will not allow checks to be printed for a vendor that has an open invoice with an EFT remit-to. The accepted practice is to process the EFT batch first and then the check batch.
The Select Checks process works as follows:
1. Create a temporary table
2. Insert all Vendors that have open invoices and match the restriction criteria specified on the Select Payable Checks window, such as Due Date.
3. If the batch is a check batch, remove all Vendors from the temp table that have a Vendor Id and Address Id that matches the open invoices (respecting the restrictions) and an entry in the EFT table.
4. If the batch is an EFT batch, remove all Vendors from the temp table that don’t have a Vendor Id and Address Id that matches the open invoices (respecting the restrictions) and an entry in the EFT table.
We are using Multi-Entity Management and can have one company paying by check and one by EFT. Thus, processing EFT and then checks is not realistic. MEM relies on the stock GP stored procedure to choose vendors as described above. We have approached MEM with this problem and they have basically punted and stated that they try to modify as little of GP code as possible.
Our current solution has been to modify the GP stored procedure that handles the vendor list creation to make it MEM aware. Thus, payments from one company do not affect those from another. Within a company, EFT payments must still be processed first if the unlikely scenario of having a check and EFT payment for the same vendor in the same batch exists.
Share
Report
45
All responses (
Answers (
