RE: GP 2016 Web Client user can login but errors are showing up in SQL error log

by Derek Albaugh @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 11:00:15 PDT 2018

The Runtime Service uses the FQDN if it is a self-signed certificate or one created in CA. If using a third-party certificate, you could potentially have it setup however.

The fact that your users can login to Web Client, but get prompted for the GP login window means that Identity Management is not setup correctly. The 3 parts of this setup is:

1. In GP Utilities, you create a proxy login which then gets created in SQL with the DYNGRP role assigned for all system and company databases for GP.

2. When installing Web Client, this exact proxy login and password needs to be entered in the GP Configuration window, which shows the paths to your GP code directory, Dex.ini and Dynamics.set file.

3. Lastly, in the User Setup window in GP, the GP logins need to be tied/associated to the Windows account they are logging into Web Client's initial login window as.

If this is all setup correctly, then yes, when the user logs onto Web Client using their Windows account, it should see they are tied to a GP login and log them into the GP application automatically as that user, only seeing a company selection window if they have access to more than one GP company.

I'd verify the above 3 settings again, as most likely they are not correct. I'd also recommend not copying/pasting user ids and passwords as well, as I've seen that not always work.

Thanks

Upgrading Without Source Code Control?

by chadbruels @ Microsoft Dynamics GP - Recent Threads

Fri Mar 23 10:03:26 PDT 2018

In the near future I will be helping someone upgrade a development dictionary from GP 2013 R2 to GP 2016 R2. The environment does not have any source code repository, so I am writing today to explore options for a successful upgrade.

The help document for Dex Utilities states:

The Developer Update utility is no longer used to move integrating applications to new versions of Microsoft Dynamics GP. You must now use the source code control capabilities in Dexterity to update your integrating applications. Refer to the Integration Guide for a complete description of this process.

So I believe that option is not viable. I am interested in why that utility can no longer be used for this if anyone has background there.

Setting up a Generic provider in Source Control Options:

I feel the next easiest option would be defining a Generic provider in Dexterity. I have some assumptions about that I would like to ask about.

1. This will not provide version control, but that should not matter for this process.
2. It will allow us to check in the dictionary resources - pointing to a compressed 2013 R2 dictionary in the Original Dictionary field - which will simply store them as text files in a folder on the drive.
3. Then we can pull those resources "down" into a compressed copy of a 2016 R2 dictionary - pointing to a compressed 2016 R2 dictionary in the Original Dictionary field - and that should give us a proper upgrade. 
4. We always want to use an Index file. Is there any issue with doing that with a Generic provider? 

I feel this should be obvious, but I have always done this process with either Visual Source Safe or Team Foundation Server. 

Year End routine process cycled

by Juli @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 11:27:38 PDT 2018

Hi,

     A client is trying to run the year end process, but this never ends... I activated a SQL Tracer and it shows an insert in GL20001 table, but the proceess seems to be cycled, if I check the table I found the same records number and they don´t change the amounts for debit and credit columns, this process never ends and never execute the routine to copy from GL20000 to GL30000.

The versión of GP is GP2010.

Regards

Julia Gallegos

Expense accounting

by Steven Bragg @ Articles - AccountingTools

Mon Mar 26 16:24:00 PDT 2018

Expense accounting involves the proper recognition and recordation of a consumed expenditure or an incurred obligation. This process is critical to recognizing expenses in the correct amount and reporting period. The following activities are needed in expense accounting:

Consumed Expenditures - Occurs when a supplier invoice is received or cash payment made in exchange for goods or services.

1. Decide whether the amount is to be treated as an expense or asset. If the item can be consumed over multiple periods, it is likely to be treated as an asset.
2. If an expense, recognize it within the correct expense account, such as direct materials, supplies, or utilities.
3. If an asset, record it in either the prepaid expenses account (for short-term assets) or a fixed assets account (for longer-term assets).
4. If a prepaid expense, monitor it each month and charge it to expense as consumed.
5. If a fixed asset, charge a consistent portion of it to depreciation expense in each month, until it is fully consumed.
6. If no invoice has been received or payment made, there may still be an obligation to pay a supplier. If so, create a reversing journal entry that records an accrued expense in the current period, and reverses it in the next period. Doing so ensures that the expense is recognized in the correct period. When the invoice is received or payment made in the next period, it offsets the reversal, resulting in no net entry in the following period.

Incurred Obligations - Occurs when a business takes on an obligation to pay a third party.

1. Decide whether there is a probable obligation and the amount can be clearly determined. If so, record a liability. The offset to the liability is a charge to expense.
2. Review the obligation in later periods to see if the amount has changed. If so, adjust the liability and the offsetting expense.

The expense accounting noted here is used in an accrual basis accounting system.

Related Courses

Bookkeeper Education Bundle 
Bookkeeping Guidebook 

Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or via IM.

by Arfcorp @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 15:45:17 PDT 2018

Microsft GP 2016:

How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or using Integration Manager?

