Search results for query: *

What I am doing should be easy - I must be missing something minor. I'm creating a parts catalog. Each Item Number has it's own picture. The pictures are stored on the C drive as bitmap files. I create the report - create a group for each item number. Then I insert picture - (any...

I have a report that runs fine on v8.5. I need to convert it to V9 or later. I have a formula field: @difference = {#RTEstGrp2}-Sum ({@Actual}, {pc00300.zTaskID}) This works fine in V8.5 - when opening report in V9 - I get......... a summary has been specified on a non-recurring field...

I have several Access(2000) Queries created that are querying data from a SQL database. I inherited these queries and everything was working fine. We recently changed our SQL server and our IT person deleted the old ODBC connection and created a new one to the new SQL server. Now my queries do...

SRS Newbie........surviving so far I need to total a calculated field. The calculated field is in a group recordset (not detail). Here's my calculated field (Gross Margin) =iif(Fields!TOTALDOLLARSINVOICEDMATCHED.Value > 0...

Newbie to SRS......... Need to basically create a field on my report. I want the field to contain a string 'Yes' or 'No' based upon the numeric value of a field. I tried as follows: (Added this expression to a text box on report) =iif(Fields!QtyReceivedSoFar.Value)> 0, "Yes"...

Client is running DynamicsV90. They have a problem with redundant customer ids in their live database. In other words, 1 customer (SMITH Company) might have 3 master ids - SMITH01, SMITH1, and SMITH. All 3 had a purpose at one time. Here's what I know - I know that with the Prof Tool Kit...

My client is a manufacturing company with a small retail store front in their mfg business. They are looking for the ability to swipe a credit card/verfiy the credit card and have the information integrate directly with the Sales Transaction Entry form of Dynamics. They have looked at the...

I am linking two tables (Crystal X) - Table A is a Bill of Material Table - it has multiple records for a distinct item. Table B is a Qty on hand table - it also has multiple records for a distinct item number. Example: Table A PPN ITEM NUMBER Widget Gadget Test Gadget Table B...

Greetings - Strange situation with one of my clients that I wanted to get some feedback on. Somehow the IV00102 table (item qtys) has been significantly modified - they lost - BUYERID/item assignments, they lost purchasing and manufacturing leadtimes and they lost the make/buy codes...

I have a report where I want to use select expert to define report date range - I want report to look only at records with a date up to 30 days prior from now and 365 days forward. I tried the follwoing formula(s): {TEC_SALESFORECAST_QTY.DATE1} in (LastFullMonth)or(Next91To365Days)...

My client is using GP MFG V80 - SP3. I need to create a costed - multi-level BOM report. Has anyone had expereince trying to create a stored procedure that extracts from the BM010115 and BM010415 tables? The way the data is stored, I would need to somehow loop through the table to 'explode' the...

My client wants to install a label maker in receiving and print user-defined labels based upon information from Great Plains - example, lot number, receipt, receipt date, vendor, PO, etc. Does anyone have any positive expereinces or recommended software solutions to share?

Greetings everyone - I was wondering if anyone has imported notes into Great Plains? Here's scenario - client is currently running erp system and has decided to implement Great Plaind Mfg. The current erp system is MAX running on Pervasive SQL. I need to import inventory items from MAX with...