Modified GL Transaction Entry window available

I just uploaded a modified GL Transaction Entry window to the GPUG Share my code site. Here’s the link:

http://community.gpug.com/Go.aspx?c=ViewDocument&DocumentKey=93cb4f9c-3c1e-4082-bf7b-5548d0c162d0

Here’s what it looks like:

image

If you cannot access this on GPUG, and would like a copy of the .package file, please send me an e-mail. leslievail@earthlink.net

Enjoy!

Leslie

Continue reading here:
Modified GL Transaction Entry window available

June 3, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 246

Customer (Sales) Posting Accounts

Here’s a document I did a bit ago to help explain what the posting accounts meant as an aid to setting up a new installation.

We’ll start with the SOP Setup window.

clip_image002

If you use Sales Order Processing or Invoicing, choose whether to use the posting

accounts for:

• Sales from the customer or the item

• Cost of Sales from the customer or the item

• Sales Returns from the customer or the item

Sales > Cards > Customer (Accounts Button)

clip_image004

About Customer Accounts

The accounts entered on a customer card are used to default on to a transaction. Cash is always defaulted from the Checkbook If the Checkbook radio button is highlighted as in the screenshot above. If you do not have an account specified on the Customer Account Maintenance, the system looks to the company posting account defaults from the Posting Accounts Setup window (below). You will notice that not every account on the Posting Accounts Setup window appears on the Customer Account Maintenance window.


Administration Series > Setup > Posting > Posting Accounts

clip_image006

Accounts Receivable

The default account that receivable amounts for this customer will be posted to.

DR Accounts Receivable

CR Sales

Sales

The default account where sales amounts for this customer will be posted. In SOP, this account is used only if ‘Posting Accounts From’ is set to Customer.

DR Accounts Receivable

CR Sales

Cost of Sales

The default account where cost of sales amounts for this customer will be posted. The dollar amount of ‘Cost of Sales’ is not determined until the Invoice is actually posted. This is because the cost is not known until the invoice is posted. The FIFO layer cost is not known. This is a Cost of Goods Sold account. In SOP, this account is used only if ‘Posting Accounts From’ is set to Customer.

DR Cost of Sales

CR Inventory

Inventory

I have never found a use for this account because Inventory is always taken from the item. If you know when it defaults in, please let me know :).

Terms Discount Taken

Terms discounts might be offered to your customers as an incentive to pay their account balances before the due date. In order to use this account as a default the ‘Track Discounts Available in General Ledger’ must be selected on the Receivables Setup window. This is typically an expense account.

DR Cash

DR Terms Discount Taken

CR Accounts Receivable

CR Terms Discount Available


Terms Discount Available

Terms discounts might be offered to your customers as an incentive to pay their account balances before the due date. In order to use this account as a default the ‘Track Discounts Available in General Ledger’ must be selected on the Receivables Setup window. This is an Asset account typically included in the Accounts Receivable category.

DR Accounts Receivable

DR Terms Discount Available

CR Sales

Finance Charges

If finance charges are assessed on this customer, this is the account that will be credited. This is typically an income account.

DR Accounts Receivable

CR Finance Charges

Writeoffs

This account is used when a customer doesn’t pay the full balance on a document and the remainder is written off. This is typically a bad debt expense account, or a debit to the reserve for bad debts contra asset account.

DR Writeoffs

CR Accounts Receivable

Overpayment Writeoffs

This account is used when a customer pays more than the full balance and the overpayment is taken into income.

DR Accounts Receivable

CR Overpayment Writeoff


Sales Order Returns

This account is used when return documents are used in sales transactions. This is typically a contra account to sales revenue. Often, it is taken against Sales instead of using a separate account.

DR Sales

CR Sales Returns

Read More:
Customer (Sales) Posting Accounts

May 26, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 289

The Dynamics GP Blogster in Johannesburg, South Africa

My travels will take me to the beautiful and cosmopolitan city of Johannesburg, South Africa to conduct Microsoft Dexterity training for customers in the area. I will be there from Sunday May 25, 2014 through Saturday, May 31, 2014 and I am looking forward to meet a number of you.

I will be available in the afternoons after 6:00 PM local time and as time permits. For those of you who decide to tag along for dinner or otherwise, table topics are fairly open. If you are a prospective customer considering Microsoft Dynamics GP and would like some insight, please feel free to drop by as well. Please feel free to contact me by adding your comment to this blog and I will get in touch with you or click the email button on the right.
 
Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Taken from:
The Dynamics GP Blogster in Johannesburg, South Africa

May 25, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 298

New Dex.ini switches added to the list

Thanks to Rick Kohler I can add some new Dex.ini switches to my collection. The switches below control the behavior of the HITB (Historical Inventory Trial Balance) tool.

HITB_SkipReconciles=TRUE

Enables Step 2 without having to complete all of the reconciles. Thanks to Rick Kohler for this switch.

HITB_SkipErrorChecking=TRUE

Enables Step 3 regardless of whether errors exist during the data integrity checks. Thanks to Rick Kohler for this switch.

HITB_SkipClearingTransactions
=TRUE

Allows user to perform Step 5 regardless of whether balances still exist in the inventory accounts. Thanks to Rick Kohler for this switch.

HITB_SkipVersionChecks=TRUE

