Search results for query: *

All, I need to modify the renaming of a file to include the month end date for the period. The problem is they may run the integration at either the end of the current month or in the first few days of the next month. I thought maybe to use pull the actual date they ran the Integration and...

Hi, When using the Inquiry>>Transaction by Vendor window and then trying to drill back on a payment the Payables Apply Zoom and the Payables Distribution Zoom windows are emply - What do you think is wrong? Thank you, Dan Bigelow

I am trying to configure the report server and I get the following error after hitting the start button: System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed. at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus...

All, I have a report I am building in Resport Designer not yet published- I need to do the following: 1. Fit the report to one page when printing - I know there is a Fit to Page property but I can't get it to work 2. Is there a way to auto size columns so they change size based on the data...

I need to be able to have users enter parmeters which then would be used to build views or temporary tables basded on the user input -- I am using version 11 and not sure if this is even possible. I can write the code in SQL but again everything depends on the user input. Thank you,

Can you use smartlist or crystal to search through the OLE notes? Thank you, Dan Bigelow

Hello, My client wants to have an Income Stmt created in FRX to export to an excel spreadsheet with each month of the year as a seperate worksheet. So the spreadsheet name would be IS 2006 and each worksheet would be a month July, August etc. I am having trouble getting this to work - Trees...

I have never used the VBA Modifier function: My client would like to change the default sort setting in the Vendor lookup window from Vendor ID to Vendor Name. I have changed using the additional sorts feature but it always resets after you close the window. I suspect the code is run every...

I am trying to show Requisition Management through Business Portal 2.5 and GP 8.0 - I get all the way to the create Po piece and get the following error - Invalid persisted data has caused the EntityKey to be Null - when i went on to Partnersource they said the error is caused by not having a...

I have a client and they want to run one company - within that company they have two federal tax id's - they pay 1099 vendors from separate checkbooks but they only want one vendor id. For example checkbook 1 would be associated with fed tax id 1 and they would pay Dan (a 1099 vendor) but also...

We have a customer which is using workforce roi's Advanced PO - we need to migrate the data to GP POP, but the migration tool for this process fails - I was thinking of opening the code from the migration tool but it is a chunk file and I am having trouble. Any suggestions for moving this data...

Help, I have a linked Excel spreadsheet and one of my key columns is returning a #Num! in Access - note out of 400 records only 4 have a problem. In my queries Access see these fields as null. I have tried to use Nzfunction but the #Num! still remains - so I tried to use the Nz topopulate all...

Hello, We have a client converting to Great Plains 7.5 - they currently used stored procedures to move data from a website to a home grown db and then use more stored procedures to move the data into Platinum, there financial software. The goal is to be able to take data directly form the...

For some reason I can't respond to my intial posting - Can the business portal allow salespeople to log in and view crystal reports - if so how does this work?

Hello, I have recently installed Business Portal 2.0 on a test server. I need for the salespeople to be able to access, invoices and sales reports. The invoice is from Great Plains but the reports are created in Crystal v9. I know I can create a BP site which is restricted by salesperson...

Here is my report: I have created a sales aging report grouped as follows: All Caps = groups SALES ID DOCUMENT DATE INVOICE details then of course all the footers; because their are multiple payments to invoices I had to group by invoice in order to...

I have created a report which gives a grid layout report based by salesperson, one page per salesperson - the problem is the grid only prints down as far as the sales detail - i.e some salespeople have five lines others fifteen lines, the client would like the grid to print on the entire page of...

I am having trouble with a Crystal Report linked to Great Plains. The customer wants a Sales/History - AR/History report - I made one and it works fine - shows sales and payments by a certain date - however we have not run Remove Paid Transactions, as once the information has been moved to the...

I need help with a report problem - I am linking to Great Plains Tables through an ODBC and I have created a Sales/AR report for my customer. Currently I have no problems with this report, however Great Plains uses a routine to move paid transactions to a history table. If you do not use this...

I would like to change the size of the information pulled from a field in an invoice report. I know how do this if the text is on the report i.e Pay this amount--- just double click and and the menu opens, but I can't fiure out how to on fields. The field is customer name and I want the font...