Category: GP

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

Earlier today I published a post on running a Receivables transaction import and am accompanying it with this video version of that post.

You can watch the GP Elementz – Financial Elementz – Run Receivables Transaction Import video:

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

With the Receivables Transaction Import definition created, we can now use it to import some transactions. I have the template populated with two lines, which are for separate invoices.

The Doc Type field should be set to one of the following numeric identifiers:

1. Sales / Invoices
2. Debit Memos
3. Finance Charges
4. Service / Repairs
5. Warranty
6. Credit Memo
7. Returns

Continue reading “Features of Financial Elementz from ISC Software: Run Receivables Invoices import”

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

Earlier today I published a post on creating a Receivables transaction import and am accompanying it with this video version of that post.

You can watch the GP Elementz – Financial Elementz – Create Receivables Transaction Import video:

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

Financial Elementz includes a Receivables Transaction import which can be used to load the following transaction types into Receivables Management:

1. Sales / Invoices
2. Debit Memos
3. Finance Charges
4. Service / Repairs
5. Warranty
6. Credit Memo
7. Returns

The import uses an Excel spreadsheet as the data source, which the user can select at runtime, but the format of the file needs to be defined in advance; the import supports the creation of multiple import definitions so that, if required, sales transactions can be imported electronically from multiple different systems and do so including different columns and in a different order.

To create the import definition, open the Receivables Transaction Import window ()Sales area page » Transactions » Financial Elementz » Receivables Transaction Import[/gmenu], enter the new Definition ID and tab from the field; when prompted, click Yes to create the new definition:

Continue reading “Features of Financial Elementz from ISC Software: Create Receivables Invoices import”

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

Earlier today I published a post on running a Manual Payments import and am accompanying it with this video version of that post.

You can watch the GP Elementz – Financial Elementz – Run Manual Payments import video:

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

With a Manual Payment Import Definition created, we can now use it to import data into Microsoft Dynamics GP.

The file can include multiple payments, one per row, for different payment types and creditors. The example I am using has a cheque/check payment to one creditor and a cash payment to a second. The Payment Type is one of the following numeric identifiers:

0. Cheques/Checks
1. Cash
2. Credit Card (Card name is a mandatory field for this payment type)
3. EFT

Save and close the prepared Excel spreadsheet:

Continue reading “Features of Financial Elementz from ISC Software: Run Manual Payments import”

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

Earlier today I published a post on creating a Manual Payments import and am accompanying it with this video version of that post.

You can watch the GP Elementz – Financial Elementz – Create Manual Payments import video:

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

As well as the Payables Transaction Import covered over the last couple of posts in this series, Financial Elementz includes a Manual Payments Import with which you can import payments from other systems into Microsoft Dynamics GP. The source file is an Excel spreadsheet and the import definition window allows you to create multiple definitions for importing payment files.

The Payment type column is a numeric identifier from one of the below four payment types (as supported in the Manual Payment Entry window):

0. Cheques/Checks
1. Cash
2. Credit Card (Card name is a mandatory field for this payment type)
3. EFT

I am going to create an import definition for the below example file:

Continue reading “Features of Financial Elementz from ISC Software: Create Manual Payments import”

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

Earlier today I published a post on running a Payables Invoices import and am accompanying it with this video version of that post.

You can watch the GP Elementz – Financial Elementz – Run Payables Invoices import video:

This post is part of the Features of Financial Elementz from ISC Software, as well as part of the over-arching GP Elementz from ISC Software series.

With the Payables Transaction Import definition created, we can now use it to import some transactions. I have the template populated with two lines, both of which are for the same invoice.

The import will group together header fields which are the same so that the tax and distributions are included on the same transaction. In this case, I have two sets of tax and two distributions going to different accounts. The integration will create me a single tax entry as the Tax Details are the same and two separate PURCH distribution rows.

The Doc Type field should be set to one of the following numeric identifiers:

1. Invoice
2. Finance Charge
3. Misc. Charge
4. Return
5. Credit Memo

Continue reading “Features of Financial Elementz from ISC Software: Run Payables Transaction import”