Discussion Forums

Is there a way to setup a Flat Rate Earning code that could be added to the Employee Compensation Tab of the Employee Payroll settings ?? This Flat Rate Code would then automatically  be picked up on each Payroll run so one doesn’t need to import a Earnings file or hours file each run. I have a client that doesn’t want hours to appear on the paystub for the Salaried Employees as they are being paid a set amount whether they work 30 hours or 50 hours. This desire is to prevent any lawsuits on overtime for the Salaried positions.Thanks

I'm trying to import employees but I get the following error: this Import Scenarios: 

Hello!I know Cases in Acumatica are support cases or tickets that help track customer requests, but can it also be used for internally? For example, when we close an opportunity, I want to be able to create a case/ticket internally from this opportunity to track next steps. And then close it once the work is completed. Can Cases do this or is there something similar that Acumatica offers? Thanks!

Hello,I’m creating payment pluign and integration between acumatica and cybersource payment acceptance, Cybersource secure acceptance requires creating of signature that is being posted with the transaction details, cybersource uses this signature to verify that the authenticity of the request.This signature can have special characters like = / _ - … etcWhen I implment GetDataForPaymentForm, I add the signature as form Parameter input with other transaction parameters, I set UseGetMethod = false so it uses POST method.Submitting to cyberosurce endpoint always fails because of invalid signature, upon troubleshotting, I found that Acumatica is stripping the = character from the signature when posting to the end point which at the end make signature not matching and cybersource declined the transaciton.And cybersource won’t accept URL encoded signature and it fails as wellI did PxTrace logging and made sure that correct signature is generated but when Acumatica post it it remove the = cha

