Hello community,
I would like to know how can a user allocate a specific inventory for a specific project. i am looking if Acumatica can allow us to allocate qty for future purposes for a particular project.
Thanks in advance.
Hello community,
I would like to know how can a user allocate a specific inventory for a specific project. i am looking if Acumatica can allow us to allocate qty for future purposes for a particular project.
Thanks in advance.
HI
Here is the information from the help:
If you have enabled the Inventory and Order Management and Inventory features on the Enable/Disable Features (CS100000) form and are using the related functionality, you can use the enhanced integration of projects with inventory by enabling the Project-Specific Inventory feature.
Once you have enabled the feature, you configure the applicable projects to use the needed inventory tracking mode. For each project, you select one of the following modes in the Inventory Tracking box on the Summary tab of the Projects (PM301000) form:
In an existing project, you can change the inventory tracking mode only if no items have been received for the project yet.
If you need to disable the Project-Specific Inventory feature in a production system, you can do this after the following preparatory actions:
Once the feature is disabled, the system will continue tracking inventory for projects using the only Track by Location mode.
Inventory Tracking in Projects
For a project in which the Track by Project Quantity or Track by Project Quantity and Cost inventory tracking mode is selected in the Inventory Tracking box of the Projects (PM301000) form, you create and process documents with stock items as follows:
Tracking Item Costs
In a project with the Track by Location or Track by Project Quantity mode selected in the Inventory Tracking box of the Projects (PM301000) form, the cost of the issued materials is not project-specific and is defined by general cost calculation rules. The cost of an item depends on the item valuation method and is affected by other factors: the warehouse location from which the item is issued, the account and subaccount, the selected subitem, and the lot or serial number of the item. For more information on how the system calculates item costs, see Item Costs and Valuation Methods: General Information.
In a project with the Track by Project Quantity and Cost mode selected, the system tracks project-specific cost layers. That is, for each combination of project and project task, the system calculates the cost of each item depending on the item valuation method and other applicable factors: the warehouse location from which the item is issued, the account and subaccount, the selected subitem, and the lot or serial number of the item.
thanks,
Iqra
Hello
What table can I use instead of the above warning one?
I setup a warehouse called PROJECT and I use a business event to add locations for every project/task (segmented key for warehouse location needs to be 30chars) as they add new ones. You can flag this location as not available etc, so that they cannot use it / see it in replenishment, sales orders.
So if they use Track By Location on the project, they simply transfer stock from their normal stock warehouse to the project location / warehouse. Then once it is issued (used) to the project, the cost goes to the project.
Hello
What table can I use instead of the above warning one?
Hello All,
I would like to know what other table shall I use instead of the one for which warning sign is getting displayed? it is INLocationStatusByCostCenter? This table is not supported in 22R2.
Hi Harry
Prior to 2023.1 I was using the PMLocationStatus table, in order to return the quantity on hand at the project location. The below site has been upgraded to 2023.1 hence the warnings below, but this worked fine prior to the upgrade.
Is someone please able to drop the project specific inventory quantity and cost GI’s into this chain, I am unable to access the URL link provided.
Hi I have followed the example as per this discussion.
To issue the materials for the customer, you process an inventory issue for the project on the Issues (IN302000) form.
I first reviewed if we do have material available in the warehouse. QTY on Hand on the Inventory screen ScreenId=IN202500 indicate that I do have material at the warehouse.
On the Issue I select the Issue to the Project Cost layer. I get the error below. So I am not able to Issue the material to the project but I can transfer the material to the Project.
Updating item 'AE-ET340 0' in warehouse 'KLY KLY ' quantity on hand will go negative.
Please advise, did I miss a step?
Retha
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.