Unfortunately there are some fields that only calculate in the screen and this is one of them. I'm not 100% sure, but I think the reason for it has to...

Any reason why you wouldn't use Issue and have someone just pick the correct Subaccount? You could still drive Account from the Reason Code. The Issue...

Naw, just $35. It's a nice feature to have so it's worth it.

Hey @michael-hansen, I went ahead and bought the PM feature. You can use the icon highlighted in the screenshot below on a post to send someone a mess...

Hi Levan, I wish I could help on this, but I don't understand the Tax Module well enough at this point.

Hey Fozzie, When you open Excel files from an email or download one from the internet, Excel goes into protected mode which you can see in the yellow ...

Cheating is welcome here 🙂

I wish the file attachment feature in the forum worked better, but we're stuck with what we have for now. I actually don't use the attachment feature....

Hey Michael, You're killing it with the forum participation. Love it! I agree with you about variables. If you can use something like Sum() instead it...

Excellent. Glad you got it working. Some people install the MICR font on every client machine which is a pain to maintain going forward. Getting it wo...

Thanks Julian. And hopefully the SEO feature in the Forums works well so people searching Google in the future can find this post.

I usually import it from Excel as a journal entry into the Journal Transactions screen with every line hitting the Cash account so there is no impact ...

Thanks for jumping on this so quickly Michael. As far as I know, the only workaround for the negative thing would be to create a row that pulls the va...

You can do a Prepayment authorization on the Bills and Adjustments screen and cut a check to an employee (both employees and vendors are available the...

@RowCode just returns the code of the row, not the value in the row. So it works great in a true/false test, but not to return a value. But I think yo...

If it displays within Report Designer, but not when you print the actual check, my first guess would be that the MICR font has been installed on your ...

Nice job. Looks good.

Agreed. Would be easier to see what's going on with the .rpx file. The screenshot of CurrTot is set to a formula of 0 which of course will always be 0...

Hi Levan, I experience the same thing that you do and I can't think of a solution other than doing a small customization on the Bills and Adjustments ...

Hey Joseph, You could do something like this, assuming Row 0030 and 0040 in your Row Set are the rows that you want a different calculation on: =IIf(@...

Hey Gonzo, I'm not 100% sure, but as far as I know this is not possible. You might want to vote on this suggestion to get it included in the product:

I'm not sure what the current BI360 live connector for Acumatica looks like and what modules it covers. BI360 normally pushes you towards working with...

I should mention that I don't know for sure that it's not possible through an Import Scenario. I just personally don't know how to do it.

Thanks for linking to that post Michael. As I mention in that post, I was able to do something like this with Microsoft Flow and the Acumatica REST AP...

Hey Shawn, I'm not exactly sure why, but some DAC fields are too complex to be filtered on. "Too complex" is my explanation. Something is special abou...

It would definitely be cool if you could generate HTML. It would open up a lot of possibilities. But I could also see there being situations that woul...

Cool. Hey, as long as it's working, that's good enough for me. I was just curious 🙂

Thanks so much for chiming in on this Michael. I'm not sure I have much more experience on these variables because I try to avoid them as much as poss...

Are you always running this for the current month and are you using Excel 2016? If so, then you could get the 13 months if you use the Power BI functi...

I can't think of a way to speed it up. Unfortunately OData can be kind of slow. You could use Power Update to refresh it for you overnight as long as ...

Hmmm, I've seen this before, but am trying to remember the specifics of it. Would you be able to attach the main report and the subreport so I can tak...

I have seen this done. I reached out to the partner that I saw it at to see if they would like to share. If I remember correctly, there were a lot of ...

I'm not sure how to put a hyperlink in part of a text field. As far as I know, the entire text field has to be a hyperlink and it can only link to one...

Hi Gonzo, Since we're in Excel with Velixo Reports, there are probably multiple ways to do this: using an Excel Add-In, using VBA code, etc. But I pre...

Awesome. Thanks for the feedback.

I just added my vote and also added a comment with an idea on how to implement it.

Hey Michael, Welcome and thanks for posting here. You could try adding a field to the grouping like this: 1. Open the Groups area: ...

Thanks Gabriel. That fix worked for me. I just created an Excel file and imported it into a screen successfully.

Thanks for the heads up Myrcenary. I actually had the same issue yesterday coincidentally, but I didn't realize that it was because of Velixo Reports....

Sorry I haven't been able to respond. I should be able to this weekend.

Hmmm, not exactly sure what you mean by 13 months. I forget, is your fiscal calendar 13 months? Do you have a screenshot of the pivot table that you...

Thanks for following up with the explanation. Maybe you just need a customization to take Volume out of the calculation equation. Or use a Stock Item ...

Ah, ya, likely you might want your partner to help you build the Dashboard widgets anyways. Sometimes though the hardest thing is knowing what you'd w...

It's a difficult account to reconcile unfortunately. The easiest thing to do is to keep it reconciled moving forward. One idea is to drop the GL Trial...

Are you using an Import Scenario? What kind of data source are you using (CSV, Excel, etc.)? I just tried it using an import scenario and the Excel ...

Hi Karen, It's been a while since I've looked at this, but one thing I remember causing a problem is Purchase Orders that are closed manually after ...

Hey Animal, You can definitely do this and it's a great idea too for the reason that you mentioned: Server-side filtering is faster, especially when t...

Are you getting something like this? Additional technical information:Correlation ID: 74711a33-f0da-431d-af42-f53fc320bf0eTimestamp: 2017-11-25 02:59:...

Hi VJW, As far as I know, that's the intended behavior and the reason for the Blank Lines To Append field on the Prepare Physical Count screen: It wi...

You would use the URL of your Acumatica instance instead of (I was using that because Acumatica is running on my local computer). But, something has ...