To help best manage your accounts payable, here are some things to know about the Bill/Payables Transaction Invoice/Receivings Transaction workflow between Bill.com and Microsoft Dynamics GP (MSDGP).
Bills/Purchase Invoices
- Bills coded only to GL accounts in Bill.com sync to MSDGP as Payables Transaction Invoices with the details on the distribution table.
- Bills coded to items or items and GL accounts in Bill.com sync to MSDGP as Receivings Transactions, with any GL coded expenses detailed on the distribution table.
- Unpaid Payables Transaction Invoices or Receivings Transactions in MSDGP sync to Bill.com as bills.
- Bills in Bill.com will sync to MSDGP as unposted transactions.
- Unpaid posted and unposted Payables Transaction Invoices/Receivings Transactions in MSDGP will sync to Bill.com as bills.
- Bills in Bill.com will sync to the AP account linked to the vendor in MSDGP. If there isn't one, it syncs to the default AP in MSDGP.
- Class, department, employee, job/project, and customer do not sync on bills/Payables Transaction Invoices/Receivings Transaction as MSDGP uses coding on GL accounts to categorize expenses. These classifications should only be used for the approvals process in Bill.com.
- Edits to a bill in Bill.com will not sync to the Receivings Transaction in MSDGP if it has items. Edits should be made in MSDGP.
- Edits to a bill in Bill.com will not sync to the Payables Transaction Invoice/Receivings Transaction in MSDGP if it is posted.
- Edits to a Payables Transaction Invoice/Receivings Transaction in MSDGP will not sync to the bill in Bill.com if the bill is paid or partially paid.
- If you delete/inactivate a bill in Bill.com, it will not sync to MSDGP if the Payables Transaction Invoice/Receivings Transaction has been posted.
- If you delete a Payables Transaction Invoice/Receivings Transaction in MSDGP, it will not sync to the bill in Bill.com if the bill is paid or partially paid.