Discussion Forums

Have made one Custom Endpoint under GI which is having User, Roles Entities added and we are able to fetch custom endpoint data using Odata in VMware Postman but want to publish this endpoint for all end-users with valid Acumatica credentials and same endpoint if can be configured in Java CodePOC DescriptionWe are working on a Hyper Scaler project POC and need to build an Acumatica Connector which should extract data from Cdata (serving as the data source) and synchronize it into some Data store. Additionally, it should retrieve detailed Access Control Lists (ACLs) from Cdata and perform ACL synchronization alongside the data sync to ensure least-privilege access for logged in use

Can you help me? The closed invoices should no longer appear in the template, as the payments have already been applied. Also, the aging report appears to be incorrect — all entries are showing under 'Current,' which shouldn’t be the case. I’ve already set the 'Period From' and 'To' in the template,

 Hello Team,I am creating an automation where the system will automatically create Purchase Receipt type Transfer Receipt and add all the SO have the same Project ID on that transaction. However seem like the import dont work, please view my setup as below:1. I create an generic inquiry list down necessary info. You can find attachment for reference  A business event with setup group record by Project ID with an aim to create only 1 Purchase Receipt if there are multiple of SO with the same Project ID. It was raised by schedule Create an Import Scenario for create Purchase Receipt type Transfer Receipt and add all SO  As the result, the system only create Purchase Receipt and cant add Transfer order.Looking for advise from you allThanks in advance

Hi everybody,is it possible to create a contract from a sales order? For example: I sell software for a monthly fee. I have the non-stock item “software usage” in my sales order. Can I now create a contract based on the sales order?Kind regardsMichael

All,There is one customer where we need to charge an additional 10%; I’m confident we can accomplish this via Discount Codes but I’m at a loss on how to go about this.Are there any tutorials, walk throughs, videos etc on how to accomplish this?Any solution will do -- at the individual item level, via discount code, via a special item class, whatever it takes -- we need to apply an extra 10% for a specific customer to drive that price to our ecom portal.Thanks!

Hello community,i have been trying to import sample time cards into the system, but the scenario triggers the following error:how to resolve this?I also have attached the xml file for the scenario.

I’m trying to work through course T290 using 24.211.0024 (2025R1) and have got stuck with the step where I compile screen RS201000 using the command:npm run build-dev -- --env screenIds=RS201000This fails with the error:Task never defined: screenIds=RS201000 Has anyone seen this before and knows how to resolve it? Other npm commands work OK. I needed to execute  Set-ExecutionPolicy RemoteSigned  before npm would run at all. And edit gulp-tools to resolve the message Error: spawn EINVAL by changing line 108 from const cmd = spawn(command, args, { cwd, }); to const cmd = spawn(command, args, { cwd, shell: true });Also “npm run build-dev” works without the extra parameters.

Error: The Confirm Shipment action is not available in the Shipment: Shipment Nbr. = 000009 document at the moment. The document is being used by another process.When i am conforming the shippment the following error has occured.

Hi! Currently emails that come through on the Acumatica cases, we also receive them in our outlook inbox. Is there a way to set up notification for when a ‘note’ is created on the customer portal? Or to just notify the case owner in general if there is a new activity (that is not email) created on the case?Thanks! 

I am creating a PO receipt through the REST API, and for lines that are sent to a different warehouse or location than the default, the quantities are doubled.  The client has separate virtual warehouses set up for damaged goods, if if received products are received to the damaged warehouse, the resulting quantity shown in the UI is always double the quantity that I sent in the HTTP body.  Anyone have any ideas what is causing this, and how to avoid it?Jim 

Looking to see if the rest of the room has any creative ideas to accomplish this. We create orders with multiple pieces.  Some of the pieces are in stock and the other pieces may need to be sourced.  You can go in and allocate a serial number but it still allows another order to allocate it until someone tries to confirm a shipment (Hard transaction).  Then it stops you due to being allocated to multiple orders.   How can i allocate an item where it won’t allow someone else to choose/allocate it as well?  (Pack and Hold electronically).  

