Discussion Forums

Hi EveryoneI am currently facing a scenario where the same lot number is being received across multiple purchase receipts for the items. We need to implement validation to ensure that duplicate lot/serial numbers are not entered in multiple receipts, while still allowing the same lot number to be received in different receipts.Could you kindly clarify if there are any existing validation configurations or methods in the system to prevent duplicate lot/serial entries in Purchase Receipts? Additionally, I would appreciate any guidance on how to handle this scenario effectively. 

For complex report , I am creating CTE based sql view. In my view script there are multiple CTE. I want to filter every CTE with report input parameter so that less data get read by every CTE and  report performance gets improve.To achieve this I would like to follow the same steps to create sql view with parameter. https://stackoverflow.com/questions/2281890/can-i-create-view-with-parameter-in-mysqlbut I am confused as how to pass that parameter in DAC @p1 value so that the same parameter get reads by every cte. 

We are using MRP to identify when we need to manufacture an item.   MRP is adding the Quantity Remaining to Produce from a production order to the Qty On Hand.  In the example below the Qty On Hand shows 50 but in the first line below it is adding 168 to that number making the total Qty On Hand 218.  The 168 is what is remaining on the production order to be completed. I’ve also included a screen shot of the production order showing the 168 Remaining to produce.  How can I tell MRP not to add the remainder on a production order to the qty on hand?  

I have a client with 1 Company (With Branches Requiring Balancing) setup in Acumatica and have around 20 Branches in it. The client's new requirement is to establish an additional company and transfer certain branches from the existing company to this newly created one. This is necessary in order to facilitate the submission of Group VAT for specific branches located in the UK. Since these branches have existing transactions, the ability to switch and select a different company on the Branch screen is disabled. Is there a way to reassign the branches to the new company? Regards 

I am migrating version 22.122.0019 -> 24.100.0139 and I am getting the following errorwhat solution we could apply?

We have a subreport that has been developed, and is working using data from the CRRelation table, which was submitted last week with issues. The subreport is a part of the groupFooterSection1. The subreport is receiving the parameters without any issues, but the final Sales figures are not all showing up as expected. I attempted to adjust the size of the subreport in various ways, using Custom, A6, and other dimensions trying to get the size down. Everything in the groupFooterSection1 has been encapsulated on a panel, and I’ve attempted to use a separate panel, no dice, no panel, no dice, putting the Sales figures on it’s own panel, still no dice. The user is adamant about using the CRRelation table to prevent his users from having to keep typing the same data from one report to another. On another note, I again want to thank all of the people that helped me last week to use the CRRelation for the data.Word attachment has screen shots of the work done and I’ve included a zip file of th

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?