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!

Register Log in
  • Congratulations derfloh 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. JeffMachine

    Need help in identifying potential item shortages

    I have data from a manufacturing system and each row represents a transaction. I need to know when an item is scheduled to go negative and the next scheduled replenishment date and amount after that. Sample data. Data is not stored in order, will need top be sorted by itemid,reqdate...
  2. JeffMachine

    Link to the exchange rate table

    I have various sales and orders queries that I must now link to a currency table to convert to USD. The currency table looks like this: currency fromdate rate USD 1900-01-01 78.44 USD 2006-08-31 77.839 USD 2006-09-30 79.001 USD 2006-10-30...
  3. JeffMachine

    I need to modify my inventory valua

    I need to modify my inventory valuation report to show the newest and oldest date an item has been in inventory. I've added a subreport that selects all receipts for each item. I've passed the qtyonhand to the subreport for comparison. I've ordered the subreport by transaction date descending...
  4. JeffMachine

    linked server, error 4064

    I created a query that links 2 servers (used sp_addlinkedserver). I used this query for a Crystal report. Works fine if I run the report. I assume because I have admin rights. My users get a 4064 (failed to retrieve data) error code when running the report however. Any ideas on how to get...
  5. JeffMachine

    Assign "Language for non unicode programs" setting by user

    We have a 2008 ru2 Terminal server that serves two user bases, one in China and the other in India. The Chinese have a application for reporting taxes that needs to have the system locale (control panel/region and language/administrative/language for non unicode programs) set to Chinese...
  6. JeffMachine

    Rounding price increase to the nearest

    We are increasing our prices by 4% (price*1.04) and I need to write a query to show the sales dept. what the new prices would look like and I need a little help with the syntax to calculate the new rounded prices. We would like to round these new prices based on the table below: Price...
  7. JeffMachine

    Need help with a Vlookup formula

    I need help creating a formula that will add column B to the sum of D where column A = column C. Column C can have multiple entries for column A so a sum is needed in the vlookup. There might not be anything in C for every A. C and D would be used as the table array A B C...
  8. JeffMachine

    Indentify second occurance of a character

    I have a field whose data looks like this: 003391 003391-01 003391-01-01 002498-02-01 004895-02 004895-02-01 005523-01 I would like to have a query that returns "Warranty" for lines 3,4 and 6 and nothing for the others. Warranty items end in "-01" but only after the second dash. So lines 2...
  9. JeffMachine

    Need to add a total valuation column to a crosstab

    I have created a crosstab report that shows each item and the quantity of that item in each warehouse along with the total of all warehouses. whse1 whse2 whse3 total item1 1 2 6 9 item2 0 3 2 5 I would like to add the item's description as a...
  10. JeffMachine

    how to add days to the due date

    Macola version 7.6.400a I would like to change some of my open AP item's due dates by adding 83 days to the trx_dt. In other words due_dt=trx_dt + 83 days. This is simple when the date is stored as a date format, but how do you do it when the date is in yyyymmdd format? P.S. I know how to...
  11. JeffMachine

    how is available credit calculated

    Macola Version 7.6.400a How is the available credit, that is on the customer credit box that pops up when entering a order, calculated? for example: credit limit 500,000.00 A/R balance 40,977.36 open orders 5,080.00 available credit 578,942.64 ???
  12. JeffMachine

    PWE login error -- 2006:Invalid Tools collection index

    Version 7.6.400a I have one user who can no longer log into PWE. She can still access standard progression, however. The full error message: 2006:Invalid Tools collection index Error In Form_load of frmMain at Line #:1685 Any ideas? Thanks...
  13. JeffMachine

    Changing unit price in OE to allow items over 10 million

    We are currently transitioning off of Macola so I no longer have any Macola support. We have recently received an order (from the fed gov of course) for an item over 10 million dollars. What do I need to do in Macola so I can enter this item? The oeordlin table is still set at the defaults of...
  14. JeffMachine

    cross tab report help

    I need to create a report that spreads the cost of a job over the life of the job. Report should look like: Job Amount enddate Jun09 Jul09 Aug09 etc..... Job1 10,000 10/15/09 2000 2000 2000 until oct job2 20,000 11/23/09 3333 3333 3333 until nov My data is...
  15. JeffMachine

    Looking for first 5 consecutive numbers in a string

    I have a text field that I need to search in looking for the first 5 consecutive numbers, which would represent a PO #. Here is what some of the the data looks like, the numbers on the right is what I'd expect from the query: Text field PO field PO 31125...
  16. JeffMachine

    Another help in converting data in a query

    I have a numeric data field called amount(numeric 28,12), data looks like this: 281.400000000000 17892.840000000000 .170000000000 I need to format in a query to look like this: 000000000281.40 000000017892.84 000000000000.17 Thanks ...
  17. JeffMachine

    help converting data in a query

    I am writing a query and I have a field (voucher, nvarchar(20)) whose data looks as follows: 00002_vir 00003_vir 00012_vir 200001_vir Basically, I need to strip off the "_vir" and left pad to 8 places with zeros and I need some syntax help. So the end result of the query would look like...
  18. JeffMachine

    Need help creating a continuous form report

    I am trying to create a report for an inventory count tag. This is to print on a preprinted multi-part form on a dot matrix printer. The tag form is 6" wide with a height of 4" (not counting the feed holes). I haven't been able to get this to work by setting the report up using a label...
  19. JeffMachine

    DTSrun not working

    I've created a DTS package that exports data from a Excel spreadsheet into a sql table. It works fine when run from the Enterprise Manager. But it errors out when run from a stored procedure. Stored Procedure: CREATE PROCEDURE [run_haas_po_import] AS exec master..xp_cmdshell 'dtsrun /S...
  20. JeffMachine

    Pro's and Cons to ES

    We are looking a new ERP system to replace the one we currently use (Progression). My company has different entities that either manufacture or distribute machine tools. We will be looking at Axapta, Navision, Syspro, Epicor, Exact ES and maybe a couple of others. My question to the Exact...

Part and Inventory Search

Back
Top