@Naveen Boga Thank you. It worked!
Hi, I think this would be helpful. Use your DAC something like this. #region StartTime [PXDBDateAndTime(UseTimeZone = true, DisplayNameDate = "Date", DisplayNameTime = "Time")] [PXUIField(DisplayName = "Time", Enabled = false)] public virtual DateTime? Time { get; set; } public abstract class time : PX.Data.BQL.BqlDateTime.Field<time> { }#endregionYou can set both date and time at once. And then you can show it in two separate fields in the UI.
@Django @darylbowman Thank you so much for your responses. Showing <New> was not succeeded, I had to go with substitute key option.
Hi @Chris Hackett I had to fetch records using a selector and insert those records to the Grid through code. I was unable to find why the default behavior is not working.
@Patrick Chen Thank you so much! it worked.
@Patrick Chen Can I do the same in mobile application as well? Is it possible?
@kandybeatty49 Yes, I want to see the last PO when navigating to the Purchase Orders Screen instead of a list.
@kandybeatty49 Yes I tried that. It does not works for mobile application. Anyway thanks for the response!
I added that as an Product Idea. Please refer the link.
@vardan22 Do I need to do that for each and every DAC if I have multiple table joins in the Projection?
@vardan22 Thanks for the response!Imagine, I have joined InventoryItem and AMProdItem tables with SOLine in the Projected DAC. Then what are the fields that I need to set as Keys(IsKey=true).?
Hi @lauraj46 , I already generated the DAC as you said. I mentioned one of my DACs in the question as well. HI @Robert Sternberg I tried this in my local Acumatica instance. Backend is MYSQL
@Robert Sternberg I tried that as well. But Still it does not work. My Acumatica Version is 22.218
@Robert Sternberg I tried changing those as well, but no luck
@dcomerford @Naveen Boga I tried publishing the same package in another instance and it works. But as @mikegrci said, my GI shows expected results while Report shows some unexpected results. Those extra ones seems to be duplicated records. But GI shows correct records without any issue as I mentioned.
Hi @Laura02 . Thanks for the response!.
@Laura02 Can you suggest any workaround for this known issue?
@Laura02 Thank you!
Here is the AR Preferences screen. No customizations have been published related to this.
@manikantad18 Yes, I Unpublished and published the packages again. That solved the issue. Thanks a lot!
Hi @cmetzger. Thanks for sharing!
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.