Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Missing account number in GL10110 and GL10111 1

Status
Not open for further replies.
SpeedBWild

SpeedBWild

Programmer
Apr 29, 2004
117
US
I am missing actnumbr_1, actnumbr_2 and actnumbr_3 (we do not use actnumbr_4) for some of the posted data in GL10110 and GL10111. What would cause this to happen? When I go into GL00105, I see the actidx and the associated account number. I also see the actidx, account number and actcatnum in GL00100. This seems odd to me, any ideas?
I fixed all the missing data a couple of days ago,but when I took a look at it this mornig, I found 13 more records missing data. I know the data is recent because it is for year1=2004 and period=8 (this year, august). I just can't figure out how it is getting inserted into the tables without account number information.
 
Sort by date Sort by votes
These two tables GL10110 and GL10111 are summary tables and are created when you reconcile. They do not require the actual account strings. They use the Actindx. This I believe is for speed purposes.
 
Upvote 0 Downvote
Ok- but why would it not have account information for only some of the accounts and not all of them?
 
Upvote 0 Downvote
If you manually changed this info it will show. That's why those new records did not have act numbers associated with them, because they were added through the system. That's why I suggest you follow the info in your other thread and delete the GL10110 and GL10111 and reconcile. It will clear this up for you.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

appelq
  • Locked
  • Question
Cash Batch and Bank Fees in Dynamics GP
Replies
0
Views
331
appelq
appelq
kgeorge71
  • Locked
  • Question
Bank Recs not tying to GL in Dynamics Great Plains
Replies
0
Views
408
kgeorge71
kgeorge71
Nisly
  • Locked
  • Question
Deleting purchases from Fixed Assets Purchases in Great Plains
Replies
0
Views
277
Nisly
Nisly
Devanand0311
  • Locked
  • Question
Syntax error in date in query expression 'UCase
Replies
0
Views
257
Devanand0311
Devanand0311
ACCT PDC
  • Locked
  • Question
Switched to DirectDeposit Payroll and now entries not carrying through to bank reconciliation
Replies
1
Views
294
ACCT PDC
ACCT PDC

Part and Inventory Search

Sponsor

Back
Top