if some items does not have the cost that mean it the cost was not entered in during receipt.You can fix it by going to Inventory adjustment and enter the cost only to that stock.
Its up to you if you want to show separate inventory numbers or just lump them into 1.that should be it but you should test it out on a test system first.
What is your valuation for your products?
You need to setup Charts of Accounts and add the Sales 40000 and Purchase 57300 with the product category. 400001 - Widget1 Sales400002 - Widget2 Sales573001 - Widget1 Purchase573002 - Widget2 Purchase Then setup the Item Classes Widget1 and Widget2.Next assign stock to the item classes.
You have to setup GL accounts for each product in Sales and Purchase. Then you have to setup each Item Class for those products and link the GL accounts to it.
Its the database that is slowing everything down.Get 2 more SSD drive and separate the data MDF and log LDF files on there own drives and it will speed up tremendously. SSD are inexpensive like $50 for 250 GB.1 - SSD OS1 - SSD Database files.1 - SSD Log files
You can manually enter the last cost but the rest are system calculated.
Thanks @TimRodman and @ccleary !!
@ccleary , the report is in the server but I get this error message.
@ccleary , yes I can remove the site map, but I want to delete it completely off the server or database.
We are self hosted, maybe we can use WebAuthn to secure the website and after the user authenticate via a Yubikey then the user can login via their username and paswword.
We are running Windows Server 2019 with Hyper-V on 1 DL360-G9 serverHyper-V - 6 400gb SSD SAS Raid-6 / OBR6VM1 - IIS / Acumatica - 48gb / 12 Virtual CoresVM2 - IIS / Acumatica Self Service Portal - 32gb / 8 Virtual CoresVM3- SQL Server 2019 64gb / 16 Virtual CoresPretty snappy and works great.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.