Solved

Hi guys, does anyone happen to know how to terminate a deferral schedule related to an AP bill? In the system I couldn’t find any button to close/cancel/delete/terminate/reverse it.Till now I have run recognition twice (at the end of December 2021 and January 2022). But unfortunately we just found out that there’s something wrong with the bill and we need to reverse the whole thing, including the bill and this deferral schedule.How will it infect the deferral schedule if I reverse the bill now? Is there anything else that I need to do?Thanks.

I am trying to help a customer with trying to get DeviceHub setup and eventually to get FedEx labels to print via DeviceHub.There are bits of information scattered in the community and on other Acumatica focused sites on the web. Acumatica help documentation also is difficult to find instructions for DeviceHub installation and configuration.Does anyone have a top-to-bottom documentation on at least the DeviceHub setup and usage? Thank you,Greg

We have been using ShipStation and Acumatica for 4 years, and have not run into this problem. To my knowledge, no settings or configurations have been changed. But over the last several weeks, the integration seems to have degraded. We can export shipments fine, and maybe 1 out 15 shipments gets confirmed. The vast majority, however, remain open. When the issue first started, the tracking # and freight costs were still importing. I was able to build a filter based on these parameters and my warehouse was able to manually confirm the ones that had shipping info. On the ShipStation Log Details screen, most are in error. I have searched this Community and others like it and the ShipStation Community and have been able to find anyone else with this specific issue. Any help or guidance would be greatly appreciated. 

I ran into an error when publishing a customization project that I haven’t seen before:  “The '<project name>' customization project contains a prohibited database script”.  The customization has published without errors and the db script in it executes fine on many different Acumatica instances except for this particular one.  The db script just drops a view if it exists, and then creates the view.  The Acumatica build is 21.115.0017.  The error shows up right away after selecting Publish.  Did I miss something in the release notes somewhere where certain db commands are no longer allowed in scripts, or could it be a licensing or permissions issue of some kind?

Hi all. Are Balance sheets and Income statements possible in Acumatica with Power BI?

Should I be concerned if the update completes despite having ‘aborted’?

I have items on my MRP Exceptions that are showing Transfer Available types. How do I get these off of this list as they should not be available from that supply warehouse? They are the ones highlighted on the bottom.  

I am attempting to create a Project for a Business Account programmatically.  public class ExtendProjects_BusinessAccountMaint_Extension : PXGraphExtension<BusinessAccountMaint> { public PXAction<BAccount> CreateServicesProjectAction; [PXMassAction] [PXButton(CommitChanges = true, Category = "Record Creation")] [PXUIField(DisplayName = "Create 'Services' Project")] protected virtual void createServicesProjectAction() { BAccount bAccount = Base.BAccount.Current; if (bAccount is null) return; PXLongOperation.StartOperation(Base, delegate () { CreateServicesProject(bAccount.BAccountID); }); } public static void CreateServicesProject(int? bAccountID) { if (bAccountID is null) return; var bAccountGraph = PXGraph.CreateInstance<BusinessAccountMaint>(); BAccount bAccount = bAccountGraph.BAccount.Cur

I have created a wiki article consisting of a few images making up a flow chart. I would like to create a link from the image to a process screen (new cases) in the customer portal, so that the user can click on the image and will be taken to the appropriate screen.

Hi, One Employee needs to report the time Two different Projects. Once complete the Time Card Entering need Project manager Approval base on line level ProjectWise. (01). How Could we facilitate the Approval for individual Project managers upon line level?(02). Is there any restriction to enter one Employee to multiple Labor Items or Is that One to one mapping?  Regards

Hello! We’re attempting to troubleshoot a new store connection and seem to have everything in place on the Shopify side – when we try to sync the orders we get the following error:Inserting 'Sales Order' record raised at least one error. Please review the errors. CuryOpenTaxTotal: Tax is not up-to-date. CuryUnbilledTaxTotal: Tax is not up-to-date. ShipVia: 'Ship Via' cannot be empty.Shipping address and methods are present in the order JSON along with Tax lines which appear to all be accurate. Any input on where the misconfiguration could be would be greatly appreciated!

We would like to get a version of the AR aged report for Customers who have an invoice outstanding over 90 days (age03), and then we want to show all invoices for that customer.  If they do not have an invoice over 90 days old we don’t want them on the report. I thought that there would have to be a way to filter the report using the AgeTot03 variable (<>0) then print but I am not having any success.Any ideas?

All - I have an Import Scenario created the goal is to import time from a SQL table to the Labor Screen and create the labor batch. See Scenario The data comes in with out issue when I prepare it however the import is giving me the following error.   Any help is greatly appreciated. 

Our customers get uploaded automatically from our CMS. By error sometimes twice. Once in acumatica, how do I merge the customers, so I have only one customer in acumatica?

I am using the external tax provider and this is causing me to not be able to unclose appointments without disabling the external tax provider. How would I fix the taxes so they are up to date so it no longer causes this error?

I have created a Processing screen, To process EMAIL and PRINT of multiple Payment and Application documents.While Processing PRINT I am getting the following ERROR. The Screen ID showing in the error message is the report screen ID which should pop up to print the report. but the Report is not popping up. Following is my code : We are getting error in line no 72, throw ex; I am unable to find out where I am going wrong,Thanks In Advance.

We need to order Bank Checks.  Does Acumatica have a standard “form” of check?  If so, where can we order the checks that match the standard Acumatica “form” of check”? 

When I try to unclose an appointment I get the following message. Another process has updated the ‘FSAppointment’ record. Your changes will be lost. Is there any way to stop this from happening? It is preventing me from being able unclose appointments. 

The Automation Schedule History shows all of our email are “Processing completed with Errors’.  We cannot find what is causing these errors.  Please help us understand the errors and show us how to fix the issue.   

I brought back a copy of the Finance Basics course from the Acumatica Conference for our Controller. She has been working through it, but is confused because the instructions don’t quite match up to the guide. For example, financial periods are not open for the 2022 time period (this can be fixed by opening financial periods for 2022). In addition, for example, when reversing a transaction on page 10, it says to find the transaction on 2/25/2022...but this doesn’t exist. It does exist for 2/25/2021.I would like to fix this problem, so that the user doesn’t keep having to second guess the training materials or work around them. Is the fix here to just change 2022 to 2021 for all instructions? Can someone advise? We are using u100 from 2022 R1 currently. I have attached the Learner training guide from the conference.

In Field Service we mostly care about the service address, which would be the Customer Location address.  We need to be able to have the user, in the Service Order screen, enter in an address and have the system match it to a customer record and populate the Customer field and the Location field with the match.  I am not a developer and would like to know if this is addressable either by a Workflow type customization. I have tried using Actions/Navigation:Search Records but the closest I have come is to allow a popup of the Customer Location GI.  This could possible work if the user could use the popup GI and search the address, select the customer and have it populate in the Customer field with the corresponding Location ID. Any ideas or pointers would be great.  Thanks.

Hi guys After copied data I am not able to paste because Paste option in disable how can I get data by pasting. 

Is there a way to change the probability values based on the stage the opportunity is at?  If so, how?  An example for further clarification would be I want the qualify stage to be 15% not 10%.   Thanks in advance,Tom

Several internal users and our construction clients use Bluebeam Revu software to view pdf’s and for other functions.  Our Subcontract docs produced in Acumatica appear like this to a Bluebeam user……Has anyone else experienced this and is there a fix?

Is there a way to filter the schema objects using the SQL connector in a data provider?While I am only using one table I see reference to all the tables in the import scenario XML