Solved

We are using 2020R2 and I am trying to edit many of the construction reports to have the project manager as a parameter.  Our previous version 2019R1 had the project table right in the schema, so it was easy.  In this version for example, the Project WIP Reports only has the tables Branch, PMReportProject, and PMWIPTotalBudget.  When I look for the tables in the DAC, they don’t exist.  I assume that they are hard coded somehow, as they are not a view in SQL and I can’t find these 2 of the tables anywhere in acuamtica or the SQL server.  Does anyone know the relations of these tables with regards to the project table so I can add ownerID.Thanks

Hi, I have created a pivot table for shipment data and it has lots of number fields that are presented as text, when you export to excel. Is there a way to format the number columns so, it will show left aligned in the table and will have the correct format when exported to excel?

04-Jun-2021When I attempt to install the ERP 2021 R1 Update 6 version from the downloaded AcumaticaERPInstall.msi file, I receive the error listed in the title above.  I also receve the same error when attempting to install the ERP 2020 R2 Update 11 version. I have reviewed the “Сan’t get your IIS version from the registry. Probably you don’t have IIS?” error resolution, but I cannot duplicate it.  My registry does not have the key:  Computer\HKEY_LOCAL_MACHINE\SOFTWAREMicrosoft\InetStp Please advise.  Thanx.

