I’m trying to add a the Qty. on Supply from the prepare replenishment page to a Custom GI page. I tried different ways to link the relationship but I can’t get any numbers to show up. Can any help guide me on what I did wrong in the relations?
Answer
Help Adding Qty. On Supply column to a Generic Inquiry
Best answer by lauraj46
Hi
We often use the DAC INSiteStatus on these sorts of GIs. A sample GI is attached.
According to the INReplenishmentItem DAC definition, the Qty on Supply field is the total of qtyPOPrepared, qtyPOOrders, qtyPOReceipts, qtyInTransit, qtyINReceipts and qtyINAssemblySupply. If you want to stick with INReplenishmentItem, you might try displaying these fields separately and that might give you some insight into the issue.
Hope this helps!
Laura
+8Iqra ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*. Proud Acumatica MVP (2024, 2025) - See my journey here: https://community.acumatica.com/community-site-discussions-150/iqra-harrison-acumatica-mvp-2025-28977
+8Hi
We often use the DAC INSiteStatus on these sorts of GIs. A sample GI is attached.
According to the INReplenishmentItem DAC definition, the Qty on Supply field is the total of qtyPOPrepared, qtyPOOrders, qtyPOReceipts, qtyInTransit, qtyINReceipts and qtyINAssemblySupply. If you want to stick with INReplenishmentItem, you might try displaying these fields separately and that might give you some insight into the issue.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.