you can run a query, something like this:
Code |
---|
Query = New Query("SELECT
| InventoryJrnlBalance.QtyBalance
|FROM
| AccumulationRegister.InventoryJrnl.Balance AS InventoryJrnlBalance
|WHERE
| InventoryJrnlBalance.Product = &Product
| AND InventoryJrnlBalance.Location = &Location");
Query.SetParameter("Product", CurRowLineItems.Product);
Query.SetParameter("Location", Location);
QueryResult = Query.Execute();
If QueryResult.IsEmpty() Then
Else
Dataset = QueryResult.Unload();
CurrentBalance = Dataset[0][0];
EndIf; |
and then find out a way to show a balance, maybe in a message window - Message();
Also when you open the item card the balance is shown on the card.