Share
Reportmy historical cashbook has missing periods and some cashbooks have misplaced or wrong periods.i.e start and last months showing wrong range
*This post is locked for comments
You’re offline. This is a read only version of the page.
my historical cashbook has missing periods and some cashbooks have misplaced or wrong periods.i.e start and last months showing wrong range
*This post is locked for comments
Hi Santiago,
Thanks for the advice; I recommend that you either raise this issue with your partner or log a support request with Microsoft. It sounds like there is data damage in your installation that requires further investigation.
Regards
Rob
Hi Rob,
Thanks for your prompt response. i get this when i go to Reports - Financial - Bank Management - Historical Cashbook. this happen to about 3 of my cashbooks.
Hi Santiago,
Thanks for the question; do you find this happening in the Cashbook Transaction Enquiry/Void window? If so I suggest that we recreate the CB900035 table; this table holds all transactions that are in this window and takes it's data from the CP200001 (Open) and CB400005 (History) tables.
To recreate the data in this table please do the following after making a backup:
1 - Run this script against the company database to clear the CB900035 table:
Delete CB900035
2 - Next log into GP and go to Enquiry - Financial - Bank Management - Transaction Enquiry/Void.
3 - Enter a chequebook ID, year and period; no information will appear in the window.
4 - To recreate the data in the window select the Upgrade from Recon button. This will insert the data back into the CB900035 table and now populate the view.
You need to repeat this step for each chequebook that you have. After that can you please check to see if the missing information is now there.
If this does not fix the problem for you or the data issue is not affecting this enquiry window I suggest that you raise this with your partner or log a support incident with us.
Regards
Rob
#1
Almas Mahfooz
3
User Group Leader
All responses (
Answers (
