Skip to main content
Question

Report : Dollar amount base on Materials Min. & Max.

  • August 8, 2024
  • 5 replies
  • 85 views

Good morning all,

 

 I want to run a report on the total $Dollar amount on all my registered materials based on minimum buy and maximum buy quantities. 

 

 Is Acumatica capable and how?

 

Thank you 

5 replies

Forum|alt.badge.img+3
  • Acumatica Employee
  • August 9, 2024

@PROTOFEF

I’ll attempt to answer but I am not sure I fully understand the question. 

If I understand correctly, each inventory item has a minimum order quantity and a maximum order quantity (by vendor), and you are looking to multiply each quantity by the cost of the item? 

If these items are all purchased and have a default vendor, then you could build a generic inquiry (or modify an existing one) to perform the calculation for you if this is a recurring need. 

Is this what you are looking to do or did I miss the mark? 

 

Sincerely, 

Andre St. Amour


  • Author
  • Freshman I
  • August 12, 2024

Good morning, 

 

 This is what i am looking for but not by Vendor but as a whole For all vendors one total dollar amount for my minimum buy and my maximum buy. 

 

Can someone explain, the datils on HOW it can be done. Ty 

 

Thank you. 

 

 


Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • August 12, 2024

HI @PROTOFEF 

Do you have a current example of this report? Maybe if you share that, it could help someone create something for you or lead you to what you are looking for. 


  • Author
  • Freshman I
  • August 12, 2024

i currently do not have a report or example of this report. 


  • Author
  • Freshman I
  • August 13, 2024

total dollar amount ($$$) for minimum buys on all materials and vendors 

total dollar amount ($$$) for maximum buys on all materials and vendors