Allows the user to enter the window if on a version previous to build 1061. Thanks to Rick Kohler for this switch.

HITB_DebugFile=c:somefile.txt

Used to create a detailed debug log of the reset dictionary (Dynamics GP must be re-launched to take effect):

Taken from:
New Dex.ini switches added to the list

May 20, 2014 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 347

Tech Tuesday: Table Links in Extender

Our Product Specialist, Nicole Albertson, dives deeper into Table Links in Extender for this week’s Tech Tuesday below:

Extender includes the option for Table Links. Linking an Extender Window to a table ensures that the Extender Window’s data is deleted when the corresponding table record is removed. 

How many tables can you link?
A window can be linked to one or more tables. When it is linked to more than one table, the Extender Window’s data will only be deleted when there is not a corresponding record in any of the linked tables. 

How does it work with Work/Open/History?
If you link an Extender Window to a work table and not the corresponding history table, the Extender data will be deleted when the record is posted because the data is removed from the work table during the posting process. The key is to make sure that you link to the table for each Work, Open, and History so that the data doesn’t get removed in the posting process.

Example:
If you create an Extender Window on the Item Maintenance window in Microsoft Dynamics GP, you may want to add a Table link to the Item Master. This will trigger Extender to remove the data you have entered in the Extender Window for that specific item when the Item is deleted in GP. So, for example, I have an item called ‘100XLG’ and I have entered data into the Extender window for that item. When I delete ‘100XLG’ from GP, the Extender data will be removed as well with the table link in place. If I don’t have the table link, the Extender data would remain even though the item had been deleted.

In Extender 2013, the Table Links can be setup on a window by going to the Options button.

In Extender 10 and 2010, you can access the table links in the setup of the Extender Window by going to the Options menu and selecting Table Links.

Want more Extender information? Please feel free to reach out to us at sales@eonesolutions.com for more!

Read More:
Tech Tuesday: Table Links in Extender

April 22, 2014 · Nicole Albertson · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 317

Changes and New Opportunities at eOne

Many of you will have noticed this week that Lauri is no longer answering the phones when you select renewals on our automated phone system. Lauri finished up with eOne last Friday and has moved on to some new and challenging opportunities. I think in the end collecting endless numbers of $200 payments become too easy with such good resellers – so Lauri has moved to a position where she can use her persuasive and negotiating skills to collect much larger outstanding amounts.

We will miss Lauri’s energy and passion.

For right now please address all emails to renewals@eonesolutions.com rather than directly to Lauri’s personal email account. The phone numbers remain unchanged 888-319-3663 (press 4 for renewals). Our team of Danielle, Alicia and Naomi will be ready to answer all your questions and queries on renewals. You will receive the same fast response times and great service you have been used to.

When one journey stops, new opportunities always emerge. So at eOne we are taking the opportunity to change the way we handle this role of AEP collecting. We will announce more details over the coming weeks – but this role is going to become more of a partner advocate role split across more eOne team members. These advocates will be working with you on both AEP payments, but also on a whole range of other topics like access to support, training needs, marketing activity, etc. This is going to be an exciting change in the way eOne does business that I am very sure will bring many benefits to our resellers.

More details to come as we roll out these changes.

You’ll need Skype CreditFree via Skype

See original article:
Changes and New Opportunities at eOne

April 21, 2014 · Martin · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 274

Tech Tuesday: Using a Go To that Populates a Microsoft Dynamics GP Combo Box

This week’s Tech Tuesday is by our Quality Assurance guru, Jared Dux, who gives a great example of how to set up a Go To properly on the Account Summary SmartList in SmartList Builder.

Sometimes when setting up a Go To in SmartList Builder the value trying to be passed is not populated in the Microsoft Dynamics GP window being targeted. This usually happens when the wrong data is used. A good example of this is the Detail Inquiry window in Microsoft Dynamics GP. The year field is required, but the combo box expects a string rather than an actual date, so selecting a date field in your Go To setup will not function properly. The example below will describe how to set up the Go To properly on the Account Summary SmartList.

Set up a calculated field to make the Year a string

  1. Enter Year_Calc as the Field Name 
  2. Set the field type to String
  3. Add the year field as the Calculation like: Account Summary:Year 
  4. Save the calculated field

Set up the Go To


  1. Add a new Open Form Go To
  2. Name your Go To, select Microsoft Dynamics GP as the Product, select Financial as the Series, and select Detail Inquiry as the Form.
  3. Add a task to populate the Account Number
    • Select Set a field value and run the field script for the Task Type
    • Select Account Number as the Field
    • Select Account Summary as the Table
    • Select Account Number as the Value and save the task
  4. Add an additional task to populate the date with the calculated field
    • Select Set the value of a field for the Task Type
    • Select Current Year CMB as the Field
    • Select Calculated Fields as the table
    • Select Year_Calc as the Value and save the task
When the Go To is used now, the year will be populated in the target window and the correct data will be returned.
Curious to learn more about SmartList Builder? Email sales@eonesolutions.com to learn more!

Continue reading here:
Tech Tuesday: Using a Go To that Populates a Microsoft Dynamics GP Combo Box

April 8, 2014 · Frank Hamelly MCP-GP MCT MVP · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 254