Solved

Hello,I am trying to set up shipping rates in the Freight Rates tab in the Ship via Codes screen. I need the rates to change at certain volumes and weights, whichever is higher. However, despite all the help articles saying that it calculates freight first by weight, and optionally by volume, it seems to only calculate the freight by volume. Is there any way to change a setting so it will calculate freight based on the higher of the two, or is it only possible to calculate based on volume? Thanks for your help!

Hello - Does anyone know how I can get this field to show up on a GI? It is on the Customer screen under the Billing tab. It seems when the “Override” box is checked, that it will not appear. However if there is a value there and the box is not checked, it will. I am not sure why some are checked and some aren’t either? Maybe an update changed this? Note - this information does typically come from an API connection to a separate system.. not sure if that plays a part.. any help would be appreciated!  

Acumatica lets you make mass changes to bills of materials but it doesn’t appear that you can make mass changes to existing production orders when the bills of material are changed.Does anyone know if this is possible?I have several customer asking this.

This seems like a simple task, but I haven’t been able to find instructions that have worked.I have an inquiry screen with a simple Filter DAC for the header and a Details DAC for the grid.The grid contains a column “Commission”, and I need a summary field to display “Total Commission” either in the header or on the grid footer.I’ve found an article Calculating Grid Totals on an Inquiry Form - Acumatica Developers Blog and followed the last (most advanced) example and I’m still getting inconsistent results when I have a mixture of header filters, shared filter tabs, and ad-hoc user filters applied.I’ve been working on this for a few days and trying many different things, but always with mixed results.If nothing else works, I’m willing to consider adding an action button that has to be clicked to refresh the total.In a regular Generic Inquiry, a summary field can be defined for the footer, and the column total will reflect the total for all records in the grid view, regardless of how fi

I have entered SO Order type Sales Order A for a configured Product that was marked for production.  i created a production Order from the sales order and the production order is now complete and the configured products which are also lot serial controlled are allocated to Sales Order A. then Customer service said they want to use the products built for Sales Order A on a new Sales Order B.  Same Qty and Same Configuration. Nothing i have tried will allow me to allocate the meters to the new Sales Order.i have broken the link to the Production Order and linked it to the new sales order.   Deleted the Shipment Confirmation from SO A. Unallocated and even deleted the line off of SO A and still can’t get create a shipment for Sales Order B.has anyone successfully be able to do this when a production order is linked to a sales order?     this happens in our current system about 2 - 3 times per month and we are getting close to implementing.    We are now in 2022 R2 but will soon be in 2023

Hello I’ve been reading the Acumatica documentation to understand how the webhook functionality is handled for Authorize.net plugin. We have a cloud based instance of 2023R1 Acumatica that we access via a subdomain. https://businessname.acumatica.comAfter following the integration and setup steps for Authorize.net specific to 223R1 here, I’m still getting basic authentication errors. I verified with Authorize.net that credentials are entered correctly and that there is no API restrictions for our account.The one area of Authorize.net that still remains unclear is if the webhook url is supposed to enabled or made available by our instance. Is the webhook necessary for the native Authorize.net plugin to work in 2023R1? Or can it simple receive the necessary data via the API token and and transaction key? 

People are voiding payments that have already been deposited to the bank and it makes for A LOT of unnecessary work when reconciling.  In my eyes, there should be no reason to void any transaction that has already been released in a deposit.  If, for whatever reason, you need to void a transaction; you would need to first void the deposit, do what you have to do and recreate the deposit after.  Once a payment is deposited, it should be locked; period. Even Quickbooks had this capability; it’s very simple because the transaction is posted to the ledger when released in a deposit.  But if this is too much to ask, we should at the very least have the ability to restrict certain users from making changes to released payments, especially if they have been deposited.   Does anybody have any thoughts or workarounds to avoid this from happening?

Hi All, I am trying to copy an arm report from one tenant to another. For some reason I am doing something wrong because I cannot see it on the tenant I imported it to.

Hi Everyone, I am trying to do a Hubspot integration with Acumatica CRM, I am following the quide hubspot team provided but once I allow permission, I keep getting the following error. Has anyone tried this and ran in to similar error. Any help would be appreciated. Thanks.  

Purchase Order Status not open, not completed, but in transit (shipped), but not received.How can you set up a shipped status for Purchase Orders? 

Hi Everyone,We are trying to automatically create a Purchase Order from an Appointment form.The functionality is almost complete, but I am encountering an issue when I call the Create Purchase Order (CreateProc) function within the POCreate graph. It redirects to the Purchase Orders form after executing the CreateProc function, and the subsequent functionality does not work.POCreate graphPOCreate = PXGraph.CreateInstance<POCreate>();graphPOCreate.Filter.Cache.RestoreCopy(graphPOCreate.Filter.Current, filter);graphPOCreate.CreateProc(list, filter.PurchDate, filter.OrderNbr != null, filter.BranchID);POButtonPressed(adapter);POButtonPressed this function not executed.Plz tell me how to resolve this..? ThanksNageswararao A.

