Search results for query: *

hello I checked the report and the user name is not anywhere. It is using windows authentication. I am also getting this error when i test the odbc connection. loging failed for user (null). reason not associated with a trusted sql server connection. villica

Hi I get a box that says oled db at the top datasoruce(already filled in) user id (prompt) is blank pw (prompt) is blank database (already filled in) after you enter usename and pw you have to click next villica

Hello everyone We have user that installed crystal on his computer and he also designed some reports. Another person is using the same computer and trying to use those reports but every time he opens crystal it ask for a login user name and it default to the person that designed the reports...

Hello everyone. I really don't know much about GP but the Auditor have asked me this question. Are there any manual or system entry indicator for GP? This is where the system automatically posts to the GL's or an indicator that show the entry was manually entered and not system calculated...

Hello everyboy Is there a way to produce a report that list all the document entered and posted in 2010 but with a document date of the prior year. Critieris(up to and including January 8th) I would like these fields DOC# VOUCHER STATUS AUDITTRAIL TYPE DOCDATE POSTDATE APPLYDATE DR CR...

Hi everyone, is there an easy way to resolve the above error thanks villica

Thank you so much. I will run to make sure I get what I need villica

Hi everyone does anyone has a query that will allow me to pull invoices paid and unpaid for a specific vendor villica

Hello everyone Annual Units are entered in 1 input and percentages in another input sheet, the calculations takes place and save all the way through the input but the totals are not carrying through to the reports. sometimes the information is not showing up at all, or it is incorrect...

Hi Robert thank you. I printed the edit list and I did not see anything on the messages portion of the report. I will look one more time. villica

Hi everyone we have 2 batches are stuck in the batch recovery windows. When you try to get them out there it goes about 5% and then it gives the error message "posting interrupted" The cheques were all printed but I believe that the batch was only partially posted. Is there a way to run an...

sorry I did not word it properly there is an inquiry summary screen in the financial module inquiry\financial\summary\ it shows all the periods my question is, which tables in GP has this summary data and the detail data villica

Hi I am wondering if someone can help me figure this out In the summary inquiry screen, you can the debit, credit etc period totals. Which tables in GP has this data villica

I found the table rm0101 villica

Hi everyone I need to query some data out of the customer table, but I don't know the table name. Can anyone help please villica

I really haven got an answer and I can not use the open report over as the report is already open When the report opens up, it has a query as a record source which has every record. Also when the report opens up another little form opens up and with list of names. When I click on any of the...

When the report opens up, it has a query as a record source which has every record. Also when the report opens up another little form opens up and with list of names. When I click on any of the names the report used to display only that name and the transaction for that name only instead of...

Hi everyone I have an access database that does not longer work in access 2007 I think the problem is here. It does not apply the filter Reports("rpt sample").Filter = "ID=" & lstCFAMS.Value villica villica

Hi everyone I have an access database that does not longer work in access 2007 I think the problem is here. It does not apply the filter Reports("rpt sample").Filter = "ID=" & lstCFAMS.Value villica

Hi Victoria, Thank you so much for your help. I think I finally got the query to work. I linked your query to the gl30000 table to get the date. Thanks again villica