Microsoft Dynamics GP Forum - Recent Threads

RM Detail Historical Aged TB

Ganesh K — Tue, 21 May 2013 14:39:03 GMT

Hi,

while i print this report, the values are not being displayed in some buckets but the values are reflected in the total for the customer. Please can anyone help me on this. GP version is 10.0.Please have a look into the screen shot

Thanks & Regards,

Ganesan.

Create posted RM document

Adriaan Davel — Mon, 06 May 2013 12:26:41 GMT

Hi, I need to create posted RM documents (I specifically do not want to use eConnect and post), is there any knowledge base documents or other reference material out there that will explain how to do this?

Color Setting for multiple companies

Katie Pieczynski — Thu, 16 May 2013 19:37:36 GMT

I am trying to change the color settings for each of our companies.

For example Company A I have the Drop Menu Background a light grey.

Company B I want red and Company C I want blue. I am logged in as SA in Company A and if I make changes to company A it takes effect. If I then pick a different company (wile I am still in Company A) it does not make the changes. If I physically log into Company B or C I do not get the option for color settings under the administrative tab. Can anyone shed some light?

Thank you

I need some help running the following reports in GP

Mian Sufian MCT — Wed, 15 May 2013 05:42:38 GMT

I need some help running the following reports in GP:

1. Income Statement as of 12/31/2012 for the 12 month

2. Balance Sheet as of 12/31/2012

3. Cumulative General Ledger for 2012

4. Trial Balance as of 12/31/2011 (Summary-Totals only)

5. Trial Balance as of 12./31/2012 (Summary- Totals only)

Year End Close Journal Entry in Wrong Year

AddisonEd — Tue, 21 May 2013 17:25:15 GMT

I was preparing to make the final changes to 2012 and close that year when GP made me close 2011 again. When that happened, the year end journal entry posted to period 12 of 2011 instead of period 0 of 2012. I now have beginning balances in 2012 that are correct but the ending balances in 2011 are wrong.

I have a hunch that when GP made me close 2011 (a historical year) something went wrong and the rollforward didn't go to 2012. I have been trying to figure this out for a while now and any help would be great.

Workflow Registration

Travis — Wed, 22 May 2013 01:28:18 GMT

Hi Guys,

I have a client who wants to start using workflow and I can't see anywhere if they are registered for it or not. Is this a product that needs registration or will it just work as long as GP is registered?

GP 2010 is their version.

MS Forecaster User recreation

PM CCS — Wed, 22 May 2013 00:30:13 GMT

Has anyone seen a problem with recreating a user and assigning them to a group, where they are the only people not to see any data in forecaster?

GP 10 Memory Error

LuisJahn — Tue, 21 May 2013 20:50:03 GMT

Hello we have GP10 with the latest Service Pack working fine. We have one workstation that made some custom reports and we´re trying to export those to the rest of the workstations.

However, every time we try to use Tools/Personalization/Maintenance to export the reports we get a "Memory Error" message besides each report on the results window.

It does not matter if we try to export one or 20 reports, the result is the same. It's worth noticing that the same workstation works fine with every other GP 10 feature except this one.

Also is worth noticing that the process actually creates an export package however we do not have any means to know if the package is correct.

Please help us, we haven't found any articles online referring to this issue.

Thanks

Electronic Reconcile 'Record type match not found' error

Alicia Berglund — Mon, 08 Apr 2013 15:37:53 GMT

Have just setup Electronic Reconcile in GP 10 for the first time. The bank does not provide a Record Type Code or a transaction code in the file. Are these required? When attempting to download we receive an error 'Record type match not found'. Any help would be greatly appreciated!

Error message on Integration manager

George Wang — Tue, 21 May 2013 20:23:13 GMT

Hi, Guru,

We run GP 11 with Integration manager. Currently two users run IM and try to post records. They got

Error message “Could not update; currently locked.” Two users close GP and IM, and reboot their PCs.

They got the same message when running IM.

I appreciate for any help!

George W

Delete Vendor EFT Info

Jennifer Wheeler — Tue, 21 May 2013 19:43:02 GMT

