Recent content by chuito7

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 (______...