Looking for a report or GI that would show available inventory for components of a kit. I can’t seem to locate anything like that but it sounds familiar. Am I missing something or does this not exist?
Original question from client: I want a report that shows my available inventory on hand for all the components in a kit, all on one report.
Best answer by Jeff96
View original
One of the augforum.com podcasts has a person who developed this. It is also on github. Contact tim rodman. He will know. ToonSix@intercs.com
+4
+1
+1
I think I followed the following link at least according to my comment saying it work for the customers need.
https://www.augforums.com/forums/acumatica-generic-inquiries/non-stock-kit-stock-availability/#
+1
See attached, only thing I have not figured out yet is how to create a parameter so the user can put a QTY in the header then have it multiply the component quantity by the parameter
+2
Try this one
Try this one
See attached, only thing I have not figured out yet is how to create a parameter so the user can put a QTY in the header then have it multiply the component quantity by the parameter
P.s. I added a color code if there wasn’t enough quantity to make the amount you wanted.
Might use the Qty Available instead of Qty on hand but you get the idea.
=Iif(([QtyToMultiply]*[INKitSpecStkDet.DfltCompQty]) >[INSiteStatus.QtyOnHand],'red20','default')
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
