customizationacumatica

Acumatica GI - Inventory Transaction History Screen


I want to create a GI for Inventory Transaction History Screen (IN405000).

Since the table InventoryTranHistEnqResult isn't present in the database...few of the columns of this screen are taken from INTran Table.

I am not able to find following columns: BegQty, QtyIn, QtyOut, EndQty...

I also tried the following query on database to find these columns

SELECT c.name AS ColName, t.name AS TableName
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%EndQty%'

The DAC for these fields is:

enter image description here


Solution

  • Looking at the information behind the page in the page Graph will give you the answers to your question. Inventory Transaction History Screen (IN405000) uses graph InventoryTranHistEnq. The grid in this page uses DAC InventoryTranHistEnqResult in the following view:

    PXSelectJoin<InventoryTranHistEnqResult,
    CrossJoin<INTran>,
    Where<True, Equal<True>>,
    OrderBy<Asc<InventoryTranHistEnqResult.gridLineNbr>>> ResultRecords
    

    The ResultsRecords are built dynamically in the inquiry using the following:

    protected virtual IEnumerable resultRecords()
    {
        int startRow = PXView.StartRow;
        int totalRows = 0;
        decimal? beginQty = null;
    
        List<object> list = InternalResultRecords.View.Select(PXView.Currents, PXView.Parameters, new object[PXView.SortColumns.Length], PXView.SortColumns, PXView.Descendings, PXView.Filters, ref startRow, PXView.MaximumRows, ref totalRows);
        PXView.StartRow = 0;
    
        foreach (PXResult<InventoryTranHistEnqResult> item in list)
        {
            InventoryTranHistEnqResult it = (InventoryTranHistEnqResult)item;
            it.BegQty = beginQty = (beginQty ?? it.BegQty);
            decimal? QtyIn = it.QtyIn;
            decimal? QtyOut = it.QtyOut;
            beginQty += (QtyIn ?? 0m) - (QtyOut ?? 0m);
            it.EndQty = beginQty;
        }
        return list;
    }
    

    So i guess the short answer is you cannot use the results of this page for a GI as it is built in the page only. You might want to look into adding what you need to this history page via a customization or make your own version of this page/graph/dac if the information you need is that important.