I have built a custom screen with a primary grid:When I enter two or more items into the list and save, only the last item is saved: Why? DAC:[Serializable][PXCacheName("IN Fulfillment Warehouse", PXDacType.Catalogue)][PXPrimaryGraph(typeof(INFulfillmentSiteMaint))]public class INFulfillmentSite : IBqlTable{ public static class FK { public class Site : INSite.PK.ForeignKeyOf<INFulfillmentSite>.By<siteID> { } } #region CountryID [PXDBString(100, IsKey = true, IsUnicode = true)] [Country] [PXUIField(DisplayName = "Country")] [PXDefault("US", PersistingCheck = PXPersistingCheck.Nothing)] public virtual string CountryID { get; set; } public abstract class countryID : PX.Data.BQL.BqlString.Field<countryID> { } #endregion #region StateID [PXDBString(50, IsKey = true, IsUnicode = true, InputMask = ">CC")] [State(typeof(countryID))] [PXDefault] [PXUIField(DisplayName = "State")] public virtual string StateID { get; set; } public abstract class stateID : PX.Data.BQL.BqlStr

Customer is on 2023R1Created a new Business Event Based on status chnage on a new Sales order GI Business Event did not trigger as expectedCopied the GI and BE to Sales Demo instance and trigger worked as expectedwhat could the issue be on the customer instance to cause the BE not to trigger ?

Hi All, I have looked at the existing topics here for GL Journal upload as well as the out of box ACU Import GL Transactions. none of these has helped me to load my data. I have uploaded the sample of data I am trying to upload. it loads the first line but fails at the second line I also have no explanation on why it does what it does. I had to move things around until it posts Debit side for my Inventory account and credit to GRNI ( po Accrual or Goods receipt not invoiced) Appreciate your help and insight on this. Thanks Ghazal 

I am working on a 12-month calendar forecast P&L.  It is not a rolling report and will always display January - December from left to right and a total. The results will display either actual or budget.  For the months up to and including the date the report is run the actual results display by month and budget will display for the months after the date selected.  For example, if I set the date to 08/2024 the report will display actual results in separate columns for January - August and budget in the columns for September - December.along with a total.  The column set has 36 columns, 12 columns to pull actual, 12 to pull the budget and 12 to add the combination of actual/budget based on the date selected.  I have it working to display either actual or budget by month using a visibility formula.  I now need the visibility formula to use in the 12 columns of totals so that only the total for the combination I have selected displays.  I have tried the formulas in other discussions, a

I restarted my laptop today after the current windows update. All my local Acumatica 2024 R1 instances don't work anymore after restart. They all work fine yesterday. I get the following error. Does anyone have the same problem?Method not found: 'Serilog.LoggerConfiguration Serilog.Configuration.LoggerSinkConfiguration.Logger(Serilog.ILogger, Boolean, Serilog.Events.LogEventLevel, Serilog.Core.LoggingLevelSwitch)'.   

I have a custom table with a basic GridView screen for entry.  When entering values for the first row and clicking Save, an error is thrown saying that one of the non-nullable fields has a null value.  After some debugging, it appears that the save is trying to save the row I entered, plus a new blank row -- thus, the complaint of the null value. In fact, if I make the field nullable, it actually saves the blank row (blank except for identity field) in the db.  Also, this only happens on the first row entered.  If I add another row and save, it doesn’t happen.  My guess is maybe a table/DAC key issue that makes it want to insert instead of update, but I’ve triple checked my key references.  Does this ring a bell to anyone as something you’ve run across?Custom Table1 and Table2 have identity keys.  Custom Table2 has a foreign key to Table1 referencing its key field.  Table1 primary key definition: public class PK : PrimaryKeyOf<CFLocationBarcode>.By<locationBarcodeID>{ pu

 My Requirement is that on every release of a purchase receipt, I need to raise fieldupdated event of each inventory id’s last cost field. I have a chain of events that is attached further with Last Cost field updated event. I tried various ways but that event isn't triggering programmatically. If values entered manually in that field, it works perfectly fine.

From my understanding, non-persisted fields are the best way to handle data that needs to be calculated using some business logic. However, since these fields aren’t saved to the database, we can’t use them in generic inquires and reports. If I instead saved this field to the database, I think I would need to make sure that it is recalculated either every time one of the values in the business logic equation changes, or if a user or anything else is interacting with it, including a report/inquiry. I’m not sure of the best way of doing that or if I’m missing something.

 We use the process to create transfer orders based on SO demand, Create Transfer Orders on the Sales Order Menu.  This process works great except for one piece, the tie to the Sales Order is lost after the shipment for the transfer is confirmed. While Creating Transfer Order the Line Details are there tying the SO to the transferAfter Create Shipment is clicked, Line Details still ties the SO to the transfer.After Confirming Shipment, Line Details are gone on the TRThis makes it so the system cannot tell the user that originated the sales order that their product is in to fulfil the customer’s needs.Anyone else run into this?  Is it a bug or by design?We are currently on version 2023 R2.Thanks!  

Happy Monday! I have been spending some time with teams-based notifications, which has some incredible potential. I would love to be able to send a message when a SO line has been changed and what has changed. The use case would be if a Customer changed the QTY or we had to remove a line, it would be nice to keep everyone involved on the same page via teams. While I can notify when a line has changed (see image), I can’t really say what has changed. Is that possible?   

Be default, commerce connector merges customers from external systems using the same email address. i.e. when you have two or more customers from one or more stores irrespective of the connectors(Shopify, BigCommerce etc.,) imported into Acumatica, the connector creates one customer record for all.But because of some business scenarios if this is required to not to be merged and create separate customer records, then this could be done using the attached customization. Once the customization is published, you see a new checkbox called “Merge Duplicate” in Entities(BC202000) form. If checked for the stores for the customer entity, then customer records from different stores would be merged and you would have one customer per email ID. If checked for few stores and not for all, then checked stores will create a separate customer records but unchecked stores will share a common customer record.   

Related to this question.I can’t figure out why adding a popup dialog to Opportunities breaks the address lookup map.I can see that the ASPX page uses #include to load in some panel templates. This is the broken result of the ‘Address Lookup’ button after adding my popup dialog element: 

We are creating a report in Report Designer where one description field needs to be set to Can Grow. The user would like the detail section to be maintained at a minimum height, but would like the Detail Section to grow when the description field grows in height. Currently, the Detail Section height remains constant and when the Description field grows in height, it is cut off at the bottom. Is there an easy way to cause the Description section height to grow when the field grows?

Hi all, I am having issues logging into the mobile app.  Each time I try I get an invalid credentials error.I am able to login on the website, and have confirmed I am using the correct web address for the mobile app.  We tried logging one of my coworkers in and their credentials worked fine.any assistance would be greatly appreciated.

Hi,I used the screen “Web Services Endpoints” then menu “… > Service Definition > Open API 2.0” to generate the swagger.json file.This is for the Acumatica: "/entity/Default/23.200.001" collectionI then processed that through the openapi-generator to generate a java client:java -jar openapi-generator-cli-7.8.0.jar generate -i [domain]entity/Default/23.200.001/swagger.json?company=[company] -g java --api-package [mypackage].finance.acumatica.openapi.client --model-package [mypackage].acumatica.openapi.client.model -o testoutput --skip-validate-specThat generates the java client .java files.  These all compile to .class files without any errors.So this all looks good so far.  This is industry standard for generating a client from swagger.json data.  However when I run the client I get an error.  The client makes a request to acumatica for data like:                        VendorApi va = new VendorApi(apiClient);                        List ids = new ArrayList();                    

We use AWS to send text messages, we have an Amazon SNS topic “Acumatica” and an access key associated with that. As more departments send SMS notifications through Acumatica, we would like the replies to go to different people. Is it possible to set up multiple SMS providers in Acumatica pointing to different AWS topics? Has anyone done this?

I am building an Export scenario based on Invoices and Memos.I am able to successfully select and include the Item Description field in my export. I would like to use a LEFT() function to select only the left 40 characters, but I am struggling to figure out the DAC prefix for this field or I do not have the proper syntax.When I look at the SYMappingField, it shows me that the “Object” name is Transactions, but when I add that to my function, it does not validate.What is the best way to determine a field’s DAC ?OR, am I having a syntax issue?=Left( [Transactions.InventoryID!Descr], 40)  

what is the replacement for this Graph WarehouseManagementSystemGraph in 2024 R1 ?

Hello,Has anyone been able to customize the font used in the dashboards ?

 What is the problem with my code all the other with ewt is already not shown but still there is one that is showing i already fix this hahhahaha  =IIf(InStr(Trim([GLTran.TranDesc]), 'EWT') > 0 OR [GLTran.TranDesc] = 'EWT FOR 4TH QTR 2022_DAP' ,'', [GLTran.CreditAmt] - [GLTran.DebitAmt]) 

We have almost 100,000 parts and are going to retire about 30,000. I was hoping folks who may have done this type of thing might be willing to share some of their experiences accomplishing this. Some of the questions I have arewhat reports did you use to quickly identify parts with no “movement” since XX/XX/XXXX? What methods did you use to retire a part? Did you just set it to inactive?