Solved

From my brief research and testing it would not appear that Acumatica allows for a workflow where Landed Costs can be entered and paid for prior to the purchase receipt. Has anyone figured out a way to accomplish this cleanly?  Like many companies, we are importing items from overseas and paying some significant landed costs in the form of freight and duties. We want to capture these costs and apply them to our item costs, but often we need to pay bills before items are received. Neither the freight companies or the brokers are interested in waiting for us to receive the inventory before they get paid and I imagine this is a very common scenario - is this a simple oversight in the Acumatica functionality? or have I missed something obvious?  Appreciate any insight others have in this area   

If you are in the prepare replenishment screen a line item will not show up as Qty on Supply if an SO is linked to a PO for that item.In my case I link SO transfers to PO’s for all or some of items I know will have to be shipped to our satellite offices once it comes in. The problem comes in if you were to check the Prepare Replenishment after that, it does not show any of that item as Qty on Supply or at least until the SO is posted.To me it seems logical that the Prepare Replenishment should still show an item as having a Qty on Supply even if there is an SO for that item.If this topic has already been discussed let me know and I will check it out.

Hello, i am trying to adjust in a part, which is not set as serial tracking..when I adjust in as inventory count reason, it asked me for receipt nbr.. can someone shed some sort of light please?Thank you Zoey 

I’m attempting to display an image from the currently selected detail line, beside the grid, and I cannot get it to work without database manipulation.The detail lines are a custom Photo record that have some details about the photo, and an image uploader shown in the element below. All on a simple form. This custom photo record is working as expected.<div id="divColumnC-Img" slot="B"> <qp-image-uploader id="ImageUrl" state.bind="Photo.ImgUrl" width="100%" height="100%" caption="Image"> </qp-image-uploader></div> Now, beside this other grid, I want to display the photo from the currently selected line. See below. However, it doesn’t load the image, and when I open developer tools I see this message on the console.“app.ts:222  GET http://localhost/<SiteName>/Shedworks%20Photo%20(PHO-00009110)/login_bg3.jpg 404 (Not Found)”qp-image-view element with the system generated value as the Image Url in the databaseHere’s that image viewer element. <div id="divCo

I’ve created a variable to sum the total amount shipped of an item during a specific time period.  However, if zero of this item are shipped, the variable is blank, instead of outputting 0.  Can someone review my code and hopefully point out what I have been overlooking? Many thanks in advance. =IIF($DateDiff > 2,CInt(SUM(IIF([SOShipment.ShipDate] >= CDate(CStr(Month(DateAdd(@EndDate,'m',-2))) + '/1/' + CStr(Year(DateAdd(@EndDate,'m',-2)))) AND [SOShipment.ShipDate] <= @EndDate,[SOShipLineSplit.Qty],0))),0)

Version 25R1I am trying the set access rights for a specific role for File MaintenanceThe primary goal is to limit ability to Add fileAt System Management level the access right for role is Multiple RightsAt File Maintenance  level the access right for role is EditUser with role can still addWhat is wrong here ?Should access rights for File Maintenance work the same as other data screens?     

If Use Fixed Manufacturing Time on Inventory Planning Preferences is not checked, we expect MRP to use manufacturing time from the BOM.We are having trouble getting it to take Queue Time into account. DA-L0 and DA-L1 both have a queue time of 4 days.Created an SO for DA-L0 on 3/15. Here is the MRP Result, with the planned action dates for the production orders being 3/15.Shouldn’t the queue time of 4 days force the action date back 4 days?If I create the RO from the SO, it does back up the start date. 

Hi there! I am seeing GL batches created and I’m not sure what is causing them or why The transactions in question are the blue highlighted batches. I’m able to link all of the other GL transactions back to their source documents and they make complete sense but it seems like AFTER we release an invoice (and after the GL for that action is created) another GL is created moving funds from the HEADOFFICE unearned revenue accounts to the SEEDS unearned revenue accounts. When I click the source document for these 2 batches it brings me back to the prepayment. When I click the audit history of these batches I’m able to link the creation back to an automation that releases the invoices but to me it doesn’t make sense as to why it’s happening when it happens. 

