Solved

Good day,I am trying to use the below formula to change the color based on the results; it was validated.  However, the error I can get it the array is outside warning bubble.=IIf((DateDiff('d',[SOOrder.RequestDate],CDate([SOOrderShipment.ShipDate]),'>0,blue','red60')))I made some changes but the same result or it is didn’t work to change the color based on >0 or <0.Your assistance would be greatly appreciated.Evan

I need to replace the Projects SimpleScreen in mobile app with the Projects primary list (HubFolder).  Adding the Projects primary list worked, but SimpleScreen still shows up in the “Other” workspace, even if I uncheck the visible checkbox in Project workspace (where it originally was). How can I hide the SimpleScreen? Attached is a screenshot of what I’m seeing in mobile. Below is screenshot of published customization code to remove PM301000, followed by code to add PM3010PL (same customization project). Stuck on where to go from here since removing didn’t work as hoped. Thanks in advance :)    

Is it possible to have a flag in the import file, to change the Activation status on file import? Lets say I have a master spreadsheet of Employees (or users) and everytime before importing it I would select which ones are Active and which ones are not. In this case I wont need to manipulate the data on the Import scenario screen. Thanks.  

Hi All , Do any one have ACH Export Scenario for Balanced File with Flat File Specs Similar to EDI / Can guide on  how to create Export File Format with Flat File Specs for ACH ?

Hello, we have entered payments to a vendor - paid them and their check has already been cashed.  However when we try to release the transaction to the GL we get the following error: Error: Another process has updated the 'GLTran' record. Your changes will be lost. If anyone has any ideas what this might be and how to fix it?  

Hi there,I have created a GI to know the qty beg, qty in/out and ending qty during a date range. I only use one table INItemSiteHistDay Before I group by InventoryID and SiteID: I expect to only show one line as below, but when I group by inventory ID and siteID, then I select the max Date, but Qty Beg and Ending are sum up, the Qty In or Out is correct. I do not know how to take two values from 2 rows: qty beginning of date from and ending qty of date to.After grouping My parameter:If you have any idea, pls advise me how to achieve it.Thanks, in advanced.

I’m trying to automate the monthly revaluation of GL accounts in foreign currency. Screenshot below is what I came up with for the filter. What I’m not sure about is the financial period. I’d like it to be relative like the date, but my understanding is that checkbox only works for date fields. Anyone know if there’s a way to make it default to current period so it doesn’t have to be manually changed every time?  

This is a manual order from BC, we want to map this from the Bigcommerce who made the order. Is this possible?  