We have 200 customers and we bring in sales documents through IM. So, if I bring in 200 sales and about 25 credit memos. I would like to post the sales invoices, then post the credit memos and have them auto apply to the sales invoices. This way, when we bring in the cash receipts these will auto apply to the balance correctly. Currently, we are having to either manually auto apply or use apply sales documents.  I see a tool RM Auto Apply mentioned on forums - is this available for GP 2016? does this work?

Password Change Failed for an Unknown Reason

by john.ellisrsmus @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 18:05:59 PDT 2018

Hello: If the error "password change failed for an unknown reason" is not attributable toward group policies or other Active Directory items, what else could it be attributable toward? Thank you! John

Payroll batch with employer benefit contribution and no wages

by BillB5 @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 16:07:11 PDT 2018

Is it possible to run a payroll batch with just an employer benefit contribution and no wages?  Our management recently added a new healthcare plan that includes an HSA.  The company is going to contribute $25 a month to any employee who was employed for the entire month.  They have to verify the employee was employed for the whole month so the contribution will come the following month.  We need to be able to record the benefit contribution for W2s but they don't want to print a check for it, or include it with a normal payroll.  Any thoughts or suggestions would be greatly appreciated.

RE: GP 2016 Web Client user can login but errors are showing up in SQL error log

by Béat Bucher @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 10:43:13 PDT 2018

Derek,

Yes.. the SQL user login GPWebClient has the permissions in the security to access the DYNAMICS db and all the company DB's under the DYNGRP & Public role..

Regular GP user can fully login into the fat client without any issues.

When trying to use the web client, they do get prompted with the GP Login screen too, instead of selecting the company straight after the Windows login page..

Trying to select 'Directory Account' in the GP login rather then "SQL server account" returns the error pop-up "This login failed. Attempt to log in again or contact your system administrator."

Using the regular GP login in the WebClient works fine.. just defeats the purpose of the SSO..

Test mode and non-GP report with a Word template

by Emily H @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 20:03:45 PDT 2018

Hello,

I am trying to use the 'run report' statement in Dexterity to create a docx file.  This is my first word template, but I think I have it set up and permissions/access are allowing me to see my report in runtime when I select the Template in Report Destination window and name the output file.  I want to automate this, so the run report will go directly to the docx file without user interaction.  Test mode doesn't seem to know about the Template, it only has "Standard" in the drop down list.  Can this be done in Test Mode?  Or do I have to build a chunk and try it in runtime?

I saw in the old forums that Dave Dusek posted a video years ago on how to debug, but I get "This video is unavailable" from YouTube when I try the url.

BTW - I am working in GP 2018, but the filter below does not have that as an option.

Thanks,

Emily

Password Change Failed for an Unknown Reason

by john.ellisrsmus @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 18:05:59 PDT 2018

Hello: If the error "password change failed for an unknown reason" is not attributable toward group policies or other Active Directory items, what else could it be attributable toward? Thank you! John

UPR30100 and UPR30300

by WindyCityGP @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 06:58:56 PDT 2018

I have found a some payroll checks that are in the UPR30300, but not in the UPR30100; should that be posssible?  This is after I ran Checklinks across the payroll module.  Is there a script that I could run that would list out those transactions that are in the UPR30300 and not in the UPR30100?

Thank you.

Year End routine process cycled

by Juli @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 11:27:38 PDT 2018

Hi,

     A client is trying to run the year end process, but this never ends... I activated a SQL Tracer and it shows an insert in GL20001 table, but the proceess seems to be cycled, if I check the table I found the same records number and they don´t change the amounts for debit and credit columns, this process never ends and never execute the routine to copy from GL20000 to GL30000.

The versión of GP is GP2010.

Regards

Julia Gallegos

End of Year Checklist for Your Small Business

by April Marasco @ Howard Bank

Mon Nov 20 14:50:54 PST 2017

The end of the year is a good time to take stock of your business – review your accomplishments from this year and plan for next year. In this infographic, we’ll give you some ideas on getting started and what you might want to include in your checklist. Take a look, and build on this …
Read more →

Vendor Master Summary - Current Balance Calculation

by njstevenson86 @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 13:26:03 PDT 2018

A little background information: 

I'm working in an environment that has multiple GP 2010 instances setup (separate databases), and I've been asked to start developing consolidated AP reports directly from the SQL Databases. I've already successfully re-created the Historical ATB report for the Payment Module with an exact match, I'm now working on the Vendor Master Summary but cannot get the amounts on that to tie to the same amounts as my Historical ATB. Does anyone know how GP calculates that current balance, and from what tables? 

Thanks, 

Why I don't accept foreign checks (aka North American banking is a mess)

by noreply@blogger.com (Steve Endow) @ Dynamics GP Land

Tue Oct 24 11:36:00 PDT 2017

By Steve Endow

Several years ago, I received a paper check, in the mail, from a Dynamics partner in Canada.  The partner was paying my US dollar invoice, and thought they were doing me a favor by drafting the check from their US dollar bank account at their Canadian bank.

Send a check in US dollars to pay a USD invoice--makes sense, right?

Nosiree.

I attempted to deposit the check at my local Bank of America branch using the ATM.  The ATM would not accept the check.  So I went inside the bank, stood in line, and then told the teller I wanted to deposit the check.  The teller looked at the check, and confusion ensued.

