ePartners Solutions or Revere Group are companies I've worked with. ePartners is very strong in Great Plains and Revere Group has a great technical team.
Is this a laser printer or a dot matrix. If its a dot matrix try using the generic printer driver. If its a laser/inkjet try using one of the drivers it emulates.
There is a sdk on the installation disks. This will list some table name descriptions and links, etc.
There are no APIs to great plains. It is built on a 4GL system. It is not object based. Parts of the code are in stored procedures and some in dexterity script.
You have several options...
IM isn't guaranteed to work with 3rd party apps, but I don't think that POP here should affect SOP.
If you take your text file and manually key in the data does it work or is there a data violation?
Are you using the right .SET file? That would be the one with your 3rd party app included.
It...
There is no batch scheduler in Great Plains. The script you would have to write yourself in the integration manager.
If you go right click on integration name, select properties > scripts in IM you'll see the events you can script for.
Did you try using a custom script in Integration Manager that would kick off an invoice after a successful integration?
There really isn't an API for great plains like we're used to.
Gotta love GPS precise error messages.
Are you using SQL optimized or regular integration manager destination? Try both if you have them.
Have you applied all the service packs for your version?
Did you try techknowledge on customersource?
Please post your error log, maybe we can tell moer...
LYR is last year sales. Did anyone ever perform the year-end close procedure for receivables? If not you won't get any values there.
LTD would be life to date sales.
If you have never run the year end close then the smart list data current year (YTD = year to date, CY = current year) will...
That might be your only solution other than a complete restore. No one closed out the year for the financials module between the udpate and now did they?
Do you have access Great Plains support or a reseller for support? If your idea doesn't work I would definately contact them because that g/l...
Sounds like your update didn't work completely. Usually the core financials updates are pretty smooth. I'd revert to the backup and try your update again.
Did you do any Dexterity customization to this system, like using core fields in a custom panel?
You find out if the error is in your ADO code or a database error. Use SQL Profiler (part of the Microsoft Sql tools) and monitor all exception events. It will tell you the specific error (key violation, type exception, etc.) so you can fix your code.
Integration Manager depending on options will run in the $10,000 to $20,000 ballpark. It doesn't currently work with all modules/objects so you need to ask very specific questions when evaluating the product. For example, it does financials but won't integrate sales territories.
I think you can...
I just updated the last thread with some more info. You will need the .f32 files in your new install, as well as the other files I mentioned on the other thread.
You won't have any *.tdb files if you didn't do an export/backup before the old system went down.
Are you copying all the .mdb, .ldb, .tpl files from the old sysdata to the new one?
Is your ODBC connection set up *exactly* the same as the old one was, same name, same server, etc?
Are your FRx...
We're using Project Accounting version 6.08sp1 and have documented many problems with Fixed Price Revenue Recognition and Budget reconciliation.
Great Plains support acknowledges these problems every time we contact them but fail to document most of the problems. Their response is always that...
What kind of network connection do you have, you should be running 100 MB/s minimum, direct to switch ideally. What is the computer's processor and memory compared to the others? What is the ping from the client to the server?
These are all things I would check first.
Yes, the navigation in FRx is Company > Spec Set.
The export file would be named *.tdb, try searching for it then import.
I've only been able to get the folder copy method to work once. Frx is a real unstable pain.
They aren't telling you the whole story. You have several options.
1. Wait for the upcoming release of Integration manager for Projects and see if it does what you want. $20,000k+ price tag.
2. Integration Assistant for Excel. It basically is a screen level integration tool that will work with...
1. Are you using two data sources, one for the header and another for the detail?
2. Assuming #1 is done, did you set the keys for the header correctly, like invoice #.
3. Did you set the relationship between header and detail correctly?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.