Qty needs to be accumulated, once the Accumulated Qty hits a minus number, thats what I need to know. The records are ordered by reqdate, when the accumulated qty goes negative I need the reqdate of the item that goes negative, this tells me the date the item is shceduled to go negative. I...
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 figured out to do this for one user. If I run this command I can get it to work for jsmith:
EXEC sp_addlinkedsrvlogin 'pcisv002', 'false', 'domain\jsmith, 'report', 'report'
What would be the same command but that would work for all users? I don't want to have to run this for every current...
Thanks for the response Frederico.
I'm not sure that's the issue though. If I remove the part of the query that accesses the linked server (it is a union query with the second part hitting the linked server) the users can run the report successfully. They just don't get any data from the...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.