I am using GP V9.0 What sql table would I look in to find the daily ar balance

I am new to GP but have worked with many of Microsoft's products. I need to take our GP 9 sp 2 install running with a SQL 2000 database and move it to antoher server (new hardware) running Windows 2003 and SQL 2005 SP2. At the same time I would also like to upgrade to GP 10 and Service Pack 2 for...

Hello, In GP - 10 is there a way to combine or not combine multiple Purchasing payments to one check? Currently my Purchasing module is set to combine multiple payments to one vendor in one batch to one payment document (printed check). Is there away to turn this feature off for specific vendors or during...

Hi Can we do a security setup to restrict users from selecting the 'Shipment/Invoice' option in the Type field of Receivings Trx Entry window? Reem

I recently read that Dynamics GP 10.0 SP2 includes a new report called the Historical Inventory Trial Balance. Does anyone know the details behind this report? Does it have quantities as well as values for inventory? Does it replace the Historical Stock Status report? We are currently begining to use...

Our company has merged with another company. We both use GP, however one is currently on Release 8 and the other is on release 9. The company currently on 8 has approximately 25 databases; the company on release 9 has 9 databases. We anticipate having the Release 8 company on 9 by Monday. We would like...

My company is changing ownership and I need to do a year end close in the middle of the year. So I need to set up two fiscal years in one calendar year. The problem is that when I set up new fiscal years - I can't name two different years "2008". I had the idea to name it "2008 v.2...

The Lock Box feature in Dynamics GP will be able to do this for you. It's typically used when a bank collects your cash receipts and sends you a text file. You would then import this text file and automatically apply to the open invoices.

Before becoming a reseller I faced this very problem in a company that I worked for. In addiiton our product was an FDA regulated lot/serial numbered item which made tracking even more important. Essentially, acting as the distributor creates this issue. There are a couple ways to address this, depending...

Hello Ron, Scribe Insight is an easy to use, point/click/configure environment, that not only can handle integration with MS Excel, but with the single purchase of the Insight licence, you can expand migration and integration to any number of data stores. You can find out more about how we have had our...