Discussion Forums

I am trying to deleted a rejected Expense Claim but when I try to do that, I am receiving an error message that says the “expenseRefNbr cannot be empty”;  if it was rejected, why is that occurring?Is this a permissions or setup issue?  And if so, what should I look to change? 

We have this error on an items product availability in Sync history. It is not translating the inventory to the Shopify store and we can’t seem to figure out why. Has anyone had this issue and fixed it?  “The record has been assigned the Deleted status because it is related to an item that is missing, excluded from synchronization, or configured to not track quantity.:

We need to fix the user that shows search result to be like the rest that doesn’t show the result on the sales order screen. See images below for the correct display versus the wrong display.  For this user a results sub window opens as the user types in an Inventory code.   This image shows how it should look without the results displaying: 

I added a Attribute to my Vendors screen (AP303000).  I have that attribute called out in my report.  I have my Report Parameters calling Report.GetFieldSchema('Vendor.APOWNER_Attributes').  I am seeing the filed populate on the Reports Parameters on the screen for report and I an even select the desired result to filter agonist.  But when I pick one of the options and run the report, I still get all values for the Attribute, not the one selected.  Am I doing something wrong, or missing a step. 

Wanted to check that I am not missing something before I write this off.We want to display GI/Dashboard on a large screen on the shopfloor and have it periodically auto refresh.We do not want to tie up a computer for each display on the shop floor.Would like to use a smart TV that could display from the URL.  However, cannot have it prompt for credentials.  So looking for a URL that could have credentials embedded.  (I am sure this is not possible, just checking) Looking for any suggestions:Want to display dashboard on shop floor and have it autorefresh.Do not want to tie up a computer to accomplish this.Do not want to have to enter credentials.   Thanks!

I am having some trouble getting a mass import to go through that will sync to our Shopify store.I have about 1000+ bin locations that I need to import into Warehouse Mapping for Shopify stores in our entities section and I keep getting a “Bindings” error whenever I try to import the data using the Import by Scenario. Here is what I have built out so far: The data is preparing correctly, but it isn’t importing. Does anyone have any tips for this?

I’m looking for a way to assign totes to shipments for wave picking before we print the pick list. Like a process screen that will allow me to do it in bulk.

Is there a way to short ship a wave or batch pick list? Let’s say I go to the location and the item isn’t physically there and I need to confirm the batch or wave pick list without that item. Currently when I try to hit confirm line, or confirm pick it gives me an error that the pick list is not done.

Hi! I am trying to determine what User restrictions are applied when an Active tenant is changed to a Test tenant. Is the number of users restricted to 2 concurrent or does the licensed number of users still apply to the test tenant with all forms and reports watermarked as test?  The Help article I found stated that unlicensed test tenants were restricted to 2 Users however it does not say if this changes when licensed. Customer is on version 2022 R2 if that is a factor in the answer.I appreciate any input!  Thanks,Michelle

What access right should be allowed to view inventory in the creation of a GI? Anyone have an idea as to why this is not able to be viewed as an administrator? 

We are a company that bills time and material invoices through the pro forma invoice setting. We are looking for a way to be able to tie this invoice into the sales order process somehow so that when we go to ship the order, it ties to the pro forma invoice.  Right now we are manually creating the pro forma invoice, manually adjusting the sales order to match the pro forma invoice price, and shipping the sales order. This creates the issue of keeping the shipment in the ‘confirmed’ status, because if we ‘prepare invoice’ from the shipment, it would duplicate the invoice and book AR twice.Does anyone know of a better way of navigating this scenario? 

Good day allI am trying to write a GI to show AR payments and their applications. Can anyone tell me the field that links the two, apart from the CustomerID.I’m using tables ARPayment and ARTranPost.I tried ARPayment and ARAdjust but can’t get that to work. I appreciate any help.Many thanks in advance.

Hello,We are working on some cleanup work on old projects and need to change the status of jobs from Completed to Active. I wanted to do a import scenario since we have about 500 jobs we are touching. I keep receiving a error on the import, couple screenshots below.1: Error message:2: Import scenario build:Thank you,Kage

How can I get value from EPEmployee for POOrder? I tried to join them by EmployeeID for POOrder and AcctCD for EPEmployee but got error that EmployeeID does not exist in POOrder. How should I join them?

Hello Team,I've added custom fields to the Revenue Budget tab on the Project screen. I wrote code for the RowSelected event, but the values are not being saved in the database when I click the Save button in the Project Header. However, if I click the Revenue Budget tab any field within it, followed by the Save button, the values are saved properly.Could you please assist me in finding a solution to save the field values without having to click on the Revenue Budget tab? Custom Field Code:public class PMBudgetExt : PXCacheExtension<PX.Objects.PM.PMBudget>{  #region UsrPTDBilled  [PXDBDecimal]  [PXUIField(DisplayName="PTD Billed", Enabled = false)]  public virtual Decimal? UsrPTDBilled { get; set; }  public abstract class usrPTDBilled : PX.Data.BQL.BqlDecimal.Field<usrPTDBilled> { }  #endregion} Code File: public class ProjectEntry_Extension : PXGraphExtension&l