I have read 3 different posts on how to set up emails, all of them break from what is available somewhere along the way. The closest I’ve gotten is:https://community.acumatica.com/security%2Dand%2Dauthentication%2D222/how%2Dto%2Dset%2Dup%2Dexchange%2Donline%2Doffice%2D365%2Dand%2Dazure%2Donline%2Daccounts%2Dusing%2Dmodern%2Dauthentication%2Doauth%2D2%2D0%2D4638?tid=4638&fid=222But they want my email authentication to be set to: Azure Modern Authentication, all I have is OAuth 2.0, they also have an “advanced” tab, which I do not.This help article (specifically for Entra ID) (https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=7ea4c814-8b24-4a77-9ae0-9596012fbfab) fails at setting the external application’s type to OAuth 2.0 (no such option exists on the external applications screen).I’m on Acumatica 24R1. I need to get an email account configured, that email is an office 365 entra ID email. How do I allow emails to be sent from this account inside of Acumatica? Thank you!

This happens on a non billable item. Can someone assist me in troubleshooting the below issue. Brief explanation:When a user selects a project task from the search option in Acumatica, it is always displayed as a billable item. However, once the form is completed using the same information, the task is correctly indicated as non-billable. 

Hello. When I create a sales order with code it is different to the sales order I create via the UI.The order type and customer are the same so I don’t understand when the final order is different.The sales order below has been created with the UI. I only set the Customer and Customer Order Ref fields. Notice that the Contact field has been set to ‘Book In’ automatically.  To create a sales order using code, I’ve used the following code.SOOrderEntry sOOrderEntry = PXGraph.CreateInstance<SOOrderEntry>();SOOrder sOOrder = (SOOrder)sOOrderEntry.Document.Cache.CreateInstance();sOOrderEntry.Document.Cache.SetValueExt<SOOrder.orderType>(sOOrder, "SA");sOOrderEntry.Document.Cache.SetValueExt<SOOrder.customerID>(sOOrder, 7511);sOOrderEntry.Document.Cache.SetValueExt<SOOrder.customerOrderNbr>(sOOrder, "Test Order");sOOrder = sOOrderEntry.Document.Insert(sOOrder);sOOrderEntry.Actions.PressSave();The sales order created is shown below. The Contact field is empty!  Can anyo

Scenario:A Fixed Asset Clearing Account was included in an Account Group. The FA Clearing Account was used for a Fixed Asset transaction with the Purchasing+ transaction type, but the user encountered the following error:“Inserting 'GL Transaction' record raised at least one error. Please review the errors. Project is required but was not specified. Account '1210101900' used in the GL Transaction is mapped to a Project Account Group.”The FA Clearing Account needs to be included in the Account Group so the user can monitor project-related costs.Also, how to specify a Project in an FA Transaction?

Use Case: I needed to show line-level markup % on Sales Orders based on Unit Price and Unit Cost. Here's how I added the field and got it working smoothly in SO301000 (Sales Orders). Step 1: Create DAC Extensions1.1: SOLineExtMarkup (Line Level) namespace PX.Objects.SO{    public class SOLineExtMarkup : PXCacheExtension<SOLine>    {        #region UsrMarkupPct        [PXDecimal(2)]        [PXUIField(DisplayName = "Markup %", Enabled = false)]        [PXFormula(typeof(Switch<            Case<Where<SOLine.curyUnitCost, NotEqual<decimal0>>,                Multiply<Divide<Minus<SOLine.curyUnitPrice, SOLine.curyUnitCost>, SOLine.curyUnitCost>, decimal100>>,            decimal0>))]        public virtual decimal? UsrMarkupPct { get; set; }        public abstract class usrMarkupPct : PX.Data.BQL.BqlDecimal.Field<usrMarkupPct> { }        #endregion    }} 1.2: SOOrderExtMarkup (Header Level) namespace PX.Objects.SO{    public class SOOrderExt