Hello Everyone,I want to sync Stock Item Attribute (combo/multi-select combo) Value Description instead of Attribute Value ID at the time of Stock Item Sync from Acumatica to BigCommerce as custom field name and value.From Entity Mapping it is not possible, so I did a customization but observed that one attribute value, updating across all other custom field values.Please find below sample code and screenshots for reference.Sample Code:public class KNBCStockItemProcessorExt : PXGraphExtension<BCStockItemProcessor>    {               public delegate object GetAttributeDelegate(BCStockItemEntityBucket bucket, string attributeID);        [PXOverride]        public object GetAttribute(BCStockItemEntityBucket bucket, string attributeID, GetAttributeDelegate baseMethod)        {            MappedStockItem obj = bucket.Product;            StockItem impl = obj.Local;            impl.Attributes?.Where(x => string.Equals(x?.AttributeDescription?.Value, attributeID, StringComparison.Inva

I have been working on a business event that triggers an email once a customer creates order from the web portal and falling short. The trigger has not worked if the portal users generate the order.  If I change the business event to trigger on record change and then do any modification changes from the ERP side, it works from the portal sales orders.  The New field value is set to createdByScreenID and Screen ID = SP700001. Could this be related to the customer's user's account types and users' permissions? Your support is appreciated.

Can someone assist me on how I change a quote to a sales order in 2021 R1 that will also close the quote?

Hello, How to include the aggregated field or sum fields in the bottom of a generic inquiry when exporting to excel? Thanks, Ed

Can someone let me know the logging credentials of Purchasing Manager of U100 data set? Thank you in Advance

I am trying to upload a TB. My base currency is LKR. However I also have two cash accounts on USD and GBP. In the upload, I specify the correct currency amounts and load the TB. I am able to release it as well. However the GL batch that gets created does not balance. Its based currency is LKR, but the two entries for the denominated accounts, it shows the foreign currency values, not the relevant LKR (Base) value. Is this a bug or am I missing something here?

Hi,Is it possible to pass a Parameter to the GI when the GI is extended via a WebService EndPoint? Setup:I have created a generic inquiry called SubcontractsByProject, it takes in 1 Parameter called ProjectID, I have set the ProjectID with a default value of a project and it filters to that Project, so the GI is working as it should. I have extended a Webservice EndPoint to SubcontractsByProject using instructions from https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/ The web service workshttp://localhost/entity/Subcontracts/18.200.001/SubcontractsByProject?$expand=ResultIt is returning data with the default ProjectID in the GI How can I pass a different value of ProjectID to the webservice?I tried adding a parameter in the Body like so in PostMan but it does not work ThanksMark

Hi,I always got PXData.PXLockViolationException a.k.a “another process has added…..”We are having a upgrade procedure right now.in my 2019 R1 Project same code, it works, but when on 2021R1, it returns me this error.Is there a new way to add lines programmatically in 2021 R1?I always do.var item = Details.insert();item.description = someDescription.Details.Update(item);but when I do Actions.PressSave() it triggers the error.been going here for weeks. I tried all solutions I can think about. Thanks, Ed

Hello everyone!Is there anyway i can change the order of the tabs in the sales order screen?We are wanting to move the “ADDRESSES” tab to be in between the “SHIPPING” tab and “DISCOUNTS” tab.  When i look in the customization screen, it appears that the order in the screen editor is correct but it does not display in ACM that way?Any ideas?Thanks! :)

HiI have installed the DH on my computer and the pw is clearly displayed.I have NOT installed any other acumatica app except for the DH.Did I miss anything? Thanks for your help  

We use Honeywell mobile hardware with the Acumatica app with the distribution module. Our delivery drivers experience an issue where the app logs out from their users when connecting to the charger. This issue happens on all the Honeywell hardware styles we use.  After testing with their provisioner application and changing Android daydream settings, we reached out to Honeywell, and here is the information. There is a power state change unique to Honeywell devices; we need to make sure we are implementing the Honeywell SDK's for android.The problem exists in the coding; the hardware will report a battery change when taken out of the dock, in which case some apps will log out when they sense a battery change, which needs to be ignored in the coding. Honeywell units have technically three potential power sources: AC power/ Super Capacitor and standard battery discharge. The device is smart enough to manage it automatically but treats all power conditions as a battery change. Does anyone

Hi,I’m using ScreenInfo to store all the screen details to custom table.Able to get ViewNames and fields but unable to get Table name for the respective views.Is there a way to fetch table name using ViewName or any other way to get all the screen details(Tables,ViewNames and fields)?. 

Hello all,I’m working on a generic inquiry. I need a total inventory amount for each item. The result as below. The item existed in different warehouse.  When I add a grouping for InventoryID. The result become to :  My question is how do I ignore grouping on MSRP column? My GI setting is below.  

Case:  A Project is setup with the Global Billing and Allocation Settings Billing Period of ‘Month’ to make mass billings of recurring invoices, where there is a task set up with recurring billing, easy by using the ‘Run Project Billing (PM503000)’ process screen. However Project has other tasks that have Billing Options of ‘On Task Completion’.Problem:  In a Project with tasks with multiple Billing Options and the Global Billing Period is Month, there is no way to run project billing just for those Project Tasks with the Billing Option of ‘On Task Completion’. The default method when you click ‘Run Project Billing’ runs the monthly task bill according to the Global Bill Period setting and resets the next billing date.  Current Workaround: Bill ‘On Task Completion’ tasks using the Invoices and Memos Screen (AR301PL)… this is time consuming and sometimes problematic if the Project has overridden the Bill to and Bill address - The invoice produced by AR301PL is in context of the Customer

Similar to this topic:I have a working processing UI that I want to use to create individual PDFs (from a report) and save to disk.  At the end of the process I want to show the same report (all together) in preview with the same records used to create the individual PDFs.  I have a working report but am struggling with how to get the joined tables in my PXReportResultSet since my delegate only gets the main table passed in as List.I’m sure I could BQL query these somehow or run a full BQL query again by passing in the filter (based on the referenced technique) but not sure if there is a better way to just grab these from the results already retrieved for the UI. Here is my code: public APStaleDateLettersProcess() { DetailsView.SetSelected<APQuickCheck.selected>(); DetailsView.SetProcessDelegate(Process); } public PXCancel<APStaleDatedCheckFilter> Cancel; public PXFilter<APStaleDatedCheckFilter> Filter; p

My aim is to edit an entity which is selected by a Filter.The Filter DAC contains only unbound fields and does not have a DB table. It is marked with [PXHidden]In the graph there is the Filter, a View for the entity and the Save action: public PXFilter<FilterDAC> Filter;public SelectFrom<EntityDAC>.Where<EntityDAC.name.IsEqual<FilterDAC.name.FromCurrent>>>.View FilteredEntities;public PXSave<FilterDAC>; In the ASPX file I set Filter as PrimaryView of the DataSource and also as DataMember of the 1st form. A 2nd form with DataMember FilteredEntities to edit the entity.The Filter works fine and I can edit the entity. The error occurs if I press the save button. PXGraph.ExecuteUpdate with viewName = ‘FilteredEntities” throwsError: The table with the name 'FilterDAC' does not exist in the database.That’s true, but shouldn’t this be ignored if the DAC has atribute PXHidden? [PXHidden] public class FilterDAC : IBqlTable { [PXString(IsUnicode = t

Via the mobile app we can attach all the photos we want onsite to the opportunity.I am looking for suggestions (maybe I have something turned off) on how to upload photos/files via the app in the project screen the same way. Any ideas?

Hi Experts,I have a data view called ‘ReportCredential’ in my PXGraph. I set ‘ReportCredential’ as a primary view for a PXFormView. Also I have a funtion called ‘reportCredential’. When the form is loading, I find the function will be called several times. Since I will call external web services in this function, I need this function to be called only once. Is there any other event handlers for the screen loading? The following is my code. Thanks,

We are using Velixo to create a report showing current percent complete and forecasting the percent complete per month till the end of the project.  The problem I have is when pulling the Budget Forecast into the spreadsheet I need the RevisionID of last update.  I have pulled that field into the GI but it wont show up.  It doesnt even show up, but its on the results grid.  Any idea how I could get this number to show?  

Does Acumatica have any solutions to integrate with lease management/accounting software for easier recording underASU842? 

Good day,  I have the situation where I need to move different finished goods items from a singe production order. In this scenario I am moving a main item from the production order, and some “by-products” or “co-products”. How would this be done with standard Acumatica Production Orders?

I’m not sure if this is a glitch in Acumatica or a setup issue on our end. Bank reconciliation is showing the direct deposit batch total as one line on the bank rec (which is how we have it setup in the bank and what we want) and no individual pay stubs; but once the bank rec is released, the individual pay stubs show in bank transaction details as cleared but not reconciled. In next reconciliation the individual pay checks show up for some reason as ready to be reconciled with the cleared box checked. Users cannot reconcile the individual pay stubs because they have already reconciled the whole direct deposit batch in the previous reconciliation. It is like a flip gets switched once the direct deposit batch is reconciled and released that marks the pay stubs as cleared but not reconciled and then allows individual the pay stubs to then show up in the bank rec. I can’t figure out why the individual pay stubs are 1-not being marked reconciled when the full batch is reconciled, and 2-why