Discussion Forums

Can someone help me figure out why this SO is showing multiple lines for the same item? Usually when this happens it’s because ACU is needing to pull from a different location or use multiple lot numbers but as far as I can tell the line details are all the same :)  

We are trying to create an integration with Acumatica API and we are encountering issues or weird behavior when updating multiple items in a parent record.For example when we try to update multiple contacts for a customer, it won't update the all contacts but only update the first one, but the weird thing is it picks up the values from the second item to update the first item, like the contact note field of second item will replace the contact note field of the first item, we are not sure if its bug or something.Anyone experience the same issues?Here is my sample Json payload for a Customer PutEntity endpoint, the note for ContactID: 100745 will replace the note for ContactID: 100743, but will not touch the second item.Seems like only first Contact gets updated.{ "id": "01a0c017-df7f-ea11-8175-b9d61cb73193", "Contacts": [ { "note": { "value": "Note for 100743" }, "ContactID": { "value": 100743 }, }, { "note": { "value": "Note f

Hi All,I am trying to set up a push notification to a Google Space webhook. I get an error that the format is incorrect - the error is generated from Google. Google does not like the format of the JSON that is sent.Does anyone know how to customize the JSON?

Hello,  So our pricing model is a direct markup of last cost. I’ve seen other topics talking about how to use a business event to automatically update pricing based on a change of last cost. First though I need to get the last cost field correct. We use a FIFO costing method for reference. Essentially, I want to be able to update the last cost to the true last cost after release of an AP Bill that has either a Purchase Price Variance or a Landed Cost tied to it, or both.  So far I’ve gotten things to work by creating a Generic Inquiry and a Business Event that looks for any AP Bills that have been released that have either a PPV or a LC document on them and calculates the total unit cost for that item that I want to update with the last cost. It triggers an Import Scenario that creates an Inventory Receipt with a Qty of 1 and Unit Cost equal to that Total Cost I calculated in the GI.The next Business Event uses a GI that looks for receipts with the reason code LASTCOSTRECEIPT. It trigg

Hi everyone,I am setting up a business event that sends the Inventory Valuation Report in Excel format by email at the end of each month. I have already configured the generic inquiry, the business event, and the automation schedule, and I have tested the report several times.When I run the report directly without any parameters and select the summary option, it prints all eleven warehouses together as expected. But when the email is sent out, it includes eleven attachments. Each one looks the same, except a different warehouse is highlighted in each file.I have tried updating the generic inquiry and adjusting the email template parameters, but I still get the same result. Has anyone seen this before or know how to fix it?Thank you!

We are using our own freight trucks to pick up inventory from manufacturers. We want to include the freight cost in the cost of those items that were purchased from the manufacturer but picked up by our trucks. We do not need an AP bill for this transaction since its not third party. Is there a way to use the landed cost process without creating an AP bill?Just FYI, we come up the with the freight cost by using a home grown freight cost estimator tool. Takes the overhead cost, repairs, maintenance, fuel price and mileage to come up with the freight cost. We would like to use the landed cost screen to enter that information and distribute the freight cost to the items on the PO without ACU forcing an AP bill. Is anyone needing this functionality?  

I have a customer who would like to create commission periods - 1st through 15th of month and 16th through the end of the month (aligning with payroll periods).  I am not finding anywhere to define the commission periods. Any help is appreciated. Thank you.

Hello - I am hoping to run a Generic Inquiry for Users be User Role. We have about 30 corporate users with access to every single user role. When sorting be user role in the ‘User List’ report, I try to add a filter that User Role Does Not Equal CORP (the user role all corp users have), yet it still returns the corp users when filtering by other user roles. Because of this I was hoping to build a generic inquiry that I can run by user role, but am not seeing a predefined one. Is there a table I can add to the default “Users” Generic Inquiry that would also pull in each users User Role?Thanks!

Hey everyone,I am wondering if anyone has a way or process, I have not set up yet that allows me to manually enter in the tax amounts for each line when creating an entry in the “Bills & Adjustments”. From the cabinet I find a header for “Tax Amount” but no value can be placed inside of it. Currently, the taxes auto calculate based on the rate set for the vendor & the tax category that is entered. Is there any way that instead of auto calculating it off the total amount, I could manually enter in the tax amount for each line? Thanks!

Hello, We currently upgrade to 2024 R2.  However, when I open the PO3020PL, it says timeout.I think it might be something wrong in the Generic Inquiry behind PO3020PL.But What’s strange, even when I try to open inquiry “PO-Receipt” in SM208000, it also time out.Can somebody help me?

