Skip to main content
Answer

Project Billing creates invoices w/inventory but does not create an IN issue transaction to reduce stock

  • January 2, 2025
  • 2 replies
  • 138 views

Forum|alt.badge.img

Good day,

The project billing does not include an inventory transaction when the project is billing for inventory used on the Project; we are currently on 2023R2.  I am not sure if this is setup issue and search Acumatica help does not give any hints on the issue.  Our projects are services provided to the client.  However, we do sell an inventory item used on the project.   We don’t bill for time; just the service so the billing type is Progress Billing.  The current process is manual; the Accountant will create IN issue when inventory is used on the project; this will reduce the inventory and create the COGS transaction associated with the project. (Payroll associated with project is also a GL transaction associated to the Project/Task.

With the above background, now management wants to project invoices to include the inventory transaction.  (The same as the Sales/Shipment/Invoice process does.)  I am trying to figure the changes needed to configure Projects.  Maybe use Project Specific Inventory (Currently not enabled).  ACM Help does not help on the Billing Part.  This seems only to only allocate the inventory but producing the inventory transaction on the invoice.   

Any suggestions?  Do I need to change to Time and Material Billing Rule?  What am I missing?  We need to get away from the manual inventory transaction.  Throws off inventory amounts and availability. 

 

Thank you in advance for you suggestions and assistance.

Evan 

 

Best answer by iqraharrison

@grillevan hi there! it sounds like there may be more than one question in here so I will try to answer the best i can :)

  1. there isn’t an automatic issue that acumatica has for stock items even if you go with project specific inventory.  however, since these items that you are selling are service items, can i ask why they aren’t set up as non-stock items? those can be set up to issue once the AP bill has been released which would get you away from the manually process.
  1. in order for the transactions to show up on the invoices to be printed, you would need to change the billing method to time and material, this will allow the transactions to pull into the project billing tab and you can select which lines you need.  this would work if you trying to show the client the transaction or would you just like to see the transaction on the project side.  

hope this helps!

2 replies

iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • Answer
  • January 6, 2025

@grillevan hi there! it sounds like there may be more than one question in here so I will try to answer the best i can :)

  1. there isn’t an automatic issue that acumatica has for stock items even if you go with project specific inventory.  however, since these items that you are selling are service items, can i ask why they aren’t set up as non-stock items? those can be set up to issue once the AP bill has been released which would get you away from the manually process.
  1. in order for the transactions to show up on the invoices to be printed, you would need to change the billing method to time and material, this will allow the transactions to pull into the project billing tab and you can select which lines you need.  this would work if you trying to show the client the transaction or would you just like to see the transaction on the project side.  

hope this helps!


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • January 7, 2025

@iqraharrison 

Thank you.  You confirmed what I thought.