Solved

Hello,      I have a need to find the modified lines.It is simple in GI by using below way: However, the same method does not work in Report Designer, even I change “Greater” to “NotEqual”  How can I achieve my need in Report designer. Please advise.

In acumatica standard, is it possible to create ECO without going through ECR?

Hi,We have set the Quantity and Price/Cost decimal place to 4, as shown below:But the in Purchase Order window Ext. Cost is still showing in 2 decimal place, see below: How to change Ext. Cost also to 4 decimal place ? Thanks,Shyam.

Hello All,How can we show Customer Class Prices in Self Services Portal ?Thank you’Jennifer

what i have to do to solve the problem 

I have been asked if there is a way to limit who shows up in the price manager Selector on the Stock Items screen under the Price/Cost tab as in the screenshot below.I have created a generic inquiry which shows who we want to see. It has the following DACS:Users → UsersInRoles - Inner join on usernameUsers → Contacts - Inner join on pkID = userIDCondition = UsersInRoles.RoleName Equals PurchasingThis seems to give the restricted set of users/contacts we want.How do I go about changing the Selector for this field to use this as a the query instead of showing the full list of employees if shows now? Thanks for any help, Phil

Our customer would like the ability to indicate a PO is critical and be notified when the PO Receipt is entered.  Has anyone done this?  Does anyone have any ideas?  Thanks in advance.

Hello dear Communiteers, I have an interesting request and I need to do a preliminary evaluation. A client of mine wants to have an integration between Acumatica ERP and BMC Helix ITSM (IT Service Management).Please, are you aware of any case or supplier of such integration ? Many thanks,EC 

how upload file from REST API when add new customer?

How do most people deal with USMCA and Canadian Customs Forms? (and other forms like these)

Hello,I have few customers which are using Self Service Portal , how can I restrict them to see specific items rather than seeing all lists of items?Thank youJennifer

Hi, I am successfully now creating a check payment BUT when there are multiple bills it does not seem to pay the one needed, is there a way of paying directly against a specific bill ? How do I pass this in the payload for Check, documentation is quite lacking. Thanks

Is it possible to set the home page for users to a specific workspace like Time & Expense?  I know you can set the home page to a specific screen but would prefer to open to a full workspace.

I’m working on ARM report for Balance Sheet by Branch, but outcome is not coming, please advise.

Hello,I’m trying to create shipment by code. I’ve already create the shipment successfully, but while I trying to create shipment from same sales order but different inventory, it’ll show message below.Here is my code I currently use.            foreach (SOShipmentPlan res in tmpShipmentPlan.Cache.Cached)            {                //foreach(list in List<SOPreShipmentLine> lists) { }                var plan = (SOShipmentPlan)res;                plan.Selected = true;                SOOrder order = PXSelect<SOOrder,             Where<SOOrder.orderType, Equal<Required<PreAddSOFilter.orderType>>,               And<SOOrder.orderNbr, Equal<Required<PreAddSOFilter.orderNbr>>>>>.Select(this, plan.OrderType, plan.OrderNbr);                graph.soshipmentplan.Update(plan);                graph.CreateShipment(order, shipment.SiteID, shipment.ShipDate, false, shipment.Operation, null);                graph.soshipmentplan.Cache.Clear();             

In the Sales Order screen, I want to take an Inventory ID value that the user has entered, say, “APPLE”. I want to look for that value in another table and possibly replace the value of APPLE with some other value.I have tried changing e.NewValue in a FieldVerifying event.A very simple version of my code is here and AMCOTTON is an existing inventory item. So, in testing this I hoped that it would but AMCOTTON into that field regardless of what I entered.protected void SOLine_InventoryID_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e, PXFieldVerifying InvokeBaseHandler) { e.NewValue = "AMCOTTON"; if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); }However, I end up with a blank field value.Is FieldVerifying the right event to make changes to e.NewValue?

when windows 11 updated,  the outlook plugin is no longer visible.   Tried to reinstall and still nothing.   