Hi everyone,I’m working with the Acumatica Report Designer and have created a custom PO Receipt report. However, the report only displays static text – none of the data-bound fields show any values.I’ve already checked the collections, data sources, and parameters – everything seems to be set up correctly. I even imported a working report from another customer’s instance as a reference, but the issue persists: fields that are linked to Haufe or database values are still not displayed.What’s strange is that all other reports (e.g. quotes, sales orders, purchase orders, etc.) work perfectly fine – only this specific PO Receipt report has the issue.The problem even affects subreports like the footer, and standard fields such as the company address (from BAccount) – none of them show up either.Has anyone experienced something similar?Any ideas on what could be causing this, or what else I could check?Thanks in advance for your help! 

Hi! In service orders, on the details tab, I can’t figure out why the billable column is grayed out? I’m also admin user. The background to this is I’m not able to invoice appointments because the error tells me nothing is marked billable. I’ve also made sure on the service order type generated billing documents is set to SO Invoices.!--endfragment>!--startfragment>  

I am having issues setting the PrimaryContact on a BusinessAccount entity.We are building a customer application form where potentical customers can apply for an account. This data is going to flow into the Business Account entity as a “prospect. The application will contain their business information as well as a list of owners/authorized buyers.  These owners will be added as associated contacts to the business account entity.   I have all of that working via the RestAPI without much issue. The trouble I am having is setting the first owner (in the list of owners) as the PrimaryContact.  I can’t get anything to work. Here are my order of operations: Create the BusinessAccount  Iterate over the incoming contacts and create each new contact and associate them to the BusinessAccount ID Call and PUT against the newly created BusinessAccount and pass in the PrimaryContactID of the first Contact in the list from step 2. (this isn’t working) I am doing a PUT to {{MY-BASE-URL}}/entity/PHDCus

We often allocate input materials to a Production Order ahead of time — but the materials are in a different location than the production site.Once allocated, Acumatica won’t let us transfer the materials to the correct location because the inventory is locked.Our current workaround is to: Unallocate from the Production Order Transfer the inventory Reallocate it again This feels messy and inefficient.Our VAR suggested we just consume from the original location and physically move the material — but we’re not comfortable doing that due to compliance concerns.Has anyone run into this?Is there a way to transfer allocated inventory while keeping the link to the Production Order?Appreciate any ideas!

On our Service Order Type I have Require Contact selected and have Take Address and Contact Information From: set to Contact. When creating a new service order would like the Primary Contact for the Customer select to come up as default. Is this possible to do with PXDefault? If so, how?

In the Log where the technician's time is entered, a technician has regular time and double time as highlighted by the earning types. When viewed in the profitability tab, the unit cost for both entries are the same. Has anyone else had this issue or where my initial setup may have gone wrong? 

Is possible to restrict this field for specific users?

My generic inquiry game is a little rusty… Does anybody know how to get the Appointment Log Times - Start and End Times on a generic inquiry?  I’m not seeing this field as an option for selection when building the GI. It’s only giving me the Start Date and End Date 

Hello im having problem with my Address in result grid its not showing can anyone help me  

Hello Acumatica Community. No doubt others have had the same issue. Where a salesperson wasn’t entered against a customer and Sales Orders have been processed without a sales person.Is there any possible way to go back and add the sales person for correct reporting?

Hello,      I have a issue with opening “PO.30.20.PL” in genericy inquiry.  I suspect it is an access right issue. BUt How can I find where it is located on “acess right by screen”  

Hi Everyone,I have a source dataset (shown below) for creating SO Invoices. I’ve set up an import scenario that is working fine, but it is generating three invoices instead of the expected two.Based on the data, I expected only two invoices because the Reference Nbr is the same for the 1st and 3rd lines. Has anyone encountered this issue before? How can I modify the import scenario to ensure only two invoices are created in this case?Additionally, I noticed that Acumatica has removed the sorting option for grids in Import Scenarios. Has anyone found a workaround for this?Thanks in advance for your help!  

Hello,               I found this post for replacing image on login pagehttps://community.acumatica.com/customization%2Dtools%2Dand%2Dframework%2D245/how%2Dto%2Dreplace%2Dimages%2Don%2Dthe%2Dsign%2Din%2Dpage%2D3841But I do not want to this kind of complicated.  I just want to put a simple notice like below: Any quick and simple way to do this?

Hello,                  Very strange,  I have a same customization project,  I can open and view it in 1 web site with SSL connection on.  While another web site display empty in the project editor with NONE ssl/tls connection.                      Is there any restriction on it? What is the logic behind it?