By using this website, you agree to our Terms of Use (click here)
The DateInfo table can be helpful for several reasons. Here are a couple off the top of my head:
1. You need a record for every date, even if there is no data on a particular date.
2. You want a quick way to get the Week Ending Date.
I was trying to do #2 recently. First I tried to use a formula to get the Week Ending Date for SOOrder.CreatedDateTime, but there is no "WeekOfYear" formula:
So, I tried joining from SOOrder.CreatedDateTime to DateInfo, but I couldn't do it without getting an error.
This was the best way that I could come up with:
=CInt(CStr(Year([SOOrder.CreatedDateTime]))+Right('0'+CStr(Month([SOOrder.CreatedDateTime])),2)+Right('0'+CStr(Day([SOOrder.CreatedDateTime])),2))
Does anyone else have a better idea for how to accomplish this join?
Hi Tim, nice idea! I recently discovered another handy use for the DateInfo, which is as a means to print multiple product labels without the need for a customization to create a custom Numbers table.
The problem is described here: https://www.augforums.com/forums/acumatica-report-designer/printing-product-labels-from-purchase-receipt/
And I described the use of the DateInfo table to avoid a customization here: https://www.linkedin.com/posts/laura-jaffe-965a411a_acumatica-labels-reportdesigner-activity-6790750118200049664-uP0T
@lauraj46 Thank you so much for sharing this! I just commented on your LinkedIn post and asked you a question there. I also posted the LinkedIn link on the AUGForums.com Discussion Topic that you linked to above for others who land there via a Google search.
Now when I think "Laura Jaffe", I'll think about more than just "I can't believe that I worked down the street from her in Solon, Ohio and didn't realize it" 😀
I'm looking forward to reading future creative solutions from you!
I wish that I could find a way to subscribe to you on LinkedIn so I could know when to read your solutions, but my "5 minutes of research" led me here so I gave up:
https://www.linkedin.com/pulse/post-article-notifications-coming-back-linkedin-john-marrett
On a related "how can I subscribe to creative stuff like this" note, I'd love to get your thoughts on the following...
I've been thinking about a way to "curate" Acumatica Reporting Tools tips and tricks content here on AUGForums.com. I started with a new Tags feature that allows me to make Discussion Topics that are Notes (click here) standout from most of the new Discussion Topics which are Questions (click here), but I've realized that I don't have a way to allow people to subscribe to Notes only. So I'm re-thinking and considering to create a new Forum called Acumatica Reporting Tools Tips and Tricks. Since you can subscribe for email notifications by Forum, this would allow people to subscribe to only received notifications for things that land in Acumatica Reporting Tools Tips and Tricks forum. I want to manually curate the content so I would be the only one who could add content to that forum and I would do it by taking content from other forums and moving it. I could still use the Notes (click here) tag to help things standout when scrolling through Discussion Topics from all forums and I could rename "Notes" to "Tips and Tricks".
I would need to build some simple rules around what Discussion Topics are candidates for the Acumatica Reporting Tools Tips and Tricks forum. Something like this:
1. It must be related to the Reporting Tools in Acumatica and not another area of Acumatica, consistent with my attempt to focus the Forums content on this site more on the Acumatica Reporting Tools (click here).
2. It must be at least 100 words. There are so many places to find tips & tricks: various VAR blogs, Community.Acumatica.com, LinkedIn (as you just demonstrated), etc. I'd love to have all of the content here on AUGForums.com, but I realize that's not realistic. So I'd be fine if someone is sharing a link to content that lives elsewhere, but I'd want at least 100 words that give an overview, why you're sharing it, etc. rather than just "checkout this link".
What do you think?
@timrodman I'm so glad you found the post useful. I'm honored that would want to subscribe to my LinkedIn posts. Sadly I'm a LinkedIn newbie and I don't know if that's even possible.
I think it would be a cool idea to create a moderated Acumatica Reporting Tools Tips and Tricks forum that is separate from the questions. I would subscribe.
@lauraj46 Alright, here's an update on this idea. First, thanks for kickstarting this idea with your really cool solution.
Ryan and I covered your solution during a recent Live broadcast. @ryanxbyte came up with the idea to call it #AcumaticaTnT - Acumatica Tips and Tricks that will blow your mind. We even have a cool dynamite logo. Here's Ryan introducing the segment:
Tonight I started to respond to a Discussion Topic here on the Forums and I realized that it would be easier to record a video. So I did. Then I thought, hey, why not use the #AcumaticaTnT hashtag? Here's the video:
When I went to the next Discussion Topic on my Unseen List (click here) it took me here. With #AcumaticaTnT on the brain, I recalled what I wrote in the last monthly update email about organizing all Discussion Topics into Notes and Questions. I thought, why not use #AcumaticaTnT in place of Notes? So I just made that change and now you can see #AcumaticaTnT in red on the top of this Discussion Topic. You can click that red button to see all #AcumaticaTnT Discussion Topics. Once Google indexing catches up, you should be able to search the content of all #AcumaticaTnT Discussion Topics by doing something like this in Google:
Remove the site:augforums.com part of the search to search the internet (including social media) for #AcumaticaTnT and see that you're the first hit:
See what you started? 😀
@timrodman I love the new #AcumaticaTnT hashtag, and the dynamite graphic! I listened to the podcast live and was floored that the DateInfo tip was featured as the first tip. Really looking forward to finding more Acumatica Tips and Tricks here 🙂