Eventually a manager came over and explained to me, with full confidence, and in no uncertain terms, that they were unable to accept the check.  He explained that the problem was not that the check was from a Canadian bank.  He said that the problem was that the Canadian check was issued in US Dollars.  He claimed that because the country of origin did not match the check currency, the branch could not accept the check.  That's the policy. (no it isn't)

So...how can I deposit the check?

The manager handed me a special envelope and a triplicate carbon copy form.  He said I needed to fill out the form and mail it with the check to a super special obscure department at Bank of America called "Foreign Clean Collections"--whatever that means.  Once the check is received by that department, it will review the check and coordinate with the foreign bank to get the funds transferred.  This process will take 6-8 WEEKS.

You're kidding me, right?  Nope.

So, being curious about this banking train wreck, I gave it a try.  I filled out the form and mailed the USD $1,000 check off to the super special department.

A few weeks later, a deposit shows up in my account for $800.  Yup, $200 less than the check.  In addition to having to wait several weeks for the deposit, I was charged $200 in bank fees!

After that nightmare, I stopped accepting any foreign checks.  I put a big red note on my invoice that says that I only accept credit cards and wire transfers from non-US customers. And guess what: That process has been working just fine for years.

This week, a Canadian partner didn't read my invoice, and didn't read my email with the invoice, and they mailed me a paper check.  The check is from their Canadian bank, issued in US Dollars.  Great.

So I contacted a colleague who regularly receives Canadian checks, and she said that she routinely deposits Canadian checks issued in USD at her local BofA branch without any issues.  Huh.

But having paid my $200 entrance fee to the Bank of America Foreign Clean Collections Club, I wasn't about to just deposit this new check, wait several weeks, and see how much I get charged.

So I did the obvious thing:  I called my local Bank of America branch.

First customer service rep:  "Sorry, I don't deal with those things. Let me transfer you to our back office."  Apparently the back office doesn't have voicemail and is out to lunch at 9am, as the phone rang for 3 minutes with no answer.  I tried calling the branch back, but this time nobody answered and I got a voice response system.  So the local bank branches are useless when inquiring about these things.

So I then called the main BofA customer service 800 number.  I spoke with someone who tried very hard to help, but she was unable to find any information and her computer and phone were unable to contact the department who might be able to help.  So she gave me the phone number to the Bank of America Foreign Exchange Call Center.

I then directly called the illustrious Foreign Exchange Call Center and spoke with someone who, for the first time, sounded like he understood the mysterious process of depositing foreign checks with Bank of America.

"Can I deposit this Canadian check drafted in US Dollars at my local California branch?", I asked

"Every check is reviewed on a case by case basis.", he replied

What?  What does that even mean?

"Every check is reviewed on a case by case basis.", he replied

So you have no consistent policy about depositing foreign checks?

"Yes, we have a very consistent policy that I just explained to you.  Every check is reviewed on a case by case basis.", he replied


After speaking with him for several minutes and apparently annoying him, here is my understanding of the official Bank of America policy / procedure for foreign checks.

1. Acceptance of a foreign check is completely up to the discretion of the BofA branch, and the inconsistent and incorrect training that a teller or branch manager may have received.  The branch can simply say they don't accept foreign checks. Or they can conjure up an excuse as to why they can't accept the check, like "the country of origin does not match the check currency".

2. If the branch is willing to try to accept the check, they can scan the check in their "system".  This "system" then determines if Bank of America is willing to accept the check at that branch.  Apparently this involves super secret algorithms about my "relationship" with the bank, the physical check, the bank that issued the check, the country of origin, the currency, the amount, etc. 

3. If the "system" determines that the branch can accept the specific check, apparently the check will be deposited in a fairly normal manner.

4. If the "system" determines that the branch cannot accept the check, then the magical process with the Foreign Clean Collections department kicks in, and you get the multi-part form, special envelope, a 6-8 WEEK processing time, and hundreds of dollars in fees that you will not be able to determine in advance.

5. The representative claimed that Bank of America only charges a flat $40 for the Foreign Clean Collections process, but that the issuing bank can charge their own fees for having to process the foreign check.  In my case, I was charged around USD $150 by the issuing Canadian bank just for the honor of cashing their USD check.  There is realistically no way for you to know how much the foreign bank will charge in advance.

6. I asked the representative how I was supposed to accept payments given the uncertainty and fees involved in this process.  He told me that they recommend wire transfers for foreign payments, and basically told me not to accept foreign checks.

What a shocking conclusion.

Naturally, I have received several responses from people saying that they accept foreign checks all the time at their bank and never have an issue.  Good for you, I say, enjoy the 1900s!  The Pony Express loves you!

I rarely receive such checks, don't want to have to drive to the bank to deposit them, and don't want to deal with clueless bank employees and the nightmare game-of-chance process outlined above.

Checks are a vestigial organ of banking and are a testament to the absurdly anachronistic North American banking system.  Talk to someone from any country with a modern banking system and ask them how many checks they issue.  "Checks?  What?" will be the response.  People from Singapore and Australia literally laugh in disbelief when I mention that the US still uses paper checks.

