DSD Business Systems DSD Business Systems News 
Product News, Tech Tips and the Inside Scoop 
July 2003 l www.dsdinc.com l 619-683-9900

Index   MAS 90 / MAS 200 l MAS 500 l SalesLogix l Microsoft

MAS 90/ MAS 200

MAS 200 and MAS 90 Promotions

Existing Customers

MAS 200 Upgrades – Receive a $100 User Discount for Add-on Users

15% Off Business Alerts Module

Purchase the RMA Module and Get a Rebate of $125

Gold Plan Members Get a 15% discount on Add-on Modules and Additional Users for MAS 90 and MAS 200

Promotions Expire 3/31/03

For more information, contact Stephanie Smith at 619-683-9900 or StephanieS@dsdinc.com

Upcoming MAS 90 and MAS 200 Classes

Class

Class Date

Sign-up Deadline Cost per Person
Library Master April 14 April 1 $425
General Ledger April 15 April 1 $425
Accounts Payable April 16 April 2 $425
Accounts Receivable April 17 April 2 $425
Inventory Management April 22 April 8 $425
Sales Order Processing April 23 April 9 $425
Purchase Order Processing April 24 April 10 $425
Crystal Reports April 28-29 April 14 $800
Library Master May 12 April 28 $425
General Ledger May 13 April 29 $425
Accounts Payable May 14 April 30 $425
Accounts Receivable May 15 May 1 $425
Inventory Management May 20 May 6 $425
Sales Order Processing May 21 May 7 $425
Purchase Order Processing May 22 May 8 $425
Library Master June 9 May 26 $425
General Ledger June 10 May 27 $425
Accounts Payable June 11 May 38 $425
Accounts Receivable June 12 June 2 $425
Inventory Management June 17 June 3 $425
Sales Order Processing June 18 June 4 $425
Purchase Order Processing June 19 June 5 $425
Crystal Reports July 28-29 July 14 $800

All classes are held from 9am - 5pm, and cost $425 per person unless stated otherwise. Lunch is provided. They are held at the DSD Building in beautiful Mission Valley in San Diego.

To register, call Sandy McCauley at 619-683-9900 or e-mail SandyM@dsdinc.com 

MAS 90 Tip: A/P Prepayments and Wire Transfers

How to enter a prepayment to a vendor and have it show as a debit balance in Accounts Payable and post accordingly to Bank Reconciliation and General Ledger. This is an alternative way to reflect pre-payments or deposits in the A/P module.

1) Create a new account in G/L as a holding account for Prepayments.

2) To record a prepayment:

A) Enter a Credit Memo by using Invoice Data Entry in Accounts Payable and using XXXXX-CM as the invoice number (XXXXX=any combination of numbers). Enter the amount as a negative and on the lines tab select the Prepayment account from Step 1.

B) Enter a Transaction Journal Entry in the General Ledger and select check numbers and the appropriate bank account. Click on the lines tab to enter a check # for your records (not a real check #) and select the Prepayment account from Step 1.

Step A will create a Debit to the Accounts Payable account and a Credit to the Prepayment holding account.

Step B will create a Debit to the Prepayment Holding account and a Credit to Cash, as well as send the transaction to Bank Reconciliation.

3) Now the General Ledger will show correct as well as in Accounts Payable you would see the negative balance on the Credit Memo which reflects the prepayment.

4) The next step is to receive the invoice. After the receipt of invoice you will end up with an invoice with a positive balance and a Credit Memo with a negative balance.

5) To apply the Credit Memo to the invoice use Manual Check Entry. For the Check number use APPxxx (xxx=any three digit number.) This will automatically gray out the check amount as 0.00. Select the vendor, select the Lines tab. First choose the Credit Memo from the Invoice Number lookup and select it, then select whichever invoices you want to apply the Credit to. You can apply the full amount or a partial amount to either one or more invoices. The amount of the selected invoice(s) must be equal to the amount of the credit memo.