When a customer is set to credit hold or inactive they do pop up in the search.  My concern with this is we had an employee accidently create a new customer for someone that was previously set on credit hold (also happened for one set as inactive) that we shouldn’t be selling to due to past due account.  How is this best handled in the system so employees are seeing these customers when searching.  

Hey all, I looked through the search but I could find a definitive answer. I would like to know if there is a stardard GI or report were I can find a PO that was deleted, more pointedly who deleted the PO. I have already enable the “show deleted records” in the Purchase Order GI but that does not produce any results. We have had this crop up a few times and I would like to find out why it is happening.  Let me know if there is a way to do this. Thank you

Hi all,I'm trying to create a prepayment invoice via the Acumatica Contract-Based REST API. I'm POSTing to:/entity/BDP/24.200.001/SalesOrder/CreatePrepaymentInvoiceOKWith payload:{  "entity": {    "OrderType": {"value": "SA"},    "OrderNbr": {"value": "0001170"}  },  "parameters": {    "PrepaymentPct": {"value": 100.00},    "CuryID": {"value": "GBP"}  }}I'm getting a 500 error: "The Create button is disabled" (PXActionDisabledException). The SO status is fine — I can create the prepayment invoice manually without issue in SO301000 and SO501000.My understanding is that the Acumatica commerce connector creates prepayment invoices via the API successfully — so there must be a way to do this. Has anyone solved this, or can point me to how the commerce connector achieves it?Thanks, James

Hi, working with a base report for Germany ARXXX.rpx, we have now new a Swiss localization and added the base report with the localization tag in the name ARXXX.CH.rpx.We wanted to make some changes in the CH report and noted that if we make some changes in the data schema (for example different parameters or filters) , the report CH does not work anymore if the localization CH is activated.It looks like the Schema has to remain the same for base and localization version and only the content of the report can be adapted in the localization version.Can someone confirm these findings?

When an invoice is generated from FS501300 (Service Contract Billing) an invoice is generated using items that are listed in FSContractPeriodDet (Services Per Period tab on the Service Contracts Screen)After the invoice is generated, there is no way to tie the invoice line (ARTran) back to a specific service/item which is IDed through the ContractPeriodDetID field.It appears to me that the ARTran table should have a ContractPeriodDetID field so that we can link back to the correct service contract line. There are no noteID or line nbr fields in FSContractPeriodDet table. The only unique identifier seems to be ContractPeriodDetID.Am I missing something or is this an oversight in the table design?We need to link back to the equipment number defined in the FSContractPeriodDet table, but there appears to be no way to do so. 

The new Project Address fields implemented in 2020 R2 to replace the single Project Site field is definitely an improvement.  But I wonder why it isn't configured as a selector whereby the user can select from the customer's locations, like the Default Location.  Have others encountered this?  How are you handling it if so?  

Hi, how do I reverse FA Reconciliation+ type? 

When a customer orders from our online store the sales order comes into our system sometimes before the payment. When the payment does come thru, because that payment can be for multiple sales orders it comes into Acumatica hitting our Unearned Revenue account under the HeadOffice Branch.I have created an import scenario that takes that amount and based on the applied to order of the sales order and allocates the money to the respective branch of the Unearned Revenue accounts. My original plan was to have this import scenario run once a night since most of our sales orders aren’t touched same day, but I’m wondering if a business event can trigger that import scenario for when payments do come into the system?

