Solved

Hi All,we created a GI and published to UI with granted for all roles, next we created business event with GI and added a email subscriber and schedule also. Now in system monitor we are getting below errorwe are in 24R1, version 24.107.0004. Can someone please help us what the issue is about.ContextScreenId = GIXXXXXXContextUserIdentity = adminCurrentCompany = companyEventID = Scheduler_SchedulerThrewExceptionEventIdSourceContext = SchedulerException =PX.Data.PXException: Error: A site map node with the screen ID GIXXXXXX cannot be found.   at PX.Data.PXGenericInqGrph.CreateInstance(String screenID, String prefix)   at PX.SM.AUScheduleMaint.CreateGraph(String graphName, Boolean secure)   at PX.Data.Process.ScheduleProcessor.ProcessSchedule(AUScheduleMaint graph, AUSchedule schedule, Object key)   at PX.Data.Process.ScheduleProcessor.TryProcessSchedule(AUSchedule schedule, AUScheduleMaint graph, Object key, DateTime nextrun)

Hello everyone,How to fix the above error? This is an order placed in BigCommerce from a B2B customer. Also, to add context: the user used to placed the order is a super admin, that “masquerades” the Customer, and place order in behalf. Not sure if that is related, but just mention if can help.

We are hosted on Acumatica’s platform, but we have two servers. I’m assuming (for lack of information) that this is a load balancing situation. We have two urls ourname and ourname-process. We are told it shares the same database. We were told we only need to install on the main server, so we install on that server. However, randomly, when we install, it causes issue. After install:Main server functions as normal. Process server:All pages are white when loaded. It loads the menus, etc. API connections to the server break with a 500 error. We can still login to the process server.I’m attaching a screenshot and the package that broke the process server. Again, it works fine on our dev server (same version), and it works fine on our live main - just breaks the production. 

 Anyone managed to import compliance > common attributes (CL301000) to vendors at all? We can import all the other standard compliance values per supplier but we don’t seem to have the ability to select any compliance common attributes from compliance preferences or have that compliance common attribute available on the import scenario, any info would be appreciated. Thanks  

I did a very large import of contacts for a sales campaign going on and it seems that roughly 6,000 of the 8,500 contacts imported did not populate the state field despite them all following the same state name formating for the import. however if I select the contact individually in the Import and re import the contact it populates the state field without producing a duplicate contact (usually). is there something wrong with my mapping that is causing this?  

Hi,I’m working on my first customization adding a new table / DAC with a foreign key linking to Customers.The need is to restrict the selection of the customer to only customers belonging to a specific class.This is what I currently have in my DAC definition for this field:  #region CustomerID [PXRestrictor(typeof(Where<Customer.customerClassID, Equal<Customer.customerClassID.Contains<"SPECIAL">>>), "Not a Special Customer")] [Customer] [PXDefault] public virtual int? CustomerID{ get; set; } public abstract class customerID : PX.Data.BQL.BqlInt.Field<customerID> { } #endregionI’m getting a “CS1031: Type expected” error on “SPECIAL”. I can’t find an example of creating a PXRestrictor condition that isn’t based around a boolean, null check or comparison to a value from a matching field on this DAC. Is there a way I can create this sort of hard-coded filter?Appreciate any guidance here.

My production ticket seems too be splitting locations of the same items and I’m trying to find ways to correct that. I also would like help to find a way to sort locations as well so I can have people pick from the same general area of where the items are by and not have them going all over the place when the sheet doesn’t have it in order. 

How can I add the BOM to a Production Order that has already been released?

I’m trying to setup integrating FedEx, and I’ve been trying to setup the RestCarrier setting. All of the guides I’ve seen are just for PX.FedExCarrier.FedExCarrier, and don’t work for PX.FedExRestCarrier.FedExRestCarrier.

I am trying to make a copy of the Sales Orders GI that is in Acumatica but I want the GI to display the Inventory ID of the items in the Sales order, I tried adding the SOLine table to the GI and relating it to the SOOrder table but the Inventory ID result tab just shows up as blank for all sales orders despite having multiple Inventory items and Inventory ID codes in each SO. has anyone else ever done this before and could show me what I need to do to get those ID codes to display in the GI?

When I create a Production Order for a specific assembly, the system grabs a BOM that is NOT set as the default. What am I doing wrong? Why doesn’t the RO use the default BOM? I’m assuming there is a setting somewhere I’m missing...Thanks!! 

Hi team, is there by default, or has anyone had success customizing a ‘first sale date’ on the stock item profile? This would function as the date of the first sales order released which contained that SKU.  The idea being we could use this to report on product lifecycles. For instance, products are tagged as ‘Launch’ if their first sale date is <12months ago. We would then run a scheduled automation monthly to switch SKUs into the next sales phase at 13 months.Thanks!

