If you have just added a new currency or imported multiple new items into Dynamics GP, this script will ease your workload and assign all currencies to all items in one easy script.
Dynamics GP is a great system full of lots of features, but every now and then we need to turn to SQL to help us. So we have gathered some of the most useful SQL scripts from our partners, and the GP community, for your use.
Supported Systems | |
ERP Software | Microsoft Dynamics GP |
Electronic Funds Transfer (EFT) is becoming a more common payment method in our everyday personal banking. Remember the last time you transferred money to your friend? Was it done in a swipe throug...
$80.00
$80.00
This is a handy SmartList for viewing Payables documents that have originated from the POP module. It show's details of items received and the GL journal entry that relates to the documents. This can ...
Free
Free
Dynamics GP uses OPEN, WORK and HISTORY tables to process transactions. As transactions move between the tables, interruptions (much like those that cause stuck batches) can cause duplicate data to be...
Free
Free
This SmartList shows all posted deposits and the related receipts. Each receipt is on its own line and the deposit info separated as many times as they appear against a receipt. This a great repo...
Free
Free