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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by zsyed

  1. zsyed

    Conditional where statement

    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 =...
  2. zsyed

    String Field sort

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

    String Field sort

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

    Database

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

    Database

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

    Prompt Text Formula

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

    Prompt Text Formula

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

    Page skip problem

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

    Page skip problem

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

    Page skip problem

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

    Recursive Loop

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

    Recursive Loop

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

    Extract 'weight' from memo field stored in multiple lines as shown in example. Appreciate any help.

    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"...
  14. zsyed

    group formula

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

Part and Inventory Search

Back
Top