Odd question for the Adagio team. My controller and office manager are trying to track deductions on items we sell, they are asking if it is possible to set a detail item unit price less than 0 to signify a deduction on that item. Currently it requires an option between 0 and 999,999,999
~
I'm aware that there are other ways to document such as misc charge and other detail types, but was curious if this specific way was possible?
Thank you,
Jason

Hi Jason

No, the unit price must be $0 or greater.

But the quantity can be negative, if your data is set to allow credits on invoices (a Company Profile option). Of course this will be an issue with quantity on hand unless the item is a non-stock item.

Steve

Thanks for the reply Steve,

My controller is needing help with tracking deductions at the item level and is asking me this question:

"How he would recommend tracking discounts taken off of invoices at the item level.
In other words: If a customer receives a discount on a specific order for a specific item on that order, how would he suggest tracking it through adagio."

Let me know if you guys have an idea for me
Thank you

Hi Jason,

Do you use Adagio SalesAnalysis? It maintains sales data at the detail level for specialized reporting, including both item Base and Selling prices, making it easy to calculate the Discount difference in a custom report either from Adagio GridView or Crystal Reports, or even an Online Inquiry within SalesAnalysis that can be exported to Excel.

Customized reports could also be directed to OrderEntry or Invoices Historical Details.

What type of discounts are you entering for invoices? Is it a document discount that can be entered on the Total tab or an OrderEntry invoice? Or is it an item discount due to the quantity of items ordered or a customer level discount? Or both? Knowing the type of discounts would assist in knowing how the data would be stored in Adagio, and where to report on the desired discounts.

I'm sure your Adagio consultant would be happy to assist you in this investigation, if needed.