We had a Project Inventory Location GI we had created in 2022R2 we use heavily. Now that we are upgrading to 2023R2, the GI has to be re-written because of the PMLocationStatus and PMLotSerialStatus tables having been removed in 2023R1. I’ve been trying to get the GI modified using the table references in the Release Notes for 2023R1. I am apparently missing something. I would appreciate help reviewing our original GI (titled Project_Inventory_Location.xml attached here) against the version I am working to modify in our SANDBOX for our upgrade to 2023R2 titled MR_050724_Project Inventory Location.xml attached here. The modified GI is creating duplicate rows. I’ve reviewed the GI and am not seeing the reason for the duplicate rows being returned. Thanks for looking and any help you might offer in advance.
Userlevel 7
+10
Have you taken a look at the inquiries that Acumatica has published here? They should work with 23R1 and newer.
So, those “two’ inquiries do work with 23Rx. However, they aren’t providing the information we use and I am still struggling to get the same information as we were originally able to pull using our GI from our 2022R2 build referencing the new tables. Certainly likely it is something in the way I am constructing/modifying the GI. Anyone with more experience than me and some time to review what I’ve provided in .xml files earlier and willing to help me figure this out would be appreciated.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.