Solved

Version: 21.106.0024We use “No Rounding” for rounding and “#,##0” as formatting to display whole dollar amount on the report and but need 2 decimal when export to Excel for analysis. This works fine in 20R1 version, but 21R1, only whole number got exported to Excel, seems formatting actually truncated the decimals.

I’ve created a new dropdown field for the SOLine “Return Reason” but am unable to edit this field when the Sales Order status is Completed (because the workflow step prevents it). Even after Re-opening the order I’m unable to edit the SOLine that is completed including this field.So I tried adding a new workflow:Modifying the Open and Backorder step (the act of re-opening a Completed order puts it in the Open/Backorder status) by adding the Return Reason: But the field still stays locked: Am I missing something with the workflow editor?Is there a simple parameter I can add to the DAC field?

Hello,     Correct me if I was wrong, per my test, the Acumatica Mobile APP is designed for ERP use only. It can connect to an ERP instance and use ERP functionality. But It can not use the Customer Portal functionality. Although it also can be set to connect to a customer portal site, but it display empty.    Is my test result true or just I have to do some settings to make it work for Customer portal instance?

Good morning, We’re considering extending the field length of the built-in fields for Address Line 1 and Line 2. The existing field length for each is 50 characters, and we are considering extending them to 100 or 150 characters each. I understand that there’s an additional Line 3 field that we can enable as well. We would be following the instructions in this blog post: https://asiablog.acumatica.com/2018/03/extend-address-line-length.htmlWe want to be careful in proceeding since this would be our first experience with customizing a built-in field. Is customizing a built-in field a common practice? Do lots of people do this? Do customizations like this run the risk of failing during upgrades? Are there other risks or pain points associated with customizing a built-in field? All comments and experiences are welcome.Thank you, Dave

