Thank you @Dominica Sevilla-Oracle for the through check up, one last question If I may (I completely understand the Work Around),, If I were to reach out to a vendor, will they be able to create a script for this (since WF is not an option)? Thank you again for all your hard work, I greatly appreciate it.

Thank you @Ivy Lopez-Oracle I will review these documents and let you if I have any additional questions, sorry for the late response.

Hi @Patrick Fresnosa-Oracle thank you for your feedback. I have not been able to express myself clear enough in my question so please accept my apologies for the late response. Please allow me to try again. Under the entity of 'Vendor' --> Vendor Name: Kilo Byte: Vendor --> Edit --> Financial --> Currencies --> Added: USD…

Sorry about that @Ivy Lopez-Oracle my mistake, the formula you have provided me works!!! thank you very much

Hi @Joy Noreen Magoling-Oracle By this sentence: We need to keep track of these fields and cannot modify them according to the delta between the amount fulfilled and the QTY I meant that since we do not fulfill the entire line Item and there is amount remaining (Quantity-quantity fulfilled = Delta). On of the issue that…

Hi @Tiru Chembeti yesterday after a long and hard trial and error and some suite answers I was able to figure this out, thank you

Hi @Ivy Lopez-Oracle thank you but unfortunately this is still not working and tried in both directions for the start and end date, please see attached screenshots

@Matan Shachaf

Also, I do not have the Mark/Unmark Group button as shown n the print screen above

Hi @Dominica Sevilla-Oracle thank you for the checkup, any way for created some sort of automation rather than manual labor? WF perhaps?

Hi @Tiru Chembeti & @Katerina Winklerova-Oracle I am trying out this option in NS-SBX but for some reason the 'For Invoice Group' flag in the INV is greyed out, any ideas why? Already eliminated the following possibilities and not sure what am I missing: Checked all the scripts and undeployed them from the INV transaction…

Hi @Joahnna Given Uy-Oracle thank you for your response. I have yet to create the WF since I am not sure how to tackle this once. The idea is that the condition will be as such: CASE WHEN Transfer Order fields: From Location: Country NOT EQUAL TO To Location: US THEN IOR field populates Location to: I/C Inc Please let me…

Hi @Ivy Lopez-Oracle, for some reason the formula is not working well in the system, do mind having a look at the attached excel file? I used the formula for column 'H': ABS({datecreated}-nvl({trandate},{today})) which is working great but if you will look at column 'I' the formula I have added as suggested isn't working…

Got it, thank you @Ivy Lopez-Oracle

Hi @Ivy Lopez-Oracle, I know this might sound funny but by writing to you guys I found that there is no issue, the inconsistency is for when the dates are the same, but since this in regards to time stamp then it also addresses the time and not only the date, so when 2 dates are the same, this is where I didn't understand…

Very useful, I also need this formula, by how do I apply to the date fields I am using? I also need the difference between the dates and excluding the non-working dates, in my case the formula I am using is: ABS({datecreated}-nvl({trandate},{today})), thank you @Patrick Fresnosa-Oracle

@Kristoffer Viray-Oracle thank you very much, done

I see, thank you @Kristoffer Viray-Oracle this has been very helpful, one last question if I may, is there I way I can keep track of this enhancement request and get a notification if and when the product team has decides to move forward with this?

Thank you very much @Kristoffer Viray-Oracle I voted for this enhancement, I see that it only has 40 votes including mine, any ideas how many votes NS requires to start adding this to there pipeline?

Thank you very much @Tiru Chembeti for the amazing detailed and quick response, my apologies for the late feedback, this has been extremely helpful