When I run Allocations by Project,  I am getting an error message of  “ The given key was not present in the dictionary.” but only on one project.  All of my other allocations ran without an issue.  The project was setup from a template like all the projects are.  It only has one cost on it for the month. I checked the one cost that hit and there was nothing unusual about it.  Everything except the amounts and the customer appear to be the same on this project versus the other projects that ran without issue.  Any ideas of where to look for the issue?

We will be creating Blanket Sales Orders, after being on Acumatica for a while.I noticed that Blanket Sales Orders show up alongside the child sales orders on the SOOrder and SOLine DACs, which causes lines to duplicate in GI’s using these tables (For each child sales order line, a blanket order shows).My current plan is to filter each GI (we have hundreds affected) where the order type’s SOOrderType.Behavior = “Blanket order” as a future proof if the order type id or additional blanket order types are introduced. (DAC)Is there another route that doesn’t require a change to every GI?Anything else I should be thinking through?

Hi everybody.I’m trying to modify a GI but i cannot get it to work the way i want.what I want is for this column to be displayed as the "mold" column (with dashes) 

.

When you export reports from Acumatica to excel, the headers of the report are repeated at every screen break.  How do you stop these headers from repeating in excel?  There are no page breaks in the column sets or row sets.  This is something that annoys many clients, as they have to manually remove the headers from the excel file every time they export a report.

I am new to shoplifty I am trying to help customer map new fields from the Shipment to Shopify Is this done on Entities as below ? 

Does anyone know of an iquiry that can give me a list of open service orders that have items on them from a specific warehouse? For example. I would like to list open/completed service orders that have items on them frome warehouse 03 within a specific time period.

In a report I need to fetch data from GLHistory DAC, in my report table schema I have join GLAccount also. I need to get the sum of GLHistory.FinBegBalance where the Account Id is equal to 7000. for that I add variable and set its value base on a IIF condition. but it is not working.Herewith I have attached my report, inside the details section I have define the variables. currently I have changed the if condition as bellow for debugging purposes=IIf( [Account.AccountCD] = '7001',True, False) I tried different ways such as=IIf( [Account.AccountID] = 7001,True, False) =IIf( [Account.AccountCD] = 7001,True, False) etc. but nothing works

Good day,I want to create a customer through Acumatica Web service endpoint, and I get this error:"error": "Inserting  'Address' record raised at least one error. Please review the errors.; CountryID: 'Country' cannot be empty.",Country is required to create the customer, so I have the field added in the web service endpoint and I have tried using CountryID or Country, but it gives the error.Any suggestions?{ "CustomerID":{"value":"TESTCUSTOMER"}, "CustomerName":{"value":"Test Customer"}, "SendDunningLettersbyEmail":{"value":false}, "SendInvoicesbyEmail":{"value":false}, "SendStatementsbyEmail":{"value":false}, "Address":{ "AddressLine1": {"value": "123 Main St"}, "City": {"value": "Random city"}, "Country": {"value": "US"}, "State": {"value": "CA"}, "PostalCode": {"value": "00000"} }, "Attributes": [ { "AttributeID": { "value": "ARCONTACT" }, "Required": { "value": true }, "Value": { "value": "Cash" } } ]} 

In the Acumatica Construction Edition, how would I create a ‘punch list’ for projects?  Is that something done through Cases?

Most screens with grids have an option to import from an excel file.  Specifically I am talking about the SO entry screen below I have a customization where I customized and added an event handler on this screen and it fires fine when users are entering data in the grid.  But when they load records form file, it doesn’t handle.  Never fires the event from what I can tell.  I stripped it bare to see if the code was having an issue, but even the simplist code never fires as below:  protected void SOLine_RowUpdating(PXCache cache, PXRowUpdatingEventArgs e){    var row = (SOLine)e.NewRow;}But the same event fires when modifying the data in the screen. Any thoughts?  

I have had to change the URL of our production instance, and now I have no way to update the URL in the configuration wizard. Does anyone know where the configuration wizard stores its data?

In a report I use FABookBalance.BookID field. According to its definition it is an integer type, when I print it in the report it displays the FABook.BookCode field’s value. It is string type. But FABook table did not contains in the table schema of the report. I need to add a filter based on FABookBalance.BookID. Following screenshot shows the data exist in both of tablesFollowing is FABookBalance.BookID field definition  public abstract class bookID : PX.Data.BQL.BqlInt.Field<bookID> { } protected Int32? _BookID; [PXDBInt(IsKey = true)] [PXDefault()] [PXSelector(typeof(Search2<FABook.bookID, InnerJoin<FABookSettings, On<FABookSettings.bookID, Equal<FABook.bookID>>>, Where<FABookSettings.assetID, Equal<Current<FixedAsset.classID>>>>), SubstituteKey = typeof(FABook.bookCode), DescriptionField = typeof(FABook.description), CacheGlobal = true)] [PXUIField(DisplayName = "Book")] public virtual Int32? BookID {