Our company typically has 1,000 projects open at any time. We also have over 1,000 stock items at our warehouses. Any of these stock items can be used on a project. How do we issue a stock item to a project where the inventory at the warehouse is relieved and the item quantity and cost are captured on the project? This seems like a very basic scenario that is difficult in Acumatica. Thanks for your comments.
HI
Have you looked at the Help at Project Inventory? There are a few different ways to track project inventory.
https://help-2022r1.acumatica.com/Help?ScreenId=ShowWiki&pageid=c88fde12-24c2-4b9b-af43-25854318d4f9
If you want to reserve the stocks for project, you can create a custom SO order type to be used as bill of materials for project. The goal here is to be able to list stock items to be later used for a particular project, allocate them in warehouse, and issue partially from there as project need. Configure the order type so that it doesn’t require AR invoice to be created, just to issue stocks.
Thank y’all for the replies. We are mid way through implementation and have figured out the issue.
I have similar issue with my clients here. The problem is that if you select track by project, then it’s project specific inventory, so we are trying to use standard option track by location, but then you have to create a location in the warehouse for every new project and actually transfer stock between locations. These stock items can be used on a project or not, so they shouldn’t be associated with a specific project or location. And we have thousands of projects open at the same time. Any suggestions?
I have similar issue with my clients here. The problem is that if you select track by project, then it’s project specific inventory, so we are trying to use standard option track by location, but then you have to create a location in the warehouse for every new project and actually transfer stock between locations. These stock items can be used on a project or not, so they shouldn’t be associated with a specific project or location. And we have thousands of projects open at the same time. Any suggestions?
I have similar issue with my clients here. The problem is that if you select track by project, then it’s project specific inventory, so we are trying to use standard option track by location, but then you have to create a location in the warehouse for every new project and actually transfer stock between locations. These stock items can be used on a project or not, so they shouldn’t be associated with a specific project or location. And we have thousands of projects open at the same time. Any suggestions?
Agree … not yet, I was hoping to get an answer from Acumatica :) But I’ll post an update here if I have any
If you want to reserve the stocks for project, you can create a custom SO order type to be used as bill of materials for project. The goal here is to be able to list stock items to be later used for a particular project, allocate them in warehouse, and issue partially from there as project need. Configure the order type so that it doesn’t require AR invoice to be created, just to issue stocks.
Can you please clarify this easiest way? I don’t think you can type your project ID unless you have purchased inventory specifically for this project (if Track by Project selection is used). And if you use Track by Location (default) option, then you have to create a location in the warehouse for each project … and if you have thousands of projects this becomes an issue.
I understand we can change the cost layer, but this will also change the qty on hand. So, it seems like the items have to be purchased for the project specifically. Not sure if I’m missing something else.
It shows quantity on hand with Normal cost layer selected:

But if I change the cost layer to Project, the system changes the quantity to 0

And displays this error:

Not sure what I’m missing here. Any help appreciated.
Thanks,
Felix
In 2025R1 release we have updated the behavior of project-specific inventory and added an ability to issue materials not allocated to any projects to the project without transferring them to the project-specific layer first. You can find more information in the release notes https://acumatica-builds.s3.amazonaws.com/builds/preview/25.1/ReleaseNotes/AcumaticaERP_2025R1_Beta_ReleaseNotes.pdf (Projects and Construction: Usage of Free Stock for Projects with Project-Specific Inventory section)
Thank you!
Best regards,
Daria Chuprova
Senior Business Analyst in Acumatica Projects&Construction
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.