Question

Customer Invoice CUSTOMER_ORDER_IVC_REP

  • 30 March 2021
  • 4 replies
  • 194 views
R
Rank
Userlevel 7
Badge +18

Where can I see where the field DEL_TERMS_LOCATION is coming from.

The user has asked whether this is coming from the Customer Order or the Shipment?

 

Where can I see the report code that makes up the data for CUSTOMER_ORDER_IVC_REP ?

Thank you.

 

John

This topic has been closed for comments

4 replies

R
Rank
Userlevel 7
Badge +18

My gut feeling is that it would be the Shipment record, but, this would have been updated originally from the Customer Order on creation of the Shipment record.

Mohamed Infaz
Rank
Userlevel 5
Badge +10

Hi John,

Initially, when inserting or printing an Invoice, the delivery terms value is picked up from the Customer Order table.

 

Cheers, Infaz.
Chamika Dilhani
Rank
Userlevel 6
Badge +7

Hi John,

 

You can see the report code that makes up the data for CUSTOMER_ORDER_IVC_REP from the database level by viewing the Spec and Body for the package ‘CUSTOMER_ORDER_IVC_RPI’. Check PROCEDURE Report_Invoice .

 

/Regards,

Chamika

 

~Cheers - Chamika
Janandi Vishaka
Rank
Userlevel 5
Badge +8

Hi John,

 

For the invoice header it gets the value from Customer order.

For invoice lines it checks if the customer order header and line have the same DEL_TERMS_LOCATION  or not. If not the same following LINE_DEL_TERMS_LOCATION' will be added to the xml with customer order line DEL_TERMS_LOCATION  value

            Xml_Record_Writer_SYS.Add_Element(xml_, 'LINE_DEL_TERMS_LOCATION', ord_row_rec_.temp_del_terms_location);

Regards,

Vishaka

        

Terms & ConditionsCookie settings