Ukrsklad report

Good day, Oleksandr!

I looked at your screenshots. The task is completely clear: essentially, you need a "hybrid" of the standard reports "Product Movement" and "Sales".

We will take only those items where there was movement, pull in the end balance, price, and add a custom date for the last receipt. Plus, we will consolidate all of this across all warehouses simultaneously. Since you have a "Code" column, we will easily solve the issue of unsynchronized warehouses by grouping products by this code to avoid duplicates.

To mitigate your risks: I will write a test draft SQL query for one or two warehouses for free. If we get the correct figures and you are satisfied with the result — we will approve the project.

Will it be convenient for you to export the structure/database file for a quick start?

Show original

Translate

Hello! I will set up a report in Excel (Power Query). I will combine data from warehouses, displaying only sold items with retail price and stock. I will add the date of the last arrival and remove items with no movement.

Please send a sample file in the chat — we will discuss the details and I will start right away.

Show original

Translate

The task is clear — the built-in editor of UkrSklad does not provide the necessary summary report for several warehouses. The best solution: an Excel template with Power Query or a pivot table — you export data from UkrSklad, open the template, click "Refresh" — you get the required report.

Please clarify: in what format do you export data from UkrSklad — Excel, CSV? And is there currently an example of the export to see the structure of the columns? Write — I will do it quickly.

Show original

Translate

Hello. I have extensive experience with React/Node.js. I am ready to implement an admin panel with a report. Please contact me.

Show original

Translate

Good day! I have thoroughly reviewed your technical assignment. I am ready to take on the implementation of this report.

The task is completely clear. It is absolutely normal that you were unable to do this through the standard editor. For example, displaying the "date of the last receipt" simultaneously with filtering by sales requires writing a separate query to the database.

Could you please tell me which accounting system you are working with? After that, I will be able to give you an estimate of the exact time (usually such customization takes from 1 to 3 hours).

Show original

Translate

Good day! I am ready to take on the implementation of this project. I have experience working with inventory reports and understand how to correctly extract data from several unsynchronized warehouses into one table.
Here is how I see the solution to your points:
Filtering: I will set up the report so that items without movement are automatically filtered out — the list will only include actual expenses.
Pricing: We will provide current retail prices.
Date of last arrival: I will add this column for each item — it is important for understanding the freshness of the stock.
Multi-warehouse: I will gather data from all warehouses into one clear report, even if they are not synchronized with each other.
Data cleanliness: We will remove unnecessary columns (such as "quantity of arrival") to focus on the main thing — the balance after sales.

Show original

Translate

Hello. I can do this in Google Sheets using formulas. Also, we will be able to use this template further, you will just need to upload new data :)

Show original

Translate

Good day!

I professionally develop reports in Python and am ready to implement your report on product stock. I take into account all your requirements: displaying only sold products, retail price, date of last receipt, merging data from multiple warehouses, and showing stock after sales. Experience with similar tasks guarantees quality execution.

Write to me in private messages, and we will clarify the details.

Show original

Translate