Search results for query: *

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

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

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 : )

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

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

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