Fixed Charge Voucher creation example
Generating Fixed Charge Vouchers based on the Voucher Charge Interval types (Weekly, Monthly, and Yearly)
Assume fixed charges are defined for Carrier (A) and Tariff Service-Equipment Type (FTL) levels as shown in the following table:
| Fixed Charge Code | Fixed Charge Entity Type | Tariff Service | Equipment Type | Rate | Voucher Interval | Effective date | Expiration date |
|---|---|---|---|---|---|---|---|
| FXCH 1 | Carrier | 200 | Weekly | 01-JAN-2019 | 20-JAN-2020 | ||
| FXCH 2 | Equipment Type | FTL | 40 ft. | 200 | Weekly | 01-JAN-2019 | 20-JAN-2020 |
| FXCH 2 | Equipment Type | FTL | 20 ft. | 500 | Monthly | 01-JAN-2019 | 20-JAN-2020 |
| FXCH 2 | Equipment Type | FTL | 40 ft. | 2000 | Yearly | 01-JAN-2019 | 20-JAN-2020 |
| FXCH 2 | Equipment Type | FTL | 20 ft. | 1000 | Yearly | 01-JAN-2019 | 20-JAN-2020 |
Consider an A/P Voucher Batch Version is defined for a Fixed Charge Voucher, with a Billing Period of 365 days as shown in the following table:
| Version Description | Voucher Type | Fixed Charge Handling | Start Adjustment Days | Cut Off Adjustment Days | Carrier ID | Exclude Carriers Y/N |
|---|---|---|---|---|---|---|
| FX_VER2 | Fixed Charge | Only Fixed Charges | -365 | 0 | A | N |
Consider the A/P Voucher Batch Run Request is created with Start Date: 01-Jan- 2020.
A/P Voucher Batch Process will generate the Fixed Charge Vouchers.
Yearly Voucher Creation:
All the Fixed Charges with Voucher Charge Interval as Yearly will be considered for creating a Yearly Voucher.
If there are no existing fixed charge A/P Vouchers for the Year of ‘2019’ against the Carrier ‘A’ and Version ID: ‘FX_VER2’ within A/P Voucher entity, then the batch process will generate A/P Voucher as shown in the following table:
| Voucher Reference Number | Voucher Billing Period | |
|---|---|---|
| Fixed Charge Voucher Start Date | Fixed Charge Voucher End Date | |
| A_Y2019 | 01 JAN 2019 | 31 DEC 2019 |
A Fixed Charge Voucher is created as shown in the following table:
| Voucher ID | Voucher Ref Number | Carrier | Equipment Type | Service | Rate | Currency |
|---|---|---|---|---|---|---|
| 001 | A_Y2019 | A | 40 ft. | FTL | 2000 | USD |
| A | 20 ft. | FTL | 1000 | USD | ||
| Total | 3000 | USD |
For information on the format of the Voucher Reference Number, see Fixed Charge Voucher Reference Numbers.
Monthly Voucher Creation:
All the Fixed Charges with Charge Interval as Monthly will be considered for Monthly Vouchers.
If there are no existing fixed charge A/P Vouchers for the Months of Jan 2019 to Dec 2019 against the Carrier ‘A’ and Version ID: ‘FX_VER2’ within voucher entity, then the financial batch process will generate 12 Vouchers with the Reference Numbers as shown in the below table:
| Fixed Charge - Voucher Reference Number | Voucher Billing Period | |
|---|---|---|
| Fixed Charge Voucher Start Date | Fixed Charge Voucher End Date | |
| A_M01Y2019 | 01 JAN 2019 | 31 DEC 2019 |
| A_M02Y2019 | 01 FEB 2019 | 28 FEB 2019 |
| A_M03Y2019 | 01 MAR 2019 | 31 MAR 2019 |
| A_M04Y2019 | 01 APR 2019 | 30 APR 2019 |
| A_M05Y2019 | 01 MAY 2019 | 31 MAY 2019 |
| A_M06Y2019 | 01 JUN 2019 | 30 JUN 2019 |
| A_M07Y2019 | 01 JUL 2019 | 31 JUL 2019 |
| A_M08Y2019 | 01 AUG 2019 | 31 AUG 2019 |
| A_M09Y2019 | 01 SEP 2019 | 30 SEP 2019 |
| A_M10Y2019 | 01 OCT 2019 | 31 OCT 2019 |
| A_M11Y2019 | 01 NOV 2019 | 30 NOV 2019 |
| A_M12Y2019 | 01 DEC 2019 | 31 DEC 2019 |
The following table presents the sample Monthly Fixed Charge Voucher. The batch process will generate 12 monthly fixed charge vouchers; the Voucher Reference Number will differ for each of these, but the Rate will be the same.
| Voucher ID | Voucher Ref Number | Carrier | Equipment Type | Service | Rate | Currency |
|---|---|---|---|---|---|---|
| 002 | A_M01Y2019 | A | 20 ft. | FTL | 500 | USD |
| Total | 500 | USD |
For information on the format of the Voucher Reference Number, see Fixed Charge Voucher Reference Numbers.
Weekly Voucher Creation:
All the Fixed Charges with Charge Interval as Weekly will be considered for Weekly Vouchers.
If there are no existing fixed charge A/P Vouchers with Weekly Charge Interval of Jan 2019 to Dec 2019 against the Carrier ‘A’ and Version ID: ‘FX_VER2’ within the A/P Voucher entity, then the batch process will generate 52 weekly Vouchers with the Reference Numbers as shown in the following table:
| Fixed Charge - Voucher Reference Number | Voucher Billing Period | |
|---|---|---|
| Fixed Charge Voucher Start Date | Fixed Charge Voucher End Date | |
| A_W01Y2019 | 31 DEC 2018 | 06 JAN 2019 |
| A_W02Y2019 | 07 JAN 2019 | 13 JAN 2019 |
| A_W03Y2019 | 14 JAN 2019 | 20 JAN 2019 |
| A_W04Y2019 | 21 JAN 2019 | 27 JAN 2019 |
| And so on.... | ||
| A_W51Y2019 | 16 DEC 2019 | 22 DEC 2019 |
| A_W52Y2019 | 23 DEC 2019 | 29 DEC 2019 |
The batch process will generate 52 weekly fixed charge vouchers; the Voucher Reference Number will differ for each of these, but the Rate will be the same for each weekly voucher.
| Voucher ID | Voucher Ref Number | Carrier | Equipment Type | Service | Rate | Currency |
|---|---|---|---|---|---|---|
| 14 | A_W01Y2019 | A | 200 | USD | ||
| A | 40 ft. | FTL | 200 | USD | ||
| Total | 400 | USD | ||||
For information on the format of the Voucher Reference Number, see Fixed Charge Voucher Reference Numbers.
See Also