G/L Transaction example – A/R Revenue by Cost Center

Invoice linked to voucher for shipment is being transferred to Accounts Receivable module.

Shipment has three shipment legs:

Multi-legged Shipment - A/P Cost Distribution

Sequence

Origin

Destination

Carrier

Cost Center

A/P Cost

1

Cleveland, OH

Chicago, IL

A

YYYY

200.00

2

Chicago, IL

Los Angeles, CA

B

ZZZZ

1100.00

3

Los Angeles, CA

San Diego, CA

C

ZZZZ

300.00

Revenue by Cost Center flag in the Global Settings is enabled. Therefore, the revenue for this shipment must be allocated to the cost centers corresponding to each of the carriers that handled the shipment. Revenue will be allocated to the legs in proportion to the costs incurred in moving the shipment.

Multi-legged Shipment - Percentage of Total A/P Cost

Sequence

A/P Cost – Shipment Leg

Total A/P Cost for all Shipment Legs

Percentage of Total A/P Cost

1

200.00

1600.00

12.50

2

1100.00

1600.00

68.75

3

300.00

1600.00

18.75

Total

1600.00

 

100.00

The G/L Transactions generated when the voucher for this shipment is transferred to A/R would be:

G/L Transactions - A/R Revenue by Cost Center

G/L Classification

G/L Account Type

Charge ID

Destination

Debit Amount

Credit Amount

A/R Control

ASSET

WGT

Chicago

250.00

 

A/R Revenue

REVENUE

WGT

Chicago

 

250.00

A/R Control

ASSET

WGT

Los Angeles

1375.00

 

A/R Revenue

REVENUE

WGT

Los Angeles

 

1375.00

A/R Control

ASSET

WGT

San Diego

375.00

 

A/R Revenue

REVENUE

WGT

San Diego

 

375.00

A/R Control

ASSET

FUEL

Chicago

12.50

 

A/R Revenue

REVENUE

FUEL

Chicago

 

12.50

A/R Control

ASSET

FUEL

Los Angeles

68.75

 

A/R Revenue

REVENUE

FUEL

Los Angeles

 

68.75

A/R Control

ASSET

FUEL

San Diego

31.25

 

A/R Revenue

REVENUE

FUEL

San Diego

 

31.25

All the revenue from the Cleveland-Chicago leg will be applied to Cost Center XXXXX. The revenue from the Chicago-Los Angeles and Los Angeles-San Diego legs will be applied to Cost Center YYYYY. Note however, even though a total of $1750 will be applied to Cost Center YYYY for WGT, separate G/L transactions will still get created corresponding to each shipment leg.

See Also

G/L Transaction examples