Solved

Hi!Could someone help me to understand why this Import Scenario is showing me an Customer ID error and also validate the mapping? I want to import SO with the OrderNbr that the Numbering sequence is giving and with various lines per each SO.The next image is the import by scenario screen with the error: And this is the Mapping screen for the import: Attach to this post is the XML.Thank you for your help!

Hi All,We want to extend a Business Account to a Vendor using an Acumatica Webservice endpoint. In the past we were successful in making a POST request to extend Business Account to a Customer using ‘ConvertBusinessAccountToCustomer’. We were hoping if there is something like that event for extending to Vendor as well. Any leads on how to accomplish this would be greatly appreciated. Best Regards,Amruta

The Description field looks to be in default paragraph mode. Is there any limitation to the amount of information that can be added to this field? We have parts that require extensive technical descriptions.Do we have the ability to attach a document to this description?

Hi,I have done Custom in Purchase Order ScreenIn POLine level am trying to update Curyunitcost according to InventoryID -(Stock Item screen-Valuation Method-Specific)equal to 0it is updating but in header order total is updating with the price cost which is defined in stock items screen..From Where it is getting updating am not knowing..Please Suggest me with the Proper solution 

Hi. We have a client requiring setting up of approval maps for 156 branches for 12 modules 2 tier (preparer → reviewer) 3-tier (preparer → reviewer → approver)with conditions and rule actions. We believed we can expedite by either using import scenario or, worst case scenario,do a direct SQL.Anyone encounter such experience before? Thanks in advance. 

 When my company went live with Acumatica in 2019 we were given access to a preview release of the carrier integration for ShipEngine.  Last week upgraded to 2021 R1 (v21.117.0037) which includes this feature out of the box.  Before the upgrade I unpublished all customizations and did not republish the early release version we had been using.  Before this upgrade everything was working for us as expected between Acumatica and ShipEngine.After upgrading to 21R1 I had to modify our carriers to use our ShipEngine Account ID instead of the API Token that the preview release required.  After that change the Test Connection button on each carrier reports success.  However, when I edit a ShipVia based on one of these carriers the service method selector no longer loads in any of the services tied to our account.Due to this configuration issue, we are not able to successfully refresh rates or shop for rates from sales orders.  We are able to create shipments successfully with update 17, so I d

Hello,         We are having a scenario and I would like to know what is the best way to log them in system. Here is the scenario and what we are doing now:         Both “Costco” and “CITI bank” are vendors in our system.        We purchase some items from “Costco” using credit card. And in order to track inventory, we created a PO from Costco and received the items and generated the bill to Costco. We call bill 1 .        And also monthly, we get a bill from “CITI bank” including the total amount used in Costco and other amounts(means not the same with bill 1), like fuel, gas (not inventory item, so no POs). In order to log the payment, we also create a bill to “CITI Bank”. We call bill 2.          Now you see, on bill 1 and bill 2 we are actually having same item. so we don’t have to pay twice. And also we don’t have to double our liabilities.       Can anyone give me some directions to deal with this scenario in a best way.

We have 20 clients on MySQL (2019R2) which we plan to migrate to MS-SQL (2021R1)What are the requirements for such migration exercise?What would be the best practice in doing so?Was looking at 2 options,i.e :Migrate DB from MySQL to MSSQL or SnapshotAny advice would be greatly appreciated.Thanks in advance.

Is there a way to combine a Repair Order in Production with Equipment Management, so that equipment management is updated with changes made in the repair order.  Can the items of a BOM be added as a component to an item for equipment management?

I have added a custom field to AP Bills that entering value should be mandatory. On the AP Bill screen system shows a red astrix by the field label that when value entered turns its color to black. But system doesn’t force the user to enter value for it and accepts saving the form without having data in this field. I have made it “Required” as you can see below. Why?Here is the field definiatin: #region UsrCFApprovalRouteID public abstract class usrCFApprovalRouteID : PX.Data.BQL.BqlInt.Field<usrCFApprovalRouteID> { } protected Int32? _UsrCFApprovalRouteID; [PXDBInt()] [PXDefault(typeof(Search<SMUserPreferences_Extension.usrCFDefaultApprovalRouteID, Where<UserPreferences.userID, Equal<Current<AccessInfo.userID>>>>), PersistingCheck = PXPersistingCheck.Nothing)] [PXSelector(typeof(Search<UDCTEPApprovalRoute.approvalRouteID, Where<UDCTEPApprovalRoute.isActive, NotEqual<Fals

Hello, We want to track transactions that are discounted, due to a misprint/reprint (we decorate our products). I’m assuming Reason Codes on the SO Line is the best way to track this, but please suggest any good alternative ideas. Is there a way to make Reason Codes required for discounted SO Lines? Our users will forget to input a code unless we require it. 

I’m working on an upgrade from 2019 R1 to 2021 R1 and it appears that my Files section of the Customization Project Editor no longer has the add button.  I’ll share an image at the end with a side by side of a 2021 R1 demo site loaded with the U100 data set.Until today, I’ve never had cause to use the add button in Custom Files on this upgrade instance.  In every other customization project on this site (with an extension library) the DLL is visible by default. However, I have one project where the DLL did not show up and I can't figure out how to correct that if I cannot add the file and the detect changes button isn't picking the new DLL up.  I cannot say if the add button was on this screen after moving from 2019R1 to 2021R1, I never checked.I'm not sure the way I noticed this has any bearing on the ultimate cause, but I'll include an explanation if it ends up being relevant:Today I was working on a customization project that was all custom fields and no business logic.  I wanted to

