Discussion Forums

I created three DAC fields in a custom DAC as follows. When the user is redirected to the screen, those values are automatically filled. However, when I press save, the LotSerialNbr and Quantity fields are reset to empty and save as null in the database. Meanwhile, the  ProductionNbr field, which is PXSelectors, are working fine.  #region ProductionNbr    [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Production Nbr")]    [PXSelector(typeof(AMProdItem.prodOrdID))]     public virtual string ProductionNbr { get; set; }    public abstract class productionNbr : PX.Data.BQL.BqlString.Field<productionNbr> { }    #endregion     #region LotSerialNbr    [PXDBString(100, IsUnicode = true, InputMask = "")]    [PXUIField(DisplayName = "Lot Serial Nbr")]    public virtual string LotSerialNbr { get; set; }    public abstract class lotSerialNbr : PX.Data.BQL.BqlString.Field<lotSerialNbr> { }    #endregion     #region Quantity    [PXDBDecimal(

I wants to create settings screen which should contains only one record per tenant.Database structure done and save also work.But I don’t want next previous button or selection.My layout is  In graph only three linespublic PXSave<UsrCustomTable> Save;public PXCancel<UsrCustomTable> Cancel;public SelectFrom<UsrCustomTable>.View MasterView;How can I select default 1st entry ? 

 Hello - does anyone know of a way to only produce month end AR statements that include invoices that are 30+ days old? If everything for a customer is current, don't even produce a statement. And/Or if there are invoices past due, leave off anything that is current. Thanks

I have created one processing screen where I want to create a text file when I select the records and click export. And I want that file to be attached in the top right corner just like many other screens. Is this possible ? I checked and it looks like you can attach the file to a particular DAC but I don’t want to do that.

Is there a way to format the figures on a dashboard? Instead of showing for example, $251.04k. We would like to see $251,040. Is this possible?  

Hey! I was wondering if someone has figured out a way to make a GI that pulls from the Inventory Turnover project. I am trying to pull the “Qty of Items Sold” column by inventory ID and by financial period from the project.Thanks for your help!

I am hoping someone can suggest something for this rounding issue in PO Receipting. POs are normally in Purchasing Units, but Drop Shipment POs created from Sales Orders are in Selling unit for some reason.  So create a PO with UOM of EACH and Qty 2 for an item set up like this. Then create the PO Receipt from the PO. The receipt qty is correct by there is a decimal open qty calculated. You have to do a second PO Receipt for the remainder. Is this really necessary? Even if you increase company qty decimals you will get the same problem in the last percentile.    

Hello! I am trying to create a GI that shows the response time spent on cases. I need to find the difference between the case create date time and the first outgoing email completed time by our employees. We have a business event set up where there is an automatic email that goes out to inform the customers that we have received their case, so right now the ‘InitialOutgoingActivityAtDate’ field is pulling the time of that automatic email response. Not sure if this is possible or not, but is there a way to retrieve the first email sent by an employee? A email that has an owner? In this screenshot, we would like to have the date and time for 11/26 11:40amAny idea is appreciated! Thanks!!

In Finance → Manage Financial Periods, can I close month one of the new fiscal year if month 13 of the prior year is still open?

Hello! There are five companies in my tenant and each of them are using Customer Contracts for same customers. Currently it does not restrict customer contracts between companies. Is there any way of doing this?Amanda 

Hi All,Is there anyway to get a defualt branch on either the customer contracts or contract items? We have multiple branches with different contracts, it currently defaults to the logged in branch when running the contract billing

I am trying to close financial periods in Finance → Manage Financial Periods.  I am unable to close September due to an open A/R credit.  Is there any way to process the closing of this month prior to the credit being used/applied?

Hi All,I have added data to Excel with a specific format. However, I am unable to change the font style to bold in Excel.Also, when downloading the Excel files based on vendors, only one file is downloaded while the rest are not.Can you please help me with this issue? I am unsure what is causing these problems.Plz find the below attached file for view code. ThanksNageswararao.

