Solved

Hi AllWe are currently implementing a new business module - Subscription Fee for customers. This means that we will receive upfront payment from customers. From a financial perspective, we need to split the subscription fee into 12 monthly installments to accurately capture revenue each month.I'm not sure if anyone knows whether Acumatica can support this type of subscription fee module.If not, is there an integrator that can support and integrate it into Acumatica?I hope to hear from you soon."  

Hi All,I need to add a condition to release from hold to unhold event. Based on the condition need to block transferring to unhold status.Can someone help me to achieve this?ThanksBhagya  

When I got into the template item for a product we sell and try to delete one of the matrix items that we no longer offer I am getting an error. “Referenced in multiple tables”. The trace points to a number of locations including old sales orders and GL accounts entries. Is there a way to keep the references in the tables but remove from the matrix? (we use matrix to push to a number of ecommerce solutions our current work around works with some and not all) 

When creating an import scenario in our expense claims, 3 out of 27 employees are not being recognized and it is saying, “Error: ‘Claimed By’ cannot be found in the system.”However, there is nothing different with these employees that we can see (2 are senior management in the same department and workgroup, but 1 is a front-line hourly employee in a category where the other 3 similar employees are fine) but we’re new enough to Acumatica that this is really confusing us. Any suggestions of what to look for? 

 Hi,I need to work on business events. Once the check has been approved and its status changed to balance, it should trigger the business event and will send an email notification. My generic inquiry is working fine. I think I just missed something. Hope someone can help me with this.Thanks!Generic InquiryBusiness EventsEmail NotificationEmail Notification 

As part of our manufacturing process we outsource components or services that we cant establish as  individual stock items. For example, part of production might involve sending elements off to be powder coated before they are sent back to us for being assembled. We raise a PO for these services using a non-stock inventory code.I am yet to find a way to record these costs on the production order, they are expensed on receipt and unlike a true inventory item they don't backflush and cant be allocated as cost to the production order.As a result our cost of production is never 100% accurate as these service elements are never included.Has anyone found a solution to this?

Hello All,I am trying to retrieve data using OData V4 but I get the error in the subject line. Everything is on my local machine and works with OData V3. Any help is appreciated why does V3 work but not V4?

