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 strongm 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. martink1

    retruning data in a row instead of a column

    Thanks Charliy, that worked. What exactly did you have me do? I'm not an advanced Crystal user. Now I just need to get my tracking numbers to be clickable again.
  2. martink1

    retruning data in a row instead of a column

    I'm adding UPS/ FedEx tracking numers to orders as a subreport. My tracking numbers come back vertically in a column. how can i get them to populate horizontaly in a row?
  3. martink1

    Adjusting layout of report in report writing for Microsoft Great Plains

    Hard to tell from the pictures what you're doing. But have you tried increasing the size of the section that's getting over written? you do this by pulling the PH or B tabs up or down. Also make sure what section yoo're working on. Page header is different than report header.
  4. martink1

    Need a procedure to create a test Dynamics GP environment

    take a look at this thread at the bootom is the location of the capture_logins.sql http://www.tek-tips.com/viewthread.cfm?qid=1097807&page=1
  5. martink1

    Someone else is using the system error (DOS)

    not sure about DOS but in regular GP. Look in the Activity table and sy00800 in the Dynamics databse. they should be empty when no ones in the system.
  6. martink1

    Query users who have not logged in for x days, months, etc.

    I don't think you'll find that in the database, but I'm not positive. With-in GP you can run an activity report on log-ons and log-offs. But you have to have set it up to record those events. setup up is in Tools > Setup > system > Activity tracking reports are Tools > Utilities > system >...
  7. martink1

    Sales Integration SOP with items

    Is the Item your importing already in GP? I just did my first SOP intergration and I found that if the values your importing are not in GP they won't be imported. In my case it was the credit terms that wouldn't import. If you could add more info I might be able to better help you.
  8. martink1

    Integration Manager install problem

    I'm on GP10sp1. I also have to run it free standing. My GP tools menu has Integration manager grey out as well. But it does work. Are you not able to open the quick start pdf? or is your error when you try to run the Intergration? GP has to be open in the company you want to Integrate into.
  9. martink1

    Modify GP Windows

    K-man are you taklking about setting discontinued on the Item Maintenance Card? The users have to have the permissions to change it. Log in as SA and see if you can change it. If you can then you will need to adjust permissions for which ever users you want to have this access.
  10. martink1

    Modify GP Windows

    You can set your Inactive Item Type to Discontinued in the Item Maintenance window. Then in Tools > Set Up > Sales > Sales Order Processing > click the Options button under 'Options' you will see the option to 'Allow Sale of Discontinued Items' uncheck the box. We set ours to use a password...
  11. martink1

    partical payment amount missing

    Try going to 'tools-utilities-sales-reconcile and reconcile that customers current customer information and outstanding document amounts. The report print out should tell you if the remaining amount was put back on the customers account.
  12. martink1

    Can I copy a GP 8 Chart of accounts into GP 10?

    I've created a new company in GP 10, I want to copy our Chart of Accounts from a company still in 8.0 is this possible? I tried using the Customer Source script but come up with errors. Is there another way? Thanks
  13. martink1

    Great Plains Slow on SQL 2000

    DomP you deleted the Sy07110 table. Did your advanced security still work? Is the information in this table rebuilt by GP?
  14. martink1

    Can't copy paste

    We have this problem on two computers, only solution we found was, you could cut 'ctrl+x' and paste. then copy to your new location and back in the original as well.
  15. martink1

    ShipComplete SQL Query

    Borvik, what do you do with this script? what do you use it for? does this somehow print only packing slips that have inventory or ?? sound very interesting and I am curious to see. Martin
  16. martink1

    What module to use to enable accepting Credit Cards in Sales Order?

    we use Nodus credit card advantage as well. Works well, we had some glitches at first, mostly our fault. but it works well now. you can book at order and ship at invoice.
  17. martink1

    this document contains one or more posting holds

    What could be causing this? I checked customer source and the Internet but found nothing. we get this on several different invoices.
  18. martink1

    item history - inquiry

    item tables start with IV..., Iv00101 and iv00102 are the tables I use the most, the tables starting with 300 are supposed to be history tables so iv30101 or iv30301 probly contain historical info. Go the the inquiry item history window, on the menul bar click tools-resource descriptions-...
  19. martink1

    Upgrade from Great Plains 7.0 to 8.0

    you have to update e0rder to 8.0 and alsoupdate commerce server. I am just now going thru this. so I don't realy have an answer for you. there is documentation on the great plains customer source website. I'll let you know more once i get thru this update.
  20. martink1

    can multiple users edit the stock count schedule?

    I've searched all over but can't find an answer. Is there any way to have multiple users entering data in a stock count for the same site?

Part and Inventory Search

Back
Top