Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. triad66

    PAYROLL - Data Model or Descriptive Table Names

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

    Need GLDEL utility & password to fix G/L out-of-bal

    Believe you need to call Great Plains tech support for this. They use different passwords for different versions of the gldel utility.
  3. triad66

    display additional rows for export file

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

    Performance Issues

    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.?
  5. triad66

    Moving GP Dyanmics 6.0 PVSQL to a new server

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

    Moving GP Dyanmics 6.0 PVSQL to a new server

    There is a Techknowledge (875186) which explains exactly how to do it. If you follow these steps exactly it will work for you.
  7. triad66

    Row level security

    I would like to look at this demo. What's the best way to contact you, Dave?
  8. triad66

    Row level security

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

    Row level security

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

    W2 Form Type List?

    Have you tried printing the 1-Wide single feed to the screen as a test? It will print 2 to a page, and works with a laser printer.
  11. triad66

    W2 Form Type List?

    Do you see anything in the dropdown window? Did you install the payroll year end update file?
  12. triad66

    They fired our payroll expert and it is w-2 time

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

    PS TIme & Expense data entry

    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!
  14. triad66

    Crystal Reports/GP Check Number field

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

    FRx signs backwards

    stef315, You are obviously correct. Something else to consider and easy to make the mistake.
  16. triad66

    FRx signs backwards

    The original post mentions the numbers are correct, so I eliminated that as a possibility.
  17. triad66

    FRx signs backwards

    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".
  18. triad66

    FRx signs backwards

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

    Change customer number

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

    Sorting problem based on groups

    Thanks, lbass, the suggestion worked great!

Part and Inventory Search

Back
Top