Copying Requirement Routine in Consolidated Billing

[Former Member]

Hi Experts,

I have a situation where i need to implement following 4 senarios.

scenario 1: One Customer u2013 One Sales Order u2013 One Delivery  One Billing Document.

scenario 2: One Customer u2013 Multiple Sales Orders u2013 Multiple Deliveries - One Shipment  One Billing Document u2013 Per Container.

scenario 3: One Customer u2013 Multiple Sales Orders u2013 Multiple Deliveries - One Shipment  Multiple Billing Documents u2013 One for each Delivery

scenario 4: One Customer u2013 Multiple Sales Orders u2013 Multiple Deliveries - Multiple Shipments  One Billing Document u2013 for all the Shipments.

Note 1: Intl Billing Docs (order type ZIOR) will NOT be included in automatic billing due list.

Note 2: Customer Specific Consolidation Rules need to be listed by Customer via attribute 4.

Note 3: Credits and or Debits are not to be consolidated u2013 This will be following the standard Copy-Control settings in the configuration.

Note 4: Order Related Billing is not required to be consolidated provided it is not part of charge related to a delivered item u2013 This will be following the standard Copy-Control settings in the configuration. Example u2013 trim allowance or direct ship allowance related to delivered item should be included on same consolidated billing document; however, subsequent charges for freight or amounts not known at time of delivery can be invoiced separately.

and the consolidation that need to be done with customer Master attribute - 4 field for the values as follows:

and I need to set the type of consolidation that needs to be done with Customer Master Attribute u2013 4 field for the values as listed below:

a) 4a u2013 Individual: If this option is present on the Customer Master then by-pass all the consolidation rules and allow the system to create one billing document per each delivery document of the same sales order. If there are multiple sales order lines on same order and delivery they should be invoiced together.

b) 4b u2013 Shipment/BOL# : If this option is present on the Customer Master then select the u2018Shipping Document #u2019 and consolidate all the u2018Delivery Documentsu2019 onto the single Billing Document. This is our standard IOF setup since all typically need to be created by container.

c) 4c u2013 Consolidated: If this option is present on the Customer Master then select the u2018All the Deliveries Document #su2019 for that Customer that are due for billing and create a Single Billing Document based on grouping rules u2013 both custom and standard (terms, currency, etc).

For the above requirement as per client requirement need to implement Requirement Routine.

Please advise to solve this issue.

Thanks & Regards,

Prasad

[Former Member]

Moderator message - Please do not post your requirements and expect the forum to do your work for you. thread locked Rob