Search This Blog

Friday, August 13, 2010

MS GP: How to perform a backup in SQL?

To perform a GP backup:

1. Open Microsoft SQL Server Management Studio
2. Verify that everyone is logged out of GP

Open ACTIVITY table under DYNAMICS database.

3. Backup DYNAMICS database

Right click on the database and go to Tasks -> Back Up.

If you want to change a path click Remove and then Add.

Click expansion button to change a File name, click OK.

Click Options and mark “Verify backup when finished”, click OK.

Click OK to start a backup.

4. Backup COMPANY database
Perform the steps under task 3, but for a company database.

To lookup a database name, you can:

Check the name by going to Dynamics GP menu Maintenance -> Backup.

Or you can run a query against DYNAMICS:
SELECT * FROM SY01500

MS CRM: How to make attributes Business Required depending on the value of another attribute?

if (crmForm.all.fieldname.DataValue == "value")
{
//Set Business RequiredcrmForm.SetFieldReqLevel("attribute_name", 1);
}

Copy and paste to Event Detail Properties with marking "Event is enabled" box.

MS GP: How to print statements with unpaid transactions only?

To print statements with open(unpaid) transaction only, you should run Paid Transaction Removal Routine. It moves the transactions from open status to history. Since statements pick up the open transactions even if they are fully paid, running this routine will ensure that statements will show only unpaid transactions.

Note: Once Paid Transaction Removal is run, you can no longer unapply payments to a receivables invoice. If a Check option was also marked during Paid Transaction Removal, these checks can no longer be marked as Non-Sufficient Funds.

Follow the below steps to perform the Paid Transaction Removal Routine:

1. BACKUP. Make sure you have a full backup of Dynamics and Company databases, since you cannot undo this routine.

2. KEEP HISTORY. Verify that history is being kept.

a. Go to Dynamics GP menu -> Tools -> Setup -> Sales -> Receivables
b. Verify that the Print Historical Aged Trial Balance checkbox is marked.
c. Click Options and verify that Sales History boxes are marked as well.

3. RUN ROUTINE. To run Paid Transaction Removal in Dynamics GP:

a. Go to Dynamics GP menu -> Tools -> Routines -> Sales -> Paid Transaction Removal
b. Select a range of customers to run it for.
c. Enter a cutoff date.
d. Mark transaction to be removed. If Check is selected, enter a cutoff date for checks.
e. Mark Print Register.
f. If Balance Forward Consolidation is marked, the routine will consolidate balances and move current transactions to the non-current bucket.
g. Click Process.

Once the process ends, the register of all transaction moved to history will be printed. You can view history transactions in the Inquiry window.