I have tried numerous times to split a journal entry into multiple lines without it posting successfully.  The only way I can get Acumatica to split an entry to multiple sub accounts is to do it one line at a time.  Why is this necessary?We are on 2020 R1

Hi Community, I am trying to localize a purchase order print form (report) to Portuguese, it translated as expected but there is one textbook that contains one of the terms and conditions that has failed to translate even after surely translating it in the translation dictionaries as you can see in the first screenshot, is there anyone who has faced a similar problem and resolved it? your feedback will be greatly appreciated.As you can see in the last screenshot, the first two textboxes got translated as expected, apart from the last one.  

Hi,In the Opportunities screen, a client is wanting to have the CloseAsWon action triggered automatically when the Stage field is set to Won. The code below is how I have tried to set it up, but all it does is trigger a Save and nothing else happens.Is this kind of functionality possible? If so, how would you recommend setting this up?Let me know if I can provide any other information.Kind regards,Andrewprotected void CROpportunity_StageID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (CROpportunity)e.Row; if (row == null) return; // Check if the new value of StageID is "Won" if (row.StageID == "W") { //Trigger the "Close As Won" action TriggerCloseAsWonAction(); } } private void TriggerCloseAsWonAction() { var cl

I have an unusual use case.I add a button to the Appointment screen (FS300200) that allows the tech in the field to pull up a web form which is a checklist that they are to run through with the customer while on-site. I am doing this via the PXRedirectToUrlException:  // Everything is gathered up. Time to send it var redirectException = new PXRedirectToUrlException(fullURL, PXBaseRedirectException.WindowMode.New, "This is a Message, which gets ignored in this case"); throw redirectException; // call URLIt works… but…It creates a new window inside of the Mobile App’s “browser” and it does not have certain things enabled (like javascript) which are needed for the Web Application they need to run. I cannot see any way of making the mobile app open a link using the native browser of the mobile

I am doing a unit test of a customization for the accounts receivable module but I get the following error, I have already done the exercises of the pdf T280_Testing_Business_Logic_2023R2, can you help me? 

We have a few engineering changes to do that affect over 800 BOMs each. Is there a way to do a mass change on these and uprev them at the same time? 

Has anyone been able to get .heic files to embed in an Acumatica report? We are using Daily Field Reports in the PM module to capture and communicate field activities.  Part of that is showing, in a concise format, images of what was done during the day.  Everything works great if our field personnel take pictures THROUGH the Acumatica mobile app (saves images as jpg), but sometimes they end up with a picture on their camera roll (HEIC file type) and want to upload it after the fact.  The problem we’ve found is that Acumatica Reports aren’t able to render the image(s) in the report.  I realize that you can just go to the report record and open each image, but it’s much less efficient and doesn’t capture all the value of being able to auto-distribute the information via e-mail. Below you can see that we uploaded 16 photos (our report is built with enough variables to display 8), but photos #3, 6 and 8 are showing that there’s data (by virtue of the creat

We are currently on 22r2 and will move to 24r1 soon.We have the need to stop users from seeing and being able to drill down into certain accounts on the P&L by branch report.  The users are all in the same branch, but not the same “department”.  They should not be able to see wages for the branch management (highest priority), and preferably not other departments in their branch (secondary concern).I have set up a restriction group and assigned only top management and finance to the group.  I have also assigned the specific sub accounts, and then the specific GL account, to the RG as well.The result is that the user can access the P&L by department, see the Wages listed on the P&L in total form.  Further, then can click on the amount and drill into the Wages amount, seeing the restricted account detail, as well as the associated subaccounts, some of which are restricted also.I have read the help text documentation and understand that for perfo

Hi All, I need to create new DAC and dump data into new DAC using Rest API. I know how to code and put data but I am stuck in few questions like If I started new creating new DAC do i need to define new fields in that and save data accordingly and  Also how can i access that DAC using API? is there any blog that can give similar idea. 

Sharing in case anyone else gets stuck here - I setup a simple business event aimed at triggering an action. Each time I tried to setup the Action Execution I would get an error reading Error: Another process has added the 'ActionExecution' record. Your changes will be lost. After numerous attempts I noticed in the trace log that it also stated Cannot insert duplicate key row in object 'dbo.ActionExecution' with unique index 'ActionExecution_Name'.  which made me finally realized that we had an old Action Execution with the same SubscriberID in a test tenantThis wasn’t obvious, since both the Business event and Action Execution were new and totally unique, but after trying a new name on the subscriber ID I was able to save successfully