Does anyone have solution for this? We have same issue and are at a standstill.
Issue and resolution described in some detail here: ...though I don’t recall my actions to get us into trouble being as negligent as described in the article.Despite upgrading to 2020 R2 Update 11 (20.211.0037) or later -or- 2021 R1 Update 1 (21.101.0047) or later being the only resolutions prescribed, Acumatica support was able to “Apply a Patch” to our 2020 R2 Update 7 (20.207.0012) that got us posting again.
Thanks @TimRodman,I am using the @MonthEnd to as a default for a parameter in the GI, so the DateAdd() is not available to me there, or I am naïve of it’s availability. As I need to allow user to be able override the default value, defaulting the parameter is preferred. I was delighted that the @MonthEnd-1 was giving me the last date of the prior month, as desired, in the Parameters section. When seeing some unexpected results, I output the parameter value to the grid and found it to be different (the next day) from the value in the parameters.I wrote a GI just to test this and posted those results to:https://www.augforums.com/forums/postid/8892/ .Showed same “bug” in @WeekEnd, @MonthEnd, @PeriodEnd, @QuarterEnd, @YearEnd without any adjusting math.I have not tested same in Report Designer, harvesting the parameters as suggested in https://www.augforums.com/forums/postid/8865/.
@Heidi Dempsey Thank you. I am hopeful your proposed scenario will meet our needs, but the hosting server for the attachment isn’t ready to let me view it 3 days later: Scanning file for virusesCan you try to repost please?
Thank you for the quick response @Julia Lukina !I just reconfirmed that I had tried to set the Tax Zone in the Location screen. In your screenshot it appears the Business Account is also a Vendor? The Business Accounts giving me trouble are “Pre-Customer” accounts stored only as Business Accounts and not Customer and/or Vendor. I get the CR303010 screen for Locations which does not have the Purchase Settings tab and does have the Tax Zone enabled on the Shipping tab.We are on 2021 R2 Build 21.212.0039
Hi @aborisova37,If your calculated date field returns a null (empty) for any of the records, you will still get a results table that can be sorted, and some of the filters seem to work fine. However, filtering by a single date (or between with that date entered twice) will yield no results.If this is your case substituting the null with any “filler” date that can be easily filtered away or ignored should get your quick filter working.Hope this helps!
@aaghaei we are not, and have not, used multi-currency. I did take another look for a “CuryTotalAmount” and found “CuryAmount”. Added “ProductsAmount” to compare to “CuryProductsAmount” (found to agree) and added “QuotedAmount” to the comparison… just in case it might prove useful. It did not help.Here is illustrative subset of my results:Opportunity amounts not in agreementAs stated in original post, the “CuryProductsAmount” appears to be the correct value, inclusive of tax, and it is the value displayed on the screen despite the insistence of the Element Inspector:I just really need to be confident that these reports are, and should remain, accurate. Bad financial reporting, even at the opportunity level is not, and should not be, well tolerated here.@GrahamMartin I would very much appreciate your solution if you can find it in your archives.Thank You!
I am sure this is not the most efficient, but I have tested it working in 2021R1.In the Data Field use:= CDate(Concat(CStr(Year([ARInvoice.LastModifiedDateTime])),'-',CStr(Month([ARInvoice.LastModifiedDateTime])),'-',CStr(Day([ARInvoice.LastModifiedDateTime]))))Creating the appropriate date (without time) as a string converting back to date.In the Schema Field use:ARTran.TranDate (or other date only field from the schema).Use appropriate Caption to overwrite caption from ARTran.TranDateHope this helps!
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.