As a definitive answer to your point: Acumatica does NOT block customizations.You are likely blocked because your privileges got overlooked, your admi...

Glad it's working for you! Having unknown errors can really rain on your parade.

I have NO idea if this is your issue, but I don't structure my joins like that. For that same GI I would use: SOLine Left InventoryItem SOLin...

Use InventoryItem.InventoryID, which is an integer value for your items.

If you want to "nest" tables like that, the report writer will allow you call a sub-report(s) and it's pretty phenomenal. You can pass in params from ...

Well now, this IS interesting. I dumped the table with those emails (having made two for this test) and at the onset the only difference between them ...

[bad joke] The attachments... [/bad joke]But seriously, it looks like you may have forgotten to attach the images of your setup. Would you mind repost...

You have tables in your GI that I don't have in my system, so testing is not super feasible on my end. Tim will likely be hopping back in here again. ...

I don't have your rpx/xml so I can't test this, but can you try this line? I've explicitly contained both sides of your AND in parens as I'm not sure ...

That stuff works just fine, but the syntax can be rough at the start. I would suggest using the conditions tab and choosing the "is between" condition...

Thanks for checking on that Tim! I can't wait for my WMS to catch up in Acumatica so I can get this update rolling for my people, they'll be so happy.

Upvoted. I'm not in that version yet, can the same be done to PO's?

+1 for posting that and +3 to Doug for making it!

After reading your link, I can see some differences, but for this specific case they're oddly synonymous. I would love to get my hands on a list of pe...

This is one of the most infuriating things I have come across in our system: It allows you to select virtual tables, or "Views" in SQL. You cannot acc...

So he's not altering an AR screen, he's altering a Work Calendar screen, specifically, his work calendar's exceptions tab. The class for data in that ...

Link to idea post for exporting images should anyone else care to get this feature:

Thanks for the image tip. Yeah I don't know how terrible that excel export would be as images don't live "in" a cell, they live above it.

If you can post the .rpx file, it'd be super helpful. In lieu of that, I'd like to see a screen shot of your relationships table and the relation ship...

I'm glad you found your issue! I find I often have to start removing segments of reports as well when tracking down some of those duplicity errors. If...

My company is still being gated by a 3rd party from entering R2. So I know very little about any changes on that system.

I wish I could provide more help, but since all my currencies are in USD (we don't even have the currency module running), I just get a single total t...

When I have this error, it's usually an issue with my table joins, but yours appear to be clean at a glance. You have two footers for group 1, I would...

Hmm, I see you don't have a report footer. Maybe try adding that? Right click the report, then select "report footer". Add your totals to that footer....

I think you're really close! If you copy your lines from your SubTotals and place them down into the next footer, they should give you a grand total o...

To summarize a group, you generally go "up" a group and then take a sum of the fields in the previous group you needed. As an example: Header Group2...

Hello nheuer! I've edited mine extensively, but let's assume you've included the SOOrder table in your joins on the invoice report and start from ther...

This is a 3rd party site, not Acumatica itself. Everyone here works together as volunteers to support each other with ongoing issues. It sounds like y...

Thank you very much. Hope it didn't hurt your wallet!

Bit late to the party, but a private messaging system would be great, especially if we could run attachments. Some of us may be a bit averse to sharin...

That is what I tried, but the base 64 encoding creates a larger value than a single cell in Excel can hold. You can find the encoders online for free....

Attached are snippets from an invoice document with a working aggregate in the footer. I'm not doubting you, just wondering if I have a specific insta...

That is so cheating. I've used imgur before, I didn't think we could just slap in the URL here. Thanks for the tip. I was starting to feel bad about p...

And now I have a watermark. Thank you Julian! The logo was easy, I had no idea about back images. Thanks fnshem for posting your question.

So, off the cuff. You have a line who's value you wish to SUM that is being represented by a variable $DocBal, which is just: =[ARRegister.SignBalan...

Oh snap, I thought you were in the report writer. My apologies. I don't work inside the financial report writer (just not my job right now). Tim can h...

That field, let's call it "DelRev" could be modified to be DISPLAYED as a negative, but you'll likely need to tweak any sums to reflect this. I'll cov...

I think you want the value to be a sum of some of the other variables. Without seeing your .rpx file, it may be something likeValueExpr: =$AgeTot00 + ...

I am also interested in a solution for this. I tried converting my images to numeric values (which Acumatica supposedly accepts), but the length of th...

Well I've never used the assign function before. That's an awfully slick way to override a variable. I'll be keeping that one in my toolbox. Thanks fo...

My process order is set to "always" on my variable, yours is set to "while read". Might be worth trying a quick toggle on that one, just to see if it ...

I think you need to edit the variable and give it a "resetgroup" property. That tells the variable to reset itself after a specific event. It fixes is...

That is perfect. I split the groups into two, just for simplicity for myself, but your solution is perfect. It now sorts according to plan!