Thanks for sharing your solution Jim. With your FAIRYDUST and POTION, I was hoping the solution might involve a magic spell. Oh well...

Hi Aaron, Assuming that one Item could have multiple Country of Origin values depending on when it was received, you could turn on Lot Tracking and th...

So your General Ledger module balance doesn't equal your Inventory module balance? I would go financial period by financial period until you find the ...

I've noticed a few issues with Dashboard Widget drill down, most recently when a Switch formula is involved. The DRILLDOWN filter that got applied to ...

Hi Siva, I just reproduced your issue in 19.101.0084. If you create a Sales Order for a serialized item, quantity 5, and allocate 5 serial numbers to ...

Ok, I think I see what you're trying to do. Let's take the DPL report in the SalesDemo database. It has three columns: And the report looks like th...

Hi Berenice, Are you loading the Trial Balance into the Trial Balance (GL303010) screen in Acumatica, then clicking the RELEASE button to have Acumati...

Hey @joe-morris @anna-borisova @thomas-libby @aaron-thomas-cpa-citp-cisa-cism-crisc-csf @steve-wynn @arline-welty Welcome to AUG!

What version are you on? I just tried on 19.101.0084 and it worked. Have you thought about just building the Pivot Table in Excel using the OData conn...

Was UploadFileRevision.FileID the one that you were looking for?

Hey Peter, What you are getting is just a warning that the query could run slow. I wouldn't worry about it unless it's taking a long time to run. The ...

I wish we had a GetPeriodEndDate function in Generic Inquiry like we do in the Financial Report Writer:

Thanks for the feedback Royce. I hadn't noticed that since I login via a different method. Let me see if I can extend the cookie expiration to 30 days...

Hey Patrick, 1. Regarding merging, unfortunately it's not possible to merge Vendors, you have to just pick one to move forward with and make the other...

So taxes get calculated on the Sales Order the first time and are added to the TAX DETAILS tab on the Sales Orders (SO301000) screen? Then when you do...

Have you tried checking the Active checkbox on these two lines?

I just checked and Acumatica doesn't have FileGetter.aspx (love the name by the way). That's a great idea though. I updated the Acumatica Feedback sit...

Interesting scenario. That would be cool if Acumatica was smart enough to generate the inventory adjustment, but I don't think it is. You could do thi...

You aren't getting this error are you?

I've had the issue where they are blank when you click into them from a screen, but if you click the article on the left-hand side it appears. Not sur...

Can't you create Parameters in the 2nd inquiry to receive those dates, then add the Parameters to the NAVIGATION tab so they get populated when you dr...

Haven't tried it. Are you expecting Is In to provide additional functionality above and beyond Equals?

I just tried and wasn't able to figure it out either 🙁

It should just be a matter of populating the NAVIGATION tab on the Generic Inquiry (SM208000) screen, then selecting that navigation entry in the Navi...

I think you're getting that error because the way you have the Import Scenario setup is telling Acumatica to add a new line to the VENDOR DETAILS tab ...

I totally agree with John. Make sure you have a good test script of things you test in the upgraded sandbox environment, then keep adding to that test...

I agree that it wouldn't make sense for dates, but for a text contains function search this post for "substringof" I'm not sure though if Acumatica h...

I haven't but, honestly, I don't have that much experience with it. In theory I would think it would communicate with Outlook and it wouldn't matter w...

What about a Parameter that is hardcoded to true, then put all your logic on the left-hand side and have it evaluate to true/false, then select the Pa...

It wouldn't be cummulative, but you could at least group the GL Entry and PO Receipt transactions by date and look for the dates that have problems.

Agreed, it doesn't look good. Google has an interesting take on Beta software:

I haven't, but it seems like a good idea. Is there an official NCBFAA number for the form? If so, it might be helpful to include that so others search...

🙂

Yes, that's what I meant. That was our experience. Maybe there is a way around it though. Hopefully...

Cory, On your bcc question, I can't see how that would work in Acumatica unfortunately. I've used the feature where Acumatica reads incoming email and...

Are you listing the Quantity before the Unit Price? Can you include the JSON that you're using?

So you want to see the same Item listed multiple times, one line for each Item/Warehouse combination, with the available quantity displayed on each li...

Cory, On your bcc question, I can't see how that would work in Acumatica unfortunately. I've used the feature where Acumatica reads incoming email and...

As long as it isn't taking tons of time to run, I can't think of a reason why running it on a schedule would be a problem either, but I agree that it ...

Interesting. It's a pretty simple app from the user standpoint, no settings that I can think of. I don't use the Android app a ton, but I do use it an...

Hi TC, You could use field level security to make that field View Only for regular users.

I've heard of some people getting random OData errors, but it hasn't happened to me so I don't have much to contribute unfortunately. Do you get the s...

Awesome Akemi! Thanks for taking the time to leave a comment.

There's a course on Acumatica University on Report Designer: Regarding your Page Header issue, can you attach the .rpx Report Designer file here? For...