Skip to main content

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

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.


Hi John,

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

 


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

 


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