(Release 9.2 Update) Understanding the XJDE0003 and XJDE0004 Versions of the Generate Outbound Billing Order Program (R42120)
To review the consolidated billing order for a customer irrespective of the Ship To location, you must run the XJDE0003 version of the Generate Outbound Billing Order program. This version consolidates the records from the Report Consumption table (F42I03) based on the values in the Agreement Number, Supplement Number, Sold To, Ship To including Tax Rate Area, Item Number, and Branch Plant columns, and generates a single sales order for each customer as per Sold To. To review this report in the BIP format, you must run the XJDE0004 version of the Generate Outbound Billing Order program. For versions other than XJDE0003 and XJDE0004 of the Generate Outbound Billing Order program, the system generates a separate billing order number for each combination of Sold To and Ship To.
The system generates the order and the number of lines in the order based on these scenarios:
If all column values are same, the report displays on an order, a single line that contains consolidated quantities from multiple shipping orders and consolidated extended price and cost.
If all column values are same except the lot number, the report displays on an order, a single line that contains consolidated quantities from multiple shipping orders and consolidated extended price and cost. The system considers the lot from the first line.
If all column values are same except the location, the report displays the consolidated details on a single order.
If all column values are same, but the item number changes, the report displays the consolidated details on the same order but different lines for each item number.
If all column values are same, but the branch plant changes, the report displays the consolidated details on the same order but different lines for each branch plant.
If all column values are same, but the agreement number changes, the report displays the consolidated details on the same order but different lines for each agreement number.
If all column values are same, but the supplement number changes, the report displays the consolidated details on the same order but different lines for each supplement number.
If all column values are same, but the Ship To number changes with a different tax rate area, the report displays the consolidated details on the same order but different lines for each combination of Ship To number and Tax Rate/Area.
If all column values are same and the Ship To number changes but has the same tax rate area, the report displays the consolidated details on the same order.
If you have overridden the price for an agreement.
If Ship To is different with the same Tax Rate Area, but a different agreement unit price.
If Ship To is different with different Tax Rate Area.