Solved

When accessing a GI through OData in PowerBi or Excel, I get the following error message:DataSource.Error: We couldn't parse OData response result.  Error: Unexpected end of file has occurred. The following elements are not closed: feed. Line 6, position 120.Details:    DataSourceKind=ODataDoes anyone know what this means, and how this can be solved?

We are used to “reversed” GL where liability and income accounts are shown as a negative and always thought this was normal.  Can anybody tell me if we change to reversed in GL preferences how we will be affected.  We went live on 11/1/2020 and would like to see reversed (normal to us).Thanks in advance Brian

Hello,      I’d like to add 1 customized field on SOShipLineSplit dialogue,  It would be easy,  just after add controls on screen, the system would automatically generate a cs file to define the data class. User only have to define the attribute, and system maintain other codes.    However, strangely, unlike other screen (Which means other screen are customizing perfectly) , the file generating on SOShiplineSplit data class are missing a “PX” at the beginning, the first line.      Hence,  I get an error on Validation.        This error actually existed for a long time. Although I can manually change the PX_Objects_SO_SOShipLineSplit_extensions.cs file to let it pass validation.  But is there a way to solve this issue permanently?

Hi, When a client is generating an invoice from the Invoices screen (SO303000), the result shows duplicate lines.The odd thing is that it doesn’t occur for all invoices, just a select number of them, so it could be the joins, but then it could be something else, and I am out of ideas of what I can look at.I tried things like changing the groupings, comparing a problematic invoice with one that works, but still couldn’t find anything that would be the problem.I have attached the report file below. Are you able to spot something that could be causing this occasional issue?Let me know if I can provide any further information. Kind regards,Andrew

When attempting to attach a .mov video file from an iPhone to an Appointment, it just spins and will not upload the file.When attempting to attach the same file with an Android phone, it works just fine when using the ‘upload using mobile device’ button to receive a push notification to upload the file. Multiple iPhones were tested, and photos attach without issue, but videos are not working. Does anyone know of a workaround or iPhone setting that may be causing this issue? 

After a couple of rounds of trying to “PUT” records into the Stock Item that have the # symbol I’m beginning to think the API framework doesn’t accept special characters. Can someone confirm this? I’m using Power Automate Desktop to invoke the web service and insert stock items. I’ve tried the Replace Text action  (replace # with %%23 also replace # with \#), none of which work. Thanks in advance!

Hey everyone, I’m having a difficult time with this one. I broke my brain over it over the holiday weekend. I had this working at some point at the beginning of the project last week and I must have accidentally unclicked something and I can’t figure out what. I’m bringing in Payments for Sales Orders, so I have an import scenario to add a prepayment and then load the sales order. I keep getting this “Missing operator before the Order operand.” issue. Any tips from anyone out there? I’m stumped. 

Trying to extend the length of the UOM field in Acumatica and not having much success. I’ve done the following(This UOM field references INUnit.ToUnit which was previously customized by another developer to extend the field length.):Add the column length increase DB script: That however did not increase the length in the DB so I increased in manually.But I still got this error on the field I’m trying to customize:   So in addition I tried option two from this article: Extend Address Line length - Acumatica Developers Blogand got this error: 

Hi Experts,I'm working on an import scenario for Journal Transaction Entries and I am getting an error saying the Batch is out balance.I have attached my import scenario for better understanding of issue.Any help would be greatly apricated.Regards,Sweta.

Hi, I am doing a testing about the Update Sub. on Order Owner Change function at Purchase Order preferences for future used. So, how does it work? is that when I change the owner of the purchase order, then the expense sub will change based on the department setting?  However, when I change the owner to other department, the expenses sub. will not change, can anyone explain to me how this feature works? Thank you. 

I have a GI that queries a custom SQL View using a custom DAC. This GI has parameters StartDate and EndDate. Both of these parameters are not required and neither have a Default Value.GI ParametersI am then using the StartDate and EndDate to filter the results base on the OrderDate as seen here:GI ConditionsHowever, when I run view the inquiry, every time I try to select a date in one of the date parameters, it automatically gets cleared out to nothing - thus making the GI useless. I’ve tried making the parameter dates Default to @Today, but when the inquiry is run, whenever I try to change the date, it automatically reverts back to the default. 22R2 Build 22.213.0010 TIA, Dave

Hi Team,I am geting this exception while trying to add an employee with payment instructions using an endpoint.I cannot see the DetailValue property when I try to check the swagger documentation.Thanks 

Hi! I’m looking for sales demo data for 23r1 and I’m having trouble finding it. This isn’t for sales purposes but for implementation/testing.

Hello,I am trying to set up multiple system emails to be used by purchasing, accounting, admin etc.After setting up the emails given by customer, after signing in, I tried to TEST it. Then it gave me below error.The email cannot be sent because the account you signed in with does not have permission for using the email address specified in the system email account on the System Email Accounts (SM204002) form. I read some information related to the error in below post. But I would be pleased if anyone could further explain me about conditions. I think email is correctly configured and all permissions are properly set up.What are the conditions to fulfil for the email account to be used?  Further explain - No delegation, send as, send on behalf, or shared mailboxes can be used for this sign in process. Thank you!