Wire transfers have been well established since the late 1800s and now provide same day international funds transfers, usually for a reasonable fixed fee.  Credit cards are a defacto payment method for a massive volume of transactions for many countries, and have benefits like fraud protection and points, and the merchant pays the fees for those transactions--which I am happy to do.

And services like the excellent TransferWise provide very low cost EFT funds transfers to dozens of countries with an excellent exchange rate.

The only reason I have to explain why North American consumers and businesses seem to cling to checks is because our backwards banking system does not (yet) charge fees to shuffle around millions of pieces of paper with ink on them, pay the postage to mail them, scan those papers into digital images, and then perform an electronic funds transfer behind the scenes.  But they do charge a fee if customers initiate a payment electronically through EFT / ACH or a wire transfer and no paper is involved.  It's crazy.

So, after wasting a few more hours researching this topic, I now have a clear decree, straight from the heart of Bank of America, and will continue to accept only credit card and wire transfer payments from non-US customers.  If it's good enough for the rest of the world, it's good enough for me.

Blog Post: Robocup Junior WA 2018 Rescue Line Workshop

by David Musgrave @ Microsoft Dynamics GP

Tue Mar 27 18:00:00 PDT 2018

On the 15 th March 2018, the Robocup Junior WA Committee ran a Rescue Line Workshop at All Saints’ College . The workshop was a great success with a large turnout who enjoyed the session and learnt the basics of building a robot (both hardware and software) for the Robocup Junior Australia Rescue Line challenge. Below are the video recording and the links to the materials: RoboCup Rescue Line Workshop 2018 ( Direct Link ) For the Rescue Line presentation and related documentation please go to the following link: http://tinyurl.com/RCJWARescue If you are looking for documentation on Rescue Maze, please go to the following link: http://tinyurl.com/rescue-workshop Enjoy David This article was originally posted on http://www.winthropdc.com/blog .

RE: Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or via IM.

by L Vail @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 19:27:22 PDT 2018

Hi,

RM Auto Apply is indeed available for GP2016, it's downloadable from PartnerSource. It's probably also available from CustomerSource, I just don't know the link. I have it on my box account at app.box.com/.../mu5eghtaxgiin31o9win1icwme11qg57

Kind regards,

Leslie

Throughput definition

by Steven Bragg @ Articles - AccountingTools

Tue Mar 27 15:19:00 PDT 2018

Throughput is the number of units that pass through a process during a period of time. This general definition can be refined into the following two variations, which are:

• Operational perspective. Throughput is the number of units that can be produced by a production process within a certain period of time. For example, if 800 units can be produced during an eight-hour shift, then the production process generates throughput of 100 units per hour.
• Financial perspective. Throughput is the revenues generated by a production process, minus all completely variable expenses incurred by that process. In most cases, the only completely variable expenses are direct materials and sales commissions. Given the small number of expenses, throughput tends to be quite high, except for those situations in which prices are set only slightly higher than variable expenses.

For operations, throughput can be increased by enhancing the productivity of the bottleneck operation that is constraining production. For example, an additional machine can be purchased, or overtime can be authorized in order to run a machine for an extra shift. The key point is to focus attention on the productivity of the bottleneck operation. If other operations are improved, the overall throughput of the system will not increase, since the bottleneck operation has not been enhanced. This means that the key focus of investment in the production area should be on the bottleneck, not other operations.

For financial analysis, throughput can be increased by altering the mix of products being produced, to increase the priority on those products that have the highest throughput per minute of time required at the constrained resource. If a product has a smaller amount of throughput per minute, it can instead be routed to a third party for processing, rather than interfering with the bottleneck operation. As long as some positive throughput is gained by outsourcing, the result is an increased overall level of the throughput for the company as a whole.

Related Courses

Constraint Management 

Evaluation of internal controls

by Steven Bragg @ Articles - AccountingTools

Wed Mar 28 05:50:00 PDT 2018

An evaluation of internal control involves an examination of the effectiveness of an organization's system of internal controls. By engaging in this evaluation, an auditor can determine the extent of other tests that must be performed in order to arrive at an opinion regarding the fairness of the entity's financial statements. A robust system of internal controls reduces the risk of fraudulent activity, which moderates the need for additional audit procedures. The examination concentrates on such issues as:

• The separation of duties
• Checks and balances
• Safeguarding of records
• The training level and competence of employees
• The effectiveness of the entity's internal audit function

The steps involved in this evaluation process include the following:

1. Determine the extent and types of controls being used by the client.
2. Determine which of these controls the auditor intends to rely upon.
3. Based on the first two steps, determine which audit procedures should be expanded or reduced.
4. Make recommendations to the client regarding how to improve its system of internal controls.

The last of the preceding steps is useful for improving the control environment for the auditor in the following year's audit.

Related Courses

Accounting Controls Guidebook 

Forum Post: RE: Inventory Reconcile and QTY on Hand

by L Vail @ Microsoft Dynamics GP

Tue Mar 27 15:50:00 PDT 2018

