Discussion Forums

When I go to the “Where Used in BoM” for a specific item, it says that 1 of this item is required for all of the listed BoMs. This is inaccurate and I’m wondering if maybe I don’t understand what this column is used for.For example the highlighted line: it says that 1 Bone Char 50 lb 50 ct is needed to make 1 3G Garlic Grower Bulk (my interpretation) The BoM for 3G Greener Garlic Grower Bulk The highlighted line is a product of the Bone Char 50 lb 50 ct which is 1/50th of the original item. SO my math says that the BoM (3G Garlic Grower) should require 0.00012 of the original item (Bone Char 50 lb 50 ct)

I have a consolidated trial balance report in Acumatica that combines my consolidated US tenant in a ledger, another CA tenant in another ledger as well as an elimination ledger.Is there a way to link this report to an excel so I just need to click refresh in excel instead of redownloading the file. Also, in the case of having a new GL, how do I ensure the report captures the changes?     

After setting up everything within DeviceHub correctly, clicking ok results in the logs resulting in this error. What is the solution to fixing this issue?Error when trying to run device Hub

Hi All,How do you enter a note in to the printed version of a Credit Memo for customers?The same way we have that on the Invoices? 

Does anyone know if the guest pass for the Celebration dinner will also get you into the marketplace?  My nephew will be there and wants to only go to the marketplace on Monday and no sessions.  He leaves on Tuesday.

