Mike
Forum Replies Created
-
Sure, but not necessarily possible. Just need to return to sender
-
The mapi exe file dates may or may not indicate what version they are. The best way is to check the properties, details on the exe to show the version.
We used version 7.1.5.3 with 10.9 of Quantum and version 8.1.1.24 with Quantum 12.1. This allowed a user to use 64 bit Office with Quantum 12.1 with no problems (so far).
-
When you saved the report, did you specify “RPT_AP_AGING – AP Aging Report” as the Settings Group? Note that you cannot change this once you set it, so maybe delete the report and add it again to make sure you have the correct Settings Group.
Also, you will need to either log off and back on, or at least close the report settings window in order to see the new report.
-
What is the exact command you entered for the regserve and what version are your RWEasymapi32/64 programs ?
-
It could also be that there is user security on your version of the AP report. In Crystal Reports Manager, right click and select Security. If there are any users listed, then only those users can access that report. If there are none, then anyone is able. This might be why you are not able to see that report in the drop down.
-
You can block printing of a PO in the Forms Designer if the amount exceeds a limit by employee. You would need to set this limit someplace on the employee setup (you could use the PR limit field, if you don’t use Purchase Requests)
-
You should be okay.. but as they say, test in the train system first..
-
If there is no event that you can use, you could have EM run an SQL at 12:01am on first of each month to set the task status (or Work Order status) for that Admin WO to a status that blocks activity. You would need some way to identify that month’s Work Order- some flag or UDF or UDA that the SQL could look for.
-
Nate- how about Event Manager setting a task status to one which has activity blocked ?
-
Hi Craig- there might be better was, but this is how we do this. Since this is non-stock, it just made some GL entries when you received. Here is our process for void receiving of non-stock items
1. Open the PO with item to void.
2. If item to be returned has not been received in the PO, do the normal receive (Global / Receiving).
3. If PO is in Closed status, then change to Open (Global / Change Status).
4. Add a new line item to the PO:
a. Same Part Number and same quantity
b. Type is Non-Stock
c. IMPORTANT- Cost must be the NEGATIVE amount of the line item being returned, even if a return fee is going to be charged.
5. Receive this new line item on the PO (Global / Receiving).
6. Process the deferred receiver for $0.00, use PO number as the invoice number and date of the return as the invoice date.
-
Warren – the QUE Group board has this project underway as we speak ! We will update everyone as it get closer. In the meantime, thank you for your feedback and know that a better, more organized forum is coming !
-
Does this kill the 2nd session that gets created when you run a Crystal Report.
Simplest solution is to run that script as an Oracle Scheduled Job in SQL Developer.
-
I have seen this where a computer, especially a laptop, had 2 monitors attached and had quantum running in the 2nd monitor, then you remove the 2nd monitor. Windows remembers where to place the Quantum window, which is off the screen on the 2nd monitor that no longer exists.
Attach a 2nd monitor and i bet you will find your missing Quantum window. Or follow the instructions on this webpage. https://www.technipages.com/bring-off-screen-window-back-onto-screen
-
Scott- How does your method work to prevent duplicate login ? I would like to your source code if you want to share it.
Pietro- I would like to see that script as well. I was looking at this yesterday, to use a query to look for duplicate sessions and kill them. But I noticed that sometimes the duplicate sessions are for when a user has a Crystal Report viewer open in Quantum.
select v.machine, v.program, v.osuser, v.sid, v.serial#, s.user_name quantum_user, v.logon_time
from v$session v, sys_user_db_session s
where v.username = user
and v.audsid = s.audsid
-
In this case, I am trying to print an ATA 106 form for a specific stock line. I also need parameters for new/used, certified by, etc. It would be nice if the Crystal Reports method would work.
I have created an ATA 106 form in forms designer to be used as a print style off the stock line print label menu for now.. but unfortunately, the load style also sets the stock line to print…. so they need to click the edit and select the form instead of doing a load style to set the form.
-
yes that works, but it requires the main auto key (in this case, pnm_auto_key because it was invoked by Global, print custom crystal in the inventory module) to be entered, which a user will not know. Is there some way to retain that parameter ? Printing custom crystal always passes the relevant auto_key based on the module and context.
-
Hi Pauline- you can bring it back by going user, system setup, maintain system tables, company management browses, currency codes. Then click the find at the bottom of the window and check the Historical box, then Ok. You will see all of the currency codes including historical- edit the one you want to bring back and then uncheck it’s historical box.
-
I am still having this issue with another report now. There are several parameters defined in the report, one of the is the pnm_auto_key, which is passed to the report using custom crystal and rpt_custom_crystal. Passing the pnm_auto_key works great, but the other parameters (not optional) are never prompted for and the parameter panel on the left of the report cannot be changed (clicking with mouse does nothing).
any ideas ?
-
You could create an unverified company for them and be able to send out quotes. You can see the quotes in the company browse for customer quotes. Because they are unverified, you are restricted in what you can create for that customer until they are verified and become a regular company.
-
I get errors trying to import a table in 12.1.15. Same error when i try to just add a table.
I got around this by restoring the old OCDIA from before upgrade (10.9 in our case) and use it to import the table. Then close it and finish the rest of the setup and import with the new version of OCDIA.
-
Maybe you’re not getting the right costs summed up is due to multiple kit build quantity (and you don’t know which stock line went to which kit and each stock line as different costs), or the bottom window of the stock issue window only shows a couple lines and there were issues and un-issues and re-issues, etc. Resize that bottom stock_activity part of the window to see all the transactions and sort them by date to make it more clear what is going on.
Assuming that your kit build quantity is 1: run this query in Interactive SQL- change the MSI2072 to your SI number. it sums up all the stock issue stock line costs for that SI. That number should match the cost that you see when you go to the Global, Kit options, browse assembled kits and then inspect the built stock line.
If your kit build is for more than 1, this won’t work.
with bom as (select wob.woo_auto_key, wob.wob_auto_key
from wo_bom wob, wo_operation woo
where woo.si_number = ‘MSI2072’
and woo.woo_auto_key = wob.woo_auto_key)
select sum(stm.unit_cost * sti.qty)
from stock stm, bom bom, stock_ti sti
where bom.wob_auto_key = sti.wob_auto_key
and sti.stm_auto_key = stm.stm_auto_key
-
Anthony- if you have 10.11 or higher, you can use the Colored Grid / Color Management to create your own customized colors/fonts for various browse windows. The one to use for the IC Repair Order history is QQ,IC,REPAIR-SHORT. You should be able to provide a condition to meet your needs and set the color as needed.
-
Take a look at this post- Jason supplied the query for WO Cost analysis..
https://quegroup.org/f_crystal/10033943?rid=10041043%23#10041043#10041043
-
2 things to look at- what is the code that loads the memo field or is it a DB field ? And if you select the data from isql directly, does it appear as a long text string ? there might be carriage returns in the data..
-
Craig- if you uncheck the Char Wrap on the right click properties, does it display properly ?
-
Can you send a screen shot of what you are seeing ? i have noticed that some display monitors that have flatter aspect ratios (wide but not very tall) will cut off Quantum windows, not showing items at the bottom of the window.
-
Craig- is the memo field not expanding to as the text grows to multiple lines ? can you share a screen shot of what you are seeing and a screen shot of when you right click the memo field in the design view?
-
You can change the select statement to get the sequence and the text column. Then on the line where you add the rows to the memo field (memo.lines.add), you would put the sequence field like now and add
+ ‘ ‘ + q.FieldByName[‘text field name’].AsString
before the closing right parenthesis. So basically concatenating the sequence with the text on each line.
This will make the report print faster (each time it has to stop and get data from the database takes time).. Plus if the text spans multiple lines, i don’t think it will line up with the sequence number in your current report.
-
Gabrielle- group by and count are the answer here. This is a simple query to count the number of sales orders created each date. You can modify it to your query as needed.
SELECT entry_date, COUNT(*)
FROM so_header
GROUP BY entry_date
ORDER BY entry_date
-
Sarah- if you add “order by wti.sequence” to the end of your sql text in the code, it will sort the data returned in the proper order.
It looks like you are pulling 4 memo fields to display the info- just make sure they are all sorted by the same column. You could possibly combine the sequence number and text into a single memo field so that they line up when the text is longer than a single line.
-
How does Mobile Imaging compare with ImagePro in terms of price and functionality ?
-
Brandon- take a look at the QueSources in the members area, in the Forms Designer section. There is an entry there for querying the attributes.
Home/ Members-only /QUEsources/ Forms Designer
-
DIA is way more powerful, not quite as user friendly though. PL/SQL is pretty basic language. You can figure it out looking at other DIA scripts provided.
-
We just use the invoice that gets created from the WO Billing to send to customer. I created a modified WO Invoice form of the standard invoice that only prints the first line on the invoice and any charges that were added to billing or invoice. They load this as a style when printing. (invoicing a sales order, they use the regular invoice form). This prevents all the lines from every WO transaction from appearing on the invoice.
-
Another trick that i use is to aggregate the results into a single text field. In this case, the sub select is returning multiple rows, so there must be more than 1 Po for each SO. Maybe that is legit or maybe there is a cancelled PO that was recreated, so 2 exist.
There are many other scenarios where there might be one or more items that match in the sub select. You can try this listagg function and you will see the all the matching PO for that SO.
(
SELECT LISTAGG(POH.PO_NUMBER, ‘ | ‘)
WITHIN GROUP (ORDER BY POH.PO_NUMBER) “PO_NUMBER”
FROM PO_HEADER POH,
PO_DETAIL POD,
PURCHASE_SALES PUS
WHERE POH.POH_AUTO_KEY=POD.POH_AUTO_KEY
AND SOD.SOD_AUTO_KEY =PUS.SOD_AUTO_KEY
AND PUS.POD_AUTO_KEY =POD.POD_AUTO_KEY) PO_NUMBER
i have not tested this but have used something like this many times in other reports.
-
Josh on our Quantum, the WOS_auto_key can be null, which indicates a Pending status. So that join will not include those work orders. That may be your issue. Also, not sure what the p= is after the 2nd date comparison ?
-
single row sub query errors are generally produced by this type of statement- try removing it and see if the error occurs still- if not, then dig into this sub select and see what is causing it to return more than 1 row).
(SELECT DISTINCT POH.PO_NUMBER
FROM PO_HEADER POH,
PO_DETAIL POD,
PURCHASE_SALES PUS
WHERE POH.POH_AUTO_KEY=POD.POH_AUTO_KEY
AND SOD.SOD_AUTO_KEY =PUS.SOD_AUTO_KEY
AND PUS.POD_AUTO_KEY =POD.POD_AUTO_KEY
) PO_NUMBER
-
Figured it out with help from Jake Anderson. In a Formula Field, the Crystal Report function called FileName returns the file name of the report. When running the report in the Crystal Report editor, it shows the file path and name where the document lives on your local workstation.
But when the report is run within Quantum, some other magic happens. Apparently, Quantum creates a temporary file in the users temp folder, named like this:
C:UsersITADMI~1AppDataLocalTempqCRI_234_6c6b9368-5cb2-3e37-d500-e1781caab5c3_tmp.rpt
As you can see, the filename here appears to contain the cri_auto_key from the report. A little checking by hovering the mouse over the report name in Crystal Reports Manager confirms it to be correct.
So a little string magic and you have the cri_auto_key for the currently running report. Here is a formula that extracts cri_auto_key from the FileName function return.
Local Stringvar string1;
Local Numbervar loc1;
Local Numbervar loc2;
loc1 := InStr(Filename,”TempqCRI_”) + 10;
string1 := mid(FileName,loc1, 20);
loc2 := InStr(string1,”_”) – 1;
left(string1, loc2);
The reason for wanting the cri_auto_key is for a Sale Order C of C report i created. I wanted a drop down box for the signature name that only contained user names authorized to run this report. That makes it easier to maintain that dropdown when personnel change- changing the security of who can run the report changes the drop down list.
I am sure there are other uses for the cri_auto_key- like displaying the actual name of the report and date modified, as shown in Crystal Reports Manager, in the footer.
-
how to get the cri_auto_key, inside the report, for the report being printed is what i need to figure out.
-
awesome- glad it worked for you !
Learning RAP (the code for forms designer) is not easy, but once you look at existing code examples and learn to decipher the error messages, etc, it gets much easier. Browsing this forum is also a great way to learn it.
-
Thank Ian… i think we have the signature part figured out.. Now i am trying to figure out the CRI_auto_key for the Crystal Report being printed.
-
Sarah- look closely at the code in the message above. the Var statement and the next qc statement come BEFORE the begin statement. In yours, you have begin, then var, then qc.. then the actual begin statement.
-
Josh- can you post your SQL query here ?
-
Hi Jim.. i played around with your idea… cleaver idea- so you need to select the report from the list in the first query, right ? I was hoping I could do this without user intervention somehow..
-
The changes i made are subtle- changed ( and ) to [ and ], and “” to ”.
You just need to replace all the text below procedure varDescrOnGetText(var Text: String);
with the code above. so the first line after the procedure will be the “var” line.
Take a look at other code in other modules to get the hang of the language and syntax…
-
The error messages on the compile (you should right click and select compile when adding or changing code, so that you can identify the errors) are not super helpful but if you look at the line number and what it says is wrong, you can usually figure it out. You need to put cursor on first line of code and use the down arrow to move 1 line at a time downward and count the number of times you press it to determine what the line numbers are.
I had not checked the code that I pasted above, but i just did and made corrections to it to remove the syntax errors. It should work now.
-
Sarah- if the data item is not in the data feed provided to the report, you need to extract it from the database for each record. THe code that is above your statement assigning the PN description to the text field (and is commented out) does this in the old method.
This is the newer way to add data fields to your report
var
qc : TOracleDataset;
begin
if (wo_operation[‘pnm_auto_key’] > 0) then
begin
qc := TOracleDataset.Create(nil);
qc.SetSession;
qc.Sql.text :=’Select description from parts_master where PNM_AUTO_KEY = ‘+ WO_OPERATION[‘PNM_AUTO_KEY’];
qc.Open;
Text := qc.FieldByName[‘description’].AsString;
qc.Free;
end
else
Text := ”;
end;
-
Josh- make sure that your join on the shipping data is a left join, not a regular join. That will return rows where there is not shipping data (open WO)
-
Carli- we had something similar, but more of a consignment arrangement. We don’t have Lot module either, so we turn in parts from a Work Order on an engine (which is like your lot). We add a consignment code to each part and some tear down costs at the turn in. Then we add them to individual work orders to make them sellable and add more costs. Then they are sold or used on other customer WO. I wrote some reports to look for invoices for SO or WO where any of those consignment parts were issued and report of profit / consignment costs.
In your case, your PO would list all the parts and their cost (you can import PO line items from an Excel sheet). Then receive all the parts and assign a consignment code during receiving. You can then report on SO/ WO usage for those stocklines.
Maybe this helps your situation
-
Hi Jim.. i never was able to figure out how to get the CRI_auto_key for the currently running report. Maybe someone will share the answer for that.
This is how you can get the sysur info the person running the report:
Select SYSUR from SPS_SYSUR
This returns the sysur_auto_key for current user. You can join this with the sys_users table to get what ever user info you want to display.