Hi Tania, It is my understanding that the reconcile utility doesn't interact with the SEE30303 table. The reconcile utility goes through 6 steps. I know there is a KB out there, but I don't recall the number. Here's what I have in my notes as to what goes on in the reconcile: Quantities are reconciled between the Purchase Receipts Work (IV10200) and Purchase Receipts Detail (IV10201). In this step, Item Balance is calculated. If the in and out tables don’t match, RECON records are added to the Purchase Receipts Detail (IV10201). Item Balance is reconciled against the Serial/Lot Number Master Tables (IV002/300) Quantities are reconciled between the Purchase Receipts Work (IV10200) and the Item Quantity Master (IV00102). Quantities are reallocated according to several tables: Inventory Transactions Amounts Work (IV10001) Inventory Serial and Lot Number Work (IV10002) Sales Transaction Amounts Work (SOP10200) Sales Serial/Lot Work and History (SOP10201) Invoicing Transaction Amounts Work Invoicing Serial and Lot Number Work On order Qtys in the POP receipt and line tables are compared to the Item Quantity Master (IV00102) The Item Quantity Master (IV00102) is checked for internal consistency between site and record total Kind regards, Leslie UPDATE I just noticed I had an article about this on my blog http://dynamicsconfessions.blogspot.com/2011/11/reconciling-inventory-what-really.html The KB article is 874220. LV

Summer 2014

by Bart Rydzewski @ Greater Metro Federal Credit Union

Wed Dec 17 11:06:05 PST 2014

Summer 2014 Online Banking Upgrade On The Horizon! Annual Meeting Check Ordering The Magic Minute The VA Branch Schedule Have You Seen Them? Holiday Closings As we head into the summer of 2014, your Credit Union continues to work towards making your “Banking” experience better than a “Bank” experience. Getting directly to a specific Greater... Read more »

Winter 2015

by Bart Rydzewski @ Greater Metro Federal Credit Union

Fri Feb 20 07:15:29 PST 2015

New Greater Metro Plastics Board of Directors Elections EMV Chip Technology Remote Deposit Capture (RDC) Mobile APP The Annual Meeting CUC Mortgage A Redesigned Website Welcome New Members! Tax Refunds New Greater Metro Plastics – Coming Soon! Newly designed cards that were originally scheduled for delivery in the 4th Quarter of 2014 were delayed in... Read more »

How to Transfer an Image Onto Glass

by @ How to of the Day

Tue Mar 20 17:00:00 PDT 2018

Putting an image onto a glass object—such as a glass, mason jar, mirror, or window—is a way to personalize and decorate your living space. You can transfer any type of image that has been printed from a laser printer, or that you find in a book or magazine. To transfer an image onto glass, fix adhesive packing tape to the image you’d like to transfer. Soak the image and tape in warm water, then remove the paper and stick the image onto a glass object. Alternately, you can use a gel transfer medium to move the image directly on to a glass surface.

Deleting Stuck FA Purchasing Transactions

by TracySam @ Microsoft Dynamics GP - Recent Threads

Fri Mar 23 11:15:12 PDT 2018

Hi,

There are 2 transactions which appear to be stuck in the FA Purchasing table and are automatically added to any transaction I pull on from the Purchase window.  I can see the amounts if I click on the expansion beside Acquisition Cost.  I have checked the FA01100 table and they are not there.  They are also not the Purge Purchasing Transactions window.

How can I get rid of these transactions ?

Thanks

Human resource accounting

by Steven Bragg @ Articles - AccountingTools

Wed Mar 28 16:21:00 PDT 2018

Human resource accounting involves the tracking of all costs related to employees in a separate report. These costs may include the following:

• Employee compensation
• Employee payroll taxes
• Employee benefits
• Employee training

Such an accounting system can be used to determine where human resources costs are especially heavy or light in an organization. This information can be used to redirect employees toward those activities to which they can bring the most value. Conversely, the report can be used to identify those areas in which employee costs are too high, which may lead to a reduction in force or a reallocation of staff away from those areas.

A more comprehensive human resource accounting system goes beyond the simple tracking of employee-related costs, and addresses the following two additional areas:

• Budgeting. An organization's annual budget includes a component, in which is concentrated all employee costs being incurred from across the organization. By concentrating cost information by its nature, management can more clearly see the total impact of human resource costs on the entity.
• Employee valuation. Rather than looking at employees as costs, the system is redirected toward viewing them as assets. This can involve the assignment of values to employees based on their experience, education, innovativeness, leadership, and so forth. This can be a difficult area in which to achieve a verifiable level of quantification, and so may have limited value from a management perspective.

From an accounting perspective, the expense-based view of human resources is quite easy - employee costs from the various departments are simply aggregated into a report. The employee valuation approach is not a tenable concept for the accountant, since this is an internally-generated intangible asset, and so cannot be recorded in the accounting system.

Related Courses

Human Resources Guidebook 
Payroll Management 

The chart of accounts most suitable for a small company

by Steven Bragg @ Articles - AccountingTools

Mon Mar 26 16:31:00 PDT 2018

A smaller business can dispense with many of the more specialized accounts and instead use an abbreviated chart of accounts. By doing so, it can greatly simplify the chore of recording business transactions. The following list of accounts may be adequate for compiling an income statement and balance sheet under a double entry bookkeeping system. However, please note that there are nearly always special accounts used in some industries, which are not mentioned in the following list. The basic accounts are:

