chris_kzn
24th October 2011, 15:33
Good day BaaN gurus,
I am stuck on a small problem and so am hoping you may be able to offer some advise. Attached is two scripts I have got, the first is a simple SQL Query script (the main program script), the second is a report script. I received a request from our Sales department to please create a label printing program. In my limited knowledge, I have been able to create this one and so thought it would suffice. However my despatch personell have come to me complaining that the staff are continually loosing the excessive labels and so this system is not working for them. What happens is that they do some partial deliveries and so label some items, then loose the rest of the labels. What they would like me to do is to be able to select a certain range of labels and have these labels printed. when the rest of the items become available, they want to be able to print the labels for those items. The problems I experienced is that when I use these two scripts, firstly the report script autogenerates the numbers, lets say, 1 of 100, all the way to 100 of 100. This does not seem to work if they do part deliveries of lets say, the first 10 items. The label report will print 1 of 100 to 10 of 100, once the next available set of part delivered items comes along, then it prints 1 of 10, instead of starting from 11 of 100.
Does anyone know how to make this possible? Does any of the above make sense? I am hoping that someone might be able to describe how they managed to get their BaaN IV system to perform this sort of task.
Any useful advise is greatly appreciated. Thanking you in advance.:(
I am stuck on a small problem and so am hoping you may be able to offer some advise. Attached is two scripts I have got, the first is a simple SQL Query script (the main program script), the second is a report script. I received a request from our Sales department to please create a label printing program. In my limited knowledge, I have been able to create this one and so thought it would suffice. However my despatch personell have come to me complaining that the staff are continually loosing the excessive labels and so this system is not working for them. What happens is that they do some partial deliveries and so label some items, then loose the rest of the labels. What they would like me to do is to be able to select a certain range of labels and have these labels printed. when the rest of the items become available, they want to be able to print the labels for those items. The problems I experienced is that when I use these two scripts, firstly the report script autogenerates the numbers, lets say, 1 of 100, all the way to 100 of 100. This does not seem to work if they do part deliveries of lets say, the first 10 items. The label report will print 1 of 100 to 10 of 100, once the next available set of part delivered items comes along, then it prints 1 of 10, instead of starting from 11 of 100.
Does anyone know how to make this possible? Does any of the above make sense? I am hoping that someone might be able to describe how they managed to get their BaaN IV system to perform this sort of task.
Any useful advise is greatly appreciated. Thanking you in advance.:(