Features of Financial Elementz from ISC Software: Available imports

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.

Financial Elementz includes a number of import routines which can be used to import data from Excel spreadsheets into Microsoft Dynamics GP without the need for a tool like Integration Manager or SmartConnect.

The available imports are:

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

Have an enquiry for ISC Software Solutions?

If you’re interested in speaking to ISC Software about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

Features of Financial Elementz from ISC Software: Introduction to Financial Elementz [Video]

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.

Earlier today I published an introduction to Financial Elementz and am accompanying it with this video version of that post.

You can watch the GP Elementz – Financial Elementz – Overview video:

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

Have an enquiry for ISC Software Solutions?

If you’re interested in speaking to ISC Software about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

Features of Financial Elementz from ISC Software: Introduction to Financial Elementz

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.

Financial Elementz is a set tools that can significantly improve productivity with easy to use windows and reports. Designed and created by ISCs Microsoft Dynamics GP consultants and developers to improve the daily tasks of a typical finance team, Financial Elementz provides real benefit from the outset.

Financial Elementz is a Dexterity add-on with windows which match the style and layout of standard Microsoft Dynamics GP windows.

Some of the included windows are:

  • General Ledger
    • General Ledger Accounts Import
    • General Ledger Import
    • GL Detail View
    • GL History Detail View
    • GL Batch View
  • Payables Management
  • Receivables Management
    • Receivables Transaction Import
    • Customer View
    • Customer Credit Check
    • Receivables Transaction Analysis
    • Receivables Batch View
    • Receivables Aged Trial Balance

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

Have an enquiry for ISC Software Solutions?

If you’re interested in speaking to ISC Software about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

Features of Financial Elementz from ISC Software: Series Index

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.

Financial Elementz is a collection of imports, inquiries and reports from ISC Software which can improve the efficiency of finance/accounting teams by adding functionality to Microsoft Dynamics GP.

Over the course of this series, the index, below, will automatically update with the new posts as they go live (unless you’re reading a syndicated version of this post in which case check back here)

Features of Financial Elementz from ISC Software
Introduction to Financial Elementz
Introduction to Financial Elementz [Video]
Available imports
Available imports [Video]
General Ledger Code Import
General Ledger Code Import [Video]
Create General Ledger import
Create General Ledger import [Video]
Run General Ledger import
Run General Ledger import [Video]
Create Payables Transaction import
Create Payables Transaction import [Video]
Run Payables Transaction import
Run Payables Transaction import [Video]
Create Manual Payments import
Create Manual Payments import [Video]
Run Manual Payments import
Run Manual Payments import [Video]
Create Receivables Invoices import
Create Receivables Transaction Import [Video]
Run Receivables Invoices import
Run Receivables Transaction Import [Video]

Have an enquiry for ISC Software Solutions?

If you’re interested in speaking to ISC Software about consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else, you can use the form below.





Your Name (required):
Your Email (required):
Subject:
Enquiry message:

Microsoft Dynamics GP SmartList window won’t open for one user

Microsoft Dynamics GPI was doing some consultancy for a client recently when they took the opportunity to ask me about a problem encountered by one of their users, whereby they were unable to open and use SmartList. it showed in the Windows task bar as open, but they couldn’t see it or bring it to the front. I tried the usual of trying to right click the window in the task bar and hitting Maximize, but this had no effect.

As this rang a bell, my next port of call was to search for similar problems and found a thread on the Community forum with an answer from Jonathan Fear of Microsoft suggesting that the System User Defaults (SY01402) table which holds window positions on a per user basis may be corrupt and need fixing.

I ran a select on both the user with the problem and one who could open SmartList successfully:

SELECT * FROM DYNAMICS..SY01402 WHERE syDefaultType = '96' AND (USERID = 'sarah' OR USERID = 'jane')

The user with a problem had a SYUSERDFSTR value of FALSE~681~1536~-25632~-117~327~ with the highlighted section throwing the window far off the visible screen area, whereas the user who could see SmartList had a value of 289.

i got the user to log out of Microsoft Dynamics GP and one simple update statement later, and the user had SmartList opening correctly on screen for them:

UPDATE SY01402 SET SYUSERDFSTR = 'FALSE~681~1536~-289~-117~327~' WHERE syDefaultType = '96' AND USERID = 'sarah'

Integration Manager error when running a Sales Order Processing integration

Microsoft Dynamics GPI created an integration recently using Integration Manager for a client to import sales invoices into Microsoft Dynamics GP. It worked fine when I was developing it, logged in as DYNSA, and for one of the finance teams managers, but produced an error for the user:

Integration manager error log

Opening source query...
Establishing source record count...
Beginning integration...
DOC 1 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 2 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 3 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 4 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 5 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 6 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
DOC 7 ERROR: Unknown Great Plains field subtype '10016'. - Field 'Deposit Received' of window 'SOP_Entry' of form 'SOP_Entry'
Integration Failed
Integration Results
    7 documents were read from the source query.
    7 documents were attempted:
        0 integrated without warnings.
        0 integrated with warnings.
        7 failed to integrate.

I toggled the Integration Manager ini file parameters so I could see what was happening with the windows to get an indication of the problem. The first window opened was Sales Order Processing Setup; why tis opened I’m not sure, but the user didn’t have permissions for this window. I did a quick test by copying the users security to a test account and added access to that window and the integration ran through without a problem.

This seems to be an operating as designed thing, but it seems odd that the SOP Setup window needs access.