I am trying to create a new Workspace. However, when I click the 3 dots on the left menu, the only option I have is to collapse the menu. Is there somewhere else I can access creating workspaces, or is this a permissions issue for my user role?

Hello All! I am looking to combine our current users' roles into singular roles. For example: I am part of 5 roles. I created a new role; I want to copy everything that I am a part of and move it into this singular role. Is this possible without having to go through and copy all permissions from each role? I hope that was clear…  Thanks,Brent

We have the following inventory labels form, and it prints additional labels based on the number of cross-references on the item profile. If there are three references or alternate IDs, then it prints three labels automatically. It might do because we added this table (INItemXRef) to the Schema Builder, but when I remove the table, then the label does not work.   

Sales Order - > Create Purchase OrderIn the Create Purchase Order screen , click ‘Process ALL’Error: Inserting 'Purchase Order' record raised at least one error. Please review the errors.Error: 'Owner' cannot be empty.       at PX.Data.PXUIFieldAttribute.CommandPreparing(PXCache sender, PXCommandPreparingEventArgs e)   at PX.Data.PXCache.AttributeHandlersSquasher`1.<>c__DisplayClass2_0`1.<To>b__0(PXCache cache, TArgs args)   at PX.Data.PXCache.OnCommandPreparing(String name, Object row, Object value, PXDBOperation operation, Type table, FieldDescription& description)   at PX.Data.PXCache`1.PersistInserted(Object row, Boolean bypassInterceptor)   at PX.Data.PXCache`1.Persist(PXDBOperation operation)   at PX.Data.PXGraph.Persister.Persist(Type cacheType, PXDBOperation operation)   at PX.Data.PXGraph.PerformPersist(IPersistPerformer persister)   at PX.Data.PXGraph.TransactionalPersist()   at PX.Data.PXGraph.RetryTransaction(Action persistBody, Int32 maxRetries)   at PX.

A line of code like this will crash the code page in the Customization Editor in 22R2, after it is saved and reloaded:ApplyDocuments.SetCaption($"Apply Prepayment of ${amountOfPrepayments}");I believe the issue is the ${} within the interpolated string.

After upgrading to 24R1, it seems that the Total Cost field was removed in 24R1.  What was the reason?  Is this an oversight or is there some other way to get this information? 

Hello all,I have the validate on totals entry activated and i am looking to import Amount - the field that requires the user to type in the figures manually if the Validate on totals entry is activated. Do we have any import scnearios in AR to import the Amount? or do we need to import the Invoices by disabling the amount checkbox? Regards.

Can a sales order has multiple lines of document discounts? Acumatica only allows one line of document level discounts. There is a requirement from my client to enter two lines of document discounts. How can this be handled in Acumatica? Is there a workaround to cater the above requirement. 

Hi Team,We have a requirement to load all account records from the Account Details screen without the Account ID filter. We are using the same graph as a reference and have created a new screen where we removed the Account ID filter and the respective conditions in the code. However, on the new screen, we are unable to load the Beginning Balance and Ending Balance values correctly for all accounts. Could you please share your thoughtsPlease Find the Screenshots for reference:Account Details Screen:New Custom Screen: Thank you,

I have an bill that has an unreleased retainage. When you look at this original bill the rounding diff is 0. Once I release the retainage which creates a new bill it now shows up with a rounding diff. The problem here is that although I can execute payment, the retainage bill stays open because of this rounding diff. And consequently by having the retainage bill open the original bill also stays open even though the full amount has been paid. How can I work around this? Retainage BillOriginal BillOriginal Bill 

How do you adjust total accumulated depreciation for an existing asset.  Our tax auditors are constantly changing the depreciation method at year end.  We get a depreciation schedule for the next year.

Hello,We recently been having this issue or every screen loading 10 secs before the next screen.Upon checking our AWS cloud we have never reached over 50% memory or cpu in the task manager.We still have 30% space left in our DB storage.Any advice on what should we do?This is how it’s like sometimes on a daily basis  Our version/build:Acumatica Cloud ERP 2022 R2Build 22.212.0046 +