Solved

The Rocky Mountain Acumatica User Group (RMAUG) is based in Denver, Colorado.  Currently the RMAUG is integrated with the Acumatica User Group community.  The RMAUG has been in hiatus during the Q2 & Q3 COVID Pandemic. The Q4 2020 plan is to be coordinated with the Acumatica User Group community.  Stay tuned for future updates.   

Has anyone solved the issue of how to license their customization that is aimed at a specific vertical in order to retain control of their IP?  We’ve been spending a lot of time working on our vertical specific dashboards, reports, and functionality during the last few months and now need to work on how to create a licensing process that will allow us to ‘turn off’ that functionality once a license expires.  We saw an example at Summit but I’m wondering if anyone else has been working on this or has an efficient way of accomplishing this.

I have created a sales analysis query using sales analysis.My query showing Customers - products - qty sold and amount of sales.I am trying to make the report provide total per customer, I can see that when I collapse the customers but do not see the total when taking the report to excel, any one experience on solving this issue?

Can we attach files and videos to topics?

I recently submitted reviews for Celigo and it’s been more than 2 weeks since I did this, is this even working? who approves the reviews? Just following up as we had few our clients submit review for our plugins as well and they don’t appear either … I have sent emails as a follow up, thought to share if this catches someone’s attention ….https://www.acumatica.com/acumatica-marketplace/celigo-integrator-io-ipaas-integration-platform/

How do I see the progress on my previous ideas submitted on the old forum?

Hello,    We are calculating commissions based on profits of each AR document.For example, if the total prices of 1 invoice is 1000, and the total cost of all the items on invoice is 800, then the commission would be calculated based on 200.    However, we encountered a case:We did oversell for 1 item, such as item A. and Item A has 0 qty and 0 average cost in system. Supposing, we sold 10 cases item A at price $100, since item A has 0 average cost and 0 ARtran cost, the profit for Item A is calculated to $1000. which is not right in the real world.  The next day, we did receipt on item A with unit cost $80.  So the total profit of item A on that invoice should be only $200.       Is there a way for us to adjust that profit? If we can not do it on that single invoice, can we do a combination of several docs to adjust?

When I create a Purchase Order, I use inventory Items to fill out basic information, like account and sub account. However, I’ve notice that while the Account does match the Inventory Item. The system pulls the Sub Account from the Vendor’s profile.  This creates a problem because while the Vendor’s sub account is the most likely to be used, it doesn’t mean that it always be the same. My Inventory Item has the correct sub account.Posting class is set to pull the information from the Inventory Item ( II-III-I ) Is there a way to fix this? 

Our customer has started to use discounts extensively and originally we setup 6 decimal Price / Cost because it allowed us to match to the current price structure which is specific for almost each customer. We have learned that this causes rounding issues when unit of measure conversions are introduced.  We have an opportunity when publishing the new price sheet to clean up some of this rounding by changing to a 2 decimal Price / Cost setting in Company miscellaneous settings.  In our testing this appears to correct many rounding issues.  Has anyone seen negative impacts in the transactions by reducing the number of decimals?  All input is appreaciated.  

Hello,      Our company normally just give customer credit memo and will not refund money. So we used “customer refund” function only 1 time in 2019R2, and it is ok. It went well, no error happened.       However, after we had upgraded to 2020R2 and we had to create a new customer refund. it says “Sequence contains no matching element”. Just right after we have chosen the type as “customer refund” or “void refund”.      Can someone helped us out?  

I am looking for a good solution to verify special order items are correct.  We do a lot of special orders where we buy items only after a customer places an order.  After receiving the PO, we put them into a single Special Order bin.  We can link the PO to the sales order so it automatically allocates.  The problem is when the shipment is created, the quantities are automatically allocated and therefore don’t require scanning.  Many of our items look similar so it is easy for someone to grab the wrong item.  Anyone have a good solution?

Has anyone figured out a good way to avoid email loops in Acumatica?  This is specifically related to auto creation of Acumatica Cases via email.  The issue comes up when someone emails two system, in this case two support email address for two different companies, and both system have an auto reply. The result is the each auto reply creates a new case and a new auto reply and so on. 

When we use the tool in the Acumatica Partner Portal to request a sandbox for upgrading a SAAS customer, can we upgrade more than one major version (ie from 19.1 to 20.1)?  We recently used the tool to create an upgrade sandbox but found that we could only upgrade on version at a time.  Is it only possible to create a sandbox for upgrading more than one version by filing a support case?  If our customer is moving up two version we don’t want to have them go through the upgrade process twice.

How to show Google maps in a wiki and expose that Wiki on dashboard? We can add google maps script to show up in Wiki page but would like to see if we can add that wiki into dashboard Wiki component and show on the dashboard.