Search results for query: *

Is it possible to remove a deleted company from GPs? Specifically, it looks as if the SQL tables were dropped for a test company in GP w/o first deleted the test company from GP's Company Setup window. The company is still showing up in GP and we want to remove it. Thanks, Omar ---- Tell 'em...

I'm creating a new currency translation db because the company wants to calculate exhange rates on a monthly basis rather than a daily basis. The company already has a DAX db with daily rates. Is there a way I can export the historic rates from the old DAX db to the new DAX db so that we don't...

I'm getting an error message when running FRx. The message is the following: "Any row with a CCHIST format code must specify a Historic Rate ID in Column D." I've examined the row format and all rows with a CCHIST setting do have a historic rate ID in column D. Unfortunately, the error...

we would like to audit failed login attempts to the GP application. is there a way to do this? we have rockton's audit module. thx, omar ---- Tell 'em Omar back!

when importing a budget from excel, do the periods included in the budget have to be open? can some of the periods be closed? also, what formats do the excel cells have to have? GP's help only mentions view only.... :-( ---- Tell 'em Omar back!

I'm trying to upload a budget to GP using the Excel import method. The budget is for the upcoming new fiscal year. Problem is, the new fiscal year is not an option in the budget year drop down box. How do I add the new year so I can select the proper budget year for the new budget? Thx ----...

Does anyone have suggestions for what tables/forms to audit using Rockton's software for SOX? Thanks ---- Tell 'em Omar back!

Is it possible to store w/i the same Access 2003 table, one column in english and another column in Japanese characters? Thanks ---- Tell 'em Omar back!

I'm looking for a solution to create reports in Japanese from a SQL database. Is there any reason why Japanese characters WON'T appear in a SQL Reporting Services report? The Japanese characters are not currently in my system. I'll have to create a translation table. Another question, does this...

I setup a db with security. I added 2 users and assigned them to the read only group. I've noticed a problem with the security. Perhaps I am missing something in the security configuration. If one of the users exits the db and then re-enters the db using the shift key (bypassing the startup...

I have a table with line item sales information. Each record = one line item. there are usually several records in the table for 1 company. There is a field in the sales line item table for adjustments. I have an adjustment file that I want to use to update the adjustments field in the sales...

I want to include in a report a field titled "data valid as of [date]". I want the date to equal the date a table was last modified. I'm guessing i'll have to create some code that 1) goes and looks at table property date modified and 2) formats this date for the report. Anyone know a way to do...

I understand Great Plains does not support the Japanese language. Does anyone know of a 3rd party module or other work-around for using Japanese in Great Plains? Thanks ---- Tell 'em Omar back!

I'd like to create a SQL query to grab the beginning balances of our P&L accts. Any idea what table & column i should grab? Thanks ---- Tell 'em Omar back!

We have an IM that imports vendor address info. source files contain upto 100 records. the primary Address ID field is set as a constant. Recently, not all imported vendor card Address ID fields are populating with Primary. I've looked at the IM and the field is still set to constant. I've...

I want to write a report that will link data between the Smartlist Sales Transactions table and the Sales Line Items in SQL. What are the names of the tables? Is there a valid link between the two? Thanks, Omar

We're trying to delete records from the >>cards >>Fixed Assets >> General >> Purchase window (Fixed Assets Purchasing Transactions). When an item is marked and the delete button selected, we get an error message: Error Message 30920241 not in 3rd Party Error Message Master. what gives? is it...

I have a user that is getting strange results in the sales receivable batch window. the window lists 6 transactions when there are only 5. also, the amt total is not correct...it is more than what the transactions amount to. i've looked at the rm00401 table. should i look elsewhere for help? Omar

I'm trying to find the Description Field that appears on the Sales Transaction Inquiry Zoom window? What is the field name and what SQL table does it reside? We have folks that want to include it in a smart list. Thanks, Omar

I want to create a new table based on a current table in the same db and will use a create table query. Easy so far. I want to add a field in the new table that didn not exist in the old table and I want to do this in the in the create table query. I can add the new field but its format is text...