For teams that run on Merit Aktiva
Merit Aktiva stock count from a spreadsheet
Merit Aktiva has no separate stock count report. Its help pages explain that differences after a count are worked out by hand and entered as stock in or stock out per warehouse, and that opening stock cannot be imported and is typed in.
How it goes today
- Print the stock report for the count date.
- Put the counted numbers next to it in a sheet.
- Work out per item whether there is more or less than in Merit.
- Enter a stock in and a stock out per warehouse, line by line.
- Change the account on each line to the one you use for counts.
How it can go
Send your stock count as a sheet and approve the differences.
You send the count as a spreadsheet, per warehouse. You first see the differences against the stock in Merit Aktiva on the count date, with their value. After your approval, one stock in and one stock out are entered per warehouse with the account you use for counts, and the count file noted on them. For a surplus you choose the last purchase price or the current cost. Opening stock for a new start goes in the same way from a sheet.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Merit Aktiva key in the portal, never in the chat.
With Hypamoon, when I send a stock count for a Merit Aktiva warehouse as a spreadsheet, match it on item code and show me the differences with the stock in Merit on the count date, with their value. After I approve, enter one stock in for the surplus at the last purchase price and one stock out for the shortage, on the account I give you, and email me a summary.
In Merit Aktiva, under Settings, Company details, API settings, the main user creates an API ID and API key for each program that connects. This works on Merit Aktiva Pro or Premium. It stays yours.