Assets

• Cash. Includes the balances in all checking and savings accounts.
• Accounts receivable. Includes all trade receivables. It may be necessary to also have an "Other Receivables" account for other types of receivables, such as advances to employees.
• Inventory. Includes raw materials, work-in-process, and finished goods inventory.
• Fixed assets. Can be subdivided into multiple additional accounts, such as machinery, equipment, land, buildings, and furniture.
• Accumulated depreciation. One account is generally used to compile the accumulated depreciation for all types of fixed assets.

Liabilities

• Accounts payable. Includes all trade payables due to suppliers.
• Accrued expenses. Includes all accrued liabilities, such as for wages and taxes.
• Sales taxes payable. Includes all sales taxes billed to customers, and to be remitted to the applicable local governments.
• Notes payable. Includes the remaining balance on all loans payable. For tracking purposes, it may be easier to create a separate account for each loan payable.

Equity (assumes a corporation)

• Common stock. Includes the amount originally paid by shareholders for their stock.
• Retained earnings. Includes all cash retained in the business from profits, which have not been distributed to shareholders.

Revenue

• Service revenues. Includes all sales related to the provision of services to customers.
• Product revenues. Includes all sales of products to customers.
• Repair revenues. Includes sales generated by repair work and the sale of spare parts to customers.

Expenses

• Cost of goods sold. This includes at least the material cost of items sold, and at a more sophisticated level, can include the cost of direct labor and allocated factory overhead.
• Salaries and wages. Includes the cost of all salaries and wages not already included in the cost of goods sold.
• Rent expense. Includes the cost of rent for building space, vehicles, equipment, and so forth.
• Utilities expense. Includes the cost of heat, electricity, broadband, phones, and so forth.
• Travel and entertainment expense. Includes the cost of travel, meals, housing, and related expenses incurred during employee travel on company business.
• Advertising expense. Includes advertising and other marketing expenses.
• Depreciation expense. Includes the expense related to depreciation. This is a non-cash expense.

Non-Operating Revenues and Expenses

• Interest income. Includes income on all invested funds.
• Interest expense. Includes interest paid and accrued on debts owed by the company to lenders.
• Gain on sale of assets. Includes any gains on the sale of assets.
• Loss on sale of assets. Includes any losses on the sale of assets.

It is best to consult with a CPA who understands a company's industry to see if any additional accounts should be added to this list. In general, however, the preceding chart of accounts should be sufficient for a small company.

Related Courses

Bookkeeping Guidebook 
New Controller Guidebook 

Deferred asset

by Steven Bragg @ Articles - AccountingTools

Tue Mar 27 09:12:00 PDT 2018

A deferred asset is an expenditure that is made in advance and has not yet been consumed. It arises from one of two situations:

• Short consumption period. The expenditure is made in advance, and the item purchased is expected to be consumed within a few months. This deferred asset is recorded as a prepaid expense, so it initially appears in the balance sheet as a current asset.
• Long consumption period. The expenditure is made in advance, and the item purchased is not expected to be fully consumed until a large number of reporting periods have passed. In this case, the deferred asset is more likely to be recorded as a long-term asset in the balance sheet.

Examples of expenditures that are routinely treated as deferred assets are:

• Prepaid insurance
• Prepaid rent
• Prepaid advertising
• Bond issuance costs

The reason for treating expenditures as deferred assets is that they would otherwise be charged to expense before the related benefits had been consumed, resulting in inordinately high expense recognition in earlier reporting periods, and excessively low expense recognition in later periods.

The deferred asset concept is not applied when a business uses the cash basis of accounting, since expenditures are recorded as expenses as soon as they are paid for under that method. Thus, these items would be charged to expense at once under the cash basis of accounting.

It is easy to forget about deferred asset items that are sitting on the balance sheet, which means that there tends to be a large write-off of these items at year end, when accounts are being examined by the auditors. To avoid this potentially large write-off, track all deferred asset items on a spreadsheet, reconcile the amounts on the spreadsheet to the account balance listed in the general ledger at the end of each reporting period, and adjust the account balance (usually with a periodic charge to expense) as necessary.

To avoid the labor associated with tracking deferred assets, consider adopting an accounting policy under which expenditures falling beneath a minimum amount are automatically charged to expense.

Related Courses

Bookkeeper Education Bundle 
Bookkeeping Guidebook 

Check out our It’s Me 247 Bill Pay Service!

by Bart Rydzewski @ Greater Metro Federal Credit Union

Thu Mar 24 11:05:52 PDT 2016

Check out our It’s Me 247 Bill Pay Service! Did you know you can pay your bills through It’s Me 247 Online Banking? If you are not using it yet, you are just few steps away from getting started with our Bill Pay! On our It’s Me 247 Bill Pay you can:  – Pay bills online 24/7 from... Read more »

Forum Post: Vendor Master Summary - Current Balance Calculation

by njstevenson86 @ Microsoft Dynamics GP

Tue Mar 27 13:26:00 PDT 2018

