Hey sunwayfan, Unfortunately you can only use the ARM report writer for GL data. Are you trying to report on AR data so you can include Customers and ...

What if you use a combination of Len and PadLeft? Len will tell you the length of a string. So you could use Len on A000000001352107006700030142900160...

So you want to pad it with spaces, but you could need a different number of spaces depending on how long the number on the left is? Do you always know...

What would you want the end result to look like? Are you trying to create an amount like this where there is a variable number of spaces between USD a...

HI gojok, Yes, you could do this. You would create 4 separate segments in the Segmented Keys screen and only check the Auto Number column for the numb...

Hi Piggy, If you are trying to enter a new line in the Bills and Adjustments screen, you should only be seeing items that were entered in the Non-Stoc...

Hey LarCigar, Novices welcome here. I'm still a novice myself, learning something new about Acumatica every day. If you put the branch in the @StartBr...

Hi Brian, I would think that you should be able to add the primary keys for the service order (probably OrderType and OrderNbr) to the Grouping tab in...

Hi DWS253, Would it be ok to require the branch logo's file name to be something specific (eg. "Large Logo.png") when it is uploaded? If that would be...

Hi Piggy, I personally like to configure Acumatica so that "Release" and "Post" mean the same thing. I even use the two words interchangeably. I like ...

Thanks for letting me know Michael. I'm glad that worked for you.

Ah, now I understand. What about using OData to build it in Excel and use the feature in Excel that forces the report to be 1 page wide?

Hi Fozzie, I think the problem is due to a misplaced closing parenthesis. Try moving the closing parenthesis highlighted below to the end of the formu...

Have you tried setting the Excel Cell -> Width value for each cell?

Hi Baraboo Bob, Can you attach the Report Designer report .rpx file that you are working on? I'd like to take a look at it to see if I can think of so...

I wonder if this is just a bug. It looks like someone else has already discovered it and created in Idea on the Ideas Website (click here). Might be a...

Hi shirsch, You are correct. There are a few ways that I can think of to handle this: Setup a separate user for each Branch in Power BI. Then setup se...

Hi Piggy, Yes, you can definitely do this. Actually, you can do this whenever you see the following icon on a screen: What I recommend doing is enter...

Scratch my comments on SaaS. The more I thought about it, the more I thought maybe you could do it in a Customization Project. And it looks like you c...

Hi Piggy, The reason you are getting this message is because this financial period has been closed for the Accounts Payable module. You can see this i...

Hi Piggy, The reason you are getting this message is because the Active column is not marked for October 2017 in the Financials Periods screen: Whoev...

At first glance, are you sure that it works if MasterRefNbr in the screenshot below is blank, but not null? I'm wondering if it could be blank on a Cr...

Can you attach the .rpx file?

Hi Piggy, Great question. I've always wondered this myself and your question forced me to go do some research. Let's keep this example confined to AP ...

Other than the official course on ARM (click here), the best advice I can think of is to look at the explanations of the expressions available (click ...

This is pretty clunky, but what about something like this: =MonthName(DateAdd(CDate(Left(@StartPeriod,2)+'/1/'+Right(@StartPeriod,4)),'m',0)) =MonthNa...

Does the DPL12 (Profit and Loss Rolling 12 Month) report in the SalesDemo database get you what you need? The formulas look like this: Or would this ...

Hi Piggy, You define each segment and the length of each segment for the Account and Subaccount fields by going to the Segmented Keys screen. There is...

Great question Beaker. And, don't worry, it probably took me even longer for this to occur to me. There is a great section in the F350 course on this....

Just curious, I wouldn't think that the Parent/Child tables would matter unless you were doing a Left join. Were you doing a Left join?

Hi nheuer, It works for me: I'm using Acumatica Build 6.10.0472. Maybe it's a problem with your Relations tab? This is what I used:

Hi Fozzie, I still wonder if someone has done a customization for this, but I don't know of a way to do this out-of-the-box. The only workarounds I ca...

Hey DWS253, Try POOrder.NoteID = EPApproval.RefNoteID. I would be concerned though about doing this join because Acumatica is setup to allow multiple ...

I would use AR Invoices if you only want to analyze sales that actually took place and not include sales that are going to take place in the future. I...

Hi HappGilmore, Let me say that the post you linked to was written over 2 years ago. So I had to go re-read it first 🙂 Also, before I get to your que...

Awesome. Glad to hear it. Hopefully Projects settles down in the next 1-2 years so there won't be too many backend tables changes, meaning better data...

And what sales data are you looking to analyze, Sales Orders or AR Invoices?

Shouldn't matter that you're using MYOB Advanced as far as I know. Can you browse through some products on the Stock Items screen and check the Vendor...

Hi Potato_Ghost, Just wanted to let you know that I did look at this, but it's a little over my head. I don't understand the flow of the Projects modu...

Hi mmaxwell, Some questions: By Supplier do you mean Vendor in Acumatica?What is the connection between the Customer and the Supplier in Acumatica?Are...

Hi Egates17, I've had the same issue with subreports in the past. I remember there being some differences between the PDF and HTML formats, but can't ...

Hi Gojok, You can absolutely go live without a General Ledger Trial Balance and bring in the balances later. In fact, that's usually what I see becaus...

Hi Piggy, You can control the formatting of the Due Date column by using the Format property. To remove the Time, you can use the following format pro...

Just wanted to provide an update on this. I haven't been able to test this yet, but it appears that this was a bug and it has been fixed in Acumatica ...

Cool. I'd love to hear how things turn out for you. Also, for some reason, whenever I see an Income Statement get broken into multiple columns like yo...

Hi Potato_Ghost, I love the scribbles on your screenshot. Would you be able to attach the Report Designer report (I think I finally got Attach Files w...

Hi Debbie, In my opinion, Acumatica has an overall philosophy: They make the technology tools, then they stop and let others build with those tools. W...

Is there any dynamic data in the additional page? If not, have you considered using a Report Footer section?

Doesn't look like there can be a negative indent. I can't even type the negative symbol in the Indent column in the Row Sets screen. But I think I fig...

There are a number of DACs out there that get populated at run-time by some code in a screen so they are empty in a Generic Inquiry or Report Designer...