Announcements
No record found.
i need to separate the quantity field in InventTrans table to be two fields, one for Positive quantity and another to Negative quantity.
*This post is locked for comments
It doesn't sound like a good idea, because you would have to change the whole inventory management in AX.
Can you tell us what business requirement you're trying implement by splitting the quantity field?
i need to create a new report to show item transaction, but i need to show all positive quantities in column and all negative quantities in another...
i already create the below display method but the result not correct.
display real QtyPos()
{
if(InventTrans_1.Qty >0)
QtyPos = InventTrans_1.Qty >0;
else
return QtyPos;
}
Create two methods - one will return positive quantities and one negative quantities.
It would also say that your display method isn't correct. It should get InventTrans buffer in a parameter, shouldn't it? Of course I can't know where you put the method unless you tell me that.
Hi Islam,
I do fully agree with Martin. Assuming you have an active buffer you are now only filling a true or false in the QtyPos field (QtyPos = InventTrans_1.Qty >0)
When using two display methods, it would be something like this:
display InventQty QtyPos()
InventQty qtyPos;
if (InventTrans_1.Qty >= 0)
qtyPos = InventTrans_1.Qty;
qtyPos = 0;
return qtyPos;
display InventQty qtyNeg()
InventQty qtyNeg;
if (InventTrans_1.Qty < 0)
qtyNeg = InventTrans_1.Qty;
qtyNeg = 0;
return qtyNeg;
Depending if you need to reverse the sign, you can change the QtyNeg. Note that the else might not be needed if you keep the qtyPos and qtyNeg as local variables.
You may also change it on SSRS design level only, using expression
For -ve column
=IIf(Fields!SomeField.Value < 0, Fields!SomeOtherField.Value, 0)
For +ve column
=IIf(Fields!SomeField.Value > 0, Fields!SomeOtherField.Value, 0)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CP04-islander 39
Michel ROY 14
imran ul haq 8