I am trying to update a Budget via the REST API… The inner exception I am getting is: Error: Another process has added the 'GLBudgetLineDetail' record. Your changes will be lost.Full response is below: { "message": "An error has occurred.", "exceptionMessage": "Operation failed", "exceptionType": "PX.Data.PXInvalidOperationException", "stackTrace": " at PX.Api.ContractBased.EntityService.Put(ISystemContract systemContract, String version, String name, EntityImpl entity, CbOperationContext operationContext, Boolean throwOnError)\r\n at PX.Api.ContractBased.Soap.SoapFacadeBase.PutImpl(EntityImpl entity, Boolean throwOnValidationError)\r\n at PX.Api.ContractBased.SystemContracts.V2.RestController.PutEntity(EntityImpl entity, String select, String filter, String expand, String custom)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object insta

An inquiry that was working fine started giving this error.  When I create a GI with just SOShipmentAddress or SOAddress in tables and put SOAddress.AddressID in the result grid and try to view the results I get error: Object Reference Not Set to an instance of an objectIf I view the trace log it has: An unhandled exception has occurred in the function 'IsValidateRequired'. Please see the trace log for more details.immediately before it. Does anyone know how I should go about troubleshooting this? Phil

Good day,  we use the 2020R1 API version 18.200.001 to integrate a cloud-based program called Jitterbitt/Postman..  We use to the API to send payloads with ACM data (address, items, etc)  One situation that has occurred was we had about 6 orders to send; only one payload was transmitted.  Everything was exactly the same on the mapped fields.  Anyone know why the API would only transmit one order but left the others.  The log in Jitterbit/Postman had only one record in the log.  Another question,Iis there a way for me to look at the API transmission?  a log or something that I can go into so I can check activity on the API transmissions?I know this is vague but we can figure out why one of many payloads would be passed.Thank you.Evan

When a user saves a Purchase Order, the LastPrice in the POVendorInventory table is updated.  If there are multiple lines in the PO for the same item, they may have different Unit Costs for the same inventory item.  When the table is updated, the last record in the grid is what ends up in the field.If there are multiple lines with the same inventory ID, my customer wants to update the LastPrice field with the LOWEST unit cost, not the last one to be processed.To complicate this, they want to change the LastPrice field to the lowest Unit Cost if it is overridden in the Purchase Receipts screen.  Based on my testing, if you edit the Unit Cost on the Purchase Receipts screen, I don’t see that it updates the POVendorInventory table.  They want it to update the table if the Unit Cost is overridden.  Honestly, it seems like that should be standard business logic.  On the Purchase Receipts screen, you are entering the ACTUAL cost of the item.Since the customer wants to update the LastPrice fi

Hello,     We are still using 2020 R2 Build 20.209.0027. Is there a known issue of this version or some setting issue.   I paid branch 1’s bill using branch 2’s identity. They are setting in different companies with different ledger.   I remember a pairo f entring GL transactions should be automatically generated like below. However, I did not see this in production envrionment. How is that. Thanks.

Hi,If the Sales Order Line QTY to be changed after the Production Order is created and (in Process) what the best way to ensure that the Production Order will also be updated with the new qty?We can put the PO on hold and manually update the Qty to Produce, but is there a better way?Also it was noticed the manual update is not showing in the Totals Tab - Planned Qty. Is this on purpose?Application version is 2020R2 Thanks

Hello and good Saturday everyone!I am wondering if it is possible to hang a “print report” action inside a generic inquiry?I noticed that you can export a GI to the Report Designer and build a report there, that you could upload back to acumatica and create a sitemap entry. But is there a way, like it is in normal screens, that i can hang a action to print the report inside of the inquiry?Greetings 

Hi! As you have probably guessed, our company is in the process of transferring our payroll and construction information over to Acumatica. I am running in to a lot of issues when it comes to finding documentation on how to set up the payroll side of certified projects.  I’m not finding where to set up the codes for: Apprentice, Foreman, Electrician, General Laborer, etc under a job.  I am also not finding where to set up the different rates for an apprentice, depending on what level they are at.Do any of you have any reference for this?  Or can teach me how to do this? Thank you!