MoversSuite Administration Updates

This section lists the improvements made within MoversSuite Administration - also known as the Admin Tool.

 

Data Warehouse Refresh: Now works with Xledger and has extra data

 

 

The Data Warehouse Refresh now works with whichever accounting system actively in use by your company  - either Xledger or Microsoft Dynamics GP. New to this functionality are the following details: who last ran the refresh, the start time, completed time, and when it was last executed.

 

 

 

Xledger: New warning when updating Setup Customers by Class

 

 

When updating your Setup Customers By Class setup to Xledger, a new warning now provides on how the update will affect existing records. This enhancement helps prevent unintended changes by allowing you to review the impact of the conversion in advance. Before this change, there was no way to see this information.

 

Now, the warning message and button reflect the upcoming step for the process. After selecting “Convert Prior Accounting System (if any) Customer Data -> Xledger”, the next screen displays the status of your records and details what will happen with each available option - Yes, No, and Cancel - before you commit to any changes.

 

Figure 2: Wording reflects Xledger, when applicable.

 

Figure 3: Status of records on file and what will happen with each option provided.

 

 

 

Database Changes

 

The following table lists the latest changes made to the MoversSuite database.

 

Table

Change

AccountingAccount

Added AccountingAccountTypeId.

AccountingAccountType

New table.

AccountingBankAccount

AccountingCustomer

Added AccountingCustomerCreditLimitTypeFid.

AccountingCustomerCreditLimitType

New table.

AcctTransactions

Added FullyAppliedTo as a flag to indicate when the transaction is fully applied.

AcctTransactionsApplyToInfo

BATProcess

Added RequestGroupIdentifier and AccountingBankAccountFID.

CommStmtDetail

Added AcctTransactionFid.

ErrorCodeStatistics

Renamed StartDate to be two new columns: FirstError and LastError.

GL00100

New table.

GL00105

GPCustomer

Added AccountingCustomerCreditLimitTypeFid.

GPWarehouse

Added AcctTransactionFid.

GPWarehouseStatus

Added the following:

LastStartTime

LastEndTime

LastExecRunTimeMilliSeconds

LastInvokedBy

MssWebSection

New table.

MssWebSectionPreference

PMPostingAccounts

Added AccountingAccountTypeId.

StatementChargeBack

StatementGLAllocation

StatementHeader

Added AccountingBankAccountFID.

XLedgerAccountingPeriodRange

New table.

XLedgerApplyToJournalDetail

XLedgerApplyToJournalDetailMap

XLedgerApplyToUploadInfo

XLedgerBankAccount

XLedgerJournalEntryBatch

Added RetryOfXLedgerJournalEntryBatchFid.

XLedgerJournalEntryBatchItem

Added the following:

XLedgerTransactionUploadFailureFid

Resolved

XLedgerBankAccountFid

ExternalIdentifier

PlaceOnHold

XLedgerSyncHistory

Added Bypass.

XLedgerTransactionHeader

Added the following:

ArApMatchIdentifier

ArApExternalIdentifier

SubledgerTransactionXLedgerDbId

XLedgerTransactionHoldStatusFid

XLedgerTransactionHoldStatus

New table.

XLedgerTransactionHoldSubmission

XLedgerTransactionUploadFailureMap

Table removed.

XLedgerTransactionUploadFailureSysUserMap

New table.

 

MOVERSSUITE DATABASE SCHEMA RESOURCES:

Tables Listing

Documents Table Listing

Data Views Listing

 

RELATED TOPIC:

Schema Changes

 

 

 

Release Requirements

System Requirements, Hardware Requirements, and Software Requirements have been updated to reflect the current versions needed for optimal security and functionality with MoversSuite. For software compatibility for this version of MoversSuite, see Software Compatibility.

 

NO CHANGES TO RELEASE REQUIREMENTS IN THIS RELEASE