When you create a User-Defined Field with the Low Code/No Code functionality, it creates a tab next to the “Document” tab on that screen.  (see screen shot below for reference). Is there a way to have multiple “User-Defined Fields” tabs at the screen header level? Additionally, is there a way to move a Low Code/No Code UDF, (which is essentially a type of Attribute), to the screen “Document” Header?Thank you,Jeff  

Good day,I am having an issue making available a custom field on the grid of Bills and Adjustments. I made the field available for the Workflow and I added an Event that has worked for me on other projects, but this time is not working properly. Even if I have PXUIFieldAttribute.SetEnabled the field is not available after closing a bill, but if use the line Base.Transactions.Cache.AllowUpdate = true then it will make available the custom field plus some other Acumatica fields that should not be available when the bill is closed, How can I make only my custom field available? protected virtual void _(Events.RowSelected<APTran> e, PXRowSelected baseHandler) { APTran line = e.Row; if (line == null) return; APTranExt fieldExt = line.GetExtension<APTranExt>(); if (fieldExt == null) return; baseHandler?.Invoke(e.Cache, e.Args); //Base.Transactions.Cache.AllowUpdate = true; PXUIFieldAttribute.SetE

Is there a way to connect a single scale, maybe two or three in time, to Devicehub without having to purchase "Automated Warehouse Operations"? It seems kind of silly that we can’t even connect one.Will we ever purchase "Automated Warehouse Operations"? Likely in time but we have a long way to go before getting into the Manufacturing and Warehousing aspects of Acumatica and we’d like to be utilizing this in Shipping now.Is there a compromise or work around anyone’s thought of that works? Thanks ;-)

Adding an operation to an existing production order.  This is the only operation for the production order.  The following image is from the Production order details screen.The following image is from the Companies screen. 

How do I go about making another field visible depending on the value of another field. I would like to do this with Acumatica Tools as I’m not familiar with Visual Studio.

When a customer sends an email for the support portal and when some one(including sender) reply to that email, it creates a new support case rather than looping with the first case.Email account settings are as attached.Has anyone got this issue any found a solution.

Hello all,I have been trying to fix the change ID error for the stock items. So I have 2 items with the same inventory IDs but under different classes.eg :3032 - item description A - item class A3032 - Item description B - item class BI created a PO with 3032 - item description A. And then i changed the Item ID for “3032 - item description B” to “B3032 - item description B”.But these changes got reflected in my PO too as:B3032 - Item Description A.How can I resolve this?I even tried to interchange the values as “A3032 - Item description A” & “3032 - item description B” but then my PO got changed to 3032 - item description A whereas the PO should get changed to “A3032 - item description A”. Thanks, 

If ACU processes an inbound email it can associate it with a contact. However, the activity is not visible in the opportunity activity for that contact. From the opportunity you can see the Lead’s activities, but not the contacts.How would you associate inbound emails with an opportunity?Or how would you include/merge the primary contacts activities in the opportunity’s activity list?

I find it cumbersome to have to open each project and update the % complete on each task, then move to the next project, so I want to make sure that I am not missing something obvious.  Questions:Is there a way for the system to automatically calculate and update % complete based on actual costs/budgeted costs?   Most project accounting systems seem to have that feature out of the box. Is there a way to update % complete for multiple projects/tasks at a time?  Perhaps via some sort of importing function?Thanks in advance!

Is it possible to add multiple tasks to a revenue line on a project? For example one revenue line consists of a quantity of 5 and there are 5 tasks that need to be completed to fulfill it. As they are completed project billing would be run to capture the payment and update the revenue budget  We are new to Acumatica and trying to trying to take advantage of the project functionality any guidance or suggestions would be greatly appreciated. 

I have a customer that has multiple tenants, and I wrote a SQL view to view all of the users across all of those tenants for administrative purposes.I would like to add a Navigation to pull up the full screen User (SM201010), as a Side Panel link.  However, two things are stopping me. I can setup a relation to pull these data and display it by linking in the PX.SM.Users to a Key in the SQL View. However, I can only pull the users data from the “active browser tenant”. In the SQL view I do store the CompanyID for all the users over all of the tenants, but I do not know of any way to pass that value to the Navigation link so that I can pull any user information from across all of the tenants, unless I have changed the browser into that tenant as a session.Is there any way to pass the CompanyID over to that navigation link?(and I can accept the answer of “NO”. LOL)

Hopefully I am missing something obvious - Is there a report or GI that can show unbilled project lines for all projects and their expected billing amount when project billing is run?   I supposed I can build a new GI or modify existing Project Transaction Details GI to allow filtering on the Billable and billed fields, but don’t see a way to show the expected billing amount based on billing rule and rate table on each task.Also I need to see available Progress Billing lines too, which are available in Project Transaction DetailsThanks in advance.

Like the title says, I am trying to create a GI that shows all late shipments, whos orders didnt contain any shipments prior. This may be too much to ask for. I am new to GI’s and am trying to figure this all out. Any direction towards if statements within GI’s would be helpful and any help on this particular question would also be appreciated. Thank you! Attached is the GI I have been working with.

After running allocation, the user finds out that they didn’t update/enter certain rates in the rate table.  Once they fix that, is there is a way to correct previously calculated allocation results?  Or does that have to be done manually?This question would apply to changes made to Allocation methods after the run as well. Thanks.