Search results for query: *

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

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

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

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

Hi: One of my customers use IM to integrate orders taken in a handheld. If any of the orders taken fails to integrate IM commits that document number and skip it. That causes that the document numbers are not consecutive. This situation causes audit problems and create doubt if the document was...

Hi: I prepared an invoice in Crystal Report 8.5 using SQL databases. My customer needs to print the same invoice 3 times. The first one has to say "Original" the second one "Accounting" the third one "File". Also, that each invoice prints on a different paper color (they have a printer with...

I need to print a string field (like this [____]) as many times as the qty is for that line item. For example: if they entered an item with qty of 5, they need that field to be printed 5 times, and so on. I'm using DynamicsGP 9.0, Report Writer.

Hi: I have to make a report that shows posted sales and unposted sales for each salesrep. I link the three tables by the salesrepid. Created two detail sections to put in a. Posted table fields, b. Unposted table fields to summarize by salesrepid. The posted and unposted tables doesn't have the...

Hi: First Time here... I have a table that has 334040 records. I need to populate Excel sheets that only has capacity to aprox. 65,000. How can I make a query to create a new table for each 60,000 records. I will appreciate all the help that you can give me!!! Jesus M. Cruz Narvaez