Features of Financial Elementz from ISC Software: Run Payables Transaction import

Financial ElementzThis 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
Microsoft Excel with data

Once the data has been prepared, open the Payables Transaction Import window (Purchasing area page » Transactions » Financial Elementz » Payables Transaction Import) and select the required Definition ID.

Enter the Batch Number (if the batch doesn’t exist, you’ll be prompted to create it) and use the browse button to select the file to import.

Click the Redisplay button on the action pane to load the file and display the invoices to be created:

Payables Transaction Import window showing the invoice to be created

The chevrons at the end can be clicked to fold open the scrolling window and view any error messages produced; the expansion button next to the Document Number can be used to preview the tax and account distributions to be created.

When ready, click the Process button to create the invoices (any showing an error will be ignored). Once the import is complete, a dialog will be displayed showing the number of transactions successfully created:

Confirmation dialog

The transactions will now be in Microsoft Dynamics GP on the selected batch ready for processing as normal:

Invoice in Payables Transaction Entry

GP Elementz from ISC Software

GP Elementz from ISC Software
What add-ons are available?
GP Elementz Portals
Features of PurchaseHQ from ISC Software: Introduction to PurchaseHQ
Features of PurchaseHQ from ISC Software: Introduction to PurchaseHQ [Video]
Features of PurchaseHQ from ISC Software: Secure access
Features of PurchaseHQ from ISC Software: Secure access [Video]
Features of PurchaseHQ from ISC Software: Configuration
Features of PurchaseHQ from ISC Software: Configuration [Video]
Features of PurchaseHQ from ISC Software: Setup images
Features of PurchaseHQ from ISC Software: Setup images [Video]
Features of PurchaseHQ from ISC Software: Granting users access
Features of PurchaseHQ from ISC Software: Granting users access [Video]
Features of PurchaseHQ from ISC Software: Enter a Purchase Requisition
Features of PurchaseHQ from ISC Software: Enter a Purchase Requisition [Video]
Features of PurchaseHQ from ISC Software: Enter a Purchase Order
Features of PurchaseHQ from ISC Software: Enter a Purchase Order [Video]
Features of PurchaseHQ from ISC Software: View my orders
Features of PurchaseHQ from ISC Software: View my orders [Video]
Features of PurchaseHQ from ISC Software: Workflow Integration
Features of PurchaseHQ from ISC Software: Workflow Integration [Video]
Features of PurchaseHQ from ISC Software: Document Approval
Features of PurchaseHQ from ISC Software: Document Approval [Video]
Features of PurchaseHQ from ISC Software: Receive Goods
Features of PurchaseHQ from ISC Software: Receive Goods [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Overview
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Overview [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) configuration
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) configuration
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) configuration [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Create Approvers
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Create Approvers [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Configure Delegation
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) Configure Delegation [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) submit transaction for approval
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) submit transaction for approval [Video]
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) in portal
Features of PurchaseHQ from ISC Software: Supplier Invoice Approval (Non-Workflow) in portal [Video]
Features of PurchaseHQ from ISC Software: Free Trial Available
Features of PurchaseHQ from ISC Software: Free Trial Available [Video]
Features of CustomerHQ from ISC Software: Introduction to CustomerHQ
Features of CustomerHQ from ISC Software: Introduction to CustomerHQ [Video]
Features of CustomerHQ from ISC Software: Secure access
Features of CustomerHQ from ISC Software: Secure access [Video]
Features of CustomerHQ from ISC Software: Configuration
Features of CustomerHQ from ISC Software: Configuration [Video]
Features of CustomerHQ from ISC Software: Change images
Features of CustomerHQ from ISC Software: Change images [Video]
Features of CustomerHQ from ISC Software: Manage customer accounts
Features of CustomerHQ from ISC Software: Manage customer accounts [Video]
Features of CustomerHQ from ISC Software: Manage salesperson accounts
Features of CustomerHQ from ISC Software: Manage salesperson accounts [Video]
Features of CustomerHQ from ISC Software: Account Summary
Features of CustomerHQ from ISC Software: Account Summary [Video]
Features of CustomerHQ from ISC Software: View transactions
Features of CustomerHQ from ISC Software: View transactions [Video]
Features of CustomerHQ from ISC Software: View Statements
Features of CustomerHQ from ISC Software: View Statements [Video]
Features of CustomerHQ from ISC Software: Free Trial available
Features of CustomerHQ from ISC Software: Free Trial available [Video]
Features of SalesHQ from ISC Software: Introduction to SalesHQ
Features of SalesHQ from ISC Software: Introduction to SalesHQ [Video]
Features of SalesHQ from ISC Software: Secure access
Features of SalesHQ from ISC Software: Secure access [Video]
Features of SalesHQ from ISC Software: Configuration
Features of SalesHQ from ISC Software: Configuration [Video]
Features of SalesHQ from ISC Software: Change images
Features of SalesHQ from ISC Software: Change images [Video]
Features of SalesHQ from ISC Software: Manage customer accounts
Features of SalesHQ from ISC Software: Manage customer accounts [Video]
Features of SalesHQ from ISC Software: Manage salesperson accounts
Features of SalesHQ from ISC Software: Manage salesperson accounts [Video]
Features of SalesHQ from ISC Software: Account Summary
Features of SalesHQ from ISC Software: Account Summary [Video]
Features of SalesHQ from ISC Software: View transactions
Features of SalesHQ from ISC Software: View transactions [Video]
Features of SalesHQ from ISC Software: View statement
Features of SalesHQ from ISC Software: View statement [Video]
Features of SalesHQ from ISC Software: Inventory Lookup
Features of SalesHQ from ISC Software: Inventory Lookup [Video]
Features of SalesHQ from ISC Software: Price Lookup
Features of SalesHQ from ISC Software: Price Lookup [Video]
Features of SalesHQ from ISC Software: Add Prospect
Features of SalesHQ from ISC Software: Add Prospect [Video]
Features of SalesHQ from ISC Software: Create quote
Features of SalesHQ from ISC Software: Create quote [Video]
Features of SalesHQ from ISC Software: Create order
Features of SalesHQ from ISC Software: Create order [Video]
Features of SalesHQ from ISC Software: Create invoice
Features of SalesHQ from ISC Software: Create invoice [Video]
Features of SalesHQ from ISC Software: Free Trial
Features of SalesHQ from ISC Software: Free Trial [Video]
GP Elementz Add-ins
Features of Enhanced Notes from ISC Software: Introduction to Enhanced Notes
Features of Enhanced Notes from ISC Software: Introduction to Enhanced Notes [Video]
Features of Enhanced Notes from ISC Software: Individual notes
Features of Enhanced Notes from ISC Software: Individual notes [Video]
Features of Enhanced Notes from ISC Software: Categories/Subcategories
Features of Enhanced Notes from ISC Software: Categories/Subcategories [Video]
Features of Enhanced Notes from ISC Software: Assign tasks
Features of Enhanced Notes from ISC Software: Assign tasks [Video]
Features of Enhanced Notes from ISC Software: Available for reporting
Features of Enhanced Notes from ISC Software: Available for reporting [Video]
Features of Enhanced Notes from ISC Software: Free Trial
Features of Enhanced Notes from ISC Software: Free Trial [Video]
Features of Financial Elementz from ISC Software: Introduction to Financial Elementz
Features of Financial Elementz from ISC Software: Introduction to Financial Elementz [Video]
Features of Financial Elementz from ISC Software: Available imports
Features of Financial Elementz from ISC Software: Available imports [Video]
Features of Financial Elementz from ISC Software: General Ledger Code Import
Features of Financial Elementz from ISC Software: General Ledger Code Import [Video]
Features of Financial Elementz from ISC Software: Create General Ledger import
Features of Financial Elementz from ISC Software: Create General Ledger import [Video]
Features of Financial Elementz from ISC Software: Run General Ledger import
Features of Financial Elementz from ISC Software: Run General Ledger import [Video]
Features of Financial Elementz from ISC Software: Create Payables Transaction import
Features of Financial Elementz from ISC Software: Create Payables Transaction import [Video]
Features of Financial Elementz from ISC Software: Run Payables Transaction import
Features of Financial Elementz from ISC Software: Run Payables Transaction import [Video]
Features of Financial Elementz from ISC Software: Create Manual Payments import
Features of Financial Elementz from ISC Software: Create Manual Payments import [Video]
Features of Financial Elementz from ISC Software: Run Manual Payments import
Features of Financial Elementz from ISC Software: Run Manual Payments import [Video]
Features of Financial Elementz from ISC Software: Create Receivables Invoices import
Features of Financial Elementz from ISC Software: Create Receivables Transaction Import [Video]
Features of Financial Elementz from ISC Software: Run Receivables Invoices import
Features of Financial Elementz from ISC Software: Run Receivables Transaction Import [Video]

Features of Financial Elementz from ISC Software

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you’d like to speak to someone about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.
Your Name (required):
Your Email (required):
Subject:
Enquiry message:

What should we write about next?

Your Name (required) –
Your Email (required) –

Leave a Reply

Your email address will not be published. Required fields are marked *