Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Buzz1off

    Replacement Item Numbers

    The Professional Services Tools Library (PSTL) from Microsoft has a tool called Item Modifier that will let you change the name of an item while preserving all the history." Victoria: By "name", I assume you mean item number? There is also a Dynamics GP add-on called modifier that will do the...
  2. Buzz1off

    How to handle semi-dynamic Kit Item

    Well, that helps a bit. Changing the kit contents directly in the order must be a control setting and/or a security thing; because to my knowledge, we cannot do this in our company. I will look into this. I agree, running a test first is always a good idea.
  3. Buzz1off

    Report Writer Issue - Calculated Field Holding Previous Value when Current record is Blank

    Note fields can be problematic. I remember from using D-Base & FoxPro years back note fields occasionally would lose their index reference and we all know what a corrupted index can do. In the previous life, I avoided note fields whenever possible when constructing tables.
  4. Buzz1off

    Replacement Item Numbers

    This is a connected issue with my previous thread for using Code 39 font in Report Writer. I was successful in creating a calculated field, thanks to David Mizzou. Unfortunately, another problem was discovered when we tested a variety of item numbers on the report. Although most items print and...
  5. Buzz1off

    Report Writer Issue - Calculated Field Holding Previous Value when Current record is Blank

    Could it be a relationship issue between the PA Billing Notes MSTR TEMP and the other table(s)?
  6. Buzz1off

    How to handle semi-dynamic Kit Item

    It appears Victoria tried it an it works. As I said, I didn't think it would be a problem as long as the change occurs after a previous sale is processed.
  7. Buzz1off

    Code 39 barcode in Report Writer

    Thank you, David. Adding STRIP worked. We are now able to scan the field on the report.
  8. Buzz1off

    Code 39 barcode in Report Writer

    Thank you, David. Adding STRIP worked. We are now able to scan the field on the report.
  9. Buzz1off

    How to handle semi-dynamic Kit Item

    I am a business person who understands just enough tech to get through some basic problems; however, I stand by what I said in that sometimes you cannot give the customer exactly what they want. Unfortunately, some folks just don't understand what they are asking for is unrealistic and worse...
  10. Buzz1off

    Code 39 barcode in Report Writer

    Thanks, David... we are getting closer. I had to remove the LNG_STR because the field is already a string field. I no longer get an error when trying to print the report; however, we were not able to scan the printed barcode. To make sure the calculated result is correct, I changed the font back...
  11. Buzz1off

    Receivings Transaction Entry - New user needs help

    All items should have a default site (Quantities/Sites) Default Site ID. Also, all items should have a Default Purchasing U of M, usually EA. If necessary for a specific vendor where the vendor ships in packages other than EA (each), in the Item Vendors Maintenance for this item set the Default...
  12. Buzz1off

    How to handle semi-dynamic Kit Item

    Ok, I think I have a better understanding of what you are trying to do. As it appears, this "kit" may contain different items each time it is sold, correct? If this is the case, I believe the only way you can accomplish this is to modify the kit contents each time you sell the kit. I am not...
  13. Buzz1off

    Code 39 barcode in Report Writer

    Sorry, I though I mentioned this. The error message is "Error in Equation" (equation name). Unfortunately, I am not told what the error is.
  14. Buzz1off

    How to handle semi-dynamic Kit Item

    Remember, the vendor part number does NOT have to be the same as your item number. For example, you set up three parts. The first two are generic enough they can be sourced from more than one vendor and it will make no difference to the end user. The third, if you hade different rev levels...
  15. Buzz1off

    Code 39 barcode in Report Writer

    I should include how the Calcualted Expression is displayed: # "*" + popPOLineRollupTemp.Item Number + "*" The # represents CAT (concatenate), of course. I tried with and without the + between the constant and the field, and it doesn't make any difference. The original tip was written by...
  16. Buzz1off

    Code 39 barcode in Report Writer

    A previous post (April, 2010) indicated you could create a calculated field with asterik (*) in front of and behind the dynamics field so the scanner would recognize the barcode font. The instructions were very simple and clear. I tried this, with a variety of tests and I keep getting an error...

Part and Inventory Search

Back
Top