I think this could be accomplished through a custom report or custom generic inquiry. If you are starting from the GL you would need to link back to...

From my perspective as a SQL developer, I often get frustrated when working with Generic Inquiries and Report Designer because what would normally be ...

@nburton Hello Nicky, I would be happy to discuss your needs and requirements. Please contact me at your convenience for a quick chat. Regards, ...

Laura, Have you tried using the Switch function instead? You might also consider setting up your defaults in the Departments under Organization un...

The resolution to this issue was not in the Column Set but rather in the Row Set. A user had added a row referencing another row without the "=" sig...

If I cast them to Double I get tis error: An error has occurred while the CDbl(Identifier(B)) function was being executed:'Input string was no...

Hi Dianne, We have added a couple of accounts that do not have transactions yet. I have tried forcing a zero value of the column is null but that ...

@infosourcing, I am curious as to your requirements for the GMROI calculation. Would you mind sharing your requirements?

I created a generic inquiry to calculate DSO trend for 360 days and 90 days based on AR data. You can download the instructions and the GI xml file ...

Tim, I think videos are easier and faster to absorb than simply written instructions. A video allows the viewer to listen and follow along on the sc...

I just finished the Pivot Tables section which much more useful than the training documentation provided by Acumatica and easier to get through as wel...

Tim, I finished the lessons up to the first Pep Talk. Your format is really good, concise and very easy to follow and understand. Even after spend...

It should be at the bottom of the login screen

I think I recall hearing something to that effect at Summit. I believe that is on the roadmap for a future release but not imminent...

I am working on a similar request for one of my clients. Once I have something concrete I will share in this post. If I were to do a report I would st...

Well it has been an interesting journey into the bowels of Acumatica and I have discovered the following which has been confirmed by Acumatica. If y...

I am new to Acumatica as well and I am spending a lot of time reviewing out of the box reports to gain insights into how Acumatica themselves create r...

The response from Acumatica was not encouraging. Basically they do not have an established standard and suggested to look up the forms, generic enqu...

I would like to see a more robust Pivot Table engine with more functionality such as adding calculated fields and more flexibility in creating present...

Thanks for the prompt response Wyatt. I have asked Acumatica if they have documented best practices on the subject and I will post their response to...