Skip to main content
Solved

Inventory Item Cost is not appearing in Balance tab in the Project Form

  • November 7, 2021
  • 1 reply
  • 178 views

NAthukorala47
Jr Varsity III
Forum|alt.badge.img

Hi, 

We have a requirement to Track manufacturing work order material issue cost via project Module. 

Followings are the steps we performed. 

 

1). Create a Project and added Labor and Material Cost budget tasks which attached with Material        and Labor accounts groups.

2). Then create a Item Work order via particular project/Task and release it. 

3). When issuing Items Project/Task tied with work order and will issue appropriate Project Task. 

System will create a Inventory and Project transactions. but those values are not showing in Balance Tab. Under the view transaction tab all are showing. 

4). Labor is not capturing from Manufacturing end and using Time card. When performed the time card  or particular user those values are transferring as we expected and showing under the balance tab in  the project Form.      

05). Need to know how Work Order Inventory Items are issuing to Projects and what are the workflow steps happening are there?

Attached the Screenshots document. 

 

Regards

 

 

 

Best answer by meganfriesen37

Hi There,

I would separate Inventory into it’s own “Asset” type account group (or if you don’t need the inventory on the project, you can remove the account group from it).  Your transactions are netting to $0 in the same account group, so there is nothing to show on the project balance tab.

If you are using project specific inventory, the work flow generally is

  • Inventory is added to the system against the Project and Task (either from a Purchase Receipt, Inventory Transfer, etc).
  • Then the inventory is issued (expense) to the project through an Inventory issue or a Sales Order Shipment that references the projects.
View original
Did this topic help you find an answer to your question?

1 reply

meganfriesen37
Captain II
Forum|alt.badge.img+12

Hi There,

I would separate Inventory into it’s own “Asset” type account group (or if you don’t need the inventory on the project, you can remove the account group from it).  Your transactions are netting to $0 in the same account group, so there is nothing to show on the project balance tab.

If you are using project specific inventory, the work flow generally is

  • Inventory is added to the system against the Project and Task (either from a Purchase Receipt, Inventory Transfer, etc).
  • Then the inventory is issued (expense) to the project through an Inventory issue or a Sales Order Shipment that references the projects.

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings