Clients First USA
Clients First knows their software, but they are also astute business people, and they really understand manufacturing and distribution in particular.
Jimmy Witcher, COO, Merrick
Read More
About UsService OfferingsProduct OfferingsIndustries ServedDownloadsBlogTestimonials
 

Subscribe to our mailing list

* indicates required
    Interested in    
Hot Topics
 

Latest Articles

Automatic Application of Payments and Using Payment Methods in Microsoft Dynamics NAV

Monday, June 17th, 2013

Payment Methods and Payment Applications in Navision (Microsoft Dynamcis NAV)

By Mark Chinsky

When you are selling or buying items or services, there are 2 important things to know. “How will it be paid for”, and “When is the payment due”? In Microsoft Dynamics NAV, the “How to Pay” is defined as the Payment Method, and the “When to Pay” is defined as the Payment Term

You have the ability to setup multiple Payment Methods and Terms to use on your Purchase and Sales Transactions.

Today we’ll discuss Payment Methods

In the Classic Client, Payment Methods can be found in Administration > Application Setup > Financial Management > Payment Methods.

If you’re using the RoleTailored Client, go to Departments > Administration > Application Setup > Financial Management > Finance > Lists > Payment Methods.

The screenshot seen here is the from the demonstration Cronus USA, Inc. company and this example is from Dynamics NAV 2009 R2.  This company already has some payment methods already defined.  You need at least the first 2 columns defined for a method to be valid.

Code: This column must be filled in and can’t be blank.  It is up to 10 alphanumeric characters.

Description: This column is up to 30 alphanumeric characters, and gives the end user an explanation of the Payment Code

Now your Payment Methods are ready to be used on purchasing or sales documents such as Invoices or Purchase Orders.  You can also setup a Default Payment Method for Vendors or Customers instead of having to select each time during document entry.

The 3 next columns in the Payment Method form really tell NAV how to operate with these terms.
  1. Bal. Account Type and Bal. Account No.: When using a Balancing Account Type and Balancing Account No., Microsoft Dynamics NAV automatically creates the balancing or ‘reconciling’ journal line.  Relative to Payment methods, if the Bal. Account Type and Bal. Account No. fields have a payment method code selected and its used on a document such as an Invoice, when posted, NAV will automatically create a Payment entry and apply it to the posted document.  This can be very useful, for example, when doing Counter Sales so that you invoice and get paid in one simple step.
  2. Payment Processor: This field is just became available in NAV 2009 R2 and is part of NAV’s link to Dynamics Online Payment Services (Dynamics OPS; Microsoft’s Credit Card processing module that integrates to NAV).Payment Processor is an option field with two choices: blank (default value) and Dynamics Online.  Unless you are using Microsoft’s Dynamics Online Payment Service, always leave this as blank.  If not, it will trigger credit card processing in Dynamics NAV.

We hope you found this quick tip helpful in understanding how Payment Types and Methods work in Microsoft Dynamics NAV (Navision).  If you have further questions feel free to hit the chat button below.

What’s new in SAP Business One 9.0

Sunday, June 9th, 2013

New Features in SAP Business One 9

This is Issue One of Clients First Business Solution’s Blog Series, “What’s New is SAP Business One 9.0.”  Over the coming weeks, we’ll publish functional instructions for customers on how to leverage these new features in a working 9.0 version of SAP Business One.  If you have questions about the functionality or simply need assistance, click on the Chat Button below.

Issue One:  Update to Pricelists and Discount Groups

SAP Business One 9.0 pricelist and discount groups functionality has been enhanced to improve efficiency and support specific business processes. These new features allow more flexibility in setting and managing pricelist/special pricelists. These are optional however, and users can continue to use the same methodology as in the prior release. To accommodate new pricing options new fields has been added to the pricelist and discount tables (OPLN, ITM1, etc).

The most recent pricelist functionality can now handle the following:

·         Define pricelist as active or inactive

 

image

                                                                                      

(more…)

What’s new in Microsoft Dynamics NAV 2013

Wednesday, June 5th, 2013

Tue, Jun 18, 2013 11:00 AM – 12:00 PM EDT

Webinar Registration

Discover what’s in NAV 2013 in a one-hour, live webinar hosted by Clients First and Microsoft.  This webinar is a continuation of Clients First’s live webcasts directed towards current Dynamics NAV end-users. 

The webinar will cover:

  • New Workstation interface includes Web & SharePoint Client 
  • Role Tailored Client: easier setup, added security & End-User Charting
  • New “Embedded Excel Report Writer” for producing financial reports, KPIs & Dashboards 
  • New Software Modules included, new functionality enhancements 
  • New capabilities for Cash Flow Forecasting, Cost Accounting 
  • Upgraded intuitive Microsoft Office Ribbon Interface 
  • New OneNote & Office365 integration 
  • New Document Management and Image Processing integration 
  • New Trailing Sales Orders with Personalized Quick Entry

Click HERE to register!

Epicor 9 Customization now Available for Sale

Monday, May 20th, 2013

News from Insight 2013 last week in Nashville, Tennessee.

The following Custom Programming will start rolling out next week thru August 2013. These new extensions will be supported by support and will upgrade with the standard Epicor. Many of these extensions have been requested for years as part of standard Epicor. The following is copied straight out of the Insights agenda.

New Industry Extensions for Epicor 9 and Vantage/Vista

Industry Extensions are delivered separately from the core Epicor ERP modules.

  • LockBox
  • Positive Pay
  • Supplier Payments ACH Electronic File Format
  • MICR Checks
  • Cash Receipts ACH Electronic File Format
  • Payroll NACHA Direct Deposit
  • Payroll 3rd Party Interface
  • Handheld Pick to Light (Epicor 9 Only)
  • License Plating (Vantage/Vista only)
  • Lot Driven Forms (Epicor 9 Only)
  • Job Packing Material (Epicor 9 Only)
  • Auto Putaway Bin (Epicor 9 Only)
  • International Traffic in Arms Regulations (ITAR) (Epicor 9 Only)

If you are interested in these enhancements, please hit the chat button below and talk with us or leave a message.

Link a Customer and/or Vendor to a specific GL account in SAP Business One

Thursday, May 16th, 2013

 


Automatically apply a GL Income or Expense account when invoicing a customer in SAP B1

 

A customer recently approached one of our Implementation Consultants and asked, “How can I track revenue/expenses to a specific P&L GL account by customer/vendor?” While the Accounting Tab of the Business Partner Master allows the user to define Payables and Receivables accounts for each customer/vendor accordingly, it is not possible to assign specific Expense and Revenue accounts at the BP level.

 

Business scenario:

 

The customer needs to link a G/L account to his customers or vendors, so in the marketing documents, this account will be used automatically.

 

Solution:

 

Using a User Defined Field, assign a G/L account to the BP master records and default the account to the Marketing Document via a formatted search.

 

The solution varies for Items documents and Service documents.

 

  1. Create a user defined field in the BP master data as alpha numeric; for example UDF_GL and make sure that the UDF field # of characters correspond with the total characters of GL account in the COA.

clip_image002[4]

 

(more…)