Are we able to edit the title line on the Balance Sheet report? We have consolidated Balance Sheet defined and it is either showing two different company names at the top or the wrong company names when viewing the different company reports through the tree selection. I’m not seeing the ability to open the Balance Sheet in the report designer and the row and column options do not seem to apply to the company names at the top. I’m trying to determine what variables it using for the company names.

The below formula is currently working for me to display the [ARTran.Qty] for the last 365 days. Now I need to add a seperate column to my GI that displays [ARTran.Qty] for Year To Date in the Results Grid > Data Field. Any advise on how to achieve this? =Sum(IIf(DateDiff( 'd', [ARTran.TranDate], Today() )<=365,[ARTran.Qty] , 0)) Thanks in advance! 

Good morning, When a project issue is created in Acumatica there is an option to establish a cost or day impact. Once this is setup where would the cost impact appear? Would I need to create an AP invoice for say the busted water heater needing fixed? Same question with the Days impact? How does that affect my project and where would I see that appear besides just in Project Issues screen?

Hello!I want to generate expense analysis report from report definitions and I’m required to view YTD as well as average value for a period. For an example, if I’m taking YTD values for 7th period, I want to view the average value for a period (YTD expenses / 07). I can take the YTD values (Ending Balance) and couldn’t find a way of taking average value. Is there anyway that I can do this?Thank You! 

Hello I am currently attempting to add some rich text edit fields to my customised page in Acumatica. I have tried following two different posts with two different issues following this acumatica - How to add a memo / formatted text field ala Cases - Stack Overflow post gives me no errors but the field does not work and is only a single line which cannot have anything inputted into  as seen on the right of the image below  The second post i have tried following being acumatica - How can I add a rich text box such as in the details tab in the Cases (CR306000) screen? - Stack Overflow gives me a field which works perfectly i can put data in and it saves. However whenever i go to the page it is on i get an error reading “ undefined: Cannot read properties of undefined (reading 'getValue')” Anyone able to help? Do not mind on which method ends up working Thank you!

 Hello All,I have a scenario where I created a new tab called “MyOrder” on the Sales Order screen (SO301000) using a Customization Project. Inside this tab, I have a grid bound to a custom table (MyOrder) that has a foreign key relationship with SOOrder (OrderType and OrderNbr).The grid correctly shows the data after I insert records inside the RowPersisted event of SOOrderEntry. The data comes from an API call (currently hardcoded for testing). Here is a simplified version of my code:public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry> {                                                                             public PXSelect<MyOrder,         Where<MyOrder.ordertype, Equal<Current<SOOrder.orderType>>,           And<MyOrder.orderNr, Equal<Current<SOOrder.orderNbr>>>>>     MYOrder;      protected void _(Events.RowPersisted<SOOrder> e)     {         SOOrder row = (SOOrder)e.Row;         if (row == null) return;      

Hi everyone,I’m currently working with Acumatica and trying to expose a custom table via REST API. I created a custom API entity and endpoint, but the API response doesn't return the expected field values.    I created a custom graph:And the DAC:I also created:  A custom screen VX101010 A custom REST API endpoint, in which I manually added a new entity for webOrderTaxComparison and mapped the fields to the webOrderTaxComparison view.Using Get API  GET /entity/webOrderTaxComparison/20.200.001/webOrderTaxComparisonSince I created a separate custom API endpoint and manually mapped the fields, is there anything else I need to do for Acumatica to return the actual field values in the custom object?  Any tips would be greatly appreciated!

Hi, I've created an import scenario to import customer payment methods, and the import completes successfully. However, the imported payment method is not appearing under the Payment Method tab in the Customer Master screen. Could someone assist me with this issue?For reference, I have attached the Data Provider and Import Scenario.Thanks 

Client has a business event triggered by schedule to run everyday (workdays Mon-Fri) to send email notification but doesn’t want to send it when it is a Holiday.  Is there a connection between Holiday list define under 'WORK CALENDAR' to 'Automation Schedule' function?