![Page 1: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/1.jpg)
T H E A M A Z I N G
RACE40 tips in 60 minutesJon Augdahl & Colleen
McCoshen
![Page 2: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/2.jpg)
Financial tipIn Microsoft Dynamics® SL 2011, users can link Accounts Payable (AP) and purchase order (PO) documentsUse Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module and a released Accounts Payable voucher or debit adjustment transaction
![Page 3: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/3.jpg)
Financial tipIn Microsoft Dynamics SL 2011 users can: ReverseReverse and CorrectCopy batches
![Page 4: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/4.jpg)
Financial tipMicrosoft Dynamics SL 2011 – Hard CloseFeature Pack 1 (FP1) – Hard Close restrictions by module
![Page 5: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/5.jpg)
Financial tipIn Microsoft Dynamics SL 2011 FP1, users can set up Batch Control reports to print by module
![Page 6: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/6.jpg)
Financial tipDelete suspended batches from Accounts Receivable (AR) and AP
![Page 7: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/7.jpg)
Financial tip”Pay when paid” terms
How can I make sure my vendors aren’t paid for services before my customer has paid me? Or my salespeople aren’t paid for commissions before I’m paid?
Terms MaintenanceDiscount Type: “Pay When Paid” Apply to: Vendor
![Page 8: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/8.jpg)
Financial tip”Pay when paid” terms
How can I make sure my vendors aren’t paid for services before my customer has paid me? Or my salespeople aren’t paid for commissions before I’m paid?
New screens to link or unlink an AP Voucher to an unpaid AR invoice
Access in AP Voucher and Adjustment Entry or AP Document Maintenance
![Page 9: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/9.jpg)
Financial tipKnowledgeBase #932740
Enable Print Preview in W-2 formsCreate backup copy of system databaseRun a Microsoft® SQL Server® update on the RptControl table for Report Number '02741‘ and set the DocPrompt field to null
![Page 10: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/10.jpg)
Financial tipExport to Microsoft Excel® feature from data screens like Voucher and Adjustment
![Page 11: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/11.jpg)
Order Management (OM) tipWhat is the Current OM Period!?
The more recent period between Inventory and AR
![Page 12: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/12.jpg)
Order Management tipChoose your invoicing method for project-related shippers
![Page 13: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/13.jpg)
Order Management tipGoods for Project Sales Order Purchase for Type
![Page 14: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/14.jpg)
Order Management tipGoods for Project Sales Order Purchase for Type
![Page 15: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/15.jpg)
Order Management tipGoods for Project Sales Order Purchase for Type
![Page 16: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/16.jpg)
Order Management tipNotice a Void Status AR or Inventory (IN) Batch from OM?
Re-run the Sales Journal reportSpecify Sales Journal ID on the Options
tab
![Page 17: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/17.jpg)
Project tipKnowledgeBase #847572After I closed Project Controller for the year, my project totals are incorrect
Ensure that “Balance Forward at Year End” option is checked in Project Maintenance
How to fix it? Run PMA Integrity Check for the ProjectDon’t have to reclose the module
![Page 18: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/18.jpg)
Project tipWhat's the difference between changing the Project Controller period in Project Controller Setup and running the Close Period process?Project Controller Period in PC Setup displays the current period. This can be changed manually to allow project transactions to come in via FTT process.
Best practice is you can use this field to set the period back, but ALWAYS use the Close Period screen to advance the period forward and ensures that the balances are carried forward correctly
Close Period screen actually closes the period. If year-end close is done, balance forward amounts are calculated (where appropriate). Writes summary records for PTD and YTD amounts
![Page 19: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/19.jpg)
Project tipProject Controller – KB #844051I ran Project Allocator and got a message "No Allocation
Records created." Why? Transactions may not qualify for use by Allocation Processor
KnowledgeBase article gives a set of SQL scripts to run to identify any records that exist and qualify for allocation. Also provides reasons why
The period in the related module (AP, AR, IN) is not the same period number that is in Project ControllerChange the period field in Project Controller to the period that is in the related module.
For example, if AP is in 7-2011, then the Project Controller period field should reflect 7-2011
![Page 20: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/20.jpg)
Quick Send tipAutomated faxing and emailing
Setup specific to each vendor, customer, or employee
Customer documentsInvoices from AR, flexible billings, service, construction billing, and OMAR statementsOrder Management order confirmationsManual order confirmationsShipping notices
Vendor documentsPurchase orders
Payroll direct deposit advice slip stubsUses Application Server*
![Page 21: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/21.jpg)
Quick Send tipQuick Send
How to easily resend a copy of an invoice, purchase order, or OM shipping document?Quick Send Inquiry – accessible through:
AR Invoice and MemoAP Voucher and Adjustment EntryAR and AP Document MaintenanceShared Information menu
Use filters to search on refnbr, customer ID, purchase order number, etc.Check box and click Begin Processing to resendOr just click Quick Send button to resend
![Page 22: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/22.jpg)
Quick Send tipQuick Send• You can use variables within the Subject
Text or Body Text to personalize the message• <Customer Name>• <Reference Number>• <Document Amount>• <Company Name>• <Order Number>• <Shipper ID>• <Shipper Date>• <Statement Date>
![Page 23: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/23.jpg)
Reporting tipAdd [Report-{scrnnbr}] to Solomon.ini
ZoomPercent Default Value = read from the .rpt Valid Values = 0-500
Sets the default zoom percent
Example:
[Report-01620] ZoomPercent=300 [Report-01610] ZoomPercent=200
![Page 24: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/24.jpg)
Performance tipAdd [Miscellaneous] to Solomon.ini
SiteIDValidation Default Value = OFF Valid Entries = On / Off
When set to ON, performance can be improved No longer see the “Active Site for this item” column
Example:
[Miscellaneous]SiteIDValidation = ON
![Page 25: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/25.jpg)
Reporting tipReport Assistants
Report Assistants are manuals intended to help with custom reporting – both in creating new reports and modifying existing reportsAvailable for download on CustomerSource
![Page 26: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/26.jpg)
Reporting tipReport Assistants
![Page 27: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/27.jpg)
Reporting tip - Doc ShareA customer, vendor, or project-specific Microsoft SharePoint® site can be created with one click from the maintenance screen. Invoices, statements, purchase orders, etc.Can be automatically published for centralized document retention and access
![Page 28: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/28.jpg)
Print any report to a SharePoint destination
Reporting Tip – Upload to SharePoint
![Page 29: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/29.jpg)
System tipCompany Icon in Microsoft Dynamics SL 1022Company Color
Reload menu – Choose Company from list
![Page 30: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/30.jpg)
System tipCustomized FavoritesDid you know you can add screens, reports, webpages, links to your favorite programs (like Excel) all in your Favorites menu?
In 2011 > ToolsAdd URL to Favorites (webpages)Add External Link to Favorites (like Excel)Add Screen Group to Favorites
![Page 31: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/31.jpg)
System tipSuper PV
Using Shift+F3 will give you a “Super-PV” lookup in some screensGeneral Ledger Account History
F3 = Acct, Description, TypeShift+F3 = Acct, SubAcct, LedgerID, Fiscal Year
Project Timecard EntryF3 = Employee #, Name, CpnyID, GL SubAcctShift+F3 = Employee #, Document #, Week Ending Date, Type, Status
F3 SHIFT + F3
![Page 32: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/32.jpg)
System tipImport/Export custom menusI just built some menus in Microsoft Dynamics SL. Is there a way to export or import those into another company or group? How can I create a backup copy?
Open the Menu Maintenance screen in AdministrationF3 and select the Group the menu was created for.Action: Export to create copy of the .xml fileAction: Import to import menu into new Group
![Page 33: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/33.jpg)
System tipChange Tab Order in Customize ModeI want to change the tab order in a screen. How can I do this?
Open the screen.CTRL+ALT+C opens Customize mode.Click on field you want to edit.Press F4 to open Properties of field.Edit Tab Index field – tab order is numerical. Change to a different number.CTRL+S to save changes; exit screen.
![Page 34: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/34.jpg)
System tipMake a field “Required” in Customize Mode• There is a field I need to make sure is never
left blank, but it’s not currently a required field. How can I change this?• Open the screen.• CTRL+ALT+C opens Customize mode.• Click on field you want to edit.• Press F4 to open Properties of field.• Edit BlankErr field – change to True. • CTRL+S to save changes; exit screen.
Field now Required
![Page 35: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/35.jpg)
System tipHighlight field in Customize Mode• I want to call attention to a field in a screen
that is frequently overlooked during data entry. How can I do this?• Open the screen• CTRL+ALT+C opens Customize mode• Click on field you want to edit• Press F4 to open Properties of field• Edit Back Color field, click dropdown arrow, then
select Palette tab and select a color• CTRL+S to save changes; exit screen
![Page 36: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/36.jpg)
System tipCustomize Mode on sub-screens• I want to see the database field on a sub-
screen but can’t open the sub-screen in Customize Mode. How can I do this?• Open the screen• Click the Sub-Screen button• CTRL+ALT+C will allow you to view and edit
the fields in the sub-screen in Customize mode
CTRL+ALT+CF4
![Page 37: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/37.jpg)
System tipKnowledgeBase #897393• How to add a company logo to display
when you log in to various companies• Save your logo as CPNYID.bmp (i.e.
0060.bmp)• Must be saved as .bmp – no other type will
work• The dimensions of the logo cannot exceed
192 pixels x 40 pixels• Add this file to your Microsoft Dynamics SL
root directory
![Page 38: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/38.jpg)
System tipUsability shortcutsF1: Access Online Help FilesF2: Edit in grid view or enter an absolute/relative formula in a date or period fieldF3: Look up possible values for a field or dateF4: Switch between form and grid viewF5: Clears the value in a field F7: Set a date field to today’s dateF9: Enter and display notesF10: Puts focus on main Microsoft Dynamics SL window
![Page 39: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/39.jpg)
Financial tipQuick Send• We are using Quick Send but sometimes
need to print a physical copy of the invoice. How can I do that?• Quick Print the invoice in AR Invoice and Memo• Quick Send Inquiry – drill into the View Document and print it from
there
![Page 40: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/40.jpg)
System tipIn Microsoft Dynamics SL 2011 ALL MODULES group can be removed from the users menu
![Page 41: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/41.jpg)
System tipCan’t delete Event Log records ?
Manually remove them from the PStatus table in SQL.
Delete * from pstatus
Also, delete them manually from the event log folder.
![Page 42: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/42.jpg)
Attachment tipAttach multiple documents to specific entities
Recall and review documents from Microsoft Dynamics SL screenStore documents in a Microsoft SharePoint site or network location
![Page 43: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/43.jpg)
Attachment tip
![Page 44: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/44.jpg)
Attachment tip
![Page 45: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/45.jpg)
Application server tipAllows offloading and scheduling of CPU-intensive tasks to other machines on your network
Schedule to run daily, weekly, or monthly, as well as based on the completion of a prerequisite request
![Page 46: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/46.jpg)
• Process requests• Report requests• Electronic requests (ex. Quick Send)• Transaction Import (TI) requests
Application server tip
![Page 47: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/47.jpg)
Application server tip
![Page 48: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/48.jpg)
• When installing on a Windows XP or Windows 7 machine, make sure to turn off User Account Controls (UAC) prior to the install• UAC notifies you before changes are made to your computer that require
administrator-level permission. The default UAC setting notifies you when programs try to make changes to your computer, but you can change how often it notifies you
• If you do not turn off UAC you will see a UNC path in the program path. It can also cause issues with registering files during the install• Control Panel > User Accounts• Change User Account Control Settings
Environment tipEnvironment – KB #970403
![Page 49: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/49.jpg)
General tipFollow us at
www.boyerassoc.com
Also follow Microsoft Dynamics SL Blog at:
http://www.boyerassoc.com/category/blog/microsoft-dynamics-sl
![Page 50: Use Link AP and PO Documents (03.560.00) to make a connection between a purchase order, receipt, or return transaction generated in the Purchasing module](https://reader031.vdocuments.us/reader031/viewer/2022012922/56649c745503460f9492668e/html5/thumbnails/50.jpg)
© 2013 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.