Solved

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

  • 7 November 2021
  • 1 reply
  • 135 views

Userlevel 3
Badge

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

 

 

 

icon

Best answer by meganfriesen37 1 August 2023, 22:31

View original

1 reply

Userlevel 7
Badge +10

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


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved