Hi,
I’m looking to create a GI that will list inventory transfers with their Release Dates. I don’t see a field in the INRegister table that stores the release date. What would be the way to get this date on a GI?
Thank you!
Answer
Transfer Release Date
Best answer by darylbowman
INTran does have a ReleasedDateTime. But not INRegister.
I’m not sure why you couldn’t join INTran, group by INTran.DocType and INTran.RefNbr, and use =MAX([INTran.ReleasedDateTime]).
+11Hi
Please use the INRegister.LastModifiedDateTime field. Because if the Transfers have been released then the Release Date is the LastModifiedDateTime.
Best Regards,
NNT
I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/phambaotruong
+15A simple customization could add a custom field and write the current date and time into when a transfer is released.
Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
+1Add the GL batch table to the GI and add the GL Created on date from the GL Batch to the results grid..
Ron F
A simple customization could add a custom field and write the current date and time into when a transfer is released.
A customization could definitely accomplish this. The reason I’m looking for an existing field that has this information is because the Inventory Transaction History screen has a Release Date column for transactions.
Add the GL batch table to the GI and add the GL Created on date from the GL Batch to the results grid..
That sounds like a good idea. How would I join it?
+15INTran does have a ReleasedDateTime. But not INRegister.
I’m not sure why you couldn’t join INTran, group by INTran.DocType and INTran.RefNbr, and use =MAX([INTran.ReleasedDateTime]).
Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.