Page 1 of 1

A/P check batch with incorrect posting month

Posted: Thu Apr 20, 2017 11:54 am
by SScheuermann
I have a batch of checks that were posted to the incorrect month. They were posted from A/P to Fund Accounting, but are sitting unposted in Fund Accounting. What can I do other than post in Fund Accounting, then void each one, then re-enter from the beginning?

Re: A/P check batch with incorrect posting month

Posted: Thu Apr 20, 2017 12:07 pm
by NeilZ
SScheuermann wrote:I have a batch of checks that were posted to the incorrect month. They were posted from A/P to Fund Accounting, but are sitting unposted in Fund Accounting. What can I do other than post in Fund Accounting, then void each one, then re-enter from the beginning?
Um ... are they dated incorrectly from the Accounts Payable? Could you explain what you mean by 'posted to incorrect month'? They may have been posted to paid items, but they're not fully posted yet.

Can you be more specific?? Were the checks written in April, but you still have March open in Funds Accounting??

Re: A/P check batch with incorrect posting month

Posted: Thu Apr 20, 2017 1:27 pm
by SScheuermann
The checks are fine. The date is correct. They are April checks that the system posted to March by default. The only thing wrong is the month which the system is posting them. So yes, they were written in April, but March was still set as the working month and I did not notice until after posting them out of A/P to Fund Accounting. They are still in Fund Accounting waiting to be fixed or deleted or posted.

In "Modify Unposted Transactions" under Fund Accounting I tried to change just the posting month, but I get the message, "Warning, this entry originally came from the A/P module any changes made in FA will not effect the original entry in the A/P module."

Re: A/P check batch with incorrect posting month

Posted: Thu Apr 20, 2017 2:40 pm
by NeilZ
SScheuermann wrote:The checks are fine. The date is correct. They are April checks that the system posted to March by default. The only thing wrong is the month which the system is posting them. So yes, they were written in April, but March was still set as the working month and I did not notice until after posting them out of A/P to Fund Accounting. They are still in Fund Accounting waiting to be fixed or deleted or posted.

In "Modify Unposted Transactions" under Fund Accounting I tried to change just the posting month, but I get the message, "Warning, this entry originally came from the A/P module any changes made in FA will not effect the original entry in the A/P module."
In actuality the only thing posted right now is the update to the Accounts Payable files, nothing is really POSTED to Funds Accounting until you do the Posting to Funds Accounting.

The fix is to change the working month to April, and change the posting month on the transactions to April, you'll get the WARNING message, but just click OK and continue. FWIW .. this usually does not happen if you have the checkbox on the Transaction Date Determines Posting Month checked on the intial Post to Paid Items File .. function. The system 'should' see that the date of the transaction is April, and use April as the posting month.

Re: A/P check batch with incorrect posting month

Posted: Thu Apr 20, 2017 4:48 pm
by SScheuermann
NeilZ wrote: The fix is to change the working month to April, and change the posting month on the transactions to April, you'll get the WARNING message, but just click OK and continue. FWIW .. this usually does not happen if you have the checkbox on the Transaction Date Determines Posting Month checked on the intial Post to Paid Items File .. function. The system 'should' see that the date of the transaction is April, and use April as the posting month.
Thanks Neil, the transactions are now posted to the correct month.

Is the "Transaction Date Determines Posting Month" a feature in V11.1? If so I have not seen it.

Re: A/P check batch with incorrect posting month

Posted: Thu Apr 20, 2017 5:07 pm
by NeilZ
SScheuermann wrote:
NeilZ wrote: The fix is to change the working month to April, and change the posting month on the transactions to April, you'll get the WARNING message, but just click OK and continue. FWIW .. this usually does not happen if you have the checkbox on the Transaction Date Determines Posting Month checked on the intial Post to Paid Items File .. function. The system 'should' see that the date of the transaction is April, and use April as the posting month.
Thanks Neil, the transactions are now posted to the correct month.

Is the "Transaction Date Determines Posting Month" a feature in V11.1? If so I have not seen it.
Urp .. you're right. Just fired up my copy of 11.1 and its a v11.5 feature. Not a bad reason to upgrade :)