Hello Team, We are working on the following APIs and facing the issue as data not getting updated to the screen, even though the status is Success with 200 code. Custom Endpoint created for Endpoint for Restriction Group by Subaccount (GL104030):  Requirement  is to update groups for Subaccount API to select the Group names and save by passing the Subaccount ID and the Group name via API (Postman)   Endpoint for Journal Transaction screen (GL301000):Requirement is to reverse the Journal transaction entry. We have added the action to the standard Endpoint. Same issue here as well, call is success with 204 code but transaction is reversed. (Please confirm if its feasible or not Thanks & Regards,Vidyakeerthi K

Hi Team,I have upgraded my REST API code from 2022R1 to 2023 R2. As per latest RESTSharp DLL I have modified the code and able to compile. but I’m not getting response for my Asynchronous GET Method.Below is the code and Error message for your reference. Please help me to rectify this issue.Error Message: Object Reference Error.  Regards,Ramya Krishna

We have discovered that we have duplicate IN journals being created.  So far we have found them to be on Moves, Materials, Purchase orders and Adjustments.  It isn’t every time but is a couple of times a day.  Values of the journals vary significantly.  It is across our users, so not limited to one user.The journals are identical, one auto releases and the other sits in ‘unposted’ status.Has anyone had similar happen?  

Having an issue with the Reassign process when approving AP bills.Bills are assigned using our Approval Map and occasionally a bill needs to be reassigned to someone outside the Approval Map. Our approvers need to put the bill on hold and enter the correct project task and cost code. Once they remove the hold they are no longer the assigned approver (the Approval Map assigns it back to the original approver).  Ideally the bill needs to be put on hold to edit and keep the reassigned approver – any help on how to make this work would be appreciated.

Hi,I am trying to create a business event with an action item to automatically create an appointment each  time a service order is created under field services. Here is a screenshot of my business event.  Here is a screenshot of my Action Settings  Here is another section of my action settingsNothing is happening what is wrong with my settings. Do I need to setup a import scenario? Any guidance would be appreciated.Thanks,Frances    

MRP and Production Orders (Scheduling Method Finish On or Start On) use a straight run time calculation to manage dates, not taking into account Crew Size for the work center.  Can Acumatica MRP and Production Orders take crew size into account?Here’s the conflict as the system works today.  In order to make MRP and Production Order dates work, you would have to add run time to the BOM equal to the straight time, and then adjust your work center Standard Cost equal to your rate x the crew size.  For example, if a BOM takes 10 hours to move through a work center, but you have a crew size of 3, really I would like to put 30 hours (man hours) of run time in that operation, and put your real standard cost rate (for one person) on the work center, say it’s $25/hr.  But to make MRP and Production Order dates work properly, currently in the system you would have to put 10 hours straight time as the run time and adjust your work center Standard Cost rate to $75 in order to account for the labo

We are in the middle of config and we are very disappointed and surprised to know that Acumatica does not print ACH remittances when payments are released. This is a core step in any payment processing. When you are paying vendors, any system prompts you to PRINT cheques or ACH remittances. This is normal “process flow” regardless of the payment method. Why couldnt ACH payment do the same (i.e. prompt us to print remittance details)??? This is very standard step/process - it is normal to print file copy of ACH remittances so they could be attached with invoices paid.Would you please share some input? Any help would be appreciated. Wouldn’t it make more sense to normalize the ACH payment process flow to include printing remittances?????? 

Is there a way to create custom statuses for change orders? I want my PM’s to know exactly what each thing means and sometimes “on hold” and “closed” don’t tell them exactly where it is in the process.   

Looking for instructions on how to map the export from Acumatica to Shopify. I want to export the URL of the order in Acumatica to Shopify. This will help users quickly open the order in Acumatica. I can map the actual order number via the standard available fields. However, that’s a static field with out the URL. I’m looking for info on how to map the URL at the beginning.

We have a client that had an error on their production orders and accidentally applied overhead to all of their outside processes. it was not realized until the production orders were completed (NOT Closed), but there are roughly 1000 production orders that were effected. They tried to do a WIP adjustment to offset the costs, but that was not effective, as it was reversed when the production order was completed. If anyone has any thoughts on how to best remove these, that would be helpful.

I try to connected application and I receive authorization code but when I try to get access token, it show error I follow this document 

Are there plans to sync the carrier over to Shopify when fulfillment occurs from a drop-ship PO?The situation we’re running into is when we sync the tracking number to Shopify, Shopify is choosing the carrier. I’m not 100% sure of their logic, but sometimes it chooses the incorrect carrier. When our customer looks up the tracking in Shopify (usually via the Shop Pay app), they are confused. Ideally, we’d be given the fields in Acumatica to sync the carrier, tracking number, and url (if necessary) so it doesn’t confuse our customers.Thanks in advance!

Why does acumatica show different values for the same variable/transaction in different places/report in acumatica. It is supposed to show the same amount/value for that variable/transaction irrespective of from where it is fetched in the acumatica system. One report is showing the correct value while another shows wrong value . Is it referencing a wrong table ? Why does this happen and do I need a sql script (coding) to fix this ? I do not have any further information to give ,

Is there a way to interface appointments from the field service module to an online calendar like Google calendar? The calendar layout in ACM is impossible to work with on a mobile device.

clients receive emails from their customers with a PDF of a remittance.  If we can copy the AP doc recognition service and use it for AR. This would be nice and save time.   The service needs to recognize the Name and Customer ID

The Sales Quotes screen has an option to ‘Convert To Order’. This option pops up the screen below and when you click Create And Review, the system creates a sales order based on the sales quote and uses ‘throw new PXRedirectRequiredException(docgraph, "");’ to direct the user to the sales order screen.Below is the sales orders screen, the important point is that the sales order has not been saved to the database at this point. The user has to click save to persist the info to the database.At the point of saving the sales order I want to create a purchase order (I won’t explain why). It’s important that the purchase order isn’t created unless the sales order is saved. I was going to create a POOrderEntry graph in the RowPersisting event but this results in error PX1045, as shown below. I cannot figure out where I can place my code in the SOEntry graph without the use of an event, which isn’t allowed. I wondered whether the call of PXRedirectRequiredException might provide a method I cou

Hi,Im trying to run tests for acumatica test sdk. I was able to make login into acumatica instance with code but code crashes when I try to open Sales Order screen with OpenScreen function. The issue isOpenQA.Selenium.WebDriverException: 'javascript error: window.__siteMap.Workspaces is not iterable      (Session info: chrome=119.0.6045.105)'

Is it possible to consolidate change orders? I had 15 change orders approved as one lump change order that needs to show up on my pay app as one - not 15.  is that possible if they are already listed in acumatica?