Generic Inquiry - Allocation Details

Hi @nathantrauscht ,

My understanding is that the DAC is built on the fly and therefore not readily accessible in a GI.  You can view the source code to get an idea of the logic, but I’m not sure this would be easy to replicate.  Maybe someone else has a suggestion as this would definitely be nice to have in a Generic Inquiry.

Laura

@lauraj46 It’s too bad Acumatica did not make this readily accessible through a table. I will submit a new request to add this enhancement. I think it would be a great tool to have readily accessible.

@dcomerford I will give that a try and let you know how it goes, thank you for sharing!

@dcomerford it’s not exactly what we need but it’s a good start. Just need to make some simple modifications for it work for us, thank you!

Looking for the same Generic Inquiry - Has 26R1 made this possible?

For audit purposes, our client needs a Query that shows the GL entries, but also the allocation destinations  and percentages

I have tried several attempts but have not found a good solution.

The data is in INItemPlan and the definitions (Join in PlanType) are in INPlanType.  They can be accessed from a GI.  To get the the demand from a sales order join the planid to SOLineSplit, or for a production order AMProdMatlSplit.