Search results for query: *

Having a syntax error and can someone help? select imtpartid, imtCreatedDate from parttransactions where imtpartid = 'XYZ' and imtpartrevisionid = 'A' and (case imtsource when 9 then (imtCreatedDate = (select max(A.imtCreatedDate) from parttransactions A where A.imtpartid =...

Thank you for both replies. I took the suggestion to have correct format of serial number for future generation of serial numbers. And, the formula field to sort the existing data. Thank you very much. Regards, Zaheer.

Wondering how to sort a string field to put them in the order of sequence. the field follows following format. XXYY-ZZZZ where XX - last two digits of Year YY - two digits of month. ZZZZ - numeric sequence. Example data. (in this 900 sequence to bring in before 1000). 1409‑1154 1409‑1212...

I was not sure whether it is database / ERP issue. since, it is a SQL database I thought to post in this forum. Anyhow, Thanks for pointing me the direction.

We've an ERP application built on SQL 2008 Database. We've peculiar issue with our database in one aspect. We've configured to use Average cost as our inventory costing method. Sometimes part issue to job / sales order transactions take last receipt unit cost as against an average unit cost...

I'm sorry I should have been more specific. This formula is being entered in Edit Parameter Field instance, in Prompt text field under value options. I tried with suggested syntax without end if, still I get error 1002.

Wondering anyone could help me with this. I don't have any problem without condition but If I put If then Else condition then I'm getting syntax error. Simple value: App.GetYear(Date(),"GL") - no problem with this input. Conditional VAlue: (If App.GetPeriod(Date(),"GL")-1 = 0 Then...

Just to update on my own question: I resolved this issue and figured out that it was because suppress (no-dill down) was not checked. I had a conditional formula in there to show only when needed. Having checked this option, all is printing together. Thank you.

I did checked suppress blank section on all detail sections both in main and sub report. But no luck. just to correct :50 sections, not sub reports.

Wondering whether anyone can help me understanding the page skip problem that I'm acing. I've a sub report in one of the detail sections. the report print everything fine except where there is no data concerning the table of the sub report. if there is no data then that section should suppress...

please find attached for attachment linkhttp://files.engineering.com/getfile.aspx?folder=f6f9f409-3cc9-47f9-8c80-dbfe192621c4&file=2014-12-10_10-04-06.jpg

Attached example show Assembly A is linked to Part materials B and in turn to C and D. The reason only A – B – C – D are in importance are because they are either track serial number or track lot number on the part record. When the transaction get complete with job we would have recorded serial...

Thanks a lot! SQL code helps.

PartID: XYZ rev:1 Custom memo field data: - Hydraulically controlled hose reels - Hydraulic tank: 43 US Gal - Fuel tank: 22 US Gal - Single Point Lift with 7 1/2" x 3 1/2" ID Forklift Pockets - 2" x 2" reinforced square tubular frame - Floor pan with 2"...

Hi Ian, Thanks for the suggestion. Fortunately or Unfortunately it did not worked. Multiple variable won't work in my case because of Group changes from part group to customer, and moreover, I've two levels of groups. The good thing is I managed to resolve this conundrum by eliminating...

If I could have a formaula something like this, then I could use this in ' eval ' with condition: total:=total + sum(maximum({CX_GL_SALESBYDIV.budgetamount},by customer by partgroup),{@GroupOption});

Thanks Ian. This formula works in one direction. i.e. If I choose to group by customer then group by partgroup. However, If I choose to group only by customer how would I summarize only discrete values from each cusotmer and part group combination. For example: custid partgrp budget ab001 xyz...

Thanks Madwac, I got it on how to use automated totals. However, I've little complexity that group option is not fixed. moreover, I've two levels of group options. It seem like Im would need many combination of evaluation formaulas.

I've a column in my data source with lot of duplications. I do have two columns put under group option. One need a maximum value and other need sum of all those maximum values. I can get first one by placing formula field as shown below, but don't know how to put the other one using the first...

just to update on my own post, that this problem was resolved. The reason ttx file was not talking to SQL denifition was due to missing link. I had to create a new parameter filed refering SQL definistion file. Moreover, I had to tweak SQL code to inlcude all fields bounded by the loop. Thanks,