Example of Allocation of Voucher for Shipment Group

This topic contains examples of allocation of voucher for the shipment group.

For example, there are two order releases, order1 and order2.

Order release 1 (Order1) has two order release lines (orl_11 and orl_12) that are planned for one shipment (Shipment1) with two shipment costs (0011 and 0012) as shown in the below table:

Order	Order Release Lines	Related Shipment	Shipment Cost Detail
			Shipment Cost Seq No	Cost type	Cost	Shipment Cost Reference (Qualifier = ORDER_RELEASE_LINE)
Order1	orl_11	Shipment1	0011	Base	100$	orl_11
	orl_12		0012	Base	100$

 

Order release 2 (Order2) has two order release lines (orl_21 and orl_22) that are planned for one shipment (Shipment2) with two shipment costs (0021 and 0022) as shown in the below table:

Order	Order Release Lines	Related Shipment	Shipment Cost Detail
			Shipment Cost Seq No	Cost type	Cost	Shipment Cost Reference (Qualifier = ORDER_RELEASE_LINE)
Order2	orl_21	Shipment2	0021	Base	200$	orl_21
	orl_22		0022	Base	200$

 

A Shipment group (Shipgroup1) is created With Shipmet1 and Shipment2. Also, a secondary charge shipment (SC_Shipment1) is added for the same Shipment group (Shipgroup1).

Shipment Group – shipgroup1
Shipment IDs:	Shipment1
	Shipment2
Secondary Charge Shipment IDs:	SC_Shipment1

 

The Secondary charge shipment (SC_Shipment1) has one shipment cost (0031) as shown below:

Secondary Charge Shipment ID: SC_ Shipment1
Shipment Cost Detail:
Shipment cost Sequence No	Cost type	Cost
0031	Base	50$

Invoice (Invoice1) is matched with the Shipment group (Shipgroup1) as shown below:

Invoice ID	Invoice1
Amount	710$
Line Item Detail:
Line Item	Cost type	Cost
li_1	Base	100$
li_2	Base	100$
li_3	Base	200$
li_4	Base	200$
li_5	Base	50$
li_6	Base	60$

 

When Invoice1 is approved by line.

• After Invoice1 is approved by line, for each invoice line item, the cost reference records will be created with a qualifier as SHIPMENT_COST and cost reference ID as shipment cost sequence number. Also, the order_release_line cost reference information will be copied from the shipment cost level.

  Invoice	Line Item Detail:
  	Line Item	Cost type	Cost	Line item cost reference
  				Cost Reference (Qualifier = ORDER_RELEASE_LINE)	Cost Reference (Qualifier = SHIPMENT_COST)
  Invoice1	li_1	Base	100$	orl_11	0011
  Invoice1	li_2	Base	100$		0012
  Invoice1	li_3	Base	200$	orl_21	0021
  Invoice1	li_4	Base	200$		0022
  Invoice1	li_5	Base	50$		0031
  Invoice1	li_6	Base	60$

• Voucher: V1.

Voucher ID	V1
Amount	710$
Invoice	Line Item Details:
	Line Item	Cost type	Cost
Invoice1	li_1	Base	100$
Invoice1	li_2	Base	100$
Invoice1	li_3	Base	200$
Invoice1	li_4	Base	200$
Invoice1	li_5	Base	50$
Invoice1	li_6	Base	60$

Allocate the Voucher V1 using Allocation Rule with basis as order line and metric 100% weight.

Note: The assumption is all order release lines have equal weight. 

Allocate the Shipment Group By Line Item

When the Shipment Group Allocation Type is By Line Item and 

•  if order release line information is present then cost will be allocated to that order release line. For example, li_1 and li_3.
• if order release line information is not present then cost will be allocated to order release lines of matched shipment. For example, li_2 and li_4.
• if order release line information is not present then cost will be allocated to order release lines of all the shipments. For example, li_5 (secondary charge).
• if both shipment cost and order release line information is not present then cost will be allocated to order lines of all the shipments. For example, li_6.

Order Release Line	Cost type	Voucher	Line Item	Allocated Cost
orl_11	Base	V1	li_1	100$
orl_11	Base	V1	li_2	50$
orl_12	Base	V1	li_2	50$
orl_21	Base	V1	li_3	200$
orl_21	Base	V1	li_4	100$
orl_22	Base	V1	li_4	100$
orl_11	Base	V1	li_5	12.5$
orl_12	Base	V1	li_5	12.5$
orl_11	Base	V1	li_5	12.5$
orl_12	Base	V1	li_5	12.5$
orl_11	Base	V1	li_6	15$
orl_12	Base	V1	li_6	15$
orl_21	Base	V1	li_6	15$
orl_22	Base	V1	li_6	15$

 

Allocate the Shipment Group By Total

When the Shipment Group Allocation Type is By Total and 

• if order release line information is present then cost will be allocated to that order release line. For example, li_1 and li_3.
• if order release line information is not present then cost will be allocated to order release lines of all the shipments. For example, li_2, li_4, li_5 (secondary charge), and li_6.

Order Release Line	Cost type	Voucher	Line Item	Allocated Cost
orl_11	Base	V1	li_1	100$
orl_11	Base	V1	li_2	25$
orl_12	Base	V1	li_2	25$
orl_21	Base	V1	li_2	25$
orl_22	Base	V1	li_2	25$
orl_21	Base	V1	li_3	200$
orl_11	Base	V1	li_4	50$
orl_12	Base	V1	li_4	50$
orl_21	Base	V1	li_4	50$
orl_22	Base	V1	li_4	50$
orl_11	Base	V1	li_5	12.5$
orl_12	Base	V1	li_5	12.5$
orl_21	Base	V1	li_5	12.5$
orl_22	Base	V1	li_5	12.5$
orl_11	Base	V1	li_6	15$
orl_12	Base	V1	li_6	15$
orl_21	Base	V1	li_6	15$
orl_22	Base	V1	li_6	15$