Hello There, I need to change a field mask to match with my Projects mask but i’m getting the below error. I tried customizing the base attributes through graph cachattached but I get the same error. Here is the error: Property set method not found.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.ArgumentException: Property set method not found.Source Error:Line 959: {Line 960: PXDataSource datasource = ((PXPage)this.Page).DefaultDataSource;Line 961: if (datasource != null && PX.Data.Process.PXAuditHelper.IsInfoAvailable(datasource.DataGraph, datasource.PrimaryView))Line 962: {Line 963: PXCache cache = datasource.DataGraph.Views[datasource.PrimaryView].Cache;Source File: C:\Acumatica\LarkGroup\Controls\PageTitle.ascx.cs Line: 961Stack Trace:[ArgumentException: Property set method not

Is it possible to default check boxes as checked? For example, in the Kit Specification (ScreenId=IN209500) the Allow Component Addition box and the Allow Component Qty Variance boxes default as unchecked. My client always has to check these. I want to make them default to checked. I’m guessing this is going to require a customization but was hoping otherwise. What would that customization look like?

Hi,I have created import scenario to import invoces and line items, when i execute prepare and import action for each record from excel a new invoice is created.In the excel there is only one invoice with 53 line items. But when import is done 53 invoices are getting created.Following is the image shot of the Import Scenario i have created.  Let me know what is the wrong in the above scenario.

Hello,       Does anyone know is there a way to set Maximum order qty for a certain item on order line?Like we are having item A, item A is a hot sell item, so we want to set a limit that each order can only buy 3 at maximum. Is there a way to do it?

Hi All,I have created a customized panel in “Sales Order” screen and this panel all user to add items to the SOLine.After I click on “Apply” or “Cancel” button the selected check box should be cleared. How can i achieve this. I used PXBool for selected field it is not working. Is this field is controlled buttons?Please help me on this   Regards,Ramya

Good day,Does anyone have any ideas/or maybe some documentation on how to set-up an update from an existing tenant to another tenant.  We have production tenant that needs to be update from a development tenant.  The development site has be updated/migrated with information from QB for prior and 2021 AP and AR, Customers, COA, etc. transactions which we now need to move into production.  Production has only 2021 data.  I can’t use Snapshots because the dev tenant is four months old and we are updating or adding new production transactions (none which are been posted).  Our vendor is working on programming a connections between to the two tenants and communicate updates to from dev to production.  Any insights?  Or have has anyone done a similar project before.Happy Holidays

Hi,I have two or more tenants in the same instance and i want to get the data from one data updated into another tenant not replaced, I don’t want to use sanpshot shot option as that will replace the tenat data.I want to insert the data so that old data remain intact.Do import scenario or generic enquiry serve the purpose. 

We’re using a slightly modified Inventory Balance report. Some items are being excluded from the report. Only common denominator I can find is these items all appear to show ZERO QUANTITY ON HAND and ZERO AVG COST. But I can’t figure out why that would exclude them. Like I said the file is modified from the original, so I’m attaching it here. TIA! 

We have a purchased part with a safety stock.  An existing PO will cover requirements, but it’s delivery date is far out and the vendor cannot expedite.  We will fall below the safety stock. MRP display is telling us to place a new PO, which we do not need to do.MRP detail inquiry shows this.MRP exceptions screen does show we need to expedite the PO, but since we cannot, this part will continue to show up on MRP display telling us to place another PO. Is this the general process?Do not create new POs from MRP display until you look at the detail inquiry to ensure an existing PO does not already exist?Is there any way to drop the part from MRP display other than changing the date on the PO to say it will arrive earlier (which it will not)?Thanks! 

I  am trying to update the Shipment line detail with Screen Based SOAP API service.The code is  executed but respective record not updated.Following is the code snippet var commandList = new List<Command>();                                             commandList.Add(new Key                {                    ObjectName = SO302000.Result.DocumentDetails.LineNbr.ObjectName,                    FieldName = SO302000.Result.DocumentDetails.LineNbr.FieldName,                    Value = LineNbr.Trim(),                    Commit = true                });                commandList.Add(new Key                {                    ObjectName = SO302000.Result.DocumentDetails.ShipmentNbr.ObjectName,                    FieldName = SO302000.Result.DocumentDetails.ShipmentNbr.FieldName,                    Value = acushipmentNbr.Trim(),                    Commit = true                });                commandList.Add(new Value { Value = shipmentLines.ShippedQty.ToString(), LinkedCommand = SO30

I have seen a customized change that displays more address fields when selecting the location in the header of the sales order screen.  However, I do not know what mechanism was used to create this change.  It does not appear that the screen editor allows you to make changes to the window that pops up when you click to search for the location.  Standard functionality when selecting the location is just to show 2 fields.  The customized functionality displays address 1, address 2, ZipCode, etc…. Can anyone point me in the right direction to what tool/method would be the place to start in investigating how to accomplish this?

I need to inquire about the do ability of having Quality Control or Check in Acumatica new version 2021 R1

Hi!If I have an attribute list type and I'm using it as an UDF within Sales Orders and I want to limit access to one of the attribute value for specific users, is it possible?Thanks!!