MAS 90 – Hidden MAS 90 Utilities
Here is a list of useful MAS 90 “hidden” utilities you should be aware of. These utility programs are run from the MAS 90 Menu Bar, File/Run, and typing in the program name.

APWRVD is the A/P Purge Void Checks utility. This program is used to purge a large range Void check records, which were created incorrectly. Generally, you would run the program when you attempt to Reverse an A/P Check, but get the message that the check has been voided. Running this utility program allows you to delete the Void Check, so the actual check can be reversed.

GLWSJA is the Purge G/L Update/Report in Process Flag utility. When a G/L register is updated, or a G/L report is run, a flag in set in the SY0CTL.SOA System Control File. If the process does not complete normally, this flag is left in place, preventing G/L updates or report printing. This utility clears this flag.

GLWSKA is the Clear Check Printing Flag Utility. When A/P Manual Check Printing, standard Check Printing, or Payroll Check Printing is started, a flag is set on the Bank Code to prevent another check printing program from being run, at the same time, for the same Bank Code. If the Check Print program terminates abnormally, this flag is left on the Bank Code. This utility is used to clear this flag, so check printing can be resumed. In older MAS 90 systems, the procedure was to use Data File Display & Maintenance, and edit GLWccc(60,1) for the Bank Code record, and blank out the check printing flag.

IMZBL1 is the Inventory Quantity On Hand Balancing Utility. This utility program is used to compare and report discrepancies between the Warehouse Detail (IM2) file and Cost Detail (IM3 cost tier) file for FIFO, LIFO, LOT or Serial valuation items. This character-based program will allow you to fix FIFO or LIFO items. Lot and Serial items must be fixed on a case-by-case basis using transactions or the FIX hidden feature.

PRZDRR For those of you with Payroll, PRZDRR is used to edit the Form 941, if some of the data fields printed on the report need to be corrected.

SVDATA is the windows version of the old character based SUDATA. The Copy Data Files to New Company utility program is used to make a duplicate copy of one company’s application data files into another company code. This utility is useful for making a backup of your MAS 90 data files within MAS 90, creating a Test Company using your own data, or other purposes.

 


MAS 500

MAS 500 Promotions

Family Upgrade Program

20% Off or 0% Financing When Migrating to MAS 500

Existing Customers

10% Discount on MAS 500 Add-On Users or Platform Upgrades

15% Off Purchase Order Module

For more information, contact April Holman at 619-683-9900 or AprilH@dsdinc.com.


SalesLogix

SalesLogix Tip

Here's a nice trick developed by DSD staff. A shortcut to a network folder can be put in the attachment tab in SalesLogix. This allows files to be stored on a network volume and easily be opened in SalesLogix.

Procedure In SalesLogix

1. Locate the account record to attach the shortcut to.
2. Click on the attachment tab.
3. Right-click on the white space in the attachment tab and choose "Insert URL".
4. In the "URL:" field, enter the folder. Example: M:\ClientFiles\ClientFolderName
5. In the "Desc" field, enter a description that will be helpful to identify the folder. 
6. Press the OK button.

When you double-click on the link, that folder will open displaying the entire contents of the folder.

Issues Addressed

  • When you do an "Insert File" (rather than an "insert URL), the file is copied to the SQL server, meaning that two copies will exist - a waste of space.
  • When two files with the exact same name are inserted into SalesLogix, you will see two references within SalesLogix, but in actuality only the newest insert exists on the SQL server.

 


Microsoft

Become a Windows XP Expert!

The following link leads to resources to help you gain expertise in Windows XP.

click here for more information 


This monthly newsletter is sent to DSD Business Systems customers and partners. If you do not wish to receive this publication, please reply with the Subject "Remove" and we'll exclude you from receiving it.

 


All prices and offers are subject to change without notice. Copyright 2002, 2003 , DSD Business Systems, San Diego, CA. All rights reserved.