Solved

Hello,        We recently upgraded to 2021R2.On stock item screen, if click “sales price”, normally a new tab would be open.However, some user encounter system remain still, nothing happens, no new tab open.        How is that?        We are both using chrome. Is it some setting in Chrome that prevent the new tab open?  

Overview: I have a custom table to display info to a grid.  When the user clicks a button on the form, I call two methods.  One to delete the records matching the filter and then re-add the data back into the table using the same filter values.  The data in the table cannot be “selected” using a normal select statement as I have to parse fields from the AuditHistory table (ModifiedFields contains null delimited field/value pairs).  I am “de-normalizing” the data so there is one record in the custom table for each modified field in the ModifiedFields column.  This is what the customer has requested.The form works as expected except that the DeleteData method only works EVERY OTHER TIME!  Here is the sequence of events:open form.  At this point there is no data in the table. Click Get New Data The DeleteData fires and nothing is deleted (obviously...there is no data in the table matching the filter yet) Data is added to the table as desired using the filter field values. The user clicks

Before anyone panics, I am not planning on deleting ANYTHING from a core Acumatica table! :-)I’ve read this post but it involved deleting in a “one-time” fashion using export scenarios.  I don’t think that is an option for my use case.My requirement to to create a SQL View that can pull data using a GI.  Got that under control.  The issue for me is that it is not possible (AFAIK) to create a View in SQL to pull the data and de-normalize it without using a loop in SQL, which is not allowed in a SQL View.My plan is to create a custom screen that can use C# in an Acumatica customization to process the data and store it in a custom SQL table.  When a user uses the custom screen to pull data into the table, I want to delete EVERYTHING from that table that was put in there previously by that user.  Otherwise this table will grow very large for no useful purpose.I know I can pull a record set and cycle through it and delete rows one at a time.  Is there an option in Acumatica I have not found

Hi,Appreciate help on below scenario.I have created a Purchase Order specifying the project, task and cost code. Then performed the purchase receipt to the same task and cost code & issued half of the items to the same task as per the requirement. There is a leftover of the purchased items and now I need to issue these items to another task.System does not allow to issue items to another task . How can I perform this scenario. Thank you,Dulanjana

Hi,Below error appears all the time when I try to do an inventory receipt (Inter Branch). How can I avoid this. Thanks,Dulanjana

Primary contact has been introduced for customer in 21R1. After we moved to 21R1, it seems billing/shipping contact is still loading from default Contact (defContactID in DAC) if uncheck override on Customer screen, but no where to change default contact anymore

Have custom report created in Report designer. Long comment field on the report ic cut when exported to PDF. Tried to add some spacing between sections - no change. WratText=True, CanGrow=True for the field. 

Is there a way to force a quantity more than 0 on a SO line?This is more of a quality check for Customer Service during the order entry process.

Hello Everyone,One of our client configured the InventoryID segment key like below.When we try to create an order through API with this product, getting the error “The record has been deleted”.  It's not considering the “-” while syncing the order.If provide the value without the “-” It's working fine.And also we noticed that if added only one segment key with “_” or “-”  worked fine.Is it any possible way to sync the product with this Segment Key configuration?.   

We are having performance issues with the Pack stage of Pick, Pack, Ship where when scanning multiple identical items the barcode is not being processed fast enough before the next barcode is scanned and we are getting doubling up in the barcode field as a result. I am trying to investigate to see what happens when the barcode is scanned to see if we can come up with an alternative screen or eliminate unnecessary bottlenecks. When I try to view the business logic source for the barcode field it shows PX.Objects.SO.WMS.PickPackShip+Hostbut the screen is blank. Does this mean the code is in a plugin or something and unavailable to see what it’s doing?  Is there a way to see what processes are being performed? Does anyone have any other ideas for how to go about troubleshooting the process or get around the performance issues? Thanks for any advice, Phil

I am pulling data from a table based on a PXFilter.  One parameter of the Where clause is to pull based on the current logged in User ID.  I created a public variable _currentUser that holds the User ID.public Guid? _currentUser = CommonServiceLocator.ServiceLocator.Current.GetInstance<ICurrentUserInformationProvider>().GetUserId();How can I pass that value into the Select for the View?  If I put an @P parameter, it compiles.  If I try to use a View.Select(this, _currentUser) to pass in the parameter, I get all kinds of errors. I can’t pass in the actual _currentUser variable because I think it needs to be a type, not a value.public SelectFrom<QTCAuditHistoryReport>. Where<QTCAuditHistoryReport.screenID.IsEqual<QTCAuditHistoryReportFilter.screenID.FromCurrent>.And<QTCAuditHistoryReport.changeDate.IsEqual<QTCAuditHistoryReportFilter.changeDate.FromCurrent>.And<QTCAuditHistoryReport.reportingUserid.IsEqual<@P.AsGuid>>>>.View.ReadOnly Deta

