Hello,
I am using INItemSiteHistDay to do some inventory analysis. As a gut check, I subtotaled on inventory ID and compared the results to the total of all warehouse quantities in the stock item screen.
Sometimes (not always) my results do not match what is displayed for the total of all warehouse quantities.
I am wondering if I am missing something in the following formulas, or if INItemSiteHistDay does not actually hold all inventory transactions.
These are the formulas I am using:
QtyIn = INItemSiteHistDay.qtyReceived + INItemSiteHistDay.qtyTransferIn + INItemSiteHistDay.qtyAssemblyIn
QtyOut = INItemSiteHistDay.qtyIssued + INItemSiteHistDay.qtySales + INItemSiteHistDay.qtyCreditMemos + INItemSiteHistDay.qtyTransferOut + INItemSiteHistDay.qtyAssemblyOut
Thanks for any assistance!
Best answer by Naveen Boga
Hi, @ltussing03 I just reviewed the INItemSiteHistDay.cs DAC file, and the above-mentioned formulas are correct. Please find the DAC fields with formulas below.
Hope this helps!
#region QtyIn public abstract class qtyIn : PX.Data.BQL.BqlDecimal.Field<qtyIn> { } protected Decimal? _QtyIn; [PXQuantity] [PXFormula(typeof(Add<INItemSiteHistDay.qtyReceived, Add<INItemSiteHistDay.qtyTransferIn, INItemSiteHistDay.qtyAssemblyIn>>))] [PXUIField(DisplayName = "Qty. In", Visibility = PXUIVisibility.SelectorVisible)] public virtual Decimal? QtyIn { get { return this._QtyIn; } set { this._QtyIn = value; } } #endregion #region QtyOut public abstract class qtyOut : PX.Data.BQL.BqlDecimal.Field<qtyOut> { } protected Decimal? _QtyOut; [PXQuantity] [PXFormula(typeof(Add<INItemSiteHistDay.qtyIssued, Add<INItemSiteHistDay.qtySales, Add<INItemSiteHistDay.qtyCreditMemos, Add<INItemSiteHistDay.qtyTransferOut, INItemSiteHistDay.qtyAssemblyOut>>>>))] [PXUIField(DisplayName = "Qty. Out", Visibility = PXUIVisibility.SelectorVisible)] public virtual Decimal? QtyOut { get { return this._QtyOut; } set { this._QtyOut = value; } } #endregion