Hi Animal, First of all, let me explain that Acumatica's name for Credit Memo is actually Debit Adj. which is a little weird. When you go to the Bills...

Ah, I hadn't even tried printing. I just tried it and got an empty form like this: Is that what you are getting?

Absolutely. I hope you were able to get everything working the way you wanted it.

Hey @sunwayfan, It looks like you actually attached the .RPS file, not the .RPX file. Can you open the report in Report Designer and save as .RPX? Tha...

Are you using Lot or Serial Number tracking? I believe that multiple Lots or Serial Numbers would also cause that column to show <SPLIT>.

Yikes, good luck with that! That sounds like a big headache. You might just try installing Acumatica 3.0 on a machine somewhere and taking your own sc...

Totally agree with you @shawn-slavin about discounts. That would be dangerous to try and reproduce in a Generic Inquiry.

Cool, glad to hear that worked. If you're able to share a screenshot of your report (with the numbers modified of course) I would love to see it. I'm ...

I agree with you @shawn-slavin, Create Batch Payments is normally what I see in ACH situations so the NACHA file gets generated automatically. But, @b...

I'm not that knowledgeable about Avalara, but doesn't Avalara charge per transaction? Wouldn't that allow them to make sense even in low-volume situat...

Ya, so many problems with ERP systems are actually related to process, people, and politics, but of course the software gets blamed for it.

Good call on the conditions @michael-hansen. It's possible that there is some bad data causing the error, but it would only give you the error if the ...

No problem. I got your back. Google searches can never 100% do the job that people can.

Ughh. Sounds kind of buggy, like a job for Acumatica Support. Does this only happen on one GI? What Data Access Classes are you using on it?

This reminds me of a post from @daniel-o who was trying to do something similar: Checkout that post. There is a screenshot in there that I think will ...

Hi Bodonna, I'm not sure I understand. Can you take a screenshot of the Payment Methods (CA204000) screen for your ACH payment method? As far as I ...

A customer moving from Sage 500 (MAS 500) to Acumatica? 👍 👍 👍 👍 👍 👍 👍 👍 As far as taxes are concerned, I remember the FOB affecting taxes in Sage 50...

I think a screenshot would still help me to "see" more clearly. But I think I get what you are trying to do. You want to fix the month (ie December) b...

I agree with Michael 👍

Absolutely. A picture is worth a thousand words. 😎 Just note with Customization Projects that they can get complicated really fast. In this case tho...

O wow, that looks kind of buggy to me. You'll probably need Acumatica Support on this one. But maybe the information in the Trace will say something h...

Awesome! Glad to hear that did the trick.

Ah, knew I was missing something. What if you just added the Status field to the screen? You can add it with a Customization Project. All you need to ...

You and me both Dan. I wish it would display a total. This is actually a fairly popular request. You can add your vote here: Note, the suggestion has ...

Thanks for the screenshot. Very helpful. Let's zoom in on your AgeBal00 and AgeBal01 formulas: AgeBal00 = IIF($DueDate < @AgeDate And $DueDate >...

I haven't, but I would think that creating such a detailed report in Report Designer would be doable, just tedious. With Bills of Lading, if there are...

Glad you were able to figure it out. Just curious, did it have anything to do with the Include in Qty. Available field on the Warehouse Bin Location?

Thanks for the feedback John. Much appreciated.

Hi Giorgi, Try clicking the ADD PO LINE button and pasting the PO in the Order Nbr. field. Does anything appear in the grid?

Have you tried Approval -> OwnerID -> DefContactID -> EMail? This is what is setup in the SalesDemo database:

Ah, I looked at this too quickly. I was looking in the Price Type column, but there are actually separate columns for UOM and Warehouse (pictured belo...

Perfect. Thank you for sharing your fix for the problem.

Joining tables together is by far the trickiest thing about building generic inquiries. I used to try to teach people how to do it, but eventually set...

Hi Tanya, Great to see you on here. I think the UOM is required because it's a required field on the item setup screen. And it defaults from the item....

Sweet! Glad it worked out. Also, just in case you don't already know about Inspect Element, check this out:

I was just trying to get the Automation Steps idea to work, but I'm not able to do it the way I was originally thinking. Then I realized, is there any...

I was thinking to turn YYYYWW into the last date in the week, but then I had a the same "good enough" thought as you. Extra work for something that ma...

Hi Emma, I think the issue here is that JPMBillingRule.JPMBillTypeID is actually a integer (System.Int32) whereas Fixed Price is a string (System.Stri...

I'm not 100% sure that there isn't a checkbox lurking around somewhere, but I doubt it. The Kit functionality is pretty light. You might look into the...

I would think that something like this is possible to do. Can you describe a little more about what the finished report should look like? Also, I'm mi...

Hi Taylan, Just to make sure I understand correctly, are you talking about the ENTRY POINT tab on the Generic Inquiry (SM208000) screen which allows y...

Hi Daniel, I guess the problem here is that there is no "shipment" transaction in the Shipments (SO302000) screen. The "shipment" record is really in ...

Nice one John! 👍 And thanks for sharing your solution.

Hi Grant, I agree. I think you'll probably need a SQL View for this. No egg needed though 😀 The financial period is actually stored in the ARRegister ...

At first I was thinking that you could do something like this: But then realized that of course that won't work. You could do something like having...

Hi VJW, Where do you see those options? I don't see them on the Sales Prices (AR202000) screen. Maybe are you talking about Discounts?

Good move. Just curious, did you also have to set the Schema Field column to something that is a string? Also, are you looking to translate WeekID int...

Hmmm, I just upgraded to 18.100.0049 and I don't have any issues. I added two parameters to the Controller dashboard which you can see in the screensh...

So, I can randomly select multiple items by holding down Ctrl on my keyboard and clicking on the various items?

Very cool. I like it.