Here's a couple of things to know about PR tables which may help you:
When a pay run is posted the PR history files are updated. The history files are stored in the "UPR3______' range. The checks are stored in PR check history (UPR30100) and PR transaction history (UPR30300).
Most but not all...
CR 9
btrieve/ODBC
I'm trying to create an export file to send to a barcode program.
Working off a single table with row such as:
Item Date Qty PO
RSC2214 4/12/05 768 20325
We can only get qty of 200 in a box for this item, so I'll need 4 labels and need to send to...
Have you done performance monitoring to see what's happening at different times?
Sounds like your current server should be able to handle the normal traffic. Are other apps O.K.?
Paraphrased in my own words:
Do a complete install of GP on the new server, same version exactly.
After you install Dynamics (but before launching Dynamics Utilities) you need to copy the SY003001.* and SY00302.* files from "System" folder on the old server to the same on the new server. This...
Hi Jazgeek,
Thanks, that will work for me with Crystal.
But I also need to limit security to Great Plains users. I want the "staff" user to be able to do queries, set up employee cards, enter transactions for all employees except "Admin" class (and others) of employees. Same holds true for AP...
I'm trying to set up security to prevent certain users from accessing specific records, but allow them access to other records within the same table(s).
This could be based on classes. Ex. - a user in the "staff" class cannot access payroll records of users in the "admin" class but can access...
If your question is how federal wages are calculated on the W-2 it is:
Gross wages (salary, hourly, etc.) + benefits subject to federal tax - deductions sheltered from federal tax.
Hope this helps.
Just rolled out PS T&E to our users. On some stations the tab key will take them to the next field. However, on most stations they have to use the mouse, which they are complaining about.
Compared the browser settings and can't find anything different. Any suggestions?
Thanks in advance!
Try looking in the PM30300 table, which is the 'Apply to History File'.
When you post a check and apply it to an invoice, and the invoice is paid in full, it moves to history. The 'Apply To' table stores the links between invoice and check.
Try going into your column format and go to "Print Control" in your Column Detail row. Change this value to "XCR" which should change the sign for the column if the normal balance is a "CR".
Your problem may be that you have "credit" accounts in the rows displaying as negatives.
Go into your row format and be sure the Column E (Normal Balance) has a "C" in the columns that are negative, and rerun the report.
There is a product called "Changer" from a company named "Corporate Renaissance" which will allow you to change the customer number along with all corresponding transactions.
There are several "Changer" products, one for renumbering GL accts.,one for employees, one for customers, etc.
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.