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!

Register Log in
  • Congratulations derfloh 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. chuito7

    Join tables based upon values in columns

    Join using A.YEARID = SUBSTRING(B.BUDGETID,4,4) Hope this could help! Jesus M. Cruz Narvaez Senior IT Consultant JT Consulting Group, Inc. jesus@jtconsulting.com
  2. chuito7

    Price sheet date change

    Yes you can change the date or deactivate the price sheet with users in GP. However, users using Sales Transaction Entry window have to close it and open again. Jesus M. Cruz Narvaez Senior IT Consultant JT Consulting Group, Inc. jesus@jtconsulting.com
  3. chuito7

    Contract Administration migration

    Hi: We have a customer that is trying to migrate from RTM Focus Software to Microsoft Dynamics GP Contract Administration and they want to keep all the existing contract information and customer equipment as well. I don't know if there is an Integration Manager adapter to integrate those...
  4. chuito7

    IIF condition returns error

    I have the following IIF statement: =IIf((SUM(Fields!LBS_QTY.Value)= 0.00),0.00,Sum(Fields!XTNDPRCE.Value)/Sum(Fields!LBS_QTY.Value)) if Sum(Fields!LBS_QTY.Value) equals 0.00 which if is the result has to be 0.00, instead the statement is returning me an error. What is wrong? Any help will...
  5. chuito7

    serial numbers mask

    Serial Number masks are for Auto Generate Serial Numbers at the Receiving process. GP allows you to enter any serial number it does not limit you to the serial number mask. You are not doing anything wrong, that is the way GP works!! Sorry! Jesus M. Cruz Narvaez Senior IT Consultant JT...
  6. chuito7

    How can I print x times the same field?

    It worked real good!!!! I'll appreciate your help. About the 254 characters limitation I do something to workaround this. Thanks again!!! Jesus M. Cruz Narvaez Senior IT Consultant JT Consulting Group, Inc. jesus@jtconsulting.com
  7. chuito7

    How can I print x times the same field?

    This is the approach I was testing. Ir works for the first 18 lines (Crystal 8.5) has a limitation with string fields to 254 characters, I have to break it each 18 lines. WhilePrintingRecords; stringvar x; stringvar y; numbervar nCounter; IF {@qty} <= 18 THEN For nCounter := 1 to {@qty} Step...
  8. chuito7

    How can I print x times the same field?

    Your answers are right, but I'm trying to repeat the same field x times. Not the whole record. The situation is this, this is for a picking ticket. The quantity is 4. I have to print 4 lines vertically like this ( ______ ______ ______ ______) if the quantity is 3 I have to print 3 lines...
  9. chuito7

    How can I print x times the same field?

    YES. Jesus M. Cruz Narvaez Senior IT Consultant JT Consulting Group, Inc. jesus@jtconsulting.com
  10. chuito7

    How can I print x times the same field?

    Hi: I'm trying to make a report that prints the same amount of lines or boxes of the quantity to pick. For example I got a line like this: ITEM NO DESCRIPTION U/M QTY 100XLG ITEM 1 CASE 4 ______ _______ ________ ________ So the picker at the warehouse can write down the...
  11. chuito7

    RW Catchweight Printing

    Understood! They are not using your Crystal Viewer for GP yet. I downloaded it and later I'm going to install it in my laptop to test it and recommend it. Jesus M. Cruz Narvaez Senior IT Consultant JT Consulting Group, Inc. jesus@jtconsulting.com
  12. chuito7

    SQL Store for Taxes on Posted Invoices

    The SOP30200 stores the total tax, the detail of each tax detail is stored in SOP10105. Jesus M. Cruz Narvaez Senior IT Consultant JT Consulting Group, Inc. jesus@jtconsulting.com
  13. chuito7

    RW Catchweight Printing

    Thanks for your response!!! One more question. Which driver did you use. We have here Okidata printers that can emulate IBM Proprinter III and Epson. I think that using IBM Proprinter driver should work, but what do you think? Thanks again. Jesus M. Cruz Narvaez Senior IT Consultant JT...
  14. chuito7

    RW Catchweight Printing

    I share the opinion that in Crystal it is not a big deeal. But my customer wants to print the picking tickets using dot matrix printers. By your experience, which font should I use to do this report in order to print it in a dot matrix printer. Jesus M. Cruz Narvaez Senior IT Consultant JT...
  15. chuito7

    RW Catchweight Printing

    I have Catchweight module from Trinity, I can print dual quantities for my items, weight and cases. For my picking tickets, I have to print the total cases per line, but I also have to print one line (like _______ ) per each case. For example, if the line says 4 cases, I have to print (______...
  16. chuito7

    Integration Manager 9.0 and SOP Transactions

    Hi: I'm creating a new integration of Sales Orders fot one of my customers and everything looks good, except for one error that the integration logs. DOC 5 WARNING: Line item quantities for line 12 are not fully distributed.. After a long time looking at Partnersource KnowledgeBase and...
  17. chuito7

    EXCEPTION_CLASS_SCRIPT_ADDRESSING

    I got this message when trying to integrate SOP Orders using integration manager 9.0. EXCEPTION_CLASS_SCRIPT_ADDRESSING SCRIPT_CMD_LOAD_ATSI14 and the process stops. It has to be terminated using Task Manager and Dynamics.exe as well. Thanks for your help, Chuito : )
  18. chuito7

    Customer Item Text Fields

    Thanks Dave. But I need to print the user defined fields too. The five of them. Is there a way to do that?. My customer needs "Customer Item Description" and "Text Field 1", "Text Field 2", "Text Field 3", "Text Field 4", "Text Field 5", because he needs to print a "HUGE" Description for his...
  19. chuito7

    Customer Item Text Fields

    Hi: I want to print in my invoices my customer item description and also my customer item text fields. My customer needs more than 50 characters for the item description. I already seach at MBS Knowledgebase and they make reference to this function...
  20. chuito7

    Getting Null Data

    Hi: I'm trying to make an historical inventory report using CR 8.5, SQL Database. I have my Inventory Master table, Category table, Actual Inventory and Valuation Table and Transactions Table. I linked Item Master rightouter with category, actual inventory and transactions. Since the...

Part and Inventory Search

Back
Top