This should be simple.  I have a custom dialog with some data fields, and an OK button.  I want the OK button to perform a save of the fields as well as other processing.  I’ve tried many things, but so far, my OK button doesn’t perform my associated code.  I defined a new dialog within the page editor.  I added an action button that appears on the menu, and it opens my dialog just fine via button command delegate method and the AskExt() method of the view.  But my OK button just closes the dialog and seemingly does nothing else.  I have tried setting breakpoints after the OK is returned:if (view.AskExt("viewPanel", true) == WebDialogResult.OK){ // other code here, with a breakpoint}else{ // other code here, with a breakpoint{and no breakpoints are hit.  I also set the dialog button’s AutoCallback command to a custom method with a breakpoint.  I tried a method signature of both protected void <method>() that matches a button action delegate and a public IEnumerable <meth

Hello all,I would like to know apart from the Projects screen, where is the PROJECT segmented keys being used in Acumatica? Recently I tried to import some of the project records but some of them weren’t imported. Upon analysing, i found out that the Project ID that I had been trying to import is of 11 characters whereas under the segmented keys form it is only set to 10. Now I deleted the project records and tried to change the character length to 11, but it throws the following error:  

I have created an import scenario to create employee time activities for an excel spreadsheet.  The spreadsheet contains the employee ID, the from and until weeks for the header (this is contained on each line, so the detail knows which employee and week the record should be created under) and then the date, project, project task, labor item, hours,  and description for the activity itself.  When trying to import multiple records, it only creates one activity and errors on the others, or it doesn’t create the activity, but doesn’t error.  If you go one by one and activate and import one line at a time it correctly creates all the activities.  What am I missing to allow all the lines to get created with one import as opposed to importing each line separately? 

I am trying to open the Inventory Summary screen with a PXRedirect and pass a parameter for the Inventory ID.Dictionary<string, int> parameters = new Dictionary<string, int>();var baseGraph = PXGraph.CreateInstance<InventorySummaryEnq>();//hard coded for testing//14998 = Inventory CD "1007"parameters.Add("InventoryID", 14998);throw new PXRedirectRequiredException(baseGraph, "Inventory Summary", parameters) { Mode = PXBaseRedirectException.WindowMode.Layer };The Mode = part is because I am populating a side panel.  Since I am opening the Inventory Summary screen via Javascript from an SO Line detail, I cannot do this from a standard Side Panel.The Inventory Summary screen opens in the Side Panel, but the Inventory ID field is not being populated.One option to get the data and display it in a side panel using a GI.  But there are over 2000 lines of code in the Inventory Summary graph to calculate the values displayed on that screen.  I don’t think that is an option.Is t

     public PXFilteredProcessingJoin<TSFixedDemand, TSProductionOrdersCreateFilter,         InnerJoin<InventoryItem,     On<InventoryItem.inventoryID, Equal<TSFixedDemand.inventoryID>>, LeftJoin<SOOrder,     On<SOOrder.noteID, Equal<TSFixedDemand.refNoteID>>, LeftJoin<SOLineSplit,     On<SOLineSplit.planID, Equal<TSFixedDemand.planID>>, LeftJoin<SOLine,     On<SOLine.orderType, Equal<SOLineSplit.orderType>,     And<SOLine.orderNbr, Equal<SOLineSplit.orderNbr>,     And<SOLine.lineNbr, Equal<SOLineSplit.lineNbr>>>>, LeftJoin<INItemClass,     On<INItemClass.itemClassID, Equal<InventoryItem.itemClassID>>, LeftJoin<SOOrderType,     On<SOOrderType.orderType, Equal<SOOrder.orderType>>, LeftJoin<TSProdFormulaMTranSplit, On<TSProdFormulaMTranSplit.planID, Equal<TSFixedDemand.planID>>   , LeftJoin<TSProdBOMMtranSplit, On<TSProdBOMMtranSplit.planID, Equal<TS

I have a generic inquiry that looks at all sales orders. My goal is to send an email to required receipients when a ship date changes. Here is the trigger conditions:and the fields to track: The Business Event history is empty. Ship dates are being changed.Any ideas why it is not triggering? Is it a problem with the BE or GI? 

Situation - a business has a long term loan, a mortgage loan, where the monthly payment is fixed and the split between principal and interest varies each month based on the mortgage amortization schedule. The monthly loan payments to the lender are set up to be made via PAD direct from the company bank account.I can create the first monthly mortgage payment as a journal transaction and then create a recurring transaction from the journal transaction.  Generate recurring transactions will create the monthly payment journal transactions, but only the 1st payment will be correct. The finance user will need to edit the 2nd and future journal transactions and correct the principal and interest distribution amounts manually, according to the amounts from the amortization schedule.Is there a better way to configure this?I suppose the Balanced 1st journal transaction could be exported to Excel and the future monthly payment transactions be added into the Excel sheet with the correct split betw

Hi, I incorrectly press “refund” to a customer “credit memo” in Acumatica. Is there a way to reverse the action? If not, how do I correct the mistake? Thank you. Raymond

.

var openSalesOrders = SelectFrom<SOLine> .InnerJoin<SOOrder>.On<SOLine.orderNbr.IsEqual<SOOrder.orderNbr> .And<SOOrder.orderType.IsEqual<SOLine.orderType>>> .InnerJoin<InventoryItem>.On<SOLine.inventoryID.IsEqual<InventoryItem.inventoryID>> .InnerJoin<INItemClass>.On<InventoryItem.itemClassID.IsEqual<INItemClass.itemClassID>> .Where<INItemClass.itemClassCD.IsEqual<@P.AsString> .And<SOLine.openQty.IsGreater<Zero>> .And<SOLine.operation.IsEqual<@P.AsString>>> .View.Select(this, "811", "I");Is there a way to add a GroupBy to the above query to group and sum all sales order lines by Month & Year?Coming from Python and Django in particular, something similar to Trunc is what I am looking to do.Does BQL offer anything similar?

Hi everyone, I'm encountering an unusual issue when making an API call with the 23.202 build. I'm trying to change a sales order on hold status using the PutOnHold action, but I'm immediately receiving the following error. Once this error occurs, the subsequent GET call is also not functioning and getting the same error message.   "message": "An error has occurred."    "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "A data corruption state has been detected. You cannot save the changes. Copy the data you have entered and reload the page. Date and Time: 2023-12-13T08:08:38; IncidentID: 8f01c121-fd44-4af9-bf02-6144bb6678c1; Name: Aggregate Validation: PX.Objects.SO.SOOrder+openLineCntr. You can view detailed information about the issue on the System Events tab of the System Monitor (SM201530) form.",        "exceptionType": "PX.Data.PXException",        "stackTrace": null Does anyone face this issue? 

I'm trying to figure out the best way to sync third-party fulfillment products from a Shopify store into my Acumatica. My initial thought was to use a logic statement based on the Shopify line item vendor, and then push it into Acumatica as a generic non-stock item for that specific line on the Sales Order.However, I hit a snag because the ERP field for inventory ID isn't visible on the Entities for sales orders. I've attached a screenshot below for reference. Does anyone have any ideas or suggestions on how to make this work?  

Is it possible to select which fields are (and are not) copied when using the standard copy (clipboard) action on Sales Orders?We use UDFs to trigger a few workflows. After our recent upgrade to 23r1, the values in those UDFs are persisting, causing those copied orders and reorders to not fall into the workflow. Thanks! 

Dear All,please advise me  for this case:I creates an Invoice on screen SO303000 without SO/Shipment. This SO also chooses inventory idBut I don’t want to generate an inventory issue. Thanks alot!  

When I create a generic inquiry, I am able to modify the order of columns in that inquiry. Is this information stored in the database? Thank You,Abhijit

Hello all, Just got our cloud instance up and a Second tenant  called “Demo Data Sandbox Tenant”Trying to Auth with the rest API and I get a 500 error “    "message": "An error has occurred.",    "exceptionMessage": "Current user cannot send API requests.",    "exceptionType": "PX.Data.PXException",” I am using this in my body{ "name" : "*************", "password" : "*****************", "tenant": "Demo Data Sandbox Tenant", "branch": "" } and URL is https://***********.acumatica.com/entity/auth/loginI have a local instance that I have been using for the API with no issues. Is there something I am missing for Multi Tennant?  User is an admin. Can log into the GUI no problem. Thank you

We have a client who wants to import data for invoices through import scenario.  However, they would like to not have to select each resultant invoice and print.  They would rather the system print the invoices generated from the import scenario automatically.  I inserted and selected the print and email function but it does not print.  Have I inserted this in the incorrect place or what whould you suggest?If there is a way to print all invoice from a mass release that would work as well, but how is this done?Or is a better way?Thanks.