Hello!I hope someone could help me with this issue:I’m working on a solution that creates a kit specification. I haven’t done any extensions for the kit specification DAC or Graph, I’m working with an stock 24R1 instance. However, when I save the record, I get this error:Cannot insert the value NULL into column 'NoteID', table '24R1.dbo.INKitSpecHdr'; column does not allow nulls. INSERT fails. The statement has been terminated.I haven’t came across this issue before… Usually, when I save a record I don’t have to care about genereting the noteID. Specially if its not a customized DAC and graph.Is there something I’m Missing? private static void ACUCreateKit(INKitSpecMaint kitGraph, USRMXCBOMSProduct productToSync) { kitGraph.Clear(); INKitSpecHdr kitSpec = new INKitSpecHdr(); kitSpec.KitInventoryID = productToSync.InventoryID; kitSpec.RevisionID = "WEB"; kitSpec.Descr = productToSync.MPlaceName + " - " + productToSync.MPlaceT

 I encountered an issue where the tax amount is getting removed from the document total whenever I select a check as the prepayment method.

Hello,This has happend to us twice in the past two months and need to figure out a resolution.   We have a shipment that has been confirmed and our shipping team realizes they need to make a change, they click the “Correct Shipment” and receive the following Error message as shown below:  We are unable to correct the shipment and are now “stuck” and unable to fix the issue.    I have been unable to put my finger on any commanality between the two shipments this has happend to,  and I don’t see anything unique with this shipment that makes it stand out from other shipments we have been able to correct without error.

Hi folks, I’ve been trying to solve an issue where creating sales order via the REST API can be very slow. To diagnose this issue, I enabled the request profiler and used it observe that--in addition to very large SQL counts and CPU time--the slow requests are generating exactly three exceptions per detail line: two System.InvalidCastExceptions and one PX.Objects.IN.PXUnitConversionException. Not exactly a smoking gun, but it does seem suspect to me (I don’t think we should be generating these exceptions, no?). Perhaps some data was stored in the wrong format (i.e. a string being sent where an integer is expected)? Drilling down into the exception details, it looks like the source of some exceptions may be from PX.Objects.IN.PXQuantityAttribute.CalcBaseQty; but I’m not sure where to go from here. Is there a way I can determine exactly which attributes are being set? Maybe that will help me locate the offending data format mismatch. Failing that, anyone have tips for tracking down the c

Hi everyone, I was following the suggested solution in the Report Designer Parameter relation customer id and customer location id | Community to create the parameter. I was able to output the Location parameter which is dependent to the Customer. However, it seems that the filter is not working. Output in report is still printing everything.  I tried adding the filter to the table that’s created relationship with. (Note: I cannot output this in the paramater as location the field is SOOrder.CustomerLocationID,CustomerID ) Do I need to create relationship now for the ARPayment? I have attached the report in question. Thanks a lot in advance. 

We just upgraded to 2024 R1 from 2023 R1 and in our last version the Pacejet customization added a “Shipping Services” tab to the Shipments screen with a field named “Pacejet Workstation ID” which our deployment department used to send lables to different printers.  I can’t seem to find that in 2024 R1, can someone point me to where to find that or similar functionality?Thanks!

Has anyone encountered this issue in 2024 R2? I have a sales order marked for production, and after completing the associated production order and moving the inventory into stock, Acumatica doesn’t pull that specific inventory when creating the shipment. Instead, it pulls inventory using FIFO or location priority, ignoring the production order inventory.Example:Sales Order 123 has one line marked for production, with the Production Order linked - XYZ. Production Order XYZ is completed, and the inventory is moved into stock to location ABC (via the Move Transaction on the Production Order). When creating the shipment, Acumatica pulls inventory from another location, even though the sales order’s line details so the associated move.I don’t recall seeing this issue in 2024 R1. Has anyone else experienced this?

Hello - I released a credit card prepayment towards a sales order and only after did I realize it was the incorrect branch. How do I correct the branch without voiding the CC payment to avoid running the card again? I did already try to reclassify through opening up the journal transaction it created but I get the “Some transactions of the batch cannot be reclassified. These transactions will not be loaded” message and it does not allow me to change the branch on the ones that are incorrect.Thanks,Miriam

Hello everyone, I have a custom screen which uses the same view for multiple grids.I have converted the screen to the modern UI but only one tab actually has a grid:The others look like this:This is my html:<qp-tabbar id="CstPXTab13"> <qp-tab id="tabAssembly" caption="Assembly"> <qp-grid id="gridAssembly" view.bind="Details"> <field name="PressNo"></field> <field name="PressID"></field> <field name="Core"></field> <field name="BatchNbr"></field> <field name="StartTemp"></field> <field name="FirstTime"></field> <field name="LastTime"></field> <field name="FirstTime"></field> <field name="OpenTimeMin"></field> </qp-grid> </qp-tab> <qp-tab id="tabPressSettings" caption="Press Settings"> <qp-grid id="gridPressSettings" view.bind="Details"> <field name="Pressurepsi"></field> <field name="StartTimePres

I am migrating to Acumatica ERP and have lots of stock information i want to import to the Description found under the Description Tab.Is there any special way of creating the scenario

I’m working on a new project and I could use some help with the steps I need to complete.  I’m trying to automate the importing of data from an external source on a nightly basis.  Here is what I have:External system exports multiple files to an FTP location on a nightly basis. I configured a data provider to connect and sync to the remote FTP location. I wrote an import scenario to import the external file.Here is my problem.  I can successfully run the import scenario with a single file, but how do I do it for multiple?  When I perform the “File Synchronization", I end up as multiple versions (one for each new file).  How do I configure Acumatica to execute my IS nightly and to import all the new files it finds?  

Hello, our clients who utilize Shopify as order aggregator for Facebook, Instagram, etc. report that the following error happens often:The following tax IDs received from the external system are too long and cannot be saved: METROPOLITAN ATLANTA RAPID TRANSIT AUTHORITY Local Sales and Use Tax. Map these tax IDs to tax IDs of up to 60 characters in the SPCTAXCODES substitution list on the Substitution Lists (SM206026) form.Manually fixing these issues is time consuming and our clients fear to expand their marketing on the 3rd party platforms, because many orders will fail importing into Acumatica.Question:If we programmatically change the length of the TaxID field to 100 characters, will the error go away? Or do we also need to change some business logic in the code?Thank you!

We went live this week and have major issue with Marketplaces. We do not want our Marketplace orders to calculate tax in Acumatica but need our sales to report to Avalara for our automated remittances..Avalara has a set-up for marketplaces on their side but it is after taxes are calculated in Acumatica. We need to stop the tax from being calculated in Acumatica and still have the sales send to Avalara for our automated remittances. If we select: "Disable Automatic Tax Calculation" sales do not automatically send to Avalara and we need to find a manual export/import to resolve. If we select: "Override Tax Zone" sales do not automatically send to Avalara and we need to find a manual export/import to resolve. If we enter a "Tax Exemption Number" into Acumatica for that customer - it worked on staging. It did not calculate and sales sent to Avalara. In production it is randomly still calculating tax. PLEASE HELP!

Hello,I’m facing an issue which  I believe a bug in the system. Have you anyone experienced this? I would appreciate your comments. Test ScenarioCreate an Item with product configurator with few component items. Set the price of component Items in the price list. ( I have set a customer price class and price is based on price class of the customer) Create a sales order with the configurable item. The price of the configured item will be calculated when the item is configured. Then change the price of the component items in the sales prices and recalculate the prices in the sales order.This does not change the price of the configured items. I tried unfinish the configuration and finish again. It did not change the prices as well. Is there any other way to change the prices of the configured items upon price revision? And do you think this is a bug or what is the workaround?Thank you,Dulanjana 

The report only has one table, INLocation.  I want a parameter linked to LocationCD to be a lookup.  I cannot get that to work.  Here is my setup: What are the rules for adding a lookup parameter to a report?

Hi, I am trying to get the total of the sales order (together with all the charges/discounts) I tried using the field [SOOrder.CuryOrderTotal] but when I tried to get the sum, it seems that it is getting the sum of all the line items. Do I filter them and how?Thanks so much in advance!

Hi CommunityI imported some assets with GL Update off, but now need to post these transaction to integrate with GL. Plus the asset is showing unreleased transactions and I can't calculate the depreciation.I can't see any transactions to release although they are displaying as unposted. Is there any way I can correct this please? Many thanks 

I have code that opens a new tab to an external URL like this (builder.Uri is just referencing a url):throw new PXException($"Redirect0:{builder.Uri}$target=_blank")This fails on mobile. I assume maybe because the mobile browser doesn't recognize it? If so, does anyone know how to launch an external web app from the Acumatica mobile app?

Hello,Would someone kindly be able to assist me in creating an HTML If statement for an Email Template. I am used to creating them in Report Designer, and not in the HTML of an email template. I have tried using the Acumatica AI, but still no luck. This template goes out when a Shipment is Confirmed, and I have a table for the Tracking Numbers.I would like the statement to say, IF ((SOPackageDetail_trackNumber)) has a value, display the table, IF it does not have a value, do not display the table. <p class="MsoNormal" style="line-height: normal;"><font face="Arial, sans-serif">Dear Customer,<br><br>This is an automatic email to notify you that Order # <span data-field="yes">((SOOrderShipment_orderNbr))</span> has been shipped with Shipment # <span data-field="yes">((SOShipment_shipmentNbr))</span>. You can find a copy of the shipment confirmation attached to this email.nbsp;<br><br></font></p><p class="MsoNormal

Hello,I am creating a check layout, and I am running into an issue with the location of the Date field. I need to move the Date field up slightly to be above this line:but in Report Designer, it is already at the top of the layout and I cannot move it further up.   Any suggestions on how to get this field moved further up?Thanks!