Hello,I am trying to add two custom fields (UsrMXFEPedimentoNbr and UsrMXFEImportDate) to the Line Details (Line Splitting) grid in the Shipments screen.Acumatica Version: 2025 R2SO302000 - Line Details panelFollowing the standard extension pattern, I created the .ts and .html files. However, when running npm build, I get an error stating that #grid-LineSplitting does not exist.After investigating, I noticed that SO302000_LineSplitting.html references a shared component: ../../../IN/common/line-splitting/panel-line-splitting/panel-line-splitting.html. Since the grid is defined in that shared template and not directly in the SO302000 main files, the compiler cannot resolve the after="#grid-LineSplitting" instruction. This is my code: SO302000_MyExtension.tsimport { placeAfterProperty, PXFieldOptions, PXFieldState } from "client-controls";import { SOShipLineSplit } from "src/screens/SO/SO302000/extensions/SO302000_LineSplitting";import { SO302000, SOShipment,Transactions, Packages } from

We are an engineer to order environment with an external, non-Acumatica product configurator. The output of the configuration tool is a JSON collection of operations, phantom sub assemblies, and materials. We are looking for an API based solution to create Production Orders linked to a Sales Order Line with a custom BOM. We're able to create the Production Order, but are running into difficulties identifying the correct method of providing the Operation collection along with their associated Materials [Stock Items]. We’ve tried using ProductionOrder, ProductionOrderDetail, and the CreateProductionOrder/CreateProductionOrderProcess[All] Action and have not had any success getting the Operations collection to populate.For example, in ProductionOrderDetail, we’ve supplied the Operations like below:{        "AllowPreassigningLotSerialNumbers": {        "value": true    },    "Branch": {        "value": "PRODWHOLE"    },    "CostingMethod": {        "value": "Actual"    },    "Hold": {     

Hello,We’re just over a month into our implementation and the business is looking for reports that list sales of certain models by units and not by $. Are there standard reports available or does this require a new GI?

Shopify store uses a custom app that relies on the exchangeV2 field from Shopify Order API. This field was deprecated in April 2025 and is being phased out following Shopify's standard API versioning cycle. You need to migrate to the Returns API before April 1, 2027. The app(s) impacted are: Acumatica ERP

For example, in Generate Forecasts, AM502000, I need to bring in a cross reference to display since our reports all use cross refs for internal work. I’m comfortable enough with the no-code to bring in fields in “Add Data Fields”, but I’m stuck on this. From what I can gather, I’d be doing a graph extension, but I’m lost on the rest. Could someone either point me in the right direction for examples I can pull from, or can you tell me the process? Thanks much in advance. The ability to have a cross reference displayed will be game changing on many of our screens.  

Hello, We have an issue where default email accounts linked in preferences are not populating when emailing purchase orders and sales orders.The group purchasing and customer service email accounts are linked in the default sources under mailing and printing, but the system still defaults to a generic non purchasing or customer service email when emailing forms.

One of our warehouse locations cannot be used in any production orders. The system says its inactive, and has zero quantity. This is despite the fact that it clearly on in the warehouse tab, has quantity in it, and production consumption is enabled. The parts in this location can even be used in Sales Orders without issue. I’m not seeing any reason why this location wouldn’t be working while everything else is. What could be causing this issue? 

I am trying to setup and use the Calculate replenishment part of our system.  I run the calculations, and they do not appear to be correct.  I have an item that I sell 10-12 per week.  And the lead is 5.22 days.  The system is calculating my Safety Stock at 1.09 and the reorder point at 2.91 and max suggested at 2.91.  At this rate I would always be ordering for every order that I get.  I would always be out of stock.  I have read the help menu to try and understand why these calculations are off, and I am thinking it has something to do with the number of days I am trying to stock for.  But I do not know where my setup is incorrect.  Is there a good tutorial on how to set this part of the system up?  And how to setup the Replenishment parameters.   Thank you,Kevin

Is there some sort of a “Customer Center” where we could go to a specific customer, and see every single activity that customer has with us?. Everything from Quotes, Sales orders, shipments, invoices, current balance, payments made, etc.   We came from Quickbooks Desktop and they had a customer center which showed all of this, but I am not able to find a place that tracks everything like this.  An example of this in practice would be:  A customer calls and asks one of our sales people a variety of questions, like how his current order is going, if we can send him copies of his invoices from past orders, and what is the balance on his account.  Where do we go to find this all in one place instead of jumping around?