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.
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
new
in general, at least the query for selection needs to be rewritten
Відгук від попереднього фрілансера, хто дивися код
Знайшов помилку чому показує не вірно кількість на складі
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
це частина коду з процедури, яка показує залишки (44 - тут в мене конкретний склад)
SKLADPRIHRASH.kolvo - буде стільки раз "дублюватись" - скільки є розходів по даному товару
я додав 111 один товару і додав 4 позиції списання - і в мене відобразило 444 приходу. копнув код - знайшов баг
new
загалом як мінімум потрібно переписати запит на вибірку
-
7 days89 USD
684 4 1 7 days89 USD
Good day, I can try to help with your request.
-
1 day22 USD
3555 51 2 1 day22 USD
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.
-
3 days22 USD
2071 226 0 1 3 days22 USD
Hello! I will help you fix the error, please provide the source code for analysis. Describe how exactly the error manifests! Thank you!
-
Ошибка в модели или алгоритме?
-
Aleksey V. No company
видає невірний залишок порівняно з калькулятором.
Я так розумію що алгоритм -
Я не тільки дивився, я вже й виправив))
-
Current freelance projects in the category C & C++
Comparative analysis of the effectiveness of custom software (v2.2-field) and reference software (Meshtastic v2.x)
22 USD
Comparative analysis of the effectiveness of custom software (v2.2-field) and reference software (Meshtastic v2.x) on the identical hardware platform (ESP32 + SX1268, 2W) based on the criteria of range, throughput, link stability, and power consumption. Conduct tests with… C & C++, C# ∙ 1 day 3 hours back ∙ 2 proposals |
Consultation and audit of the current project on Odoo 19 Community Edition
We are looking for an Odoo Developer — a solo developer with experience in Odoo 19 Community Edition, including using Claude Code. We need a specialist who has successfully implemented projects in Odoo and practical experience in development using Claude Code. Important: we only… C & C++, Javascript and Typescript ∙ 4 days 5 hours back ∙ 7 proposals |
Software development for Arduino (RF modules 3–7.5 GHz, automatic frequency scanning)It is necessary to develop a system on Arduino for the automatic search of active analog video signals and the automatic tuning of the transmitter to the detected frequency.It is planned to use three separate transceiver modules: 3000–4200 MHz; 4900–6000 MHz; 6100–7500… C & C++, Embedded Systems & Microcontrollers ∙ 5 days 5 hours back ∙ 4 proposals |
Black Ukraine (RP-project on base MTA)
1154 USD
|
Residential Proxy Infrastructure EngineerWe're building a residential proxy network from scratch — fully owned, no third-party suppliers. We need one exceptional network engineer to build the entire technical foundation. What you'll build: - Android background SDK that routes proxy traffic through user devices… C & C++, DevOps ∙ 11 days 1 hour back ∙ 15 proposals |
Zaporizhzhia