HI,
We have posted one SALES RECEIPT BATCH wich is containng around 60 transactions,but most of them are not reached in BANK DEPOSIT...!!! I think Payment Document Management was Enable for that user.Now, How to rectifiy this issue...Is there any way to flush the posted SALES RECEIPTS transaction to Bank deposit??
And How to disable payment management documane PERMANENTLY?
Some body please Help me.
*This post is locked for comments
Understood. At some stage the AA setting must have been ticked, and then unticked again. While it was ticked (I suspect) those cash receipts were posted.
The only issue is that you will have individual cash receipts in your checkbook, while maybe a single deposit on your physical bank statement?
The Bank should still reconcile - although you may have to do some arithmatic to figure out which cash receipts to match against the deposits on your bank statement.
Do you really want to go through the hassle of correcting this? Its a once off, the bank wil still reconcile.
If you do - I would recommend using standard GP to correct. I.e. Void the receipts and re-enter them, and then deposit them.
Hope this helps,
Ian.
Mr lan stewart ,
Thank you very much for your reply..
But that AA settings are disabled for this company.I mean it is unchecked... ANy way how to rectify those50 transaction? Actually Increase bank transaction will make double the value..! Or need to void all...?
If any modification from SQL can be done?
Ok. Within AA there is a setting that allows Cash Receipts o be deposited immediately to the Checkbook ID. I.e. you can instruct GP to skip the Deposit stage. It is likely that this setting has been checked in the AA set up. This would explain why when you oposted the cash receipts, they hit the Checkbook immediately and were not waiting to be deposited manually.
Ian.
yes
Do you have Analytical Accounting installed?
Dear Lan Stewart,
Thak you very much for your reply..The problem is Those posted batch sales receipts are directly hit to Bank account.They did not reached in Bank deposit window...
You could create a 'deposit without receipts' transaction. Create a deposit for the sum of the 50 transactions (or create a number of deposits corresponding to how they appear on your bank statement). This will allow you to reconcile your Checkbook in GP.
Your GL is correct? Seems to be from what you are saying above. So its just a matter of reconciling your Checkbook.
I echo Richard above - are you 100% sure that when you open the Bank Deposits window, there are no undeposited receipts for this Checkbook ID?
thanks a lot ..let me try this...
You could start with the Cm20200 table but it is not advisable to do back-end entries. I would first try this in a test company before doing it in production. Always make a backup first. In the test company do an entry that is of the same type and then go into SQL look at this table and see all the other values on the record. Then insert new records changing dollar amounts and trx num etc.
Mr. Richard Wheeler,
Thank you so much.... for your responses... but i have a question..
Is there any way to rectify this problem by editing manually on SQL tables? Whih tables are involved this ?
Thankyou..
Please hel me agaiin
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (