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!

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

Search results for query: *

  • Users: VictorAst
  • Content: Threads
  • Order by date
  1. VictorAst

    Macola and Using Wisys Agility Design Studio

    I have posted on SQL forum also, but was wondering if any Wisys Agility Design Studio programmers can help I am running a pivot grid to determine sales and am needing to get a percentage difference from two Aliases I created. I have the CASE statement below to determine the Difference, but...
  2. VictorAst

    Determine Percent Difference between two CASE Statements

    I am working with Wisys Agility Design Studio and writing SQL statements to determine sales differences from year to year. Case where I determine the 2016 sales data CASE WHEN oehdrhst_wv.inv_dt LIKE '%2016%' THEN ( oelinhst_wv.qty_to_ship - oelinhst_wv.qty_return_to_stk ) *...
  3. VictorAst

    Print Picking Tickets Form Update

    I am currently on Macola 9.6.500 In the Print Picking Tickets form, the criteria is to search by a range of order numbers. We use a User_Def_Fld_1 in our Pick Ticket crystal report that is used for a Production Code. Example 11-13-X. I want to be able to modify the Print Picking Tickets form to...

Part and Inventory Search

Back
Top