Forum

Hi,

how can I configure 1C:Accounting Suite v. 29 in order to show QtyOnHand when a user creates a SalseInvoice and selects an item from the list?

Thanks for any advice.

you can run a query, something like this:

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;

Konstantin,

Thank you for your answer. Is there some possibility to see this quantity directly in the list? There are:

Code, Description, Type and Price.

I would like to have an additional column with this attribute. How can I do it?

after a sales invoice is created QtyOnHand can change. how do you plan to handle this:

1) save QtyOnHand at the moment when the document was created and don't update it?
2) update this information every time the document is open?
3) only put Qty in this column for the selected item row, but erase it after the user moves to a different row?

Konstantin,

you wrote the balance was shown on the item card. Is it not the same, just another presentation at another moment?

I suggest you to implement this function using a Pickup form from Goods Expence document of Managed Application Demo as an example.