Skip to main content
Answer

INItemSiteHistDay does not seem to total to QOH

  • January 21, 2022
  • 3 replies
  • 88 views

Forum|alt.badge.img+5

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

 

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • January 21, 2022

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

 


Forum|alt.badge.img+5
  • Author
  • Captain II
  • January 21, 2022

Thanks for confirming Naveen!

Do you have any thoughts as to why the totals of these do not always equal the quantity displayed in Stock Items warehouses quantities?


Neil Cantral
Jr Varsity I
Forum|alt.badge.img+3
  • Jr Varsity I
  • January 21, 2022

When is that data in these Hist tables updated? Might be tied to the posting/release of a document?