I think uses the Object on the first line that you list on the RESULTS GRID tab. In my example below, ARTran is the first line so if I view the inquir...

This would be a perfect situation for a Variable. Just keep adding the Variable to itself.

Good point Royce. I was hoping that you would have a field like "Current Approver" that would be dropped on the FIELDS tab. I agree with you that Auto...

Are you trying to access the Generic Inquiry definition or the result set? If the result set, any reason why you're using the API instead of OData? I'...

Ah, I see. The only way I can think of without doing a customization would be to use a technique that I learned recently. Basically, setup an Import S...

Interesting that the formula didn't work. But your variable method totally works. Nice job!

Wow, thanks for pointing that out. That looks very promising. Seems to me though that it's missing Warehouse since technically discounts can be set at...

Thanks for the kind words Ted. Sorry I couldn't help on this one.

Hi Kristin, Try joining from ARTran to ARInvoice on ARTran.TranType=ARInvoice.DocType and ARTran.RefNbr=ARInvoice.RefNbr. Then join from ARTran to SOS...

I've seen this happen before in multiple browsers a while ago, but I can't remember if there was a solution. All I can remember is that it wasn't a br...

Are you auto-numbering your Items? I'm trying to figure out why it's adding new ones instead of just updating it if the Item ID matches. I personally ...

Also, note that in Acumatica 2018 R2, they created a separate screen specifically for Landed Costs. Go here and scroll to page 93 for details:

Hey Daniel, I think this is what you are looking for. Feel free to add your vote:

I tried it on 18.104.0023

Interesting... I wonder if maybe it had to do with this change from the Release Notes on version 17.203.0029 AC-82947: The Customer Statement (AR64150...

I added an idea that you can vote on for making this easier. Basically, the idea is to add a Create Task subscriber to the existing list of subscriber...

Also, this video mentions a beta integration in Acumatica 2018 R2 with ShipEngine which supports DHL

Ah, I see. Is it only closed invoices for the current period? Can you share a screenshot?

I just tried and failed. I think my trouble is with the Dialog Answer which doesn't have ADD & CLOSE as an option:

Are you running Acumatica 2018 R2 on a Production site? Hopefully not as Acumatica 2018 R2 is still in beta.

Ya, the test license for Acumatica only allows 2 concurrent users. I wonder if StarShip is logging out after making a connection to Acumatica. You can...

I'm not sure how major it would be. Depends on where the change would need to be made in the code. You'd want to get a quote from an Acumatica develop...

For the week, what about joining over to the DateInfo Data Access Class (DAC) and grabbing DateInfo.WeekEnding? For the prior year attendance, are you...

Generic Inquiry as a Data Source seems like an interesting idea, but I don't see Generic Inquiry listed in the Provider Type field on the Data Provide...

Hi Ted, Have you tried unchecking the Break on Error checkbox on the Import by Scenario (SM206036) screen? Also, is the Commit box checked for your li...

Hmmm, sounds interesting, but I personally don't have anything. I always run everything through Excel using Power Query and then make Excel my Data Pr...

FYI, regarding international shipping, I saw this section this blog post about Acumatica 2018 R2 and wondered what it was: So I checked the Release...

Hi HappGilmore, Try switching to HTML view like this: Then paste the results here. I was able to get foreach working in another situation: One thing ...

Could be a bug in your build of Acumatica. Or maybe it has to do with the Import Scenario definition. I was able to get it to work with this definitio...

Windows has been pretty good for me the last few years, but this kind of thing makes me remember more difficult days with Windows. If it does indeed w...

Thanks for sharing the video Ellie. For now, maybe you could to a negative line using a Non-Stock item?

Can you attach your .rpx file to this post?

Awesome news Gabriel. Looking forward to seeing the full roll out.

Unfortunately I think you would need a customization for #2. Not completely sure though on #1. Sounds like you want to update the Status when the Stat...

I'm not sure that this is possible. I recommend adding your vote to this:

Two thoughts: 1. Try moving your <Dialog Answer> line to the first line in the Inventory Lookup section. For some reason, those normally need to...

Do you get the same error when you paste the URL into your web browser? I usually test in the browser first to ensure that I can see the OData results...

Myrcenary, I like your idea. If I understand you correctly, I think you are suggesting to calculate the Freight Cost manually which can be done based ...

I haven't tried that many lines in a Unit Set but the performance you are seeing doesn't seem that surprising to me. From what I can tell, it has to r...

That could be it. Maybe Break can't be used with Delete.

Thanks Carl for sharing. Looks like your instructions can be used and then just changed to include the Owner rather than the Approver:

Hi Daniel, Does this formula work for you? =Report.GetDescription('OrganizationBranchReportParameters.BranchID',[@BranchID]) Note that in Acumatica 20...

Hi Vidhya, Can you outline what the Purchase Order looks like and all of the transactions that have been entered against it, including each one's impa...

Hi Matt, It sounds like you want to use the Shipments (SO302000) screen for both shipments to Customers AND shipments to Vendors. Is that correct? As ...