Accounts Receivable Field Mapping

The following fields are mapped to and from FE and Lucity as a result of the Accounts Receivable integration.

Finance Enterprise > Person/Entity mapped to: Lucity > Work > Work Orders

PE ID : CS Billing Customer ID

Lucity > Work > Work Orders mapped to: Finance Enterprise > Create/Update Accounts Receivable Set

Prefix from "Prefix for Accts Receivable BatchId for Work Order billing" setting + Work Order Rec # : Set ID

Example: Prefix "L" + Work Order Rec # 361045 = Set ID L361045

Lucity > Work > Work Orders mapped to: Finance Enterprise > Create/Update Accounts Receivable Invoice

CS Customer Billing ID : Customer ID

Work Order Number : Invoice

Lucity > Work > Work Orders mapped to: Finance Enterprise > Create/Update Accounts Receivable Invoice Details

Work Order Number : Work Order

Division : Division

CS Customer Billing ID : Customer Type ID

[default value "1"] : Quantity

Billing Amount : Unit Price

[default value "NB"] : Trans Format

CS General Ledger : Account - GL Account

CS General Key : Account - GL Key

CS General Object : Account - GL Object

CS Job Ledger : Account - JL Account

CS Job Key : Account - JL Key

CS Job Object : Account - JL Object

Lucity > Work > Work Orders mapped to: Finance Enterprise > Miscellaneous

Lucity Username or CS System Settings Fallback User : Prep ID