Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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