Founder and principal of East Coast Dynamics, a Microsoft Certified Business Professional - GP, Microsoft Certified Trainer and Microsoft MVP.
Syndicated From:
http://gp2themax.blogspot.com/ January 2010 - Posts
-
I ran into an issue today I've never noted before. I was trying to figure out why the budget in an FRx P&L report didn't match the budget figures in my Excel budget file. After a short amount of investigation, I realized that not all the accounts...
Read More...
|
-
Debi Carlton of D1 Technologies posted this solution on one of the GP forums recently - 1. Insert the image in a Word document 2. Use the Custom watermark option in format to create the watermark image 3. Copy the image and paste in Paint 4. Save the...
Read More...
|
-
There are a number of conditions that must exist before you can delete an item from the item master. You must make sure that - 1. No quantities of the item are on hand at any site. 2. The item is no longer assigned to any site. Refer to 'Deleting...
Read More...
|
-
If you encounter this error when trying to access a BOM in BOM Entry, here's how to spot the offending BOM. Transactions>Manufacturing>Bill of Material>Security * click image to enlarge All activity on any BOM will appear in this window....
Read More...
|
-
Sometimes you need to be able to change the item description on a purchase order line and have that modified description appear on the printed PO. The standard PO form does not support this because, although you can change the description on the PO line...
Read More...
|
-
I ran into this error in FRx for the first time the other day when I was changing account masks in the Row Format and Reporting Tree of a report. The customer has just gone through an account format change and all the existing reports had to be re-created...
Read More...
|
-
Part of setting standard costs involves entering setup times in the routings. Don't forget to set your normal run quantities or your cost rollup will create inaccurate standard costs for your manufactured items. A prerequisite to entering your normal...
Read More...
|
-
Occasionally, the GP system password is forgotten or lost. This password is required to make changes at the system level, such as adding a new user, changing user security, etc. Here's how to recover when this happens. 1. In SQL Management Studio...
Read More...
|
-
I get this question on a fairly regular basis. My response always is - what do you want to use the printer for? Invariably, the use is printing checks, invoices, etc, etc, etc. My recommendation is always - HP LaserJet. You just can't go wrong with...
Read More...
|
-
Need to reference the transaction(s) associated with a particular Audit Trail Ccode but can't seem to find a report that gives that to you? Let's use Account Transactions in SmartList as an example. Open the SmartList, then add this column - TRX...
Read More...
|
-
Should you need to change the valuation method on one, many, or all your inventory items, go Tools>Utilities>Inventory>Change Valuation Method * click image to enlarge Select the valuation method you want to change the item(s) to, enter the item...
Read More...
|
-
Here's a little tip I learned long ago in GP training. Posting Settings can be a little confusing at times . . . Tools>Setup>Posting>Posting * click image to enlarge If you choose to allow transaction posting vs. batch-only posting, even...
Read More...
|
-
Somewhere along the line in GP10, the prior behavior of account lookups (where you type in the first few digits of the account, click the lookup button and it takes you to the beginning of the range) went wacky such that the lookup takes you to the very...
Read More...
|
-
Have you ever posted a payables or receivables transaction into a future, non-existing fiscal period? Wish you could prevent that happening again? You can. Contact your GP partner or Microsoft Business Services. MBS provides a free utility called DocDateVerify...
Read More...
|
-
Prior to manually closing POs, check two things - 1. That all periods for the most recent historical year are closed for the Financial series, and/or 2. That posting settings for Edit PO are set to Post To and not Post Through the GL If any of the POs...
Read More...
|
-
When you make changes to depreciation-sensitive fields in an asset book record, depreciation needs to be recalculated. Changing any of the following fields requires recalculation – • Amortization Code • Amortization Amount • Averaging Convention • Cost...
Read More...
|
-
Tired of changing the Transaction Type in Sales Transaction Entry every time you open the window? Try this - Tools>Setup>System>User Preferences * click image to enlarge Select the appropriate Doc Type for you, click OK. From this day forward...
Read More...
|
-
Generally, GP doesn't allow deleting a vendor if there are any history transactions for that vendor. In most cases, this is a good thing because who wants stranded history transactions in their database? However, if you have a really compelling reason...
Read More...
|
-
Now's the time of year when many of us are reconciling our GL accounts to get ready for external auditors and closing the year. I personally spend a lot of time with my clients helping them reconcile Cash, AR, AP, and Inventory. Until now, it's...
Read More...
|
-
Contrary to what intuition would tell you, closed purchase orders do not automatically move to history as do most other documents in GP. Over time, the number of closed POs in the open tables accumulates, slowing down search and lookup functions. If you...
Read More...
|
-
If you find yourself needing to 'copy' SmartList Builder objects from one GP instance to another, here's how to do it. In the instance in which the SLB objects to be copied exist, go Tools>SmartList Builder>Export * click image to enlarge...
Read More...
|
|
|
|
|
|
|
|