By using this website, you agree to our Terms of Use (click here)
Hello @dave-ziskind, looking at the Contact DAC, IsPrimary is a field that is calculated on the fly and isn't saved to the Database. Because of this,...
@roycelithgo Definitely works! And in case anyone runs into this, make sure you use the function ISNULL([value],0) when adding them.
Turns out the users on Acumatica's community forum found a way. Thought it was really interesting way to tackle it. I still had to modify the DB...
Interesting idea, but I don't think it's realistically possible. The data types in the DB for Qty and Value are all capped at 6, or in some cases, 4 ...
If you use Tools -> Trace, sometimes you can get lucky and get more info regarding this error. If I had to guess, there's an issue somewhere in ...
@britt-steinhardt This should work: =IIF(DateDiff( 'D', [Batch.DateEntered], TODAY()) < 30, 'New' ,IIF(CINT(DateDiff( 'M', [Batch.DateEntered...
Hi @britt-steinhardt, try these: Years: =CINT(DateDiff( 'M', [START DATE], Today())/12) Months: =DateDiff( 'M', [START DATE], Today())%12
Hi @abrunner, try using =[UploadFile.Name] in the Value filed of the image. If it's possible for there to be multiple files on your shipments, I su...
If you use "Save As Template" option under the clipboard, you can name and save it as a template. Once saved it will show up as another option under ...
@nmri Neat, I had looked at restriction groups for this but didn't see any link between items and baccounts, but the customers being users on the port...
Hi @andrew-smith, As long as you have a way to partition which Items need to be seen by which companies/customers, you should be able to override th...
Hello. I have gotten something like this working using a Cross Join. Usually you want to avoid Cross joins because they can be pretty destructive, b...
@daniel-currie @timrodman using the DateInfo table discovered by @lauraj46 is just what this thing needed!
Refreshing the tables in schema editor might fix this. Open the Report. Click File -> Build Schema... Make sure "Tables" tab is selected in...
You'll need to check for 0s when you do division. Also, you'll probably want to use [SOLine.CuryExtCost] instead of [SOLine.CuryLineCost]. =IIF([SO...
It depends on your version. I think SO was moved into the workflow system in 2020R2, or 2021R1. If it's in the Workflow engine, you can control what...
@matthewjames That's a great use of the side panels
Hi @matthewjames, As far as I know, you won't be able to use the Selected field for this. The Selected field on the POReceiptLine records is only k...
This seems very possible. A straightforward, albeit manual way would be to add Mass Updating to the GI Business Account GI. Once you change owner fo...
I've found I have to always create a new Workflow and you aren't allowed to edit their built in ones (ones marked Inherited). Check around timestamp ...
Hi @tra_user, Give this a shot: =SWITCH([SOOrder.RequestDate]<=Today(),'red0',Datediff('d',Today(),[SOOrder.RequestDate])<=3,'yellow','defau...
It looks like Acumatica changed the numbering of their topics, the new link is: Thank you!
I think the issue is using fields from SOLine. I feel like your report will work if you would set the visibility expression to something like IF(SOOr...
@nmri From what I've experienced, yes. There's a lot of variability depending on PDF/Browser/Printer/Printer Driver/Printer settings that can make it...
We usually do something like XX.YY.ZZ.## where: XX is a code for our company that doesn't match one of their modules. YY is their module code (SO...
Hi @canawrot, you may run into the same issue with Acumatica complaining that the application is negative, but will it work if you use a Payment? Not...
I'd also say to anyone else looking for this issue to check your Customization projects. If you are adding things to the site map in the customizatio...
@drustorm21 @timrodman I am seconding this. I've done a lot of looking, but Acumatica as of 2020R1 doesn't keep that link. In the end, I'm going to ...
@timrodman Looks like that works great! It's good to know that the filter actually works as a "HAVING" clause behind the scenes.
Hello @scottm, I think the problem is that InventoryID is an int number field that Acumatica generates as the key for every item. You want to be us...
Hi @susank17, The table you want is SOAdjust. AdjdOrderType, AdjdOrderNbr are the Adjusted Order and AdjgDocType, AdjgRefNbr are the Adjusting paym...
@timrodman that's pretty slick! You could even use something like =IIf(SUM([APInvoice.OrigDocAmt])<[RecordCount],1,0) and attach a checkbox sche...
Hey @timrodman, I've been summoned 😀 I don't think we can clever our way out of this until we can use one GI as a table in another GI. The parame...
Hi @richard I apologize in advance for how long this became! Our PO Receipts do not worry about the price. Though, this process will be even more...
@roycelithgo Ah-ha that grouping was it, what a bother!
@kalumw I tested a new group on GL Accounts by Branch Access and it worked fine for me, no changes to the column's code needed. Can you try creating ...
@kalumw It is working for me. Is your group name actually 101? In the relation you have ='101'. These are the results I got when testing using th...
Hi @kalumw. Double check your relation. I am using Account, so make sure you change the column equation to look at your table of interest. To test y...
You should check out/p> For my dev machine, I have the features configured this way:
Hey @robcushen, I had an idea on this over the weekend if the GI is still giving you problems with this. I feel like you can use an Attribute to so...
@stian-simonsen This link walks you through Loading the Schema under Schema builder to add tables to your report. It should show up on the left for...
Hi @robcushen, =CDATE('20201015') Try running this as a data field value in your results grid. I am getting a column with values of "10/15/2020 1...
Hi @chrisw If I was a betting man, I'd wager that you can accomplish what you're after without using a sub query, and be better off for it. Having ...
You can probably use an A Inverse Restriction Group. Any entity in this group will be invisible to any member of this group. Add your prospects, the...
No sorry, I was just spitballing the joins. You want it to look like this though: ARTran Left SOShipLine Relation: ARTran.SOShipmentType Equ...
Hi @stian-simonsen, It looks like the joins under Relationships are the cause. There is a line ARInvoice Left join SOOrderShipment on InvoiceNbr,...
oof.. Thank you for the heads up
@timrodman You know me, whatever a report can do a GI can do better 😉
@gabriel This is awesome, thank you!