Hello @Naveen B it is the same GI and scheduled date field we were working on yesterday. Link below. I want to be able to have a column that says the number of days ago that it was scheduled, as in something like Today() - scheduledate . But this will not work as the scheduled date is not accessible to do calculations on I'm also having to do a slight add on to adjust the dates for our NZ timezone https://community.acumatica.com/topic/show?tid=7116&postid=22937
email was invented in 1971 - its pretty old tech. shame it cant work with acumatica
its a real shame we cannot use outlook with MYOB advanced. i have invested probably 10 hours of dev time into it and it cannot be made to work. @Chris Hackett i notice you’re following this thread - have you come across any fix that might work?
i tried to add a wildcard as the closing else but the syntax must not be right
excellent @Naveen B - works perfect other than the part for next week and this week - i wondered if these should be a range somehow? also it would be nice if it showed all until a selection was made in the combo box. would the switch function be better than nested iffs? =Switch( [TimeDuration] = 'P1', DateAdd( Today(), 'd', 0.5), [TimeDuration] = 'P2', DateAdd( Today(), 'd', 1.5), [TimeDuration] = 'W1', DateAdd( Today(), 'd', 7.5), DateAdd( Today(), 'd', 14.5) , '*')
@mkideckel - i wanted to do this also, but have found that enabling the sidebar view gives me most of what i need here - it allows me to peek into the item on each line and live edit without opening the actual document behind it
Yes perfect @Naveen B . basically in the physical workflow there are two teams, pickers and painters. the pickers are always preparing the material for the painters to work on tomorrow. so we just need “Painting Today” and “Painting Tomorrow” as drop downs and the teams can the focus on what they need to work on
This issue has been open and a fault since 2017!https://community.myob.com/t5/Other-MYOB-software/Myob-Advanced-Outlook-add-on-issues/td-p/480375
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.