Solved

Good dayI please need some help in adding a new column to the Employee Time page.The field would show the customers name next to the product that it is linked to, the project displays on the grid by default.At the moment I cannot seem to add an additional column to the grid, I added it via a customization and the field does show in the customization project but when previewing the page the column is not in the gridPlease assist me with this

In SM200530 the password field is, in the database, 50 characters long.  However, if I enter a password like:abcdefghijklmn1234I get an error when saving:Error: Updating  the 'Certificate' record failed because data in some field is too long.2021 R1 Build 21.103.0054

Does anyone know of a solution to integrate autodesk inventor so that boms from inventor can show up in Acumatica?

It would be very useful to have a single tab within the Project that pulled in key metrics that every project manager needs to be aware. All of this information exists in Acumatica- but not in one place where a PM can get an overview. On this tab I would want the following metrics:Current Contract Value, Budgeted Cost, Projected Cost at Completion, Gross Margin Budget, Gross Margin Projected, Billed to Date, Open AR, Cost to Date, Open AP, Overbilled/Underbilled status, Committed Costs, Earned Revenue, Earned Margin 

I've setup the Acumatica business skill for Alexa and connected it to the 2021R1 instance of Acumatica with the Alexa customization package. When I tell Alexa to "Open Acumatica" and it asks for the authorization code (which I provide), it seems to not recognize the code.  I’ve tried resetting the authorization code a number of times but it never works.  Anyone know how to resolve this?

When placing a purchase order initiated from a Sales Order, we are unable to split the order between 2 different vendors. Same issue if a PO was sent to 1 vendor and the vendor tells us he cannot fulfill the full order, we are unable to place the remaining qty to a different vendor

I tried to create an attribute and then a UDF for a custom field I need to add to the Contact form.  I created a custom project, I created the new field (as a string of length 10) and I added it to the Contacts form.  By Default, everything works fine.  It’s a string field and I am able to enter and save values.  However, I want to change it to a combo box so I can restrict the user’s entries.  In my custom project, I go to “customize” the attributes and I use the following:[PXDBString(10)][PXStringList(new string[] {"N", "P", "Y"}, new string[] {"No", "Pending", "Yes"})][PXUIField(DisplayName="Status")]It always gives me a TextEdit.  Am I missing a line of code?In the past, I have created the new field as an Integer and used the following code:[PXDBInt][PXIntList(new int[] {1, 2, 3}, new string[] {"No", "Pending", "Yes"})][PXUIField(DisplayName="Status")]This works and I could do this but I’m trying to keep the values as string and not integers. 

Hi:Will it be possible to see the Acumatica Summit 2021 keynote sessions and hopefully other sessions remotely live? Will they be recorded?These capabilities are very important for people who can not attend but still want to see the live sessions of the summit. These people include prospects, customers, partners and ISVs. Live sessions and recordings make a huge impact on the credibility of Acumatica.Please give as weblink where people can register for the live sessions beforehand so that they can schedule their time to attend remotely. This way partners can email their prospects and customers on time. Such emails should go out on 7/12 and again as a reminder on 7/18. These emails should also include the weblink for the recordings in case non-attendants can not attend the live sessions. Ideally an interactive participation by remote attendants should be possible. When people are involved, then they will be much more encouraged to look at Acumatica. Monologues don’t cut it. Also your re

Hello, Can we use the viewBag in Acumatica?or pass a value for example from Graph CAEntry to CAReleaseProcess  Thanks.

Orders from our Big Commerce Sandbox will not sync down to our 2021 R1 Acumatica sandbox  Nor can we get orders in our Acumatica 2021 R1 Sandbox to sync up to our Big Commerce Sandbox.  We are on Build 2 of 2021 R1.  Is anyone else having these sync issues?  Does upgrading to the current Build 9 fix these issues?  We are stuck and our 90-day upgrade sandbox period is about to expire.  Any suggestions are greatly appreciated. 

