Skip to main content
Solved

Kit inventory report


Forum|alt.badge.img

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

Check out this thread https://www.augforums.com/forums/acumatica-generic-inquiries/non-stock-kit-stock-availability

View original
Did this topic help you find an answer to your question?

10 replies

toonsix
Freshman II
Forum|alt.badge.img
  • Freshman II
  • 17 replies
  • July 26, 2022

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 60 replies
  • July 26, 2022

@toonsix do you have a timeframe for when this podcast happened? I am having a hard time locating.  I am still searching github to no avail also. 


Jeff96
Captain II
Forum|alt.badge.img+4
  • Captain II
  • 246 replies
  • Answer
  • July 26, 2022

Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 60 replies
  • July 26, 2022

@Jeff96 thank you. I skipped over that one when I was looking because it said non-stock.


nathantrauscht
Semi-Pro II
Forum|alt.badge.img+1

@toonsix I could not find the github link in the forum posts - does this still exist?


nathantrauscht
Semi-Pro II
Forum|alt.badge.img+1

@cwomack98 did you ever figure this out?


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 60 replies
  • May 16, 2023
nathantrauscht wrote:

@cwomack98 did you ever figure this out?

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/#


nathantrauscht
Semi-Pro II
Forum|alt.badge.img+1

@cwomack98 I figured out how to create a GI with the code they pasted on the forum post.

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


Troy Vars
Semi-Pro I
Forum|alt.badge.img+2
  • Semi-Pro I
  • 54 replies
  • May 16, 2023

Try this one


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 60 replies
  • May 16, 2023
Troy Vars wrote:

Try this one

nathantrauscht wrote:

@cwomack98 I figured out how to create a GI with the code they pasted on the forum post.

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')

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings