Microsoft Dynamics 365 Business Central: Notes and best practices
Here are some details on transactions and list items to help you make the best of the sync between Cashflow360 and Microsoft Dynamics 365 Business Central (MSDBC).
Note: We sync with the cloud version, not the on-premise version or international version.
| Object | MSDBC to Cashflow360 | Cashflow360 to MSDBC | Notes and Best Practices | |
|---|---|---|---|---|
| General | Close Books Date | No | No | |
| Chart of Accounts | Yes | No | - Account category in MSDBC sets the account type in Cashflow360. If no account category is selected in MSDBC, the account in Cashflow360 will be set to unspecified type. - If an account is set to blocked in MSDBC, the account in Cashflow360 will be set to inactive. Unblock the account in MSDBC to reactivate in Cashflow360. |
|
| Departments | Yes | Yes | - Department name isn't required in MSDBC, but it's required in Cashflow360. A department name must be added for departments to sync to Cashflow360. - If a department is set to blocked in MSDBC, the department in Cashflow360 will be set to inactive. Unblock the department in MSDBC to reactivate in Cashflow360. - If you delete/inactivate a department in Cashflow360, the department will be updated to blocked in MSDBC. |
|
| Locations | Yes | Yes | - Location name isn't required in MSDBC, but it's required in Cashflow360. A location name must be added for locations to sync to Cashflow360. | |
| Classes | Yes | Yes | - Class name isn't required in MSDBC, but it's required in Cashflow360. A class name must be added for classes to sync to Cashflow360. - If a class is set to blocked in MSDBC, the class in Cashflow360 will be set to inactive. Unblock the class in MSDBC to reactivate in Cashflow360. - If you delete/inactivate a class in Cashflow360, the class will be updated to blocked in MSDBC. |
|
| Employees | Yes | Yes | - Employee name isn't required in MSDBC, but it's required in Cashflow360. An employee name must be added for employees to sync to Cashflow360. - If an employee is set to blocked in MSDBC, the employee in Cashflow360 will be set to inactive. Unblock the employee in MSDBC to reactivate in Cashflow360. - If you delete/inactivate an employee in Cashflow360, the employee will be updated to blocked in MSDBC. |
|
| Currency | Yes | Yes | ||
| Bank Account Balance | No | No | ||
| Attachments | No | No | ||
| Approvals | No | No |
| Object | MSDBC to Cashflow360 | Cashflow360 to MSDBC | Notes and Best Practices | |
|---|---|---|---|---|
| Payables | Vendors | Yes | Yes | - Vendor No. is a required field in MSDBC. Set accounting preferences to auto-numbering if you have vendor sequencing on in MSDBC. - If a vendor is set to Block: All in MSDBC, the vendor in Cashflow360 will be set to inactive. Unblock the vendor or block only payment in MSDBC to reactivate in Cashflow360. - If you delete/inactivate a vendor in Cashflow360, the vendor will be updated to Block: All in MSDBC. |
| AP Funds Transfers | No | Yes | - Sync to the General Journal selected in sync preferences. | |
| Bills/Purchase invoices | Yes | Yes | - Purchase invoices and posted purchase invoices in MSDBC sync to Cashflow360 as bills. - Bills in Cashflow360 sync to MSDBC as unposted purchase invoices. - Updates made to bills in Cashflow360 will only sync to unposted purchase invoices in MSDBC. - Canceling a posted purchase invoice doesn't delete the bill in Cashflow360. You'll need to manually delete the bill in Cashflow360. |
|
| Bill Payments | No | Yes | - Sync to the Payment Journal selected in sync preferences. - Payments need to be posted in MSDBC. - Payment voids don't sync. Void in Cashflow360 and MSDBC manually. |
|
| Vendor Credits/Purchase Credit Memos | Yes, unposted purchase credit memos only | Yes, unapplied vendor credits only | - Unapplied vendor credits in Cashflow360 will sync to MSDBC as unposted purchase credit memos. - Unposted purchase credit memos in MSDBC will sync to Cashflow360 as unapplied vendor credits. - Posting purchase credit memos in MSDBC won't sync to Cashflow360. - Applying vendor credits in Cashflow360 won't sync to MSDBC. You need to apply and post in both sides manually. |
| Object | MSDBC to Cashflow360 | Cashflow360 to MSDBC | Notes and Best Practices | |
|---|---|---|---|---|
| Receivables | Customers | Yes | Yes | - Customer No. is a required field in MSDBC. Set accounting preferences to auto-numbering if you have customer sequencing on in MSDBC. - If a customer in MSDBC is set to Tax Liable, transactions won't sync to Cashflow360. - If a customer is set to Block: All in MSDBC, the customer in Cashflow360 will be set to inactive. Unblock the customer or block only payment in MSDBC to reactivate in Cashflow360. - If you delete/inactivate a customer in Cashflow360, the customer will be updated to Block: All in MSDBC. |
| Invoices/Sales Invoices | Yes | Yes | - Sales invoices and posted sales invoices in MSDBC sync to Cashflow360 as invoices. Invoices in Cashflow360 sync to MSDBC as unposted sales invoices. Updates made to invoices in Cashflow360 will only sync to unposted sales invoices in MSDBC. - After an invoice syncs, you can't edit in Cashflow360. Make edits in MSDBC and sync to Cashflow360. - Invoices with Item Charges, taxes, and discounts will only sync 1-way from MSDBC to Cashflow360. - Canceling a posted sales invoice doesn't delete the invoice in Cashflow360. You'll need to manually delete the invoice in Cashflow360. |
|
| Items | Yes | No | - Items sync from Items and Item charges in MSDBC. - Item description in MSDBC syncs to item name in Cashflow360Cashflow360. Item description is required. - If an item is set to blocked in MSDBC, the item in Cashflow360 will be set to inactive. Unblock the item in MSDBC to reactivate in Cashflow360. |
|
| AR Payments | No | Yes | - Sync to the Cash Receipt Journal selected in sync preferences. - Payments need to be posted in MSDBC. - Payment voids don't sync. Void in Cashflow360 and MSDBC manually. |
|
| Credit Memos/Sales Credit Memos | Yes, unposted sales credit memos only | Yes | - Unapplied credit memos in Cashflow360 will sync to MSDBC as unposted sales credit memos. - Unposted sales credit memos in MSDBC will sync to Cashflow360 as unapplied credit memos. - Posting sales credit memos in MSDBC won't sync to Cashflow360. - Applying credit memos in Cashflow360 won't sync to MSDBC. You need to apply and post in both sides manually. |
|
| AR Funds Transfers | No | Yes | - Sync to the General Journal selected in sync preferences. |
ACCOUNT SETUP View all
Load more