Skip to main content
Solved

Printing weight of the inventory part (available in Customer Order) on the Customer Invoice

  • December 23, 2021
  • 3 replies
  • 182 views

Forum|alt.badge.img+2

Hi All,

 

There is a requirement from a customer (European customer) to have the weight of the part (which is on the Customer Order) printed on the Customer Invoice for each specific part. Is this something possible through a configuration change? Thank you.

 

Best Regards

Akila 

Best answer by Thomas Peterson

Hi, 

I did a quick check on the REP (the view that contains the data available for customer invoice print) ang the attributes are not in that view.  Quick SQL -  select * from IFSAPP.customer_order_ivc_rep. 

I don’t see adjusted weights Gross or net) attributes and I don’t see the value from the customer order lines in the results.  I don’t see any columns like weight. 

A small mod as described by SAKUIN would be required.  

 

The 100 from my customer order line (that was from the inventory part) is not in the result (customer_order_ivc_rep)

It appears you need a small mod / report enhancement. 

 

 

Best regards, 

Thomas

This topic has been closed for replies.

3 replies

SAKUIN
Do Gooder (Customer)
Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 4 replies
  • January 26, 2022

A Mod in Report should do this if not available on IFS standard report


Forum|alt.badge.img+19
  • Superhero (Employee)
  • 1111 replies
  • Answer
  • January 26, 2022

Hi, 

I did a quick check on the REP (the view that contains the data available for customer invoice print) ang the attributes are not in that view.  Quick SQL -  select * from IFSAPP.customer_order_ivc_rep. 

I don’t see adjusted weights Gross or net) attributes and I don’t see the value from the customer order lines in the results.  I don’t see any columns like weight. 

A small mod as described by SAKUIN would be required.  

 

The 100 from my customer order line (that was from the inventory part) is not in the result (customer_order_ivc_rep)

It appears you need a small mod / report enhancement. 

 

 

Best regards, 

Thomas


Forum|alt.badge.img+2
  • Author
  • Do Gooder
  • 1 reply
  • February 12, 2022

Thank you both @SAKUIN and @Thomas Peterson for your replies. Really appreciate it.