Solved

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?

Our company has an ongoing problem of customers paying twice for invoices that they pre-payed on because the invoice doesn’t show payments applied to that invoice. I have added a subreport to show an invoice’s payments. Now, I need a way to use the payment total on the main report, which I know can’t be passed from the subreport to the main report. I ask about this on StackOverflow before I knew this community existed and someone there suggested a DAC extension, which I’ve never done before. I’ve read through the 2019 R1 Customization guide and have a weak grasp on how DAC Extensions work. The problem is that all of the examples are shown for user entry fields and all of the examples I’ve found on StackOverflow are for user entry fields, too. I need a extension field that is calculated for the report and I haven’t found an example for that, yet. I’m waiting to get approval from the finance department to contact our third-party Acumatica support company, but in hope of getting it done a

I am experiencing challenges with Access right to company documentation.We have a 3 step processStep 1 - Receive supplier invoice for expense in Company A, Create AP InvoiceStep 2 - Create ARInvoice for the on charge to my sister company, create in Company A. ARInvoice is based on AP Invoice line detailsStep 3 - Generate the APInvoice, use Generate Intercompany Documents [AP503500] Process, from the ARInvoice - APInvoice in Company BMy challenge and I hope you can assist, I need to view the PDF/file attachment for the expense received from the APInvoice that is Step 1  on Inter company Process.The challenge is that the user in company B does not have access to the Company Access Role (company A) & hence cannot view the Supplier Invoice.We are on Acumatica 20.208.0031. Row level security for Vendor Access is activeWe do not want to give the user access to the Company Access Role.  How can the access rights be adapted to be able to view the Supplier invoice that was created in a diff

Hello,  Can i consult the code source of the methods in PXCache. For example method : GetValueExt best regards. 

Hi SirI would like to do bank recon in system. However , i am not able to import the bank transaction that i extract from bank under excel file (refer to below)  Not sure what is the problem? Could anyone give me a guide/step to import/upload the bank statement transaction to system for me to do the bank recon?  

Wondering if anyone has tried the following before:Step 1) Web service call (REST) to create a Drop Ship Purchase OrderStep. 2) Web service call (REST) to create Sales Order, including Drop Ship PO information at the SO Line level in the PUT request. Has anyone tried to update the PO information on the SO Line via REST API call? Below are my two API calls – first for creating the PO, second for creating the SO.  I am trying to populate the “POOrderNbr” on the Detail record directly (which is essentially what it looks like the PO Link functionality does).  Assuming that the PO Link has some extra logic baked in that allows this field to be written to as needed. Purchase Order API call: {   "Details":[      {         "InventoryId":{            "value":"ITS-002687"         },         "LineNbr":{            "value":1         },         "OrderNbr":{            "value":"400080001"         },         "OrderQty":{            "value":1.0         },         "UOM":{            "value":"EA"