Fall '24 Accounting Seed Installation Guide

Overview

Initial Accounting Seed Installation

Install the Accounting Seed managed package and follow their configuration instructions.
Install the TMS-Accounting Seed bridge package.
Add “Transportation” to the Product object Product Family field as a picklist choice.
Make the new TMS Accounting Admin tab visible to the system administrators.
From the TMS Accounting Admin tab:
1. Set all the Global Default fields you can and click Save.
2. Click the Create Default Products button if you do not have default products available or selected on the right side of the Global Defaults section.
3. If the Unlinked Items sections is not empty:
  1. Click the Create/Match Products for Unlinked Accessorials button to associate products to all your unlinked accessorials.
  2. Click the Create/Match Products for Unlinked Taxes button to associate products to all your unlinked sales taxes.
4. After clicking these two buttons the Unlinked Items section should be empty.
Provide access to appropriate internal users for the following Visualforce pages/data:
1. TMSAccountingAdmin
  1. Add as a visible tab for appropriate internal user profiles.
2. BillingAutoCreation
  1. Add the Create Billing button to the Customer Quote related list on the Load page layout.
3. BillingTaxUpdate
  1. Add the Calc TMS Tax button to the Billing page layout.
4. BillingEDISend
  1. Add the Send via EDI button to the Billing page layout.
5. BillingGenerateAndSend
  1. Add the Send Invoices button to the Billing tab list view
6. BillingBatchPost
  1. Add the Batch Post button to the Billing tab list view.
7. BillingBatchUnpost
  1. Add the Batch Unpost button to the Billing tab list view.
8. PayableAutoCreation
  1. Add the Create Payable button to the Carrier Quote related list on the Load page layout.
9. PaymentProcessorSubmit
  1. Add the Submit to Payment Processor button to the Payable page layout.
10. PaymentProcessorStatus
  1. Add the Payment ProcessorStatus button to the Payable page layout.
11. PaymentProcessorSubmitBulk
  1. Add the Submit to Payment Processor button to the Payable list views
12. PaymentProcessorStatusBulk
  1. Add the Payment ProcessorStatus button to the Payable list views.
13. InvoiceAdjustment
  1. Add the Adjust button to the Payable page layout.
14. PayableBatchPost
  1. Add the Batch Post button to the Payable tab list view.
15. PayableBatchUnpost
  1. Add the Batch Unpost button to the Payable tab list view.
16. EPaymentDetail
  1. Add the ePayment related list to the Load page layout.
  2. Add the New button to this related list.
17. BatchPostAndPay
  1. Add the Post and Pay button to the Payable list view.
Drag all fields desired onto the Billing page layout.
Drag all fields desired onto the Payable page layout. The Payment Processor XXX fields relate to the TriumphPay integration.
From a list view, make sure all Product records have the appropriate Revenue GL Account and Expense GL Account values.
Add the Unapplied Cash/Credit Memos field to the Shipper/Consignee Transportation Profile page layout right below the Credit Limit field.
Add the Carrier Remit to Admin (AS) LWC to the Account and/or Transportation Profile lightning record page layouts for Carriers.
1. If the existing Carrier Remit to Admin LWC is on the Account and/or Transportation Profile lightning record page layouts for Carriers, remove it.
2. Add the Carrier Remit To As Of field to the Carrier Transportation Profile lightning record page layout. Set the field to read-only.
3. View additional fields in the Carrier Remit To Admin (AS) LWC by adding fields to the Load TMS21, Payable TMS1, and Vendor Invoice TMS1 field sets.
Remove all access and visibility to the Customer Invoice and Vendor Invoice objects:
1. Remove related lists from Load page layout.
2. CRUD access should be none for these objects for all profiles.
3. Hide the Customer Invoice and Vendor Invoice tabs from all profiles.
See the documentation for instructions on setting up NACHA file generation.
It is highly recommended that NO security Profiles have Delete rights on the EPayment object.

Upgrading from a Previous Version

See the Revenova TMS Fall '24 Installation Guide. Install and configure the Fall ‘24 Patch 1 TMS Release BEFORE installing the Accounting Seed bridge package.

The Accounting Seed Bridge package requires the Fall ‘24 Patch 1 package to install correctly. Install this package first before proceeding with the bridge package installation.

Review fields added by the installation. Set CRUD access as needed.

Release Fall ‘24 Accounting Seed Integration Upgrade Instructions (ETC: 15 Minutes)

You must install and test in the sandbox before upgrading production.
Perform the Accounting Seed upgrade installation AFTER the TMS Fall ‘24 Release installation.
Obtain the Fall ‘24 installation URL and password from your Revenova representative.
Install the upgrade. Wait for the “Installation succeeded” email.
From TMS Accounting Admin click the Reset Reference Data button ONCE and wait for the email indicating completion. This process does the following:
From Setup → Object manager, select the Billing Line object.
1. Select the Page Layouts tab.
2. Choose the Project Billing Line Layout page layout.
3. Add the Payable field to the page layout.
4. Click Save.
5. Select the Fields & Relationships tab.
6. Choose the Unit field.
7. Confirm the following picklist values are available in the Values section. Add picklist values as necessary. Click the New button and enter the values.
  1. Fixed Cost
  2. Percent of Amount
  3. Per Cubic Foot
  4. Per Cubic Meter
  5. Per Cwt
  6. Per Day
  7. Per Equipment Type
  8. Per Gallon
  9. Per Handling Unit
  10. Per Hour
  11. Per Kilogram
  12. Per Kilometer
  13. Per Linear Foot
  14. Per Liter
  15. Per Mile
  16. Per Packaging Unit
  17. Per Pound
  18. Per Square Foot
  19. Per Square Meter
  20. Per Stop
  21. Per Ton
  22. Per Volume Unit
  23. Per HU Position
  24. Percent of Freight
8. Click Save.
From Setup → Object manager, select the Payable object.
1. Select the Page Layouts tab.
2. Choose the TMS Payable Layout page layout.
3. Add the Unmatched EDI Transaction field to the page layout.
4. Click Save.
From Setup → Object manager, select the Payable Line object.
1. Select the Fields & Relationships tab.
2. Choose the Unit field.
3. Confirm the following picklist values are available in the Values section. Add picklist values as necessary. Click the New button and enter the values.
  1. Fixed Cost
  2. Percent of Amount
  3. Per Cubic Foot
  4. Per Cubic Meter
  5. Per Cwt
  6. Per Day
  7. Per Equipment Type
  8. Per Gallon
  9. Per Handling Unit
  10. Per Hour
  11. Per Kilogram
  12. Per Kilometer
  13. Per Linear Foot
  14. Per Liter
  15. Per Mile
  16. Per Packaging Unit
  17. Per Pound
  18. Per Square Foot
  19. Per Square Meter
  20. Per Stop
  21. Per Ton
  22. Per Volume Unit
  23. Per HU Position
  24. Percent of Freight
Make sure all relevant TMS batch jobs are running and/or scheduled. See the Batch Processes article for suggested run times.

Field/Field Set Modification Summary – Accounting Seed

Object	Field/Field Set	Action	Notes
Billing Line	Payable	Add	Allows for including accessorial charges for PayIQ consideration.
Payable	Unmatched EDI Transaction	Add	Contains the unmatched EDI transaction to create the Payable.