Skip to main content
Solved

How to add Qty in Sales Profitability by Item Class and Item(Detailed)

  • 21 July 2024
  • 2 replies
  • 30 views

Hi everyone i need one help very important.

 

There is one report which is called as" Sales profitability by Item class and Item(Detailed).

 

In this report customer told me to add one column as Qty.

 

I have added but it not working as a date time period

 

For ex:- From -13/06/2023

             To - 1/07/2024

 

             Qty - 604,69.00

             Net Sales - 674,69.00
             It Should be Same as Net Sales

 

I have tried by adding INItemSiteHistDay using table and added the relation "InventoryID - InventoryID"

 

Plz help me how can i fix this and show proper data in the Qty field.

2 replies

nhatnghetinh
Rank
Userlevel 7
Badge +5

Hi @nasirh85 

You add column “sum([ARTran.Qty])”

 

 

Best Regards,

NNT

Hi Everyone. If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*
Dipak Nilkanth
Rank
Userlevel 6
Badge +4

Hi @nasirh85 ,

As per your example I am not sure , Is the Quantity and NetSales will be same As NetSales is the Amount field.
In the Sales profitability by Item class and Item(Detailed)  report, It is taking all calculated fields from ARTran table, So as per @nhatnghetinh suggested, You can use  “sum([ARTran.Qty])” to pull quantities to display on the report.

Hope, it helps!

Dipak Nilkanth || Acumatica Developer

Reply


Terms & ConditionsCookie settings