I’m creating a notification template using opportunity details screen (GI). In the “To:”, I would like to send to the owner that creates the opportunity, but I can’t seem to find it in the entity here. Is there any way I can do it?  

We have a new payroll client that has one work location in the state of Maryland.  One employee’s spouse is an active military duty employee working in the state of Maryland but declaring Georgia as their state of residence.  I am trying to get Acumatica payroll to calculate Georgia withholding.  It wants to calculate Maryland.  Even if I put a Georgia employee address, it still does not calculate Georgia taxes.  From a quick google search, it looks like Georgia withholds based on the work state.  Does that mean the only way I can get Acumatica to calculate GA is to set up a Georgia work state which is just not a true statement.  Am I missing something? 

I am getting a Project Billing Issue: "PM Warning: Invoice was not created during the billing. Nothing to bill."This is happening for all projects when I try to run the Project Billing.This has worked perfectly in the past, and I haven't changed anything to the projects...Anyone know why this is occurring?

I have Budget with line items as follows (simplified):{ "account": "4100000", "subaccount": "ADMIN" "amount": 123.45}, { "account": "4100000", "subaccount": "CAPWRK" "amount": 567.89}, { "account": "5555555", "subaccount": "ADMIN" "amount": 1000.00} If I `PUT` to `/entity/Default/20.200.001/Budget`  but mark `”Delete”: true` on only the first item, both the first two items are deleted - ie: both items with 4100000 as the `account` are deleted, not just the ADMIN subaccount line item.Am I missing something obvious??

Invoice form with extra margin on the right side. It appears to be set as landscape instead of portrait. How do I fix this? I do not have report designer. 

Hi. Is anyone encountered this? I created a discount and it duplicates in the generic inquiry I am creating. Also, how can I get the value of its discount percent?  Thank you.

I must be missing something simple, but I cannot figure out how to add the additional standard toolbar buttons (insert, delete, move next, etc.)  to my custom screen.  My screen shows the Save and Cancel standard toolbar buttons, but not the rest.I’ve experimented with setting various properties for the datasource and form, but have not yet figured it out.I thought maybe I selected the wrong template, but I created another screen to test and it also only had save and cancel.  Tried reading through the T220 training pdf and did not see anything.

Hi. I have three variance columns that show the variance between MaterialCost and ActualCost.I want to sum these three values in a new calculated field. How do I do this? Thank you,

I am working on upgrading Acumatica to 2021 R2. This release includes the redesigned toolbar. I would like to reorder some of the Actions on the toolbar. So I follow the process outlined in the help documentation. However, when I click “Reorder Actions” and select a category other than “Top Level”, I am seeing duplicate actions. Moreover the Move Up and Move Down do not appear to work consistently with these duplicate actions.  See the screenshot below. This is on a site that is populated with Sales Demo data and has no customizations published. As you can see, each of the 4 actions in the Other category on the Sales Order screen (SO301000) is listed twice. And if you try to use the Move Up, Move Down buttons, they do not behave as expected. This makes it impossible to know which action is the one being displayed and I am unable to order them as I’d like. Any help would be appreciated.  

Long story short - I have a form that has a parent record and on a tab a child grid.  In that grid is a “notes” type field that I want to be able to edit with the HTML Editor.Example of this would be like the Activities tab on the cases where the notes show under the child grid.  The issue is that I really need it to be ENABLED right on the form.I could put the grid into “form editing” mode and have it there, but then navigating between the records becomes a pain as the flow of what I am working on users need to be able to click through and review the child records and edit the notes quickly and going in and out of form editing mode of the child grid isn’t very user-friendly. 

 As per the 22R1 developer release notes customization projects should under go certification process. So, I have a few queries on 22R1 Upgrade and hoping anyone or Acumatica team can help me on the below queries. What is the process of submitting the code for certification? Usually, there will be a lot of enhancements/CRs/Issues will be there for the same customer, Do we need to submit the code for certification each time we do a code change?  Is this mandatory or we can still go ahead for upgrade and get the certification later? Is there any tool to validate the customization from our local environment?    Thanks in advance!

I’ve noticed that invoicing sales orders removes inventory (creates an inventory issue and releases it), but invoicing service orders only creates the inventory issue and does not release it.  So the invoice dr debtors, cr stock sales, but the other half of the transaction (dr cost of stock sales, cr inventory) hasn’t happened.  Is there a reason for this inconsistency or is it a setup issue?  I really feel that users who are invoicing shouldn’t need to release the inventory issue manually, it’s an unnecessary extra step.

Hi All, Where can I see/educate myself on all the API's that are available from Advanced?  I.e. I need to provide mapping from Acumatica to third party product. Cheers,Laura