@jlange Correct. It just makes it simpler than hard-coding the CompanyID each time.

@jlange Long time indeed I'm actually trying to pass the RMColumn.Description or RMColumn.DataSourceID in to the text at the top of the report. For ...

Hi @jlange Do you happen to know how to get the Attribute for Description to flow into a Report.GetBranchName() per chance?

@kingcarlos Oh and he will 😉

@kingcarlos Thanks for the link. I will have a look and see if anything jumps out. I've already got a json get script working using Power Automate,...

Hi @ncarrier, I too am looking into the same subject as well. It seems that the custom connector is possible, but just can't find the correct syntax...

Hi, Did anyone ever get this working with Outlook Online for MYOB Advanced's version

Hi, I was just on here looking for Company Group suggestions on report and thought I would answer this query. If I'm not missing the context, I th...

Hi @busyfritz, I'll check this out in the morning and I can see the joins in the xml, so that might help. I can also see the IIF field for Availabi...

Hi @brandi-buff, Thanks for your reply. I had managed to replicate this query in MySQL using the left (or right) joins based on the Tables. I think ...

Hi @rh26, I know I'm very late in play here, but I managed to get things working using. This will display the Project ID and description as a line. ...

@timrodman I have figured it out, so I had to post this for syntax purposes and for future head-banging. The trick to this screen, as mentioned be...

@timrodman That's a bugger. I will have to look through Acumatica Training guides and videos to hope that I find a something. I will not be defeated 😝

Hi @timrodman, Did @josemar-garcia-mba ever come back to you saying they had fixed the Import? I'm struggling with the same problem and tried what y...

The next trick would be how to use the Add Items via the scenario. I just tried a few ways, but couldn't figure it out. This is what I have got so f...

@timrodman I've just run the same Import Scenario that you just mentioned and it works like a dream. I had to pinch myself to make sure it had worke...

@knosretap I'd be happy to PM and give you a little insight. Sorry for the delay as well

@timrodman How would I be able to add say 3 months onto your following code. My parameter is called @StartPeriodID. =Format('{0:MM-yyyy MMMM}',CD...

@kevin-ruppert This helped me searching for hours. Awesome bit of knowledge and probably relevant for most of the Forms in the system. 😀

Hi, I thought I would throw my hat into the ring on this. I've just created a negative Document discount that the user will chose to add at the ti...

Hi Joe, I would first say that you probably don't need a sub-report for this type of report. You can get away with Grouping to show what is in the E...

@timrodman Thanks for that Tim and I think we did that in the end. Digital Metaphors Report Builder does the same thing as Crystal, so it's a case o...

Hi @gustavo-carrasquillo Glad to hear 😊

I've figured it out now. If you add [ARHistory.FinYtdBalance]<>0 to the VisibleExpr, then it hides any account with 0.00 YTD Balance. Managed ...

Hi @megan-friesen, That is good suggestion and I think I might have to go that way. I did think that might be an easy option to start off with, ho...

@timrodman Way better than above 😆

Hi @timrodman, I've figured how to get around the problem now and it is super simple. previously I mention that using IIF([ARTran.drcr]='D',-1,1)*...

Hi @timrodman Thanks for the reply. Below is what happens when you put the =SUM(IIF([ARTran.DrCr]='D',-1,1)*[ARTran.TranAmt]) into the Sort By are...

@dwilkins Hi Dan, Thanks for your reply. The problem isn't the code, it is the Sort Order. you can use either of the above codes to get negative amo...

@gustavo-carrasquillo I believe that you can do a Total Aggregate Function for the field in question using SUM, however this only diplays at the bot...

Hi @timrodman, I'm trying to get the Dashboard Parameter to flow through to multiple GIs, but I can't get the Dashboard Parameter to work. My main q...

@ellie Unfortunately not. We are trying to do this in Report Designer only. We can potentially do it using Visibility setting having one data field ...

Hi @jlowry, I think the setting that you are looking for is inside the Service Order Types area under Time Behaviour tab. There are two settings tha...

Hi Brian, From my experience I just use the a Sequential Number in the excel file. For example if I'm importing Projects then I set Ref Nbr to Proje...

Is there any way that an Attachment against an Invoice, can automatically be attached to the email? This is a feature that would allow for attachments...

@timrodman I just wanted to say that this Active Relation join saved my mind today. I knew you could multiple the same tables with an Attribute ID, ...

I managed to figure it with help from a Guru. Very simple and obvious CSAnswers.RefNoteID=FSAppointment.NoteID

Hi Julian, I would suggest having an open route i.e. Melbourne, then pick that in the Route Document Details section. Create a new Route Create...

Hi Carl,I've got quite a few import scenarios for Service Management:- Service Jobs, Service Contracts, Service Contract Schedule Vehicles, Manufa...