Audience: Great Plains (GP) Admin and Accounting Manager
Accounting System: Great Plains (GP)
Summary: Reviews mapping fields to show how each field is represented in MineralTree and in Great Plains (GP).
Company
| Category | Great Plains (GP) | MineralTree |
| Vendor |
Vendor Originating Currency |
Vendor Currency |
| Invoices (Bills) | Sales Invoice, Invoice | Invoice |
| Terms | Terms Description | Terms |
| Discount Dates | Discount Value | |
| Discount Amount | Discount Amount | |
| Due Date | Due Date | |
| General Ledger Accounts |
Accounts Name Cash Account Account Type |
Account General Ledger Cash Account Type |
| Payment Accounts |
Checkbooks Checkbook ID |
Bank Account Account Name |
Vendors
Vendors are named "Vendors" in MineralTree*
| Great Plains (GP) | MineralTree |
| Vendor | Vendor Name |
| Address | Address Line 1 |
| Address 2 | Address Line 2 |
| City | City |
| State | State/Province |
| ZIP Code | Post Code |
| Country | Country |
| Phone 1 | Phone |
| Fax | Fax |
*Active vendors will sync to MineralTree and be available for viewing, editing, and invoice creation. Vendors must be originally created in GP, and changes after that point will sync bidirectionally. Vendors deactivated in GP will sync the deactivated status to MineralTree, but vendors deleted in GP must be deactivated manually in MineralTree.
Invoices (Bills)
Bills / Sales Invoices are named “Invoices” in MineralTree)
| Great Plains (GP) | MineralTree |
| Name | Vendor Name |
| Document Number | Invoice Number |
| Doc. Date | Invoice Date |
| Due Date | Due Date |
| Account | AP Account |
| Discount Account | Discount Account |
| Payment Terms | Terms |
| Description | Memo |
| Total | Gross Amount |
| Trade Discount | Trade Discount |
| Currency ID | Not Available in MineralTree |
*Discounts can be applied in GP or in MineralTree. Applied discounts do not appear on the remittance, but applied credits do appear on the remittance.
Bills – Expense Line Fields
| Great Plains (GP) | MineralTree |
| Distributions | Expenses |
| Account | Account |
| Debit | Net Amount |
| Type | Account Type |
| Description | Description |
Credits*
| Great Plains (GP) | MineralTree |
| Credits | Credits |
*All credits must be applied in GP. Once applied, the remaining balance of the invoices they are applied to will be correctly updated. Any credits applied in GP sync to MineralTree as credit payments against invoices.
Payments
| Great Plains (GP) | MineralTree |
| Payable Payments | Payments * |
| Amount | Amount |
| Date | Payment Date |
| Document No. | Payment Type |
| Checkbook ID | Paid From |
*All payments made in GP sync to MineralTree as “Paid in accounting system.” The check numbers for these payments are not available in MineralTree.
Please reach out to Customer Support with any questions:
- Phone: 855‑672‑9669
- Email: mtsupport@mineraltree.com