Search results for query: *

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

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 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...

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

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

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 everyone I was wondering if someone can help me create a query out of GP that will show Vendor, Vndor Id, Invoice number, invoice date, payment number and payment date. I don't know which tables I need to do this thanks in advace villica

Hi everyone I was wondering if anyone can help me with this issue. One of the accountants was in the middle of applying a payment when we lost the connection. (Cash receipts inquiry window). The payment is not in the batch. One of the invoices is missing so we cannot reapply them. villica

Hi everyone We have tons of payables invoices taht were created with a Net 60 payment terms. We want to run an update query that will change those invoices with Net 60 to Next 30 before a cheque run is done. What is the name of the table or tables? thanks in advance

Hi everyone, We are having issues with some vendors invoices set up as Net 60. Is there a query or report that I can run before a cheque run done that will identify those invoices. villica

Hi everyone, We are running GP 6.0 and I can not seem to find Historical aged trail balanc in the financial module under reports. Are there any other options, other reports that I can use. thank you kindly for your help villica

Hi everyone, There is a variance in one of the accounts sub ledger of $110.05, inv. #12345. When the invoice is pulled up in explorer it shows as being paid Mar 06/08 however when you drill down into the transaction it does not show as being applied. It also does not appear as outstanding on...

Hi everyone Does anyone know what tables contain the AR Open records in GP 6.0? thanks villica

We have across an issue in Forecaster in that the system is not calculating input totals properly as well as amounts not being pulled across correctly to the statements. Any idea what could be causing this?? We have already upgraded to sp2 villica

Hi everyone I was wondering on which table can I find this information Journal Entry TRX Date Account Description Debit Amount Credit Amount Account Number Reference Originating Document Number. thanks villica