Search results for query: *

Thanks for the replies - this is what worked for me: "C:\GPInventoryPictures\"&Trim({IV00101.ITEMNMBR})&".bmp" The IV00101.ITEMNMBR is a varchar stored in a SQL table. Bron Tamulis, CPIM Great Plains Mfg Consultant

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

Okay - I understand now - I didn't get the desired result but I understand why and I'll be able to tweek...... Thanks, Bron Bron Tamulis, CPIM Great Plains Mfg Consultant

Thanks for the reply........ The calculated field is not 'labeled' per se on my report. The Calculated field is simply an 'expression' in a textbox. In my case the 'expression' is in textbox116. I tried to change your formula to refer to textbox116 but it didn't work. In other words, I'm not...

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

Worked like a champ....... Thanks, Bron Bron Tamulis, CPIM Great Plains Mfg Consultant

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

You do not have to do anything in POP setup. The lot window should automatically pop up when receiving. Occasionally, the user needs to exit the application and then re-log in after making a change..... Good luck sounds like if it works in item transaction entry - it certainly should work in...

Worked like a champ - the select distinct records was grayed out and not an available option. The concenated formula and grouping suggestion works perfectly. Thank you very much. Bron Tamulis, CPIM Great Plains Mfg Consultant

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

Thanks for your reply. I agree with your assessment. Do you think anyone inadvertently changed data via outside application? My question is a simple yes or no question - can a user modify SQL data in a GP table by way of Access or Excel? Granted - client is absolutely crazy to allow certain...

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

thanks a bunch......works great Bron Tamulis, CPIM Great Plains Mfg Consultant

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

Margaret, The recommended way to bring on hand quantities into GP is to use integration manager. Generally, user creates an inventory batch, creates an integration, the integration creates inventory transactions - these transactions when posted populate the correct history tables. The problem...

Maximum Data Solutions is generally considered the leader in this market - they are totally dedicated to GP. The only down side is their product requires a dedicated - login workstation to work - so it eats a license and workstation. I have implemented and they can do everything they say they...