Make changes to the accounting program for the medical staff of the Armed Forces of Ukraine in C# VS 2019, MS SQL

C & C++, C# — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

Hello. I need a programmer who will check and fix the following:
the accounting program incorrectly calculates the remaining stock after incoming entries (several incoming entries) and expenses through the expense invoice.
The previous developer is in touch but busy with another project.
Also, changes will be needed in the printed forms of invoices (there will be a separate task)

The project was written without a clear technical specification, and the regulatory framework has changed a couple of times. Changes were made.

Update #1 from 9 December 2024

Feedback from the previous freelancer who looked at the code

Found the error why it shows the incorrect quantity in stock

SELECT SKLADPRIHRASH.id_tovar,
SKLADPRIHRASH.kolvo

FROM dbo.SKLADDOC
JOIN dbo.SKLADPRIHRASH ON SKLADDOC.iddoc_guid = SKLADPRIHRASH.iddoc_guid
JOIN dbo.SKLADPRIHRASH AS rash ON rash.idnakladrow_guid = SKLADPRIHRASH.idpr_guid

WHERE SKLADDOC.typedoc = 1
and SKLADPRIHRASH.idway = 44

this is part of the code from the procedure that shows the balances (44 - here I have a specific warehouse)

SKLADPRIHRASH.kolvo - will be "duplicated" as many times as there are withdrawals for this product

I added 111 of one product and added 4 positions for write-off - and it showed me 444 arrivals. dug into the code - found a bug
14 minutes ago
new
in general, at least the query for selection needs to be rewritten

Proposals 3 Withdrawn 2 Discussions 3

Please select

Oleksandr N.

4 1

Projects 4
Rating -
Rating 660

Budget: 4000 UAH Deadline: 7 days

Good day, I can try to help with your request.

Alexandr S.

51 2

Budget: 1000 UAH Deadline: 1 day

Good day.
My name is Oleksandr. I am a .net developer with 3 years of commercial experience. I specialize in backend development. I have often worked with databases. I will complete your task quickly and efficiently, write to me.