SmartStock
The module must be able to:
- keep track of sales, payments, returns, and shipments,
- work with multiple warehouses (receiving, transferring, inventory),
- account for currencies (with switching in the interface),
- support roles and access levels (RBAC),
- reserve goods until payment (with a time deadline),
- generate invoices and documents (order, return, transfer, etc.),
- maintain balances for clients and employees.
My deadlines are quite tight — I would like it to be completed in about 1–1.5 months.
Here is the detailed technical assignment:
Technical Assignment: Sales and Warehouse Accounting Module
1. Module Goals
• Accounting for sales, payments, shipments, and returns.
• Sales statistics: daily / weekly / monthly.
• Balances for clients/contractors and for employees (received/returned).
• Multi-warehouse accounting, receiving/transferring/inventory.
• Multi-currency calculations with a currency switcher in the interface.
• Generation of invoices, reserving goods until payment with a deadline.
• Support for returns and exchanges of goods.
• RBAC: multi-level access by blocks.
• Generation of a unique link for the client, where they can create an order themselves (goes to the picker).
⸻
2. Key Objects / Directories
• Client / Contractor: card, contacts, default currency, unique link for personal order.
• Employee: role, access (by blocks), balance (received/returned).
• Warehouses: name, address, status (active/archive).
• Product item (SKU):
• No weight/volume/barcode (as requested).
• Ability to add multiple modifications in one item (variations).
• Attributes: article, purchase price (for FIFO), retail price(s) by currencies, packaging units.
• Packaging units: pcs, blocks, boxes (fixed — only these three).
• Currencies: base currency of the system + others; selection via a dropdown list in the interface; support for manual input of exchange rates and connecting sources of rates.
• Cash registers/wallets: employee cash register, company cash register, current account, etc.
• Documents: Invoice (order/shipment), Payment (income/expenditure), Transfer, Inventory, Return, Replacement Act, Cancellation/Deletion Act.
⸻
3. Processes and Business Logic
3.1 Invoice / Order
• Fields: client, shipping warehouse, date, document currency, items (modification, quantity, price), unit (pcs/block/box), delivery cost, payment method, comment, responsible employee, reserve deadline.
• Statuses: Draft → Confirmed → Awaiting Shipment → Shipped → Delivered → Closed (paid).
• Separate statuses: Canceled / Return / Exchange / Deleted.
• Reservation:
• When the status is Confirmed — a reserve is created in the warehouse (the reserve holds the quantity).
• The reserve is valid until payment. The default reserve deadline is 14 calendar days from the confirmation date. (configurable)
• If full payment is not received within 14 days — the reserve is automatically released, the goods return to free stock, and the invoice is moved to the status "Canceled (refunded/reserve released)" or marked for manual resolution.
• Partial payment does not release the reserve (the reserve is released only after full payment), but the interface shows "paid / amount to be paid". (we can change this rule if needed)
• When the status is Shipped — the invoice records the shipment (courier/transport company, tracking number).
3.2 Write-off/Reserve/Transfer
• The reserve reduces the available balance but does not physically write off until the status is "Shipped".
• When "Shipped" — write-off from the warehouse (FIFO is used for cost calculation and write-off of purchase batches).
• In case of return — a return document is created, the quantity is returned to the warehouse, and a receipt record is formed in FIFO indicating the return price / adjustment.
3.3 Transfers and Inventory
• Transfers between warehouses by document (a transfer request is created → confirmation upon receipt at the target warehouse).
• Inventory: ability to create an act, reconcile with accounting, adjust quantities (adjustments are recorded as separate entries).
3.4 Payments / Cash Registers
• Payments are linked to the invoice (full/partial) or as an advance.
• Supported methods: cash, bank transfer, card (integrations of payment solutions are noted in the technical assignment, but you requested to exclude payment solutions from integrations — ultimately, payment integrations are NOT connected).
• Each cash register has a journal of income/expenditure; employees may have "cash on hand".
• Employee balance: accounting for how much has been received from the contractor and how much has been returned to the corporate cash register/bank; ability to link returns to the cash register.
3.5 Returns and Exchanges
• Return of goods: documented by a return document (arrival at the warehouse); upon return, the client's debt/balance is automatically adjusted.
-
Good afternoon, I am interested in your project. I would be happy to collaborate, please write to me in private messages on FreelanceHunt for communication.
-
Hello, I worked on the Warehouse Accounting Project, where I performed similar tasks with multi-currency and RBAC, processing over two thousand SKUs and three warehouses.
What is the limitation on simultaneous work with multiple users in your system?
I suggest we get in touch, I will provide you with free technical consultation and we will create a development plan + I will tell you about my team!
-
4429 80 1 4 Trust a professional with over 10 years of experience! The rate and deadlines are current! I look forward to collaboration! Experience in commercial development of online stores on CMS, business portals, and corporate websites - 11 years! +CMS: WordPress(+Woocommerce) PrestaShop/Opencart/Joomla/Bitrix/MODX/DLE/Shopify php/html/css/js/Mysql, PhotoShop/Figma Examples of work (from scratch, turnkey): https://wildandorganic.com/ https://cryptosignals.org/ https://ecnbot.com https://locs-ua.com/ https://www.grower.com.ua/ https://www.alternativemedicine.com.ua/ https://silkkiss.ua/ https://nordtrade.online/ https://v12coffee.com.ua/franchise/ https://smrtalgo.com/ https://sengero.no/ https://beautybysim.no/ https://sonatagalleri.com/ https://www.solmy-realestate.com/ https://www.emmanuel.com.ua/ https://www.onsitecomputersinc.com/ https://express-tehbud.com/ https://korostenporcelain.com.ua/ https://sladok.com.ua/ https://pricemds.com/ https://picupmedia.com/ https://www.serasar.com/
-
436 4 0 I already have a similar system or prototype
Covering almost everything you described (Maybe not with the same terms - But the essence is the same) + integration with trading equipment and data collection terminals/own PRRO
This is a desktop framework
In which there are a lot of industry solutions
For inventory, extremely high-quality inventory write-off (Much better than FIFO because it has its own "downsides") and cost calculation (it can't be done better, it can only be repeated)
Own report generator forms, etc.
Looks something like this
https://youtu.be/J_t1jnIqJlw
… Various industry solutions
https://youtu.be/0G-JnQemHEE
https://youtu.be/y22u8v_wbqU
-
94026 1265 1 10 Hello. I have extensive experience with React/Node.js. I am ready for collaboration.
-
1498 9 0 Hello!
I have a ready-made box solution for your tasks, the price will be minimal, implementation may take a few days!
Write to me, I will be happy to discuss the details.
-
24 7 1 Good afternoon.
I have experience and a desire to work.
I will complete it within the agreed timeframe after clarifying the details.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORPAbout the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 2 days 10 hours back ∙ 4 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 2 days 13 hours back ∙ 18 proposals |
1C data integrationOrganize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 4 days 4 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 5 days 9 hours back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 5 days 13 hours back ∙ 13 proposals |