Duplicate last exchange rate in Microsoft Dynamics GP for every day to future date

Microsoft Dynamics GPI’ve been involved in a project which has included a lot of development and therefore a lot of QA and UAT over a period of time. The client’s system is configured with daily exhcnage rates which has caused some issues with testing as not everyone doing testing has access to insert new rates.

To provide some consistency in the exchange rate for testing and to ensure that testing is not held up by missing exchange rates, I created the below SQL script to copy the last exchange rate and replicate forward for every day until a specific date (set in the highlighted parameter at the top); the rate tables which are updated are listed out qithin the query (second set of highlighted text).

This script was ***NOT*** created for use on a live system, which would include a test company on the live system, as the exchange rate tables are system setup data. It was created only for use on a standalone test system with no connection to live.

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
DECLARE @StartDate DATETIME = FORMAT(GETDATE(), 'yyyy-MM-dd') ,@EndDate DATETIME = '2020-12-31' ; WITH NewDatesToInsert AS ( SELECT @StartDate AS EXCHDATE UNION ALL SELECT DATEADD(day, 1, EXCHDATE) FROM NewDatesToInsert WHERE DATEADD(day, 1, EXCHDATE) <= @EndDate ) INSERT INTO MC00100 -- Multicurrency Exchange Rate Maintenance (MC00100) ( EXGTBLID,CURNCYID,EXCHDATE,TIME1,XCHGRATE,EXPNDATE ) --VALUES ( SELECT ['Multicurrency Exchange Table Dates To Insert'].EXGTBLID ,['Multicurrency Exchange Table Dates To Insert'].CURNCYID ,['Multicurrency Exchange Table Dates To Insert'].EXCHDATE ,'1900-01-01 00:00:00000' AS TIME1 ,ISNULL(( SELECT TOP 1 XCHGRATE FROM MC00100 WHERE EXGTBLID = ['Multicurrency Exchange Table Dates To Insert'].EXGTBLID ORDER BY EXCHDATE DESC ), 1) AS XCHGRATE ,DATEADD(day, 30, ['Multicurrency Exchange Table Dates To Insert'].EXCHDATE) AS EXPNDATE FROM ( SELECT ['Multicurrency Exchange Table Setup'].EXGTBLID ,['Multicurrency Exchange Table Setup'].CURNCYID ,['New Dates To Insert'].EXCHDATE FROM NewDatesToInsert AS ['New Dates To Insert'] CROSS JOIN MC40300 AS ['Multicurrency Exchange Table Setup'] -- Multicurrency Exchange Table Setup (MC40300) WHERE ['Multicurrency Exchange Table Setup'].EXGTBLID IN ('Z-UK-BUY','Z-UK-SELL','Z-UK-AVG') ) AS ['Multicurrency Exchange Table Dates To Insert'] INNER JOIN MC40200 AS [Currency Setup'] -- Currency Setup (MC40200) ON [Currency Setup'].CURNCYID = ['Multicurrency Exchange Table Dates To Insert'].CURNCYID WHERE ( SELECT COUNT(*) FROM MC00100 WHERE EXGTBLID = ['Multicurrency Exchange Table Dates To Insert'].EXGTBLID AND EXCHDATE = ['Multicurrency Exchange Table Dates To Insert'].EXCHDATE AND XCHGRATE IS NOT NULL ) = 0 ) OPTION (MAXRECURSION 0)

Jet Reports with Microsoft Dynamics GP book available

Microsoft Dynamics GPI have a new book available now called Jet Reports with Microsoft Dynamics GP; this book is aimed at end-users or consultants looking to use Jet Reports with Microsoft Dynamics GP for financial and/or operational reporting.

The book covers the basics of installing and configuring Jet Reports as well as how to design and build reports using the Excel Add-in, before moving on to step-by-step guides on creating six different types of report and closing with a look at the report building tools and Jet Hub.

Jet Reports with Microsoft Dynamics GP by Ian Grieve

The book is available as an eBook direct from my azurecurve Publishing site or from Amazon (for $5 more):

If you buy the ebook from me directly, the coupon code JetWithGPLaunch will get you 20% off the price of this book (offer available until the end of July 2020).

Microsoft Dynamics GP running at an appalling slow speed

Microsoft Dynamics GPOn a recent project we encountered an issue with the test ssytem running remarkably slowly in many areas. While logging in took longer than it should have, even opening the SmartList window was taking 45 seconds; when a SmartList favourite was selected, each column header and field was drawn slowly enough that it could be read before the next one appeared.

Posting a Payables batch with 50 invoices would take more than 50 minutes (I’m not sure how long it took as that was when I disconnected my session and let it run to completion by itself at the end of the day).

We installed a client directly onto the SQL Server for testing purposes and found that the speed was what we would expect to see, rather than the snails pace the users were seeing.

One of the network team noticed that the traffic speed going over the network was very ;pw compared to what should have been possible and lower than we’d expect to see. The entire environment was a virtualised one and all machines were configured with virtual 10Gbit network cards; the solution was to remove the virtual 10Gbit ethernet cards and replace with 1Gbit.

After this change was made on both the SQL Server and terminal servers, users saw the performance of Microsoft Dynamics GP increase across the board. SmartList would open in three seconds, a favourite would return rows of data far faster than could be read and batch posting was rapid.

I’m not sure if there was a peculiarity elsewhere in the system contributing to the slowness, but the only change made at that time was the replacement of the virtual ethernet cards.