Recent content by PETEHO

I have the following code but I can't get it to give me individual sums for debits and credits for each journal. I just want a list of journals names with their debit and credit values as one summed value which should match to each other in theory but our journals can be 20000 lines long. Code...

Problem solved, schoolboy error, normaly use 2 screens but had one switched off.

I Open Section expert and then press the formula button, it goes to open the pop up formula box but I just cant see it. I have tried everything. Its obviously open as I can not do anything else on screen until pressing escape and I am then back in section expert. I used this last week but...

use RC001 declare @line_amount integer set @line_amount = null select top 10 * from rec_items where (ABS(line_amount) like convert(int,isnull(@line_amount,'%'))) and rec_id = 'HWK1004' The column itself only contains numbers and is always populated however im using the code to build a report...

Just as an ODBC query from excel

I have the following code but I can not get the reults to populate Excel even though they return results in query editor. Its a slow query but should't cause a problem declare @dbs table (db varchar(20)) insert into @dbs select upper(wdname) from csmaster.scheme.workdirm where dgroup = 'sys'...

I want to sum journalamt but using the part field in the group by satement but it will only let me use the posting_code field I know its probably simple but I don't write SQL SELECT journal_number, Left(posting_code,2) as part, SUM(journal_amount) as journalamt FROM...

Thanks fopr your reply. I had astarted along that path, however I have something slightly amiss.I am getting and Invalid relationship operator for the following. Sum(case when Mi Suspense Analysis V\Debit Credit Ind = 'CR' then Mi Suspense Analysis V\Suspense Amt *-1 else Mi Suspense Analysis...

I have two fields in a Universe.I need to show the value of these value field as a Debit or credit. These are running against oracle databases My field indicator is either DR or CR. I would imagine the select statment in the universe to be SUM(amount) * -1 where DRCR indicator like 'CR' else...

I am getting the above error when writing some code(Not a single-group group function) select '01 Arrears' as arrears,a.agreement_type as Agreement_type,a.agreement_status as agreement_status ,count(*) as count,a.prb_number as prb_number,a.prb_fund_type as fund_type, sum(a.wkprem *...

I have some users who use a VFP routine. We had a power cut and when they try to access their routines they get the message file access denied. How can I unlock these tables. I do not use vfp but I can usually get by Thanks

Thanks for that info I will have a go. I don't have the software discs to load SDK. Its the world of cost cutting. We are merging two compnies accounts accross from GP to Sage. We have 100 companies on Sage and two on GP. Sage won hands down as it needs doing by July 1st Thanks Pete

I have been tasked with migrating data from a Great Plains Database to a Sage Database. I am only moving general ledger data. I was wondering if anyone had a copy or knew where I could find a diagram of how the data is linked within the GL tables. I seem to get so far then it all goes pear...

I have created a Universe based on a single excel worksheet with 70 columns, nothing fantastic. I created the universe and inserted table,all 70 column headings are shown. to check it was reading this correctly I did a count of Rows and got the following error 'Syntax error in From Clause' If...

I am trying to run the following bcp union query. I have two queries on two tables that I am trying to join the output for. Individually they work but it doesn't like the UNION command. Any Ideas would be helpful @bcp "select 'SL613'...