To help best manage your accounts payable, here are some things to know about the payment and funds transfer workflow between Bill.com and Microsoft Dynamics GP (MSDGP).
Bill/Payables Transaction Invoice/Receivings Transaction sent payments
- Payments sync to the checkbook ID for the payment account in MSDGP as Manual Payments.
- Payments need to be posted in MSDGP.
- Payment voids don't sync. Void in Bill.com and MSDGP manually.
- Any time you add a new bank account in Bill.com, you’ll need to make sure the account also has a checkbook ID and related GL account before you can sync payments from that account.
- Payments won't sync to MSDGP unless the Payables Transaction Invoice/Receivings Transaction is posted.
- Non-USD payments will not sync.
Sales invoice received payments
- Payments sync as a Cash Receipt to the checkbook ID for the payment account in MSDGP.
- Payments need to be posted in MSDGP.
- Payment voids don't sync. Void in Bill.com and MSDGP manually.
- Update your payment GL accounts to Bank account type in Bill.com so they can be used for payments and sync preferences.
- Any time you add a new bank account in Bill.com, you’ll need to make sure the account also has a checkbook ID and related GL account before you can sync payments to that account.
- Payments won't sync to MSDGP unless the sales invoice is posted.
- Non-USD payments will not sync.
Funds transfers
- Bill.com uses the Money In and Money Out Clearing GL Accounts to help with bank reconciliation. Because GL accounts only sync 1-way from MSDGP to Bill.com, you'll need to create a checkbook ID and related GL account for each of these accounts in MSDGP.
- Sync as Bank Transfer to the checkbook ID for the payment bank GL in MSDGP.