Kenneth Sanderson
- Total activity 6
- Last activity
- Member since
- 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
AnsweredHi, 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 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
AnsweredHi, 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...