Solved

Yesterday, we had severe performance issues due to multiple running processes on a single user (import orders) that didn’t stop until we manually killed the processes:Here’s the task that I want to implement on processes that have run longer than a minute or two:Is there anything I can call in the RESTAPI to achieve this? Thanks,Brian

Hello, I am receiving the following error when trying to create an AP Bill from a Subcontract.The subcontract is open, not complete.   “PO Error: There are no lines in this document that may be entered in AP Bill Document directly”

I am unable to alter the default GL account for line items in a QUOT order type. If i then copy and paste this over to a new order type obviously it stays the same account number. I need the account number to match to the mapped GL for the inventory ID. Does anyone know how to fix this or have any experience with this. I want it to default to Sales account from inventory item not from the customer info.   

Hi,  I’m running into an issue, where on Shopify Avalara will charge a “special tax”, but Acumatica doesn’t recognize it.  Screenshot from Shopify​​​​​​ 

Hi All,I am trying to build an import scenario that will create external user login (Guest accounts) for all of the contacts for each customer record.  I have a user type “unrestricted external user” and it has a linked entity to the contact record.I have created my EXCEL/CSV data provider with the Account ID, associated contacts with their email address, and the contact id (I attached some sample data that I scrubbed with fake data).When I try to execute it, I get an error...4 items have not been processed successfully. View name: UserList.I really have no clue on how to do this lol. Can anyone help me?  I have about 1500 accounts to make in just a couple of days and am totally stuck.Thank you!  

Hi Acumatica CommunityIs this possible in Acumatica Dashboards. 

I need to have an import scenario that records the payment and applies the payment to the related invoice or invoices.  I started using the one included but I am getting the error:The system failed to commit the adjustment rows.Here is a screenshot of the application section of my import. Any help would be appreciated.Thanks...coleen

Hello - I am trying to create a Project Balance GI and link in the PO associated for each transaction line, but it seems to just create duplicate lines. Below are the tables I have joined now that seem to work. Does anyone know how I can also pull in PO without having it duplicate?  

I am trying to import a SO with multiple lines. Currently the SO is being created with the multiple lines. However, if I have more than 1 SO on the CSV file to import, the import puts all the lines on one SO instead of each SO having their own lines. There was a suggestion to use 1,2,3 to enable the import to create individual SOs with the lines for each, However, I am doing that, but all the lines are still being created on one SO. See the attached Import Scenario and CSV file. What do I need to change to fix this issue? 

Hey Guys, Whats a low code way to prevent save unless CuryPremiumFreightCost > 0 where an SO or QT order type CuryVatTaxableTotal >$5000. Cheers,

Hi all I am having an issue with visibility of “customer status” in the customer GI under receivables. see the screenshot below. I get the following error which does not make sense because I am an ADMIN user role in the system.  This field will not be displayed for the current user because the user has insufficient access rights or the required feature is disabled.

I created an import to load data into the Payments and Applications screen, Documents to Apply tab. When running the import, it fails with the error: “Value cannot be null. Parameter name: row.” Please advise on the cause and required fix.My Settings:using PX.Data;using PX.Objects.AR;using ARAdjust = PX.Objects.AR.ARAdjust;using ARPayment = PX.Objects.AR.ARPayment;namespace import1.GraphExt{    public class ARPaymentEntryExt : PXGraphExtension<ARPaymentEntry>    {        [PXImport(typeof(ARPayment))]        public PXSelect<            ARAdjust,            Where<                ARAdjust.adjgDocType, Equal<Current<ARPayment.docType>>,                And<ARAdjust.adjgRefNbr, Equal<Current<ARPayment.refNbr>>>>,            OrderBy<Asc<ARAdjust.released, Asc<ARAdjust.adjdRefNbr>>>> Adjustments;     }}  

I’m looking to create a custom webservices endpoint that will take in a request with a custom format, extract Ids from some of the objects in the request, retrieve data on stock items and some related tables based on the Ids provided then put that data into a specific json format to return it.Is this possible and how would I go about doing this?

