Skip to main content

CargoWise One Visual Mapping Guide - Accounting

Rohan Shrestha avatar
Written by Rohan Shrestha
Updated this week

Accounting Table

‎‎Logixboard

Mapping Logic

Organization (company name)

Maintain → Master Data → Organizations

Order ID

Operate → Forwarding → Shipments → Basic Registration → Job Management Links → Order Refs

AND (if any)

Operate → Forwarding → Shipments → Basic Registration → Job Management Links → Job Number

Transaction Number

Manage → Receivables → Receivables Transactions → Transaction Number

OR

Operate → Forwarding → Shipments → Billing → AR Invoices → Transaction Number

Transaction Date

Operate → Forwarding → Shipments → Billing → AR Invoices → Post Date

OR

Manage → Receivables → Receivables Transactions → Invoice Details → Posted Date

Due Date

Operate → Forwarding → Shipments → Billing → AR Invoices → Invoice Date

OR

Manage → Receivables → Receivables Transactions → Invoice Details → Due Date

Invoice Status

N/A - this is generated in Logixboard based on the difference between Outstanding Amount and the Total Invoice Amount

Unpaid if Outstanding Amount matches the Total Invoice Amount OR If the Invoice was paid via LXB and that payment was rejected

Processing is displayed when a payment has been made via LXB, and it’s currently being processed. It may take a few days to clear.

Payment Received is displayed when we’ve received confirmation that your payment was submitted successfully. However, it may still take a few minutes for the payment to fully process.

Paid when a user has marked an Invoice as Paid in CW1

Job Invoice #

Operate → Forwarding → Shipments → Billing → AR Invoices → Job Invoice Number

OR

Manage → Receivables → Receivables Transactions → Invoice Details → Invoice Number

Currency

Manage → Receivables → Receivables Transactions → Invoice → Line Summary → Currency

Outstanding Amount

Manage → Receivables → Receivables Transactions → Outstanding Amount

Total Amount

Operate → Forwarding → Shipments → Billing → AR Invoices → Invoice Amount

OR

Manage → Receivables → Receivables Transactions → Invoice → Invoice Details → Line Charges → Total Invoice

Invoice Details

‎‎Logixboard

Mapping Logic

Logixboard Location

Charge Code

Manage → Receivables Transactions → Invoice Details → Line Summary → Charge

Description

Manage → Receivables Transactions → Invoice Details → Description

Related Shipment

Manage → Receivables Transactions → Invoice Details → Job

Charge

Manage → Receivables Transactions → Invoice Details → Local Amount

Total

Manage → Receivables Transactions → Invoice Details → Total Invoice

Did this answer your question?