User

Ian Wheeler

Member since
Total activity 8
Last activity
Following 0 users
Followed by 0 users
Votes 1
Subscriptions 3

Activity overview

Latest activity by Ian Wheeler

  • Ian Wheeler created a post,

    How to find the selected row number of Form table in a Macro?

    HiI am working with SAP B1 Blanket Purchasing AgreementWhen the user chooses to close a line on the agreement I want to warn them if there a associated documents attached to the line in question st...

    • Ian Wheeler
    • 2 followers
    • 0 comments
    • 0 votes
  • Ian Wheeler commented,

    HiIn the SQL Report function I am still not correct and get and error    select PD.ItemCode Component         , ('Store1'*avg(BaseQty)*COUNT(PD.ItemCode)) -isnull(CS.WhsStock,0)  [Missing Stock]   ...

  • Ian Wheeler created a post,

    Can you use @Store in SQL report?

    Hi I would like to use the @Store system in my SQL report with a SQL stored procedure EXEC    [dbo].[testmultselect] @WO = N'@Store2',    @Qty = @Store1 Invalid query tree  [300-33]. The SQL error ...

    • Ian Wheeler
    • 2 followers
    • 2 comments
    • 0 votes
  • Ian Wheeler created a post,

    Placing a label on a form with Item Placement Tool

    Hi AllThis should be possible I am sure, but I can not work out how to do it...If it is in the videos I have missed that section. So please can someone suggest how to do thisI just want to put a pl...

    • Ian Wheeler
    • 3 followers
    • 2 comments
    • 0 votes