Hi everyone, does anyone help me regarding purchas...
# suiteanalyticss
Sudhakar T
02/27/2024, 10:13 AMHi everyone, does anyone help me regarding purchase order dataset.
I have created a field in that dataset --> Open qty = Qty - Qty on shipments
Qty Qty on Shipments open qty Transaction line : Closed.
10 5 5 T
Scenerio: When transaction line is closed (T), then open qty value should be zero.
When transaction line is not closed (F), then open qty value should be value.
Sudhakar T
02/27/2024, 11:40 AMI need a formula regarding these scenerios for that.
l
Luiz Morais
02/27/2024, 2:23 PMcase when [transaction line status] <> ‘Closed’ then [quantity] - [qty shipped] else 0 end
s
Sudhakar T
02/27/2024, 3:12 PMSudhakar T
02/27/2024, 3:14 PMIn open qty, I am using this formula and already have some formula related to that. Can you pls here.
l
Luiz Morais
02/27/2024, 3:14 PMneed to add = ‘F’ after isclosed
s
Sudhakar T
02/27/2024, 3:16 PMSorry, i didn't understand.
l
Luiz Morais
02/27/2024, 3:17 PMCASE WHEN {transactionlines.isclosed} = ‘F’ THEN ({transactionlines.quantity}-
NVL ({transactionlines.quantityonshipments}, 0)) ELSE 0 END
s
Sudhakar T
02/27/2024, 3:26 PMOk, I will check it and will update.
Sudhakar T
02/27/2024, 3:38 PMStill, I am getting same issue. From my end is there anything need to be do backend data run or some more add info in that formula.
l
Luiz Morais
02/27/2024, 3:47 PMLuiz Morais
02/27/2024, 3:48 PMif you copied and paste what I sent, replace the single quotes because slack changes that to another character
s
Sudhakar T
02/27/2024, 3:56 PMI did that, but from my side it is getting same thing when transaction.line is not closed, open qty should be value but some are getting 0.
Sudhakar T
02/27/2024, 4:01 PMOk, I thing this will be backend user error and I will check it with my sourcing manager.
Great, thank you for your response and feedback.
4 Views