180
Hi,
I want to take sale line value Quantity - Quantity shipped and I have to store the values in column.
I will add the screen short for better understanding. I want only the values which is marked in yellow I dont want the red values.
pleas help me with the code. Thanks
*This post is locked for comments
Ok so you need to blank the value for the other fields. In your case, at first step (when J = 1) you assign RemQty_01 to your value and RemQty_02 and RemQty_03 are 0.
When J = 2, you assign RemQty_02 to your value but RemQty_01 has the previous assigned value.
When J = 3, you assign RemQty_03 to your value but RemQty_01 and RemQty_02 have the previous assigned values.
I think that on every iteration you need to:
1) add the value to your desired variable
2) clear the other two not used variables.
Thank You for replying Sir
but I need like this.
In sales line there is tow fields quantity and quantity shipped. i want to subtract the the two values and get it in report. The line value should print in Remain QTY1 and second value should print in Remain QTY2 and 3rd value should print in Remain QTY3 if more lines are there then it should print in Remain QTY3 The values which should come in report is marked in yellow.
in sales line there is tow fields quantity and quantity shipped. i want to subtract the the two values and get it in report. The line value should print in Remain QTY1 and second value should print in Remain QTY2 and 3rd value should print in Remain QTY3 if more lines are there then it should print in Remain QTY3 The values which should come in report is marked in yellow.
It's difficult to know what you want to obtain. If I've understood, you need to blank the value that you don't want for the lines accordingly to the J index. So:
IF j = 1 THEN BEGIN
RemQty_01 := .....;
RemQty_02 := 0;
RemQty_03 := 0;
END;
Can you first let is know what's the logic on to which you want this to be executed?
How will you differentiate between Yellow and Red ones?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (