stockroom | 🗃 Offload your store management to a worker | State Container library

I have one table: STOCK. It has (among other things) a column: EAN and LOCATION.
I'd like to know my total of stock of a certain EAN in LOCATION 'stockroom' or 'return'.

ID - EAN - LOCATION
01 - 3344556677 - stockroom
02 - 3344556677 - stockroom
03 - 3344556677 - sent
04 - 3344556677 - return
05 - 1122889900 - sent
06 - 1122889900 - stockroom
07 - 1122889900 - stockroom (added on 7 dec.2020)

The result should (at least) show me:
EAN - NUMBER IN STOCK
3344556677 - 3
1122889900 - 2 (edited on 7 dec.2020)

What DAX should be used?
Should it be done in a seperate table? Or can it be done in a new column to table 'stock'.

My VB.NET app is importing a XML file generated by a 3rd-party website into a SQL Server table. The website (and my computer) use the period character for decimals (e.g. 42.015) and everything works great. But a European user reported that numbers imported were being multiplied by a factor of 1000 or 10000. It turns out that his computer is looking for a comma decimal (e.g. 42,015) and when it sees the XML input it converts it to 42015.00.

I'm using DataSet.ReadXML and SqlBulkCopy.WriteToServer and I'm not sure where I can step in to tell the program to expect period decimals. My code is below:

I am making a HTML table to display boxes (in a stockroom) that have been added, removed and changed. The headings are denoting the owner of the box, the type of change that has occurred and the new content of the box.

Im using Django for my backend.

Can I translate the values in the 'Type of Change' into English words rather than the symbols (~, - and +)? I am using Django simple-history to record changes to my models and it returns these symbols. I would like my table to read 'Changed', 'Removed' and 'Added' in place of '~', '-' and '+' respectfully.

This is the view.py:

I am trying to navigate from one view to another in UI5 application but I am not able to do so. I recently created a copy of an existing view A and renamed it to B. Then I copied the controller of A and renamed it as controller of B. I now want to navigate from A to B view. I have declared the view B in routes just like A (renamed wherever necessary) but I am still not able to navigate. When I click on button in view A, I want to display B. But nothing happens. Console shows no error either. What can be the issue?

In Controller of A:

We currently have a small number of Acumatica locations set up which are largely functional rather than physical. (Inbound Testing, Stockroom, RMA Review, etc).

We use these to set default issue/receipt locations and other such things.

We are also interested in tracking physical locations for our serialized parts. (We would use a rack/tray/position system, with each rack holding multiple trays and position on a tray being specific to a single serial number.)

Does Acumatica have any built-in functionality to support this kind of thing, or to get us further along the path? We don't want to end up with 40,000 individual locations. If we need to add customizations, are there suggestions for how and where to do this?

I am developing an application using PyQt4 and Qt4Designer, I have designed from designer and generated python code. As you can see in the below image, when I am adding first row, it's occupying whole layout space, but later rows are of fixed width.

Image showing the actual problem

Here's my code...

main.py