Recent content by hooggie

Against the purchase receipt line table.

I'm using GP 10 and Project Accounting. When I use the lookup by contract number and use the find feature in that window nothing happens. It always takes you to the start of the list regardless of what has been typed into the Search field. Has anyone experienced this and do you know how to...

There is no automatic process for this in GP. I would suggest setting up a report to analyse your discounts so that you can repost to your location codes at the end of the month.

If this is non inventory items you are talking about this is a bug. The manual states that it should be doing what you've described above but it doesn't do it. Microsoft deny that it should be doing this despite what the manual says. I've got round this by writing my own trigger to correct this.

No it doesn't do it and no it doesn't do it in 9 and perhaps you should be upgrading to 10?

Are you running the historical aged tb? if so, this could be related to how the opening data was bought in. If you stuffed it into the tables and didn't fill in the necessary apply information then the historical TB's wont work. Otherwise if you haven't bought the data in using the UI and...

I would recommend doing this as an FRX report first column being actual spend, second being commitments, Third being 1 plus 2 and 4th being your budget then any additional columns for variance / comparison. This can be achieved in other ways too but I think the simpliest and most elegant...

set datewef = day(datewef) + '/' + month(datewef) + '/' + year(datewef) The error is because day(datewef) is an integer not a string so it's treating the + as a mathmatical + not as a string concatenation. If you wanted your script to work you would need to convert the integer values to...

4891.23,,,29/06/2006 would be better as 4891.23,null,null,29/06/2006

Change your parameters to and regdatetime >= '20070514' and regdatetime <= '200705189999999' By wildcarding you are forcing it to look for items less the earliest time on that date

Not sure if this is the best way but I think it will work select Col1, max(Col2), max(Col3) from ( select Col1, Col2, null as Col3 from Table1 union all Select Col1, null, Col2 From Table2 ) a group by Col1

Unfortunately the goal of this is to have the file emailed to the third party every night automatically so there can't be any manual intervention. Thanks for the reply anyway

Yes you can do this e.g. select 'Company 1' as Company, GLCODE, AMOUNT from DB1..SQLTABLE union all Select 'Company 2' as Company, GLCODE, AMOUNT from DB2..SQLTABLE

I am trying to export data to send to a third party in an Excel Spreadsheet. The third party is extremely fussy about how their data arrives it must be in Excel and numbers have to be numbers. When I try to DTS data to Excel or script data to Excel using insert into...

Hi I don't believe there are any standard Crystal reports for Great Plains. As standard the statement would be produced with the report writer. If this report has been written for you it would be specific to you so I doubt you'll get much feed back in here