User

Kenneth Sanderson

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

Activity overview

Latest activity by Kenneth Sanderson

  • Kenneth Sanderson created a post,

    Ageing Report column Colour if Invoice on hold

    Hi, I would like my Ageing report to, when loaded, change the colour of the Document field to Ref if the OPCH.PayBlock field is set to 'Y'. What is the best course of action for that? Thanks in adv...

    • Kenneth Sanderson
    • 2 followers
    • 1 comment
    • 0 votes
    • Answered
  • Kenneth Sanderson commented,

    Have you tried the CAST and +  instruction instead? This is part of something I used recently to generate a Serial number based on SO and Production order number Cast(T0.[DocNum] as nvarchar(10)) +...

  • Kenneth Sanderson created a post,

    Transfer to use next empty line

    Hi, I have written a line loop to copy items from a sales order to a special production order. The problem is that when it copies from one line on the sales order, it transfers the value into the s...

    • Kenneth Sanderson
    • 2 followers
    • 1 comment
    • 0 votes
    • Answered