Dear all,I have desperately tried to set up the product configurator for several hours by now. I followed the guidelines by acumatica help portal. However, if I want to try out my configuration with the action test configuration an error occurs “AM Error: The following error message occurred during calculation of a sales price for the EMS-57-EL item: Object reference not set to an instance of an object.”The item EMS-57-EL has a price set in its master data...and it is also referenced to a BOM…Can anyone help me? :( 

Since Acumatica has moved a its content to the community page, I am currently looking for a Sales Demo Data for 2021R1 Build 21.110.0032 , does anybody know where to be able to find this so we can import it into a testing tenant

I can’t seem to find the endpoint to pull all the contracts in the database. I specifically need a list of all contract ids and the associated customer.I’d appreciate it if someone could endpoint me in the right direction!

I would like to setup an audit on the Vendor name.  Does anyone know where I locate the field on the Audit Setup?I am working in 2020R2

hai, i want to ask how to solved that error ? this is import used to update data “Material” in screen Bill Of Material (AM208000). This is that Error i want to update “MATERIALS” with the same BOM, Revision, Inventory ID, and Operation ID.this is my custom import scenarioI hope someone give me help to solved this, Thanks!.

1.WE selling non stock item， I have confirmed that in non stock item [general setting], require shipping is blank2.When I create a SO to sell non stock item, the status becomes [Shipping ] and I can’t execute Prepare invoice. and can’t delete this sales order, What should I do?My current version is 20.210.0044Thanks!

Hi Guys,We have a custom report called AP invoice with 2 parameters:This gets pulled from bills and adjustments:But when i run the report it only displays the first line item on the report:Schema setup as follows:What am I missing? Thanks

We are carrying out an integration to export sales records from Acumatica Sales Order Screen into external system via third-party API, what is the best way to carry out this integration?What is the best way to send Acumatica sales data to this external API and also sales data must be sent hourly. Currently thinking of using Contract-based REST API method in Acumatica. Please let me know the right solution to go ahead with this requirement or any documents present. 

Hello Community,I have a customer running Acumatica ERP 2020R1.A user signs on to Acumatica ERP and goes to Bill&Adjustments. When the user selects  a bill (open/balanced/hold) the page takes too much time to complete to the point that if the user clicks on any of the fields , the system throws a message box informing that: “Page Unresponsive - you can wait for it to become responsive or exit the page.” The page loading time is not that much if it happened one on a while but as the user gets this delay on every document then the wait causes some work delays and frustration.On the other hand, if the user performs the same tasks (under the same conditions) but now using Edge, the page load time is definitely faster and more acceptable.  The user runs Goggle Chrome 92.0.4515.131   Has anyone experienced a similar problem? Would anyone know if this issue is somehow related to Google Chrome settings ? Could extensions be interfering? Any inputs are appreciated. 

Is there any documentation on how to connect these endpoints in API push?

Hello, Could you help me with the following issues?Where I can found  in Acumatica the costs per LOT [broken down into direct costs (RM consumption, power suppy, wages, water + sewage, variable cost) other direct (depreciation), G&A (ammortisation, salary), commercial] ?   Is it possible to do the following in Acumatica: Take all energy costs that are assigned to production (e.g. 80% of invoice electricity Q1) and distribute them equally to all articles produced in the relevant period, weighted according to the production quantity of the articles ?Thank you in advance.

Hi,Our organization is in the process of switching to Acumatica. I'm trying to import stock item profiles from our currant system, and when the import reaches half the sheet, the following error appears, input string was not in a correct format. 

Getting a message in a 2021 R2 demo site.  Is there a specific screen where I can turn this on?  Never seen this message before.

Hi folks,    Hope you are doing well.    During using Acumatica ERP, recently we have such a quest about updating a closed invoice.The details will be:Create a custom db field on invoice screen AR300010. Add it to UI. Closed the invoice. Update value on this field.Looks once an invoice is closed, all the fields get locked down.We wonder that is there a way to make that particular field editable even on a closed invoice? Best regards. Yan

Dear all,We have a requirement after MRP calculation which is to allocate by vendor ratioExample:MRP Requirement = 100Vendor A Ratio = 25%Vendor B Ratio = 35%Vendor C Ratio = 55%MRP Allocation:Material for Vendor A = 25Material for Vendor B = 35Material for Vendor C = 55How can we perform like above example? Is there any function in Acumatica can do like that?Thank you for your kind attention.Best Regards,Agung

It appears that a non-stock item can be added to a purchase order, received and paid for without ever being added to a sales order and invoiced to the customer. Is there a way to ensure that that the customer gets invoiced (e.g. requiring a sales order before creating a PO)?

How do I remove the line file atttachment column from a GI? This GI is being used on a customer portal and I want to restrict it so that it is not seen and cannot be accessed.  

Label Customization to Send Custom Report to Device Hub Returning "0 Documents added to Buffer" We are developing a label printing customization and are integrating with Acumatica device hub.  The customization is successfully creating jobs in device hub but is not adding any documents to the buffer.  I have attached our current customization project which issues print commands from the ‘print label’ button added to the Purchase Receipts screen.  It will print to a device hub printer hardcoded during testing to with Printer ID = ‘LABEL-01’.  Please see the screenshot below for more information about the error. 

I have created two unbound fields on the Create Transfer Orders screen (SO509000). This screen defaults to showing the Purchasing QTY and UOM.  The customer wants to also see the “Sales” QTY and UOM on the screen.The screen works as I desired.  Below, you can see that 0.02 of a BOX UOM is what the Prepare Replenishment screen calculated when I set it to transfer 5 units.  For that item, I set the BOX to be 250 units in a box.  So far so good.The unbound fields are created like this: NOTE: even though there is a “Usr” in the field, they are not actually in any table.  I could create them without Usr prefix, but it doesn’t really matter here.    public class INItemPlanExt : PXCacheExtension<PX.Objects.IN.INItemPlan>    {        #region UsrTransferredUOM        [PXString(6)]        [PXUIField(DisplayName = "Transferred UOM")]        [PXDBCalced(typeof(INUnit.toUnit), typeof(string))]        public virtual string UsrTransferredUOM { get; set; }        public abstract class usrTransfe

Hi Team ,I have a  requirement where an external system send the data of the attached  xml file to a text controller. there is business Logic to read the XML and convert to object and  perform business logic and then create a payment . I was tried with xml reader ,   list<> and XDocument.parse () also  facing challenge in converting with the attached xml .Can some one help me on this please  please find the attachment   

Received the following message: 'Conversion failed when converting date and/or time from character string'. My GI used two date fields; ARInvoice.DueDate and ARPayment.DocDate, I don't believe either of these data elements is stored as a Text string that would require conversion to be used in a GI. Is there more to this story?