We scan our public IP quarterly to verify security settings and we found this on a sandbox version of Acumatica used for dev/testing internally. Anyone else getting this. Is this something we can fix or does Acumatica need to update some dependencies. Acumatica Version 2020R2 build: 20.214.0030jQuery 3.4 fixed cross-site scripting vulnerability04/23/19CVE 2019-11358jQuery before 3.4.0, as used in Drupal and other products, mishandles jQuery.extend(true, {}, ...) because of Object.prototype pollution.If an unsanitized source object contained an enumerable __proto__ property , it could extend the native Object.prototype .Cross-site scripting vulnerability in jQuery.htmlPrefilter07/18/20 Impact:An attacker could launch a cross-site scripting attack, potentially leading to theft of session IDs or other consequences andcould create a denial of service condition. Resolution:[http://jquery.com/download/] Upgrade to jQuery 3.5.0 or higher.

Hello, We’re publishing Acumatica push notifications to a Kafka topic as part of our system integration. It would help us greatly to identify push notifications that result from user actions in the Acumatica UI as opposed to actions that are performed via the API. One way to do this, I thought, would be to identify the user performing the actions, since actions performed via the API are always carried out under the same user account. Is it possible to include the name or ID of the user associated with an action in our push notifications?Thank you, Dave

Hi SirWe have encountered a problem about the inventory , we make mistake do receipt in a part # where that should be use existing 5 parts to do kit assembly into one part # . Currently , our system have extra 5k in inventory history valuation but in financial inventory account is correct . We cannot do adjustment transaction as it concern about double entry where it will affected financial account figure.May i know if there is any way to do offset the extra 5k in inventory but not affected the financial inventory figure?  Hope to hear from you soon.Thank you

Hello, Could you please help me with the following issue?When trying to import sales order and credit card payment from Shopify to Acumatica, I get the following error:  “Inserting 'Sales Order Adjust' record raised at least one error. Please review the errors.PrepaymentInvoiceRefNbr: 'PPI Nbr.' cannot be empty.”I follow the instructions from the training: V210 COMMERCE EDITION (SHOPIFY CONNECTOR) 2021 R1Have any of you already solved this problem or have an idea what it could be due to?Thank you in advance for any advice!  

Hi, (01). After expired the sales quotation we need to restrict sales order creation using expired sales quotation? Further understanding, I have attached a document with screens.  (02). Also need to know how we can build the link sales quotation number and sales order number? RegardsNethupul  

Hello Everyone,We are seeing below weird issue while opening “Customers” screen, but actually SyncTimeTag table is already present in database. Please find the screenshots for reference.Can you please let us know, when can we get this issue and how to resolve this. The table with the name 'SyncTimeTag' does not exist in the database.  

How can Hubspot and Acumatica connect?_Is there a native integration?Does anyone know the steps?The blog entry from Acumatica is not updated, help please!!

Hi allFirst time here so please bear with meWhen choosing a Customer in Payments and Applications on a specific date ( July 8th ono.) it goes blank. But when in Profile and choosing Actions- Payments and Applications the process is allowed.

Hi Team,Every time when I start debugging the code I am encountering the issue ,I build the code many times and refreshed the instance again getting same, Does any one know how to fix this . Thanks,

I am wondering if there are any tools that are available to convert data from NetSuite and bringing the data into Acumatica.  Let me know if you have any tools.  I haven’t had the ability yet to see what NetSuite has as far as export utilities.  Any help in pointing me in the right direction so I don’t have to recreate the wheel will be helpful.

In a GI, I need to query the WarehouseDetails settings for Material items included in MFG BOMs.Normally I would join AMBomMatl to INItemSite ON AMBomMatl.InventoryID = INItemSite.InventoryID AND AMBomMatl.SiteID = INItemSite.SiteID.In this case however, the client has not populated AMBomMatl.SiteID, so I thought I could add AMBomItem to the joins and use AMBomItem.SiteID = INItemSite.SiteID instead.In SQL, the query would look like this:SELECT * from AMBomItemJOIN AMBomOper    ON AMBomItem.BOMID = AMBomOper.BOMID and AMBomItem.RevisionID = AMBomOper.RevisionIDJOIN AMBomMatl    ON AMBomMatl.BOMID = AMBomOper.BOMID AND AMBomMatl.RevisionID = AMBomOper.RevisionID    AND AMBomMatl.OperationID = AMBomOper.OperationIDLEFT JOIN INItemSite    ON AMBomMatl.InventoryID = INItemSite.InventoryID    AND AMBomItem.SiteID = INItemSite.SiteIDPrior to 21R1, the GI Relations allow me to join any field from any of the tables included in the GI, but in 21.106.0024 , I cannot join fields from AMBomItem to

Good morning, We are integrating with Acumatica via its API, and have run into a situation w/regard to postal code. In the Acumatica UI, I can create a business account without entering a postal code. It doesn’t matter which country I specify in the address fields. Via the Acumatica API, I can create a business account without entering a postal code if I specify the country as France. But if I set the country to US and don’t enter a postal code, the response is a 422 error code specifying a problem with postal code. So it seems the postal code is required by Acumatica API if country = US, but there’s no similar requirement in Acumatica UI. Can any one please shed some light on this? I don’t know where requirements like this might be configured or if there’s a way we can work around this. Thank you, Dave

I see there is an option under the customer to have a default project but when I add a default project I do not see where that comes into play anywhere when I create the service order. What is the purpose of having a field to select a default project for an individual customer if it doesn’t default to the service order being created?

How to pass a variable in parameter between two screens?

Can we change the function of the Save and Close button?If yes, How can we change it?