I need to look for a sales order that MAY exist or MAY NOT exist in an import scenario and the order may be accessed multiple times across different imports. If the order doesn’t exist, I need the import to start a new order.The import file has a customer reference number. This is a unique field and is my index to look for. If no match is found, I need a new order created. I thought the following commands were what I needed (ignore the highlighted line, it’s not active): I get two types of errors: If the commit box is checked on the line:Order Nbr → Customer Order NbrWhen I run the import: I get the first row to process, everything says success, but all rows are skipped except the first row. In my 5 rows of test data the PurchaseOrderNumber field alternates between Test1 and Test2. So if I run it, I get a new order with Test1 and ONE item on it (should have 3). The two rows of Test2 get ignored as do the other Test1 Rows. If I run it AGAIN, a new Sales Line is added to the order with
I have a user defined drop down field. I want to show the display values, not the stored variable values. When I run a GI, I get the values that my users see. When I run a report, I get the underlying variables.Here is my setup:[PXDBString(20)][PXUIField(DisplayName="Routed")][PXStringList(new string[] { "", "NA", "TD", "SR", "92", "LA", "TPS", "TPL", "TPN", "TGP", "TGS", "BD"}, new string[] { "", "N/A", "Troutdale", "92nd BLDG 3", "92nd BLDG 4", "LA 3PL", "TP Seattle", "TP LA/LB", "TP New York", "TGR PDX", "TGR SeaTac", "Boyd 3PL"})] When I call the field UsrRouted in a GI I get the bottom string as expected (Like “Troutdale). When I call the field in the report writer, I get the field codes from the first string (Like “TD”). How do I get the display codes from the 2nd string in a report? I can make an abomination of an “IF” statement, but that’s not the right answer, because it can’t be scaled. Thanks Everyone!
How do I get two screens to open at once in the Mobile App? For example, running SCAN AND TRANSFER, while also running ITEM LOOKUP to help me select the proper locations for the SCAN AND TRANSFER screen. Right now, leaving SCAN AND TRANSFER removes everything, so I can’t go check that I’m looking in the right locations etc. Any help is always appreciated!
I have a business event calling an import scenario (Issuing out the goods on a PO). The event frequently says the Lot/Serial number can’t be found. If I go into the History, I can see the failed event, hit reprocess and it works.So... Is there a way to get this event to try and reprocess on it’s own? Maybe like breathe for 5 minutes, then retry any failed events?I’m assuming this is either a failure on Updating IN in a timely manner or my import scenario sucks and it’s probably my import. hoping for the easy method of forcing the B/E to reprocess though, since that seems to go without issue.
We did a massive client upgrade from Version 19 (which only runs in Internet Explorer) to 23.113.0042 The snapshot is too large to move, so we enabled external file storage LOCALLY, moved those files into an AZURE BLOB. This works just fine for local files, this does not bring back files in the new version using the Azure Blob, even though it has the correct File ID in the file link. We CAN make new files in the new system and they do get sent to Azure and we CAN recover those contents through acumatica. If we try to access one of the other files, it claims it does not exist, but we know it exists as the File ID still points to the correct object in Azure and we can open it (for example the company logo that should display in Acumatica). Anyone have experience with this type of behavior before? Thank you for digging with me!
How do I set my payment terms at the vendor location level? I see it on the umbrella, but I pay an agent (umbrella), who controls many factories (locations), each with specific payment terms. How do I set these termsat the location level?
How do we look-up an item in the mobile app by description? The employees have no idea what the ID is, they just want to be able to search “bulb” in a selector (Preferably on Item Lookup) and then choose the proper item, but everything I am seeing expects an Inventory ID and doesn’t allow for a description.
Can we display images from Stock Items in Power BI? I have an OData feed that sends me the image URL, but all I get are the broken image tile symbols in my Power BI Reports.I am sending over links like: https://<MY INSTANCE NAME>/Frames/GetFile.ashx?fileID=668331C4-23A0-423F-A394-FD01CC97E868I’d love to have some fancy inventory reports come out of here if possible. I’m reading some stuff about images needing to be public, but I’m passing credentials already with OData, so I’m not quite sure where to go from here or if this isn’t an option at all with Acumatica.Hopefully someone else has had success wtih drawing an image from Acumatica into Power BI.Here is my column format: Here is my broken output: Thank you for your time and assistance!
What field defines the default Unit Price for a STOCK ITEM on a 2-STEP Transfer? Doing international transfers and customs needs to know a value. It’s not a price worksheet (this is a warehouse, not a customer) and “Default Price” doesn’t seem to come over when making a new Sales Order of type TR.I can code around this (if price = 0, then get Default Price from Stock item), but if something already exists, I’d like to leverage that instead of attaching my Mickey Mouse code to the report. Thanks Everyone!
I have an open shipment, but when I go to Show Pick List then hit delete pick list, I get an abort error: Unable to reset abort because no abort was requested. Trace Log Says: Thoughts on what’s amiss here? The Pick list has a status of PICKED, but I didn’t think that would block us or anything since the Shipment isn’t confirmed.Version:Acumatica 2022 R1Build 22.107.0022
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.