A little background information: I'm working in an environment that has multiple GP 2010 instances setup (separate databases), and I've been asked to start developing consolidated AP reports directly from the SQL Databases. I've already successfully re-created the Historical ATB report for the Payment Module with an exact match, I'm now working on the Vendor Master Summary but cannot get the amounts on that to tie to the same amounts as my Historical ATB. Does anyone know how GP calculates that current balance, and from what tables? Thanks,

RE: Void Direct Deposit Check

by Mahmoud Saadi @ Void Direct Deposit Check

Wed Feb 19 10:59:17 PST 2014

Check this out;

Why Can't I Void a Payroll Check/Direct Deposit

RE: Year End routine process cycled

by Juli @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 10:14:26 PDT 2018

Hi Mariano, GP is in SP1 and is running in the GP client server, now I have a test server to check the problem we are closing 2016 year, but the user reported the close year for 2015 was fast.

I found in SY00500 table a record with Bachnumb= GL Closing, I needed to delete this record in order to run the close year to 2016, maybe some information is incorrect or some else in tables is in incorrect, I don´t know if this can be a problem.

Last night was running the process but It doesn´t finish, and I only found the GL20001 table updated

Regards

Julia

Test mode and non-GP report with a Word template

by Emily H @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 20:03:45 PDT 2018

Hello,

I am trying to use the 'run report' statement in Dexterity to create a docx file.  This is my first word template, but I think I have it set up and permissions/access are allowing me to see my report in runtime when I select the Template in Report Destination window and name the output file.  I want to automate this, so the run report will go directly to the docx file without user interaction.  Test mode doesn't seem to know about the Template, it only has "Standard" in the drop down list.  Can this be done in Test Mode?  Or do I have to build a chunk and try it in runtime?

I saw in the old forums that Dave Dusek posted a video years ago on how to debug, but I get "This video is unavailable" from YouTube when I try the url.

BTW - I am working in GP 2018, but the filter below does not have that as an option.

Thanks,

Emily

Forum Post: Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or via IM.

by Arfcorp @ Microsoft Dynamics GP

Tue Mar 27 15:45:00 PDT 2018

Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or using Integration Manager? We have 200 customers and we bring in sales documents through IM. So, if I bring in 200 sales and about 25 credit memos. I would like to post the sales invoices, then post the credit memos and have them auto apply to the sales invoices. This way, when we bring in the cash receipts these will auto apply to the balance correctly. Currently, we are having to either manually auto apply or use apply sales documents. I see a tool RM Auto Apply mentioned on forums - is this available for GP 2016? does this work?

Getting an error while creating invoice header in GP

by Priyank Bhavsar @ Microsoft Dynamics GP - Recent Threads

Mon Mar 26 06:26:54 PDT 2018

I'm trying to create an invoice header by calling the procedure 'taSopHdrIvcInsert'. It is giving me the following error:

The INSERT statement conflicted with the CHECK constraint "CK__SY00500__GLPOSTD__59F03CDF". The conflict occurred in database "TWO", table "dbo.SY00500", column 'GLPOSTDT'.
The statement has been terminated.

I googled about this error and found that it has something to do with the DocDate.

I'm passing the DocDate like below

cmd.Parameters.AddWithValue("@I_vDOCDATE", dtDocDate.ToString());

Any help would be appreciated.

Blog Post: Setting a New Default Checkbook

by L Vail @ Microsoft Dynamics GP

Tue Mar 27 13:34:00 PDT 2018

So, you’ve changed banks and opened a new account. Now it’s time to create a new checkbook in GP and assign it as the default Checkbook ID. No problem, you’ve got this: Create a New GL Account Create a New Checkbook ID Assign the new Checkbook as the default. This is where the trouble starts. Where in the world can you set the default company Checkbook ID? The truth is, there is no single place to set the default Checkbook ID. You need to set it in several places if you want to use the same checkbook for all of the modules. Each of the following modules has a default checkbook setting. Payables Management Purchasing | Setup | Payables Receivables Management Sales | Setup | Receivables Sales Order Processing Sales | Setup | Sales Order Processing Payroll HR & Payroll | Setup | Payroll | Payroll Bank Reconciliation Financial | Setup | Financial | Bank Reconciliation Now, you need to check to see if you have any checkbook default identified on the Vendor card or Customer card. When processing a receivables or SOP transaction, GP will look for a checkbook ID at the customer card first. If it doesn’t find one there, it will look to the Receivables Management Setup window or the Sales Order Processing Setup window, depending on what kind of transaction you are entering. For payables, it will look first to the Vendor card and then to the Payables Setup window. You should never have the same Checkbook ID on a card that you have on the setup window. Let the program do the work for you. Only put a separate Checkbook ID at the card level if you have an exception from your usual checking account. If you find that you do have a Checkbook ID set on the cards and want to remove it, you can use the Class ID to remove it and then roll down the changes. If you have too many classes to do it manually, or no classes at all, you can use SQL to remove the Checkbook IDs. Your update statements would look similar to those below if you wanted to remove them all. For Vendors: UPDATE PM00200 SET CHEKBKID = '' For Customers: UPDATE RM00101 SET CHEKBKID = '' If you are using a third-party product such as Mekorma MICR or BGE Green Payable there will be other places where you’ll need to change the default. Take a look at the setup screens for any add-on products you are using and look for a Checkbook ID setting. If you find some other places where the Checkbook ID may need to be changed, please leave a comment and I’ll include it in the body of the post. Live the dream! Leslie

