Question

Negative quantity in a subcontract line item

  • 19 September 2023
  • 3 replies
  • 47 views

Userlevel 1

Hello,

I am trying to put a negative quantity in a subcontract line item, but it errors out.

Anyone have a work around for this that doesn’t require a debit adjustments.  I am trying to keep all the details on one invoice. We create the invoice for subcontractors and tie them off to each pay applications.  If we create multiple invoices it creates confusion. 

I found I can put a negative dollar value which makes the $ side work, but i don’t think it will work on the total qty side.

 

Thanks,
Jeremy

 

 


3 replies

Userlevel 6
Badge +2

@jdresel  Thanks for your question.  Can you tell me the business need for having negative quantity on a subcontract?  What is the workflow and example of needing negative quantity that is not an adjustment.

Userlevel 1

Hello Hedi,

Since we create the invoice from the owner payments for subcontracts we want to show all the changes from the payment/owner qty at once.  We run a report that shows the qty’s paid.  if the owner deducts qtys we need to show the negative quantities.  It is common for the owner to pay then deduct.  Or deduct one line item to pay a different line item.  It happens on 95% of our projects.

 

We generally worry more about qtys then dollars.  If the qty’s work out, the dollars work out.  So if we show positive numbers with negative dollars it will create the potential for errors, and cause confusion  If we export data with positive numbers it wont tie off.  I am sure we can write a report to handle this, but entering positive numbers for a deduction is out of standard practice for us. 

 

We also found out, how do you create a back charge to a subcontractor.  We would typically do this with a negative quantity change order, but you cant put negative qty’s in a subcontracts.  Just negative dollars.

 

Thanks,

Jeremy

 

Userlevel 6
Badge +2

@jdresel  If you use debit adjustments it does work for negative quantity

 

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 — 2023  Acumatica, Inc. All rights reserved