Hi All, My client is running production in 1 warehouse but materials are stored in multiple locations. they don’t use backflushing and material will be issued using the material wizard. However, the material lines on the Production could be stored in any location in that warehouse. when we run the Wizard if we don’t have enough on hand on that location the line is not brought over to the material screen. so my suggestions were 1:we have to make sure either to transfer the material beforehand (they don’t like this idea as this is adding extra step compared to what they do now) or 2: change the location on the production order detail looking trough the magnifier (they don’t like this either as it is manual) . They use WMS and they say when they create a production ticket that system aslo gives them a picking list for material issue. if I don’t chage the Location and leave it to be the main here is what happens: the Lines which we don’t have enough on hand will not come over and we cannot

Hello Community,I have been trying to release AR invoices but the system triggers the following error:  Have created this invoice by using manual numbering. So once, the invoice was saved i disabled the manual numbering option but still not able to release it. Can anyone let me know why is this error getting triggered?Thanks in advance. 

I have users that I have granted access to their role for specific dashboards but some of the items appear as a padlock instead of showing. How can I determine the specific permission that needs to be granted to allow these widgets to function? 

We had UPS Shipping Carrier integration working in Acumatica 2021R2.  We upgraded to Acumatica 2022R1 and although the license is there, we are not able to select the UPS Carrier Plug-in.  Feature is also still enabled.  See screenshots below.  Is there a customization that needs to be published to get the plug-ins?  If so, where do I find those.  I appreciate any help.  

Hi,We would like acumatica to display the first date of a week. For instance: Today it should show 08/28/2023. How can we achieve this?We tried : DateAdd(Today(),'w',-3) and it displays Tuesday’s Date 08/29/23 and not 08/28/23.What would be the best way to do this? I have this formula working in SQL :DATEADD(WEEK,DATEDIFF(WEEK,0,GETDATE())-1,0) but cannot figure out how to replicate in acumatica.  @lauraj46 - Hi Laura, could you please help when you have a chance?

Value cannot be null.Parameter name: keyDescription: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.ArgumentNullException: Value cannot be null.Parameter name: keySource Error: The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL: 1. Add a "Debug=true" directive at the top of the file that generated the error. Example:   <%@ Page Language="C#" Debug="true" %> or: 2) Add the following section to the configuration file of your application: <configuration>    <system.web>        <compilation debug="true"/>    </system.web> </configuration> Note that this second technique will cause all files within a given application to be compiled in debug mode. The

Really I want to update the Stock Items screen default price by an import scenario.Unfortunately, the default price field is not showing in the Price/Cost tab to me for creating an Import scenario.I am using the 22 R2 version. How should I get the default price field to the Import Scenario?  

Is there a way to archive the old data in acumatica system ?because we have data from 2011 and we need to delete them because the system is getting slower

PX1043    Only the methods of the PXCache.Persist family can be used to save changes to the database from a RowPersisting event handlerhere is my code  protected virtual void _(Events.RowPersisting<BOQTask> e)    {      BOQTask row1 = (BOQTask) e.Row;      if (row1.SubID.HasValue)        return;      AutoBoqRefMaint instance = PXGraph.CreateInstance<AutoBoqRefMaint>();      BOQTmpRef boqTmpRef1 = new BOQTmpRef();      BOQTmpRef boqTmpRef2 = instance.bOQTmpRefView.Insert(boqTmpRef1);      boqTmpRef2.BranchID = row1.BranchID;      boqTmpRef2.AutoBOQRef = row1.TaskID;      boqTmpRef2.Descr = row1.Descr;            instance.bOQTmpRefView.Update(boqTmpRef2);      //error here      instance.Actions.PressSave();       BOQTask row2 = (BOQTask) e.Row;      object newValue = (object) ("000000000" + instance.bOQTmpRefView.Current.AutoBOQRef);      e.Cache.RaiseFieldUpdating<BOQTask.subID>((object) row2, ref newValue);      row2.SubID = (int?) newValue;    }

Anyone out there using Acumatica Construction module with external time keeping?  Looking to connect with companies that are using partner software for time keeping to get some advice, pros / cons, etc. of these solutions. My company just started using Acumatica ERP and currently integrate with WorkMax for our time keeping solution.  We need to have employees clock in/out in real time and we are starting to do job costing, but are struggling with that.  Any suggestions on time keeping software or on how other construction companies have Acumatica set up and do job costing would be very helpful.

Hello! I’m trying to configure a business event that will look at a customer’s monthly sales vs last months sales and generate a task for a sales rep to follow up on. I am running into issues because my GI uses a formula to note the accounts with declining sales and there’s a grouping by account (GI looks at invoices and is summing by account). Both formulas and groupings are on the list of things to avoid when building a business event. Anyone have any ideas on how to look at this type of data and trigger the business event that will actually work? Thanks!