Mobile App and Remote Deposit Capture

by Bart Rydzewski @ Greater Metro Federal Credit Union

Tue Oct 03 13:26:27 PDT 2017

Download the Greater Metro FCU Mobile App from either Apple App Store, Android Google Play or Amazon Appstore on your device. In your store’s search, type in “Greater Metro FCU”, and you will find the free app. Remote Deposit Capture is part of the Mobile App and will allow you to deposit checks without visiting... Read more »

Vendor Master Summary - Current Balance Calculation

by njstevenson86 @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 13:26:03 PDT 2018

A little background information: 

I'm working in an environment that has multiple GP 2010 instances setup (separate databases), and I've been asked to start developing consolidated AP reports directly from the SQL Databases. I've already successfully re-created the Historical ATB report for the Payment Module with an exact match, I'm now working on the Vendor Master Summary but cannot get the amounts on that to tie to the same amounts as my Historical ATB. Does anyone know how GP calculates that current balance, and from what tables? 

Thanks, 

Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or via IM.

by Arfcorp @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 15:45:17 PDT 2018

Microsft GP 2016:

How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or using Integration Manager?

We have 200 customers and we bring in sales documents through IM. So, if I bring in 200 sales and about 25 credit memos. I would like to post the sales invoices, then post the credit memos and have them auto apply to the sales invoices. This way, when we bring in the cash receipts these will auto apply to the balance correctly. Currently, we are having to either manually auto apply or use apply sales documents.  I see a tool RM Auto Apply mentioned on forums - is this available for GP 2016? does this work?

No Records in Table SY09400 - GP2016

by Anvar @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 04:00:04 PDT 2018

All,

I couldn't see the below option in GP 2016 to generate the records in table SY09400. 

1. Click Microsoft Dynamics GP, point to Maintenance, and then click Clear Data to open the Clear Data window. 
2. On the Display menu, click Physical.  
3. In the Series list, click System.  
4. In the Tables pane, click the Security Resource Descriptions table, and then click Insert.   
5. Click OK.   
6. Click Yes.   
7. In the Report Destination window, select the Screen check box, and then click OK to send the report to the screen.   
8. Close the report.

Please advice.

Thanks,

Anvar

Forum Post: RE: Microsft GP 2016: How do I Auto Apply Credit Memos to the open Sales document of a customer? directly in GP or via IM.

by L Vail @ Microsoft Dynamics GP

Tue Mar 27 19:27:00 PDT 2018

Hi, RM Auto Apply is indeed available for GP2016, it's downloadable from PartnerSource. It's probably also available from CustomerSource, I just don't know the link. I have it on my box account at app.box.com/.../mu5eghtaxgiin31o9win1icwme11qg57 Kind regards, Leslie

Same Day ACH – Does it Impact Me?

by April Marasco @ Howard Bank

Wed Sep 06 06:33:40 PDT 2017

For those following the new rules towards the processing of ACH transactions, it’s no surprise to you that Same Day ACH will now apply to debit transactions in addition to credit transactions starting at the beginning of September.  For those who perhaps haven’t been following this as closely (it’s okay, we understand), let’s back up …
Read more →

RE: Getting an error while upgrading Dynamics GP company database to 2016R2

by Preetham theGP @ Microsoft Dynamics GP - Recent Threads

Tue Mar 27 12:16:11 PDT 2018

Beat,

Thanks for your help but i am having issues again though i updated to 2230. Same errors again, please find below. Please let me know if you have any comment.

"There was a problem ascertaining product version information Microsoft Dynamics GP Utilities will now exit. Please check the duinstall.log file for more information"

When i checked duiinstall.log file here is the error i have noticed,

"Failure encountered ON 3/27/2018 at 2:12:16 PM.  Error:  Product 0 does not support upgrading from version 12.0.2230."

Payroll records

by Steven Bragg @ Articles - AccountingTools

Tue Mar 27 12:00:00 PDT 2018

Payroll records contain information about the compensation paid to employees and any deductions from their pay. These records are needed by the payroll staff to calculate gross pay and net pay for employees. Payroll records typically include information about the following items:

• Bereavement pay
• Bonuses
• Commissions
• Deductions for pensions, benefits, charitable contributions, stock purchase plans, and so forth
• Direct deposit information
• Gross wages
• Hours worked
• Manual check payments
• Net wages paid
• Salary rates
• Vacation and/or sick pay

The information in payroll records have traditionally been stored on paper documents, but can also be recorded as electronic documents.

Payroll records can be considered a subset of the information stored in human resources records, which can contain considerably more information than items pertaining to just employee pay and deductions.

The time period over which payroll records must be retained will depend upon government requirements. The Internal Revenue Service typically states a required retention period in each document it issues dealing with payroll issues. In general, wage calculations should be retained for two years, while collective bargaining agreements should be retained for three years.

Related Courses

Payroll Management