id="afr::PushIframe" style="DISPLAY: none" src="https://support.oracle.com/epmos/afr/blank.html" name="afr::PushIframe"> How Does The Invoice Date Get Derived From The Sales Order Line? (文档 ID 300311.1)转到底部 Applies to: Oracle Order Management - Version: 11.5.4 to 11.5.10.3 - Release: 11.5 to 11.5 Information in this document applies to any platform. Goal How Does The Invoice Date Get Derived From The Sales Order Line? For instance, how can we get the invoice date to be the date the line(s) was shipped? User created Bill on order with different ship to date. 3 lines had holds until the ship to date. AR user released these hold but invoice shows the date on which the bill only order was created. Solution Oracle Receivables derives the invoice date from either the ship date actual or the sales order date. For shippable lines, Order Management derives the ship date actual as follows: SELECT dl.initial_pickup_date FROM wsh_new_deliveries dl WHERE dl.delivery_id = <delivery id of the line>; If this is null then the sales order date will be used as invoice date. Please set the intial pickup date correctly for shippable lines because that is what will be the invoice date. For non-shippable lines, since there is no shipping date, 1. you can choose to have the ship date actual as NULL (which allows AR to derive the invoice date as order date) OR 2. you can choose to have the ship date actual as sysdate (the date when invoice interface iscompleted) by setting the profile option OM:Set Receivables Transaction Date as Current Date for non shippable lines.This profile option is available as part of Patch 2008789 which is available on MetaLink and included in OM patchset H. Reference Note: 227816.1 for more details on this patch. References NOTE:227816.1 - Invoice Date Using Order Date not Shipment Date 确定取消