Sage 100

Back to that unposted thing I was asking about - so, those of you who know Excel a whole lot more than me (which is everyone) - would it be possible to have one column on a sheet be the standard financial stuff, then one column from the General Journal Entry files, then a third column of adding them together? (Then you would hide the first two.) Could you link the GL accounts?

I'm no expert either but a vLookup might work.

I can think of several ways to do this so I will post them individually as I can: With BizInsights, you have a function to pull Net Unposted Balances. I'm am pretty sure this is limited to unposted journal entries and will not include allocation entries or recurring entries.

Option #2 is in line with Therese. Pull your Unposted Balance data from GL_GeneralJouralDetail and GL_TransactionJournalDetail into two workstation. Then pull sums of each from the detail via the Sumif function and use the VLookup from the resultset.

Options #3, use Access with PTQ's to pull and summarize the data from both General Journal and Transaction Journal with a union query and pull that data into Excel. If you are using the Premium edition, you can use a view in MS SQL instead and just pull form the view.