By using this website, you agree to our Terms of Use (click here)
I’m new to Acumatica, I need to create a GI that will show what the remaining quantity is from a receipt. I assume this can be determined, since when doing an adjustment, you must specify the receipt to apply the adjustment quantity to.
Thank you,
Tom
Hey Tom, welcome to AUG Forums and the Acumatica community as a whole!
I am trying to make sure I understand what you are looking to do. Receipts maintain the source PO and open quantity as well as the returned quantity, but it sounds like you also want any adjustments done against the same receipt should also impact the "remaining" quantity, correct? Does this remaining quantity need to reconcile back to an open PO?
Thank you, Kevin. Yes, any adjustments made should be reflected in the remaining quantity. It does not have to reconcile back to the open PO. When looking up a receipt when entering an adjustment, it lists all receipts and the remaining quantity on that receipt, that is the number I need.
@tomlibby this info is in the FIFOCostStatus table. I have attached a quick GI I threw together for this, that I think, gets you what you are looking for. Couple things to note:
1. I built this in 2020R1, but you should not have an issue with prior versions, certainly no issues in 2019R1+
2. I did not make provisions in this GI for the location within the warehouse, but let me know if you need some help on that if its needed.
If you get an error importing this, you may need to change the screen ID in the XML file since it may have already been used in your environment.
Let me know if you have any questions.
@kevin-ruppert This is exactly what I needed. Huge help, didn’t expect you to actually do it for me. Thank you so much, really appreciate it.
@tomlibby no problem; only took a couple minutes and am glad this was what you needed. As you continue to learn and grow your knowledge and understanding of Acumatica, simply pay it forward to the next person who is new and needs some help. AUGForums is all about sharing knowledge and helping others and why Acumatica is such a great product within such a great ecosystem. Cheers!