We have a vendor who wanted to start receiving checks from us instead of EFT for payments. I didn't find anyway to completely delete the EFT info from the vendor within GP. We went into the Vendor EFT Bank Maintenance window and cleared out the info but we still couldn't get a check batch built that would include this vendor. The only way I found to completely delete the EFT info was to go into the SY06000 table and delete out the EFT record for the vendor there. So, is there a way to clear out the EFT info other than having to go into the SQL table? Seems like there should be a way to do that in GP.

Thanks
Jennifer

Global Data Synchronization - How is your company addressing this issue within GP?

Larry Turner — Tue, 21 May 2013 15:50:15 GMT

We have two large customers that required that we implement Global Data Synchronization. To meet their requirement we developed a custom software application that allows the store and maintenance of item data that could not be stored in native GP. The custom application was developed prior to my arrival here and we are soon to start an upgrade from GP9 to GP2010. I'm wondering how others have addressed Global Data Synchronization within GP2010. We would like to address current and possible future customer requirements to use Global Data Synchronization within GP using the GP database. One solution that comes to mind is to use Extender if the native GP database does not provide placeholders for the type of data required for Global Data Synchronization. At this point I'm not yet very familiar with the Extender product. I also found that a Google search on GP and Global Data Synchronization returned some results for Redtail Solutions. So, in summary how is your company satisfying Global Data Synchronization requirements with GP? Thank you.

Econnect Error when Submitting transaction with Panatracker

Cptolle — Tue, 21 May 2013 19:39:57 GMT

We have eOne Smartconnect installed and also Panatracker. I create a PO in GP and then through the Handheld I receive in the PO. Everything looks good. Then when I SUBMIT from the handheld i get the following error message. I spent a couple of hours with Tectura yesterday and we have yet to figure out why we are getting the 'item with the same key has already been added' error. Everything appears to be setup correctly but we are definately missing something. Does anyone have any ideas or has anyone seen this error message before?

Thanks,

Craig

The message from the host is:

An error occurred while submitting transaction ID d691ec4e-9f4c-4d95-b5c9-c59bb128330f.

An error occurred performing the Receiving transaction.

eConnect rejected this transaction.

An item with the same key has already been added.

_____________________________________________________________________________________

The message sent to the host was:

<?xml version="1.0" encoding="utf-16"?>

<taRequesterTrxDisabler_Items xsi:nil="true" />

<taCreateVendorAddress_Items xsi:nil="true" />

<taPopRcptLotInsert_Items />

<taPopRcptSerialInsert_Items />

<taPopRcptLineInsert_Items>

<ITEMNMBR>ABRASBELT64850</ITEMNMBR>

<ITEMDESC>6" X 48" Norton 50 Grit 27696 Sand Belts</ITEMDESC>

<VNDITNUM>ABRASBELT64850</VNDITNUM>

<LOCNCODE>10ARTESIA</LOCNCODE>

</taPopRcptLineInsert>

</taPopRcptLineInsert_Items>

<taPopRcptMultiBin_Items />

<taPopRcptLineTaxInsert_Items xsi:nil="true" />

<taPopDistribution_Items xsi:nil="true" />

<taAnalyticsDistribution_Items xsi:nil="true" />

<BACHNUMB>PTGP_RECEIVE</BACHNUMB>

<USRDEFND5>[Device]BOSScanner5[/Device][TrxReceiving.Oid]d691ec4e-9f4c-4d95-b5c9-c59bb128330f[/TrxReceiving.Oid]</USRDEFND5>

</taPopRcptHdrInsert>

<taMdaUpdate_Items xsi:nil="true" />

</POPReceivingsType>

</eConnect>

_____________________________________________________________________________________

Additional diagnostic information:

Panatracker.Model Version: 6.1.12.3

Host Adapter: DynamicsGP v11

Database host: artmecgpsql

Database name: PanatrackerGP

RM Historical Aged TB and Applying Transactions

Jim Lines — Tue, 14 May 2013 20:47:02 GMT

Hi, I've been busy this week...

I'm trying to help a client reconcile their QuickBooks Open AR as of 12/31/2012 to GP as of the same date. They've been entering everything in parallel since August and the YE Open AR should tie out. However, I am running into a ton of issues and I'm not sure if I am missing something or the system needs some maintenance.