Hi, is it possible to use SQL stored procedures or SQL functions in Report Designer?

Hi, Can anyone help me, I have created custom field in Stock Item - IN202500 and retrieve data from from Attribute - CS205000. but, not showing data. bellow screen capture in stock item screen and my DAC   

The customer has expressed a desire to restrict the system's ability to release transfer documents when there is no quantity available. They are currently utilizing the "allow negative" checkbox in the item class. Furthermore, they aim to generate a shipment for kit assembly orders even when there is no quantity available, but at the same time, they want to impose restrictions on releasing documents with a negative balance during transfers.Any one please suggest how to meet this requirement? Any configuration? Thanks in advance

How can I see Inventory on hand, reserved, and available in a grid view? I am sure someone is doing this already. Are you creating a GI or am I just missing where to go and get this. I would like all of my inventory to populate in a grid view. I dont want to look at one item at a time I would like to populate the full inventory list and then filter and sort. Stock items screen lacks inventory information I am needing.

When adding someone as a delegate for approvals, is it possible to also have the original approver still receive the notifications and approve documents?  

I have some problem. I have all right. But report parameters not availible. in 24R111 version. But in 25r1 its work. With some rights. With debug i see this error: 1️⃣ PX.Web.UI.PXReportViewer.SetReportSignFlagIfPdfCertificateIsPresent()    → C:\build\code_repo\NetTools\PX.Web.UI\Controls\Report\ReportViewer.cs:line 12182️⃣ PX.Web.UI.Metadata.AspxScreenInfoCollector.Collect(String screenId, String locale)    → C:\build\code_repo\NetTools\PX.Web.UI\Metadata\AspxScreenInfoCollector.cs:line 153In trace i have this  its error i have when i refresh report parameters. All report have this error and I can't set parameters

Good day,I could use some assistance with the review the attached Import Scenario; it worked before we upgraded to 2022R1.  The scenario creates the sale order.  However it creates only one order with all the items in it rather than create a separate order.  The file has 55 orders.  When I tested it created one big order.  I can figure out what changed after we upgraded.Have a nice day.@Evan G 

I created an custom field in purchase Order and need to enable it for all the status of the Purchase order. Is this can be done without coding?

Has anyone overcome this issue? In a classic UI dashboard, the embedded page widget is working fine for a webcam view of a construction project. Similarly, an embedded weather widget works.  Switching it to Modern UI and it results in a 404 - File or directory not found error. The weather widget has the same result. Toggling back and forth between classic/modern, the embedded pages work in the classic UI and 404 in the modern UI Sample webcam URL used for testing: https://share.earthcam.net/tJ90CoLmq7TzrY396Yd88KKPTYvGpuC9sn7UZHiL1L4.tJ90CoLmq7TzrY396Yd88KndwTghhAJ91QbmhhD8hKQ/tonnelle_ave_bridge/camera/panoramaSample weather URL: https://oneweather.org/new_york_city/#now

Our client wants to have two separate continuation pages: one for the original contract, then one for any change orders. I added a formula to group change orders separately - the client adds them in separate tasks starting with “CO”. This formula is working like a charm except the change orders always appear first. I’ve tried every group formula I can think of, changed between ascending and descending, etc., and get the same result every time. Has anyone else come across this? If so, how did you address it? First GroupSecond Group 

Hi, I want to create expense claim but when i try to select the expense item, i can not find any list of my Inventory ID (Non-Stock Item with type Expenses). Please help me to to solve about this, thank you.  

Hi, i want to create a request but the while i try to select one of the chart of account and subaccount form on of my item request, there’s no option to selected the COA and Subaccount. I already import the COA and also create the Subaccount. There’s any step that i miss while i config?Here i attach the capture of my problem, i really appreciate you responds and help. Here is the capture of the Subaccount for the Request\