Example, I have an 2012 invoice that was paid by a check in 2012. In GP, I apply it with a 12/31/2012 date and run the paid transaction removal with a date of 12/31/2012. However, when I run my HATB both the check and invoice still appear as open. When I do a customer inquiry, they are both in history and applied properly.

Do you know if, even though I set the dates as 12/31/2012, the transactions wouldn't clear because we are in 2013? Again, all dates were set to 2012.

Any help is appreciated.

Jim

MR 2012 RU5 Balance Sheet Detail Missing

Richard Wheeler — Wed, 15 May 2013 21:19:05 GMT

When I view a balance sheet and look a the A/P account I see the beginning balance amount and the ending balance amount but for all the detail transactions that make up the net change are zero. So I see all the transaction descriptions but zeroes for the transaction amounts. If I run a P/L I do see the amounts. Is there an issue with seeing transaction detail on an MR 2013 balance sheet?

error econnect 10 "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value"

CLAUDIO VARGAS ALEJOS — Fri, 15 Jul 2011 00:58:49 GMT

Hi partners, i am developing a integration application with econnect 10 in GP but i get the next error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value" please help me!!! ....
<taBRBankTransactionHeader>
<Option>1</Option>
<CHEKBKID>MICHEQUERA</CHEKBKID>
<TRXDATE>17/07/2011</TRXDATE>
<CMTrxNum>00000056</CMTrxNum>
...

Set Functional Currency but there are no currencies listed

frdbadf — Mon, 20 May 2013 21:37:00 GMT

I am attempting to install Management Reporter 2012 on a test server with GP2010 to migrate FRx data and prepare for upgrade to GP2013. I have installed GP2010 and restored the company database.

When I attempt to configure an ERP Integration the configuration fails. in the deployment log it states that I must setup a functional currency.

When I go through the steps to set up a currency, Tools, Setup, System, Currency or Multicurrency, there are no default currencies to select from in the drop down.

I created Z-US$, US Dollars, ISO=USD and proceeded to assign it ot the company but the problem still exists, Management Reporter configuration still fails with I need to create functional currency.

Thanks

Error when exporting a smart list to MS Excel

Adal Raja — Mon, 22 Apr 2013 18:51:43 GMT

Hello All! we are having issues when exporting a smart list to Excel, it will give me the following error and then crash. i have tried downloading the "Microsoft Dynamics GP 2010 and Office Web Components 2003" but still no fix. i'm using MS Office 2010 and GP 2010, any ideas?

Remove Bins: Item has pending transactions

Sylvie M. — Tue, 02 Apr 2013 19:44:27 GMT

We are getting the following error in the Exception report when trying to remove bins from Item/Site Records: ''Item has pending transactions''.

But the item has no quantity in inventory. We also ran the SQL scripts mentionned in the KB 857144 to find allocated, but nothing was found.

We're using IV, SOP, POP, Manufacturing MO, no 3rd party products.

We also reconciled POP documents, SOP documents, and Inventory.

Any idea how to find the 'pending transactions'?

Thanks,

Sylvie

Error 404 Page Not Found after Upgrade to BP 5.0

Béat Bucher — Sat, 18 May 2013 17:04:44 GMT

Hi everyone,

Does anybody have encountered this issue before after their upgrade from BP 4.0 to BP 5.0 ? the SharePoint was not changed, still running on WSS 3.0. This BP site was perfectly working before. According to the MS upgrade doc, this is the most straightfoward and safe way to upgrade the BP to be compatible with GP 2010. We upgraded our GP2010 almost 2 years ago, but the BP was left running on the version 4.0 and had no issues so far. The problem was that we added new companies to our GP system and the BP doesn't see them, or rather can't work with them because the BP configuration wizard cannot be executed in that version of GP as back-end, thus the upgrade of the BP.

After the upgrade, most of the SharePoint stuff was loading fine, but when it comes to open the BP specific web-parts, the browser just returns an error 404 Page Not Found. The browsing of the BP is made over a secured SSL link/url. When altering the IIS security configuration to allow non-secured connections, and using the regular http:// over the port 82 (where the BP site is installed), the web-parts are opening just fine. So this seems clearly to be an issue with the IIS security config and the SSL. But nothing has been changed on this side, only the BP was uninstalled from the version 4.0 and the new BP 5.0 was setup by using the installation program. This shouldn't affect the IIS settings, but I suspect that some of the ASPX files that have been replaced by the setup are no longer recognized to be used with the SSL security protocol.

Can anybody shed a light on this ? I've looked everywhere on the net about SSL related issues with SharePoint, but none of them deal with Business Portal web-parts...

Thanks in advance for the help.

Sales Order Location

jmawebtech — Mon, 20 May 2013 23:06:00 GMT

Hi,

I have written some code to pull a list of Sales Orders:

wsDynamicsGP.GetSalesOrderList(new SalesOrderCriteria(), context);

wsDynamicsGP is the web service API:

http://msdn.microsoft.com/en-us/library/cc508537.aspx

I have MS Dynamics GP 2013. I cannot find any of these transactions under Sales > Sales Orders Transactions. Am I looking in the wrong place? Is there a way to look up transactions by customer?

Dynamics GP10 Sales Order Processsing

Elizabeth Nentwig — Mon, 20 May 2013 15:32:52 GMT

What table contains the SOP 'Customer Promise Date' in GP10? I've located SOITEMPROMISEDATE in the IS030001 table but this date is equivalent to Req_Ship_Date in the SOP30300 table. I'm looking specifically for promise date entered on the 'Additional >> Manufacturing Sales Item Detail' window.

Any help would be greatly appreciated!!

Smartlist shows we received 3 lines but Items Quantities Maintenance doesn't.... What's going on? Where is the problem?

WennSoft — Fri, 10 May 2013 17:05:31 GMT

We are showing that we have received 3 lines from PO# BTS00033842 on Receipt BTS00014186. Smartlist is showing this

But we are not seeing received in Inventory- still showing on order on the PO. Can you advise? What is going on? Where would we look to fix this?

Batch Date vs Transaction Date

Waleed Tibi — Tue, 24 Apr 2012 18:47:40 GMT

Normal 0 false false false EN-US X-NONE AR-SA

Dear All,

I am planning to change the setting of the GP system to create the journal entries from the batch date; currently the system creates the journal entry from the transaction date.

I was wondering how many of you are in favor of creating the entries from the transaction date? (is the bach date the best practice to close the accounts monthly?), just a little note, the reason that I plan to switch to the batch date is to close the accounts month by month.

Thank you in advance

Duplicate check numbers

beth SECI — Tue, 21 May 2013 12:15:10 GMT

Is there a setting in the system to no allow duplicate check numbers?

Create sales Invoice in GP

PriyaS — Thu, 16 May 2013 09:40:15 GMT

Hi All,

I am trying to create a sales invoice in GP using the web service. But I am always getting the "A validation exception has occurred".

Please help me to fix the issue. What are the minimum fields are required to create an Invoice.

For testing I have just copy paste the code given in this link http://msdn.microsoft.com/en-us/library/cc508459.aspx

But it is not working also, giving me the same error.

Regards,

Priya.

Switch off Dynamics GP integration with Lync

Ian Grieve — Mon, 20 May 2013 11:11:31 GMT

I may be missing something obvious but how do you switch off Dynamics GP's integration with Lync?

A client has Lync installed but does not want to use it with GP.

Thanks.

US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

Carolyn Ballard — Mon, 13 May 2013 21:02:33 GMT

I have a customer that has the US version of Dynamics GP and they have acquired a UK office. We are converting their UK Sage accounting system to the US Dynamics GP. the UK office woudl be a seperate database/company. We can solve the date format issue by having a dedicated citrix server set to European date format. All seemed good with the world until I came to post bank receipts. In the UK every transaction has a vat tax associated with it. You can deal with that in PM and GL ; however the bank reconciliation module does not allow you to track vat taxes! UGH I woudl appreciate any recommendations.

So, I have 2 thoughts/questions

1- can I install the UK version on a citrix box, (assuming a seperate sql install)?

2-- is there any way to solve the vat tax transaction entry requirement with another tool?

If you use the gl to enter the transaction, half of the problem is solved, but then you cannot use bank reconciliation.

HELP!

Thanks

Carolyn

Inventory Reconciliation running slowly

samarhassan — Thu, 16 May 2013 12:36:56 GMT

We have a situation where inventory reconcile of about 7500 items and 200 sites takes more than 12 hours to complete overnight. We have to run reconcile on a daily basis as the qty balances are generally out of balance after day's work.

Our current release is GP2010 SP3 with 63 concurrent users and the database size reached around 30GB in only one year and half.

We have a numerous transactions in inventory tables like:

IV30300 >> 1,968,200

IV10200 >> 1,391,921

IV10201 >> 2,660,920

So please help if there is a way to get this maintenance activity to run faster by any enhanced inventory reconciler utility.

And what is the way we can keep our history in the same database more than one year and with lower size and high performance?

GP 10 takes too much time while posting Sales Transaction.

Asif Fattah — Mon, 20 May 2013 13:35:44 GMT

Dear All,

I am using Microsoft Dynamics GP 10. from last 3 days when I am going to post Single Sales Transaction Batch It takes 20 to 30 minutes. We are using AA and we don't have more then 2000 entry in Sales Order Process Module.

Can any body tell me how can I resolve this issue.

Regards,

Asif Fattah

Would a sales backorder or sales order trigger a manufacturing order?

Alvaro Rodríguez Ochoa — Mon, 20 May 2013 18:11:17 GMT

I was wondering if I enter a backorder or a sales order and there's not enough pieces for such item, would the MRP would suggest us to input a manufacturing order to fulfill such items?

Also can a backorder be transfered to a sales order?

Regards.

A save operation on table 'MO_Order_MSTR' failed accessing sql data

Hilal — Mon, 05 Apr 2010 05:40:53 GMT

Hello

I am facing these two error messages in Manufacturing Order Form and BOM form

1. A save operation on table 'MO_Order_MSTR' failed accessing sql data , this message appears , when i open Manufacturing Order Form ,and then when i save the Manufacturing Order .

2. A save operation on Table 'BOM_Line ' failed accessing Sql Data, when i add button after the adding new components in the BOM form

If someone knows about these errors please give me solution

HILAL UDDIN

IT Project Manager

CPC - Riyadh

How do I import cash receipts and apply to specific invoices in Integration manager?

nrc Diane Terry — Thu, 15 Sep 2011 01:12:49 GMT

I want to import cash receipts and apply them to specific invoice numbers, but I am getting warnings that "Apply-to document (invoice #) had problems saving." The cash receipt is importing but it isn't applying.

I have followed the example of the sample RM Cash Receipts integration, but it seems to have errors in it. On the 'Cash Apply' options, it is set to 'Auto Apply' rather than look at a source file. When this option is chosen it auto applies based on document date, and doesn't apply to the invoice you have specified.

I setup a new integration. There is only one txt delimited file, however I have created two 'sources' from it - one for the main cash receipt import, and one for the Cash Apply import. I only want to apply one invoice to each cash receipt.

I have setup the 'Cash Apply' mappings as below

Apply-To Document Number = source field - invoice number

Apply-To Document Type = Constant - Sales/Invoices

Apply-To Amount = Source field - payment amount

Can anybody advise what I am getting the errors "Apply-to document (invoice #) had problems saving."?

Excel or smartlist report that will pull in the customer notes from customer card

Katie Pieczynski — Mon, 20 May 2013 20:28:31 GMT

Does anyone know if there is a report or if I could build a report that would have the customer number/name and the notes from the customer card? Basically I run a report that has all of our past due customers and what balance they have in each category (this is a smartlist) I would like to include the notes from the customer card on that for when I send it to my boss. Any suggestions would be great.

Thank you,

Is there any bank reconciliation product that pulls activity from GL?

Carolyn Ballard — Mon, 20 May 2013 15:41:43 GMT

I have a company that only uses GL, PM and FA. THey have custom software for the income side, so they are not using RM. THey have extensive electronic bank deposits and they are currently posting journal entries. However that defeats the ablity to use the bank reconciliation, electronic reconcile features. Does anyone know of an ISV that can pull activity from the GL for bank reconciliation purposes?

Thank you

Carolyn

Dynamics GP 2013 with Sharepoint 2013

Dipal Patel — Fri, 08 Mar 2013 21:07:37 GMT

Hello

I have installed Dynamics GP 2013. I am trying to install Workflows in dynamics. I am not able to do that and i am getting error - i have to install sharepoint 2010.

So Workflow in dynamics gp 2013 will not work with sharepoint 2013?

Thanks

Setting up ODBC for Great Plains

r_nsh — Mon, 20 May 2013 17:09:39 GMT

Hi,

For users to access Great Plains/Frx, they need a ODBC setup.

We have sql 2005 for Great Plains databases. How can i setup the ODBC - should it be based on sql authentication or windows authentication? Should the users have db_owner access or sysadmin access? We do not want to sset the users up with sa account in ODBC connection.

Can you please help me with this.

Thanks,

r_nsh.

Installing Tools in a Test Company

MWeickert — Mon, 20 May 2013 19:11:47 GMT

Is there a way to get around Microsoft CustomerSource credentials to install tools?

One specific example is the Historical Inventory Balance Report and the Historical Inventory Balance Report Reset Tool which has to be installed. When I was trying to install these, I realized that it requires Microsoft CustomerSource access to do so.

Would these externally installed tools work with a test company or does it require the live info?

Remove detail in GP?

Carl Holzhauer — Wed, 15 May 2013 12:17:46 GMT

It seems like a bunch of system maintenance has been neglected over the years, which has led to slow performance and bloated databases.

Can someone link me to something that shows how to remove details for each module and just leave the historical data? What other things should we be doing to control the size of our data and to help reports run faster?

Thanks

Human Resources Accrual Schedule

George Lasseigne — Mon, 20 May 2013 19:36:38 GMT

I'm trying to setup an accrual schedule for our company. We get 0 days the first year of service, 10 days after 1 year, etc. Also our vacation expires at the end of calendar year. I've yet to find the magic formula to make this work. My best guess was to setup an accrual for year of service , accrue by Interval (365 days per interval, though not sure how leap year would work out), and number of hours to 40.

Could someone point me in the right direction on this?

Human Resources Discipline Points

George Lasseigne — Tue, 14 May 2013 20:04:44 GMT

I'm testing the use of the Human Resources feature in GP 2013 to track discipline points. I'm trying to figure out how to reset the points for all employees to zero at our fiscal year end. I'm sure I could delete entries in the database, but I'd like to keep the history. I don't see any way for points to be tied to year.

Thanks,

George

Active Directory to login to GP

mmiller1225 — Thu, 09 May 2013 19:06:15 GMT

Does anyone use Active Directory to login to GP. FastPath has a product, Has anyone used it? Are there others? What would you recommend?

Alternatives to replication

Carl Holzhauer — Fri, 26 Apr 2013 13:51:51 GMT

We currently use replication to get data from our GP SQL server to another SQL server so we can use it for our CRM program. The problem with this is that replication alters the table structure so we can no longer run a program like CDA so we can archive our companies.

We looked at log shipping, but my DBA is telling me there is a delay between the time data is written to the GP server and the time the logs are applied to our CRM SQL server and that delay is too long for our needs.

Are there any other options that we should look at?

What's the smallest time delay we can have with log shipping?

Integration Manager throws 7997 error on Country of Origin when creating an Item

Dean Edouarde — Mon, 20 May 2013 18:26:07 GMT

It doesn't seem to matter of the Intrastat option is checked or not on the Company record, Integration Manager throws an error when attempting to create a new Item in the Integration Manager. VAT10007 is empty but VAT10001 does contain records relating to Sites and possibly other mater tables.

The actual error is:

Microsoft.Dynamics.GP.eConnect: Number = 7997 Stored Procedure taUpdateCreateItemRcd : Description = The Country Origin does not exist in the Intrastat Maintenance table

AAG20001 tables causing latency in Cash management Transactions

Greg Horner — Fri, 17 May 2013 00:56:40 GMT

Hello,

Our customer is on GP10 SP2. (relevent or not) They use Analytical Accounting. When they enter a Bank transaction, it takes a good while (~2 minutes) for it to populate the default cash line. Ran a trace and determined that the AAG20001 table was being hit and that table has 1.8 million records.

1. Should this be happening at all? Why does GP care what's in the AAG20001 table on a bank transaction entry?

2. Also, if I delete these records, I'm curious to know the effect. Does anyone know what table FRX uses when reporting AA transactions?

Thanks in advance. They are considering moving to GP2013, but it takes hours for folks to enter bank transactions right now.

MR 2012 Single User

Richard Wheeler — Thu, 25 Apr 2013 21:20:40 GMT

I know all the requirements for MR 2012 want a domain, however has anyone tried and been succesful in gettting MR 2012 installed on just a single computer? We have a couple of not-for-profits with limited funds and they cannot afford or even need a domian.

Dynamics GP YTD and MTD Usage for Inventory Items

Jeff Titus — Mon, 20 May 2013 13:04:49 GMT

Is there a built in function for GP to calculate and store Month-To-Date and Year-To-Date Usage numbers?

HR Discipline stages

Scott Witteveen — Mon, 20 May 2013 16:33:58 GMT

Is there a way to change the descriptions of the discipline stages in HR?

GP 10 Data Archiving

Martin Tomala — Fri, 27 Nov 2009 04:12:18 GMT

Hi All

Lets assume for a moment that I have 10 years of company data and I would like to archive 8 and keep 2.

Is there a way this can be achieved? If ~yes please tell me what's the best practice.

I personally think we can only start a new company and bring over the opening balances and some open transactions.

Has anyone ever tried to delete data from some key transaction tables based on a date range and then perhaps running checklinks to see if data integrity is maintained?

Cheers Martin

Microsoft Dynamics GP Forum - Recent Threads

RM Detail Historical Aged TB

Create posted RM document

Color Setting for multiple companies

I need some help running the following reports in GP

Year End Close Journal Entry in Wrong Year

Workflow Registration

MS Forecaster User recreation

GP 10 Memory Error

Electronic Reconcile 'Record type match not found' error

Error message on Integration manager

Font size

Delete Vendor EFT Info

Global Data Synchronization - How is your company addressing this issue within GP?

Econnect Error when Submitting transaction with Panatracker

RM Historical Aged TB and Applying Transactions

MR 2012 RU5 Balance Sheet Detail Missing

error econnect 10 "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value"

Set Functional Currency but there are no currencies listed

Error when exporting a smart list to MS Excel

Remove Bins: Item has pending transactions

Error 404 Page Not Found after Upgrade to BP 5.0

Sales Order Location

Dynamics GP10 Sales Order Processsing

Smartlist shows we received 3 lines but Items Quantities Maintenance doesn't.... What's going on? Where is the problem?

Batch Date vs Transaction Date

Duplicate check numbers

Create sales Invoice in GP

Switch off Dynamics GP integration with Lync

US based company, has UK office that needs to convert to GP-- all seemed fine until I got to Bank receipts

Inventory Reconciliation running slowly

GP 10 takes too much time while posting Sales Transaction.

Would a sales backorder or sales order trigger a manufacturing order?

A save operation on table 'MO_Order_MSTR' failed accessing sql data

How do I import cash receipts and apply to specific invoices in Integration manager?

Excel or smartlist report that will pull in the customer notes from customer card

Is there any bank reconciliation product that pulls activity from GL?

Dynamics GP 2013 with Sharepoint 2013

Setting up ODBC for Great Plains

Installing Tools in a Test Company

Remove detail in GP?

Human Resources Accrual Schedule

Human Resources Discipline Points

Active Directory to login to GP

Alternatives to replication

Integration Manager throws 7997 error on Country of Origin when creating an Item

AAG20001 tables causing latency in Cash management Transactions

MR 2012 Single User

Dynamics GP YTD and MTD Usage for Inventory Items

HR Discipline stages

GP 10 Data Archiving