Home

GP 2013 - Encore Business Solutions Inc.

1. Amount Received 0 00 5 i Terms Discount Taken 0 00 Trade Discount l i 0 00 On Account ji 1 463 18 bag J Comment ae ras Holds ieee mime eee A 1 463 18 Configuration The configuration setup for Unit Defaults is under the Project Tracking Setup Options window Also Units can be a required value for a specific Breakdown code settings can be accessed under Breakdown Maintenance Note Payroll hours defaults as the Unit instead of quantity Project Tracking Setup The Default Unit distribution is determined by the Amount type setup in Project Tracking Setup Options and the Units Default settings For example for Sales order processing the default is Sales and Unit Default is set to Sync with GP Quantity as such when creating a SOP invoice and verifying the Project Tracking distributions Units will be allocated to The Sales amount type Note that if Units Default is set to no Default then the unit will not default to any amount type Project Tracking Build Notes To return to Table of Contents click Here Page 37 of 52 Encore PM project Tracking Setup Project Tracking Project Tracking File Edit Tools Options Help sa Fabrikam Inc 4 12 2017 Cif Transactions IV Enable Project Tracking Transactions Require Full Ask to Enable Use for Constant PM opti eat E Distribution OpenPT Quick Enty Transaction U
2. TESTPT Project Adjustments with GL Entries x Comma Delimited r Import Setup ID Description File to Impart Inta File Type File Mame oe ID sulle 15 with decimal C UsersAdministratorsDesktop PTIMPORT TESTFILE csy Import Fields po Type Format Width 1516 mem ooo fe 15 Project Tracking Inquiry i Save Delete Report Project Tracking Inquiry Distributions by Project updated for Units field PA Project Tracking Inquiry Distributions by Project File Edit Tools Additional Help sa Fabrikam Inc 4 12 2017 OK Summary Project ID TESTA Project File Open History Customer Display C Wok Posted Both I Display GL Posting Date Document Number unts frrensactionanoun A Dae Pepin ake Eee es ee a ae ee STDINV2837 SalesOrder ACTUAL COST MATERI 000 sTomv237 5aes0rde saeSTax oof s200 STDINV2637 Sales Order SALESTAX 00 Project TackingAdut SALES ugh a22095 col 14 0000 sTomv283 6aes Order ACTUAL COST MATERI O00 7 250 00 670 00 STOINV2E29 Sales Order saes ow 5 stows se 760 sTonzss0 ssid ACTUAL OOST MATER ono senon 5106 80 sown feao saes O oo an TEFEN Project ID Legend Work transactions Void transactions iy 2 Enhanced Advanced Analytics window Updated Inquiry to have Debit and Credit fields as defaults and new optional field added called Net amount This was added
3. Resyne Dist Default Delete Document Number CTROOOO0000001 4 Document Date 06 01 2015 Transaction Type Subscription Billing Contrac Posting Date 06 01 2015 Document Amount 450 00 Amount Distributed 450 00 Amount Remaining 0 00 Cost Amount 25 00 Cost Distributed 25 00 Cost Remaining 0 00 Poet BLAccount Amount Type Breakdown Amount Proposal Number Work Order Number Units TESTA ee SALES SALESI 500 00 1 3M Cleaning Solvent TEST A PNOO1 TESTA WOOO BOB SEAGERTS CALGARY AB TESTA 9999 9999 9999 9999 9999 TRADE DISCOUNT TD 50 00 1 3M Cleaning Solvent TEST A PNOOt TESTA WOOO BOBSEAGERTS MONTREAL MB TESTA oe o ACTUAL COST LABOR ACLI 1 3M Cleaning Solvent TEST A PNOOI TESTA WOOO BOBSEAGERTS CALGARY AB 16 Add Project Tracking Distributions Redesign This window has been relabeled from Project Tracking Adjust Distribution to Add Project Tracking Distributions Posted Documents Similar to Project Tracking Inquiry window this has been redesigned as well for a matching layout Project Tracking Build Notes Page 21 of 52 To return to Table of Contents click Here 17 18 Encore Au Add Project Tracking Distributions Posted Documents fe x File Edit Tools Options Help sa Dextordinary I
4. A Project Tracking FREIGHT FREIGHT No Freight ai RSE ar Seog SSR SE SO MISC CHARGE MISC CHRGE Mo Miscellaneous Charge oy Breakdown Maintenance H Budget Detail Actual l G Budaet Detail Setu SALES SALESZ Mo SALES TEST c i p SALES TAX SALES TAX No Sale Tax H a Budget Detal Variance TRADE DISCOU TRADE DISC No Trade Discount H E Budget Header H E Closed Project Distributions H E Posted Project Distributions H E Unposted Project Distributions _ a r I 2 Optimization for Project Analysis reporting Report optimized to pre filter on work open and history tables prior to creation Project Tracking Build Notes Page 32 of 52 To return to Table of Contents click Here Encore m Project Analysis Report Options File Edit Tools Help Debug Clear x Delete E Print Report Option NEW Report Layout Project Analysis Report 1 hi Group by Field Salesperson ID x Include Project Files IY Work I Open History IM Detail Report Project Status Oper ai Force All Projects In Report Show Amounts All Amounts x O Cash Received Only Amount Type z Breakdown IL F Include with Revenue Transaction Type lt ALL gt z W Trade Discount M Freight Ranges Project ID From Pie i To Sales Tax Remove I4 d Fl Destination 7 3 Enhancement for PT distributions for Subscription Billing Module Enhancement to match fields for new field added to Subscription Billing module for Hea
5. 001 0 00 DOUG GILMOUR MONTREAL Qc PTOO058 2015 1000 1000 0000 4175 0000 TRADE DISCOUNT TD1 22 50 PTO0058 PRONO1 PTO0058 WO01 0 00 BOB SEAGERTS MONTREAL MB TESTA 9999 9999 9999 9999 9999 TRADE DISCOUNT TRADE DISC 50 00 1 3M Cleaning Solvent TEST APNOOI TESTA WOO001 0 00 Default ProjectID ME a 4 Improved access to Project Tracking Distributions Inquiry Users can not access Project Tracking Distribution inquiry from Transaction Entry Zoom window Project Tracking Build Notes Page 14 of 52 To return to Table of Contents click Here Encore Te z du Detail Inquiry Of x Customize this File Edit Tools View Help sa Dextordinary Inc 07 13 2015 Clear amp Redisplay Account 1000 1000 0000 1100 0005 O gt G sa Dextordinary Inc 07 13 2015 Description PETTY CASH f Y File Edt Tools View Additional Help E Document Number 64 i I Display Master ID Name in W0 Proposal Number Document Date 06 19 2015 Transaction Type GL Adjustment Posting Date 06 19 2015 Di Journal Entry 64 Audit Trail Code Document Amount 800 00 Amount Distributed 800 00 Amount Remaining 0 00 Sc l l Cost mount 0 00 Cost Distributed 0 00 Cost Remaining 0
6. Improved Project Tracking Distribution entry for Subscription Billing Contracts The Project Tracking Distributions entry window will now have the ability to Resync the PT distributions created for any changes made to the Contract For example if PT distributions are assigned for the contract level and any of the following is changed on the contract the user can resync the PT distributions to pull in the new data Adding new line item Removing Existing Line item Unit Price Change Quantity Changed Description Changed Markdown applied Markdown Removed GL account override added or removed With this feature it will allow for more flexibility in the product as the user will not need to rebuild the Project Tracking Distributions when adjustments to the contract are made They will retain any existing Distributions assigned that are not affected by changes to the contract Project Tracking Build Notes Page 25 of 52 To return to Table of Contents click Here VD i Le ee F L Z i Cr Project Tracking Distribution File Edit Tools Options Help Debug sa Dextordinary Inc 05 29 2015 Document Humber CTAOOOUD000005 06 01 2015 Transaction Type Contract Bill 06 01 2015 Document Amount 229 00 Cost Amount Document Date Posting Date Province Test field Diu UD field ane field UD field p SALESI a s9900 C UTC OCOCOCSCSCSCSC S 00 SBUNEDEF _ ATUAL COSTLABOR gt ACL aera TOO C O 0
7. 3 User Defined 3 E E Invoicing Transachon Enty E m User Defined Tite 4 User Defined 4 E E Sales Order Processing all al User Defined Tite User Defined 5 E E Purchase Order Processing E User Dehned Tite amp User Defined 6 E B Fawol E User Defined Tite7 User Defined 7 E E Ba janak au x B Post Actual to Budgets based ort Alleen eU imate ec i C GLPosting Date C Document Date lcs LULA e E E M Disable Crose Project Budget Reporting No Waming on Partial Distributions Automaticaly Caculate Operating Cost I Require Breakdowns Revenue Require Description except on tay and freight Labor Cost 2 Auto Create Project from SOP Number Auto Create Distributions for Deferrals T Auto generate Project Numbers Deferral Dummy Project C SECHIN Usel Defined Field Tites A OF Cancel fest Provect ID Mert Adjueiment Number PPT OODO0000000000002 1 Resolved issues with Allocation of quantities 2 Fixed issue with VCR button when displaying assigned Breakdowns only 3 Fixed issue in the function ME_Retained_ Description Description comparison issue Build 1 005 May 9 2013 Enhancements 1 Enhancement for Description We have added a new description field of length 255 characters to the PT tables We have populated the same data existing description to this new field Replaced existing description field on forms and reports with new 255 Character description field 2 Enhancement new field We have ad
8. Adjustments options through transaction inquiry User will now have the ability to add PT adjustments to transactions through Transaction inquiry for the Following Transactions GL entries through Journal Entry Inquiry and Transaction Entry Zoom AP Entries through Payables Transaction Entry Zoom AR Transactions Through Receivables Transaction Inquiry Zoom Cash Receipts through Cash Receipts Inquiry Zoom Project Tracking Build Notes Page 5 of 52 To return to Table of Contents click Here Encore Invoice Transaction Through Invoice Inquiry lventory Transaction through Inventory Transaction Inquiry POP_Matching Through Purchasing Invoice Inquiry Zoom POP_Receipts Through Receivings Transaction Inquiry Zoom Sales Transaction through Sales Transaction Inquiry Zoom Users will need to enable this ability through Project Tracking Setup Once enabled if the user attempts to access PT distributions for the transaction inquiry and the PT distributions do not exist for the transaction then the user will be notified and provided the option to add the PT distributions Mi project Tracking Setup Oe x File Edit Tools Options Help Debug Ask to Enable OpenPT Quick Entry Require Full Distribution General Ledger Payables Transaction Entry Iv Receivables Transaction Entry Invoicing Transaction Entry Sales Order Processing Purchase Order Processing Payroll Cash Receipt Entry Allocations out of Inventory
9. Au Project Tracking Inquiry Fie Edit Tools Additional Help OK 5 Cea Redisplay Project ID O Description mE x Summary ransacation Type AP Youcher Customer Document Number Display C Wok Posted C Both Date F l Display GL Posting Date Amount Type l j M Display Voucher Number for AP Vouchers ears Number 7 F I Display Master ID Name in WO Proposal Number ProjectID Document Number Date Amount Type Transaction Amount Manager y Povrce UserDefned4 UserDefned5 User Defned6 User Defined DUMMY DEFERRAL 00000000000000008 AP Voucher 05 15 2015 ACTUAL COST LABOI ACLI 500 00 DUMMY DEFERRAL 00000000000000009 AP Voucher 05 15 2015 ACTUAL COST LABOI ACLI 650 00 DUMMY DEFERRAL 00000000000000011 AP Voucher 05 20 2015 ACTUAL COST LABOI ACL1 500 00 PAYABLE TEST 00000000000000009 AP Voucher 05 15 2015 ACTUAL COST LABOI ACL2 45 50 PAYABLES 00000000000000013 AP Voucher 06 22 2015 ACTUAL COST LABOI ACL2 25 00 PAYABLES 00000000000000013 AP Voucher 06 22 2015 ACTUAL COST LABOI ACL3 33 25 AP Voucher 06 22 2015 ACTUAL COST LABOI ACLI 600 00 00000000000000014 AP Voucher 06 22 2015 ACTUAL COST LABOI ACL2 30 00 PAYABLES 00000000000000014 AP Voucher 06 22 2015 ACTUAL COST LABOI ACL3 39 90 00000000000000015 AP Voucher 06 01 2015 ACTUAL COST LABOI ACLI 400 00 PAYABLES 0000000
10. Batch ID sa Document Type Invoice F Intercompariy Doc Date 05715 2015 Description Date Yoided 00 00 0000 P O Number Vendor ID 010 j Hame American Airlines Cargo Address ID PRIMARY Remit To ID PRIMARY Tax Schedule ID P N NO 2P Payment Terns 24 EOM Net 15th 1099 Amount 475 00 Purchases 500 00 Trade Discount 25 00 Total Payments 40 00 is a a r m rou eo oa 1 Resolved issue with Help Files failing to opening About this window Link will now open the Project Tracking User Manual on any Project Tracking window 2 Resolved problems with Project Analysis reporting Users received an error when generating the report with Range filtered on User Defined Fields 3 to 7 Users also received blank report when reporting filtered for amount types of Actual Cost Labor Actual Cost Material and Adjust Both issues have been resolved 3 Resolved problems with defaulting Project ID in PT distribution window Issue noticed with Description field being cleared when defaulting the project ID in the PT Distributions window This has been resolved 4 Resolved issue with Amount Remaining in PT distributions entry window for General Journal Entry Project Tracking Build Notes Page 27 of 52 To return to Table of Contents click Here Encore Issue was noticed for General Journal Entry and distributing to an amount type of Trade Discount or sales The amount remaining was displaying incorrectly This has been resolved Resolved issue with SOP
11. L Reference Docume Doc Date Document Number Descripti H1 Group by ME Group Field H2 Project Project ME Job ID ME Work Scope ME H3 Amounttyp Amount Type ME Amount Type H4 Breakdown Breakdown Breakdown oie neem eran an Fs Document Document Number Reference Document JME Breakdow F4 Breakdown ca are Total for Breakdown gt gt gt o Doc Date Document Number Gilesperach i Waspeciiied Selespersch tk 88 Project PAYABLES Amount Type ACTUAL COST LABOR Breakdown ACLI ACL1 06 01 2015 00000000000000015 06 22 2015 oo000000000000014 AMER DOC 8 Adjust Project Tracking Distributions window Redesign The Adjust window has been redesigned to be in line with Project Tracking inquiry New Filters have been added as well allowing users to search by Project or by Document Number Document Number range moved from additional filters to main window If search by Project ID is used the User can also use additional Filters such as Amount Type Breakdown Code Transaction Type and Account Number brought into the main window Additional Filters button will allow user to use pre existing additional filters Project Tracking Build Notes Page 17 of 52 To return to Table of Contents click Here lt Encore Au Adjust Project Tracking Distributions Of ES File Edit Tools Help sa Dextordinary Inc 07 13 2015 OK 5 Clear Add Adjustment Mass Change Select by Project ID TESTA
12. P O Number Remit To ID PRIMARY Shipping Method MAIL Payment Tems 2 EOM Net 15th Tax Schedule ID P N NO P Purchases 0 00 1099 Amount Trade Discount 0 00 Cash Freight 0 00 Check if Miscellaneous 0 00 Credit Card Tax 0 00 Terms Disc Taken Total 0 00 On Account 7 Distributions s I4 4 gt DI byBatchID Status Unsaved iy Vendor Yearly Au Quick Project Entry Window File Edit Tools Additional Help sa Dextordinary Inc O7 10 Proie c Amount Type ACTUAL COST MATERIAL Split A Ae Breakdown EEMS Description User Defined 4 f User Defined 7 City User Defined 5 Proposal Number Province User Defined 6 f work Order Number 2 Cleanup of ME_GL_TRX_HDR_WORK_Cache table ME97749 after posting and deleting of transactions With this update should GL transaction be deleted or posted then this will remove the transaction from this table This will assist with improving posting batches as posting process reviews table during posting Project Tracking Build Notes Page 13 of 52 To return to Table of Contents click Here Encore 3 Resync option for SOP Transactions With this new feature should a SOP transaction already have Project Tracking Distributions created and a user make changes to an SOP transaction prior to posting they can now Resync PT Distributions for the transactions The user would access PT distribution entry window The amount and Cost remaining would update accordingly showing amounts that
13. PT adjustments window Users can now search by document or by project on the Adjust Project Tracking Distributions window Additional filter options enabled when selecting by Project ID Primary additional filters viewable on page are Amount type Transaction Type Breakdown Code and account number Additional filters accessible using the Additional Filters button Adding Adjustments have also been separated out from PT adjustments and posted distributions Project Tracking Build Notes Page 7 of 52 To return to Table of Contents click Here Encore PT adjustments now accessible through the Add PT adjustment button on this window Primarily used to set Beginning Balance and add a PT adjustment not linked to a posted transaction Users can also add PT distributions to posted transactions by selecting the Add Posted Distribut Button on this window This will open the Add project Tracking Distributions window which is also accessible from Project Tracking main menu on the Transaction Pane JE Adjust Project Tracking Distributions Papel a t File Edt Tools Help Debug sa Dextordinary Inc 08 31 2015 PF DocumentNumber Project Description CustomerID Amount Type Se Transaction Type ne I Display Posting Date Breakdown code RY Account Number ee ee I Display Voucher Number for AP Vouchers Additional Filters I Display Master ID Name in WO Proposal Number lah Legend V Void transactions G Project Tracking Build Notes
14. Page 8 of 52 To return to Table of Contents click Here Encore PA add Project Tracking Adjustment File Edit Tools Help Debug 08 31 2015 Sarve Cancel Beginning Balance Adjustment Project ID TEST Transaction Type Project Tracking Adjustments Document Number Document Date 087 3172015 7H Description Adjustmerit Amount Type SALES Breakdown Amount Units Manager MANAGER City State User Defined 4 User Defined 5 User Defined 6 User Defined 7 Work Order Number Proposal Number TEST Originating Master IC sa Originating Master Name is Hour forked Account Number GL Posting Date 08 31 2015 7H BA add Project Tracking Distributions File Edit Tools Help Debug sa Dextordinary Inc 08 31 2015 x Transaction Type C AP Voucher C Invoicing Invoice C AR Invoice Purchase Order Invoice C Cash Receipt Purchase Order Receipt GL Adjustment Sales Order Processing Inventory Adjustment Journal Entry 145 Document Date 08 31 42015 Amount 0 00 Mo Amount shown for Gl Project Tracking Build Notes Page 9 of 52 To return to Table of Contents click Here Encore Project Tracking Transactions Transactions Adiust Project Tracking Disinbutions 4 Improved messaging for sub ledger General entries As users are unable to create PT distributions manually on sub ledger entries the message has been improved to ensure clarity as to what le
15. and the user can select default to restart the creation process Cancel would return the user back to the Add Project Tracking Distributions Posted Documents window with the current set distributions Microsoft Dynamics GP ltyou click OK these PT distributions will be attached to this documents To make subsequent changes you must use the Adjust PT Distributions window Delete Cancel Improved ability to access Adjust Project Tracking Distributions window from Transaction Inquiry With this ability the user can quickly update Project Tracking Distributions for posted transactions should they need to be updated after the transaction has been posted To do this the user would access the Transaction inquiry and then access Project Tracking Distributions inquiry for the transaction From here they can select Additional gt gt Adjust Project Tracking Build Notes Page 22 of 52 To return to Table of Contents click Here Encore Distributions or Ctrl K This will open the Adjust Project Tracking Distributions window filtered to the specific Document number Ai Sales Transaction Inquiry Zoom 5 x File Edit Tools View Options Additional Help sa Dextordinary Inc OF 13 2015 2 OK Type T ype ID 06 19 2015 Batch ID Default Site ID Customer PO Number Document Mo Customer ID Customer Mame Ship To Address YELLOWSTONE 3266 Rosew
16. breakdown codes for projects for which no breakdowns have been assigned 2 Fixed the issue in Redisplay button in Budget Maintenance screen Project Tracking Build Notes Page 44 of 52 To return to Table of Contents click Here Encore Build 1 012 Jan 7 2014 1 Fixed the problem with the Add_JC_Dist_Line Script of form ME_Job Cost_Distribution has two optional parameters Under certain conditions the optional parameter can be referenced in run time causing a wrong number of parameters error message Build 1 011 Jan 3 2014 1 Fixed the problem of Project Distributions automatically being created from Batch Payroll screen even when project distributions are not actually created 2 Fixed the issue which existed in assigning Project Tracking information to an already posted payables transaction from the adjustment window 3 Re fetched the Note Index for a Project ID if for some reason it wasn t set initially when the Project was created Build 1 010 Nov 15 2013 Enhancements 1 Enhancement Project Tracking Creation of Project Tracking Budget Importer Project Tracking tons ards Transactions Cards Adjust Project Tracking Distributions Project Project Tracking Importer Breakdown Budget Importer Vendor Breakdown GI Rreakdown File Edit Tools Help sa Fabrikam Inc 4 12 2017 Budget Import Setup ID Import File File Type Lomma Delimited X n Import Replaces Any Ex
17. have not been distributed yet By selecting The Resync option will Resync PT distributions for the transaction The process will update all existing PT distributions accordingly for any changes to Description GL account and Amount It will also insert any new PT distributions for any new line items added or markdown being added Note any new rows being added will be set to the default user Project ID during Resync and may need to be adjusted Au Project Tracking Distribution File Edit Tools Options Help sa Dextordinary Inc 07 10 2015 Delete Default Resync Dist Document Number IVC20045 Document Date 06 01 2015 Transaction Type Sales Order Processing Ceidio Document Amount 511 25 Amount Distributed 460 43 Amount Remaining 50 82 Cost Amount 25 00 Cost Distributed 25 00 Cost Remaining 0 00 ProjectlD P gt GL Account P Amount Type Breakdown Proposal Number Work Order Number Units a a O User Defined 4 Defined 4 p User Defined 5 Defined 5 J9 User Defined 6 Defined 6 p User Defined 7 Defined 7 aa ITT 2015 9999 9999 9999 9999 9999 SALES SALES 500 00 1 3M Cleaning Solvent PTOO058 PRONO1 PTO0058 001 0 00 BOB SEAGERTS CALGARY AB PTO0058 2015 1000 1000 0100 4500 0003 ACTUAL COST LABOR ACLI 25 00 1 3M Cleaning Solvent PTOO058 PRONO1 PTO0058 W001 0 00 BOB SEAGERTS CALGARY AB PTO0058 2015 1000 1000 0500 2292 0000 SALES TAX STX2 3 00 PTOO058 PRONO1 PTO0058
18. of Contents click Here Encore Project Tracking Distribution File Edit Tools Options Help sa Dextordinary Inc 10 02 2014 Document Number CTROOOOO0000009 10 02 2014 Transaction Type Contract Bill 10 02 2014 Document Amount Document Date Posting Date Cost Amount Description User Defined 3 ence User Defined 6 Proposal Number 2a Order ebei E 1 3 M Safe Stripper MANAGER CITY TEST EST OST MATERIAL 1 3 M Safe Stripper MANAGER CITY TEST BLES 1 3M Stripping Pad Frame MANAGER CITY Total Document Amount Distributed 28 34 GBB Total Cost Distributed i O KE iJ 2 Default Project ID Delete Default m Project Tracking Distribution File Edit Tools Options Help sa Dextordinary Inc 10 02 2014 Document Number CTROOOOOO000009 10 02 2014 Transaction Type Contract Bill 10 02 2014 Document Amount Document Date Posting Date Cost Amount User Defined 3 fs User Defined 4 Du i Tees 5 air Teee Defined 6 9 User Defined H Proposal Humber Work Order Number SALES 1 S M Safe Stripper MANAGER CITY a 1 3 M Safe Stripper MANAGER CITY SA SALES z 1 SM Stripping Pad Frame MANAGER CITY Total Document Amount Distributed 26 34 FM Total Cost Distributed se 20 96 3 Enhancement for PT inquiry Document Zoom Project Tracking Build Notes Page 35 of 52 To return to Table of Contents click Here Encore PT Inquiry now has the ability to zoom to the G
19. p Document Number Project Description this is my test a description Customer ID AMERICAN Amount Type TRADE DISCOUNT Transaction Type Sales Order Processing 7 I Display Posting Date Breakdown code Account Number z i js MV Display Voucher Number for AP Vouchers i iti i I Display Master ID Name in WO Proposal Number Distribution Description G LAccount Number Work Order Number Proposal Number ger O Ciy Province O User Defined 4 0 User Defined 5 UserDefined6 User Defined 7 J3 05 01 2015 TRADE DISCOUNT TD1 50 00 1 3M Cleaning Solvent 1000 1000 0000 4100 0000 BOB SEAGERTS MONTREAL MB TESTA C20032 Sales Order Processing 05 01 2015 TRADE DISCOUNT TRADE DISC 22 50 1000 1000 0000 4175 0000 0 00 0 00 ELAINE BENNET TESTA I C20033 Sales Order Processing 06 01 2015 TRADE DISCOUNT 263 92 Trade Discount 1000 1000 0000 4175 0000 DOUG GILMOUR power Id 4 gt h Project ID Legend Void transactions iF 9 Project Tracking Distributions Inquiry window Redesign This window has been redesigned to be in line with Project Tracking Inquiry The window has been made larger to allow 3 rows of data instead of 4 rows per transaction and simple view of 1 row instead of 2 Au Project Tracking Distributions Inquiry File Edit Tools Additional Help Document Number
20. the ability to open the Project Tracking Distribution window for a document with a source that matches the Source Document defined in the Deferral Setup window This will allow the project to be changed later Receivables Management Sales Order Processing Invoicing Payables Management Purchase Order Processing Distribution Entry Window Sales Transaction Distribution Entry Sales Distribution Entry Invoice Distribution Entry window Payables Transaction Entry Distribution Purchasing Distribution Entry Navigation Transactions gt gt Sales gt gt Transaction Entry gt gt Enter or select a customer ID gt gt Distribution button Transactions gt gt Sales gt gt Sales Transaction Entry gt gt Enter or select a document number for an invoice or return gt gt Distributions button Transactions gt gt Sales gt gt Invoice Entry gt gt Enter or select a document number gt gt Distributions button Transactions gt gt Purchasing gt gt Transaction Entry gt gt Enter of select a voucher number gt gt Distributions button Transactions gt gt Purchasing gt gt Receivings Transaction Entry gt gt Enter or select a receipt number gt gt Distributions button e Weare supporting the following modules windows 4 Webclient Ul adjustments e Project Maintenance window and sub windows e Project Tracking Inquiry window and sub windows 5 Enhancement Project Import module e Allowing the description to be of
21. to eliminate confusion Project Tracking Build Notes To return to Table of Contents click Here Page 41 of 52 DA Advanced Analytics Detail Inquiry File Edit Tools Help 2 Origin Amount Type Date Y work Open History V Revenue Expense Cash All From Account All C From Project ID All From Account Project ID Doc Number Transaction Type Amount Type Amount Credit TESTA CTROO0000000005 Contract Bill Sales 229 9 0 00 EEEE L z EE SREE i Sn corre ee NORC 7 EAEE EE S ma ae pE i ee Ega A eaS iandaiin e EAE OS i Cine ia a a a ET en as TESTA CTROGOOGOO00006 Contract Bill Actual Cost Labor 36 250 00 36 250 00 0 00 36 250 00 3 Enhancement Advanced Analytics Feature added of saving the grid view settings to the favorites Project ID PA Favorites ay History Customer File Ed Tools Help sa Fabrikam Inc 4 12 2017 Both ANANNNAANANANANAGRS AT Ont indice ACTIIAL CNCTLAROR ivanced Analytics Detail Inquiry Ear T Ep q Amount Type sa Fabrikam Inc gin i Date eed Work y Open v History l V Revenue w Expense wW Cash SAI C From 1 1 1900 To 1 1 1900 count All O From To yect ID All C From A Ta 4 Enhanced installation file Users will now receive a reminder informing them to run Table Conversion should they install a new build The notification will in
22. when there are Project Distributions When the CB No Warning when full distribution not required is not marked in the setup and when the user has not allowed the transactions to be saved Save Anyway in case of any warning e And the calculation check used to determine the differences between PT distribution and the original transaction is being derived from the Full Distribution check calculations Update on Journal Entry inquiry On Ctrl J from Journal Entry Inquiry window the Project Distribution Inquiry window should be opened irrespective of whether the selected transaction line has distribution or not The PT Distribution inquiry window should be opened even if the journal has at least one PT Distribution irrespective of the selected line 1 Fixed the issue of description field is not displaying in the Project Tracking Inquiry window Build 1 004 March 5 2013 Enhancements Project Tracking Build Notes Page 49 of 52 To return to Table of Contents click Here lt Encore 1 Update Voiding CM Documents The doc type was changed from a 0 to a 12 therefore the code for voiding needed to be updated 2 Updated customized reports a PM Transaction Posting Journal b MC PM Transaction Posting Journal 1 Fixed the issue with Budget End Date 2 Resolved issue with work order and proposal umber fields failing to reset their existing values if the project id selected was the user id project Build
23. 0 67 63 Account Description Exchange Rate INVOOS Sales Order SALES 0 00 500 00 Distribution Reference INYOOS Sales Order EST COST MATERIAL 0 00 1 45 1000 0000 0000 1300 0200 0 00 1 500 00 lt INYOOS Sales Order TRADE DISCOUNT 0 00 29 33 1000 0000 0000 2480 0000 1 500 00 0 00 INYOOS Sales Order SALES TAX 0 00 39 02 INYOOS Sales Order SALES TAX 0 00 3 58 Marr Project ID Legend Work transactions V Void transactions 17 Total 1 500 00 1 500 00 Difference 0 00 fe Home ma oe laa gt Di x 2 Resolved problems with Vendor Breakdown failing to auto populate Build 1 016 Sept 17 2014 Enhancements 1 Enhancement Breakdown Unit Accounts feature Users will now have the option to enter and report on quantity units in Project Tracking based on breakdown code The project tracking unit s value should default to the GP Transaction quantity from its originating GP module i e SOP IVC IV POP Payroll SB Note Example below based on SOP Transaction Project Tracking Build Notes Page 36 of 52 To return to Table of Contents click Here lt Encore F Wi Project Tracking Distribution Pa fe E4 File Edit Tools Options Help sa Fabrikam Inc 4 12 2017 C Mo Document Number STDINV2636 Document Date 471272017 Transaction Type Sales Order Posting Date 971772014 l Document Amount 1 463 18 Amount Remaining a 0 00 4 Cost Amount 1 485 o0 Cost Remaining 0 00 E
24. 0 SALES2 E saena ooo T S ooo a a 000 Total Document Amount Distributed 229 00 Total Cost Distributed 18 62 i Default Project ID aR Ie PI4 _ rewneoit ok _ Delete Default 6 Improve Distribution Inquiry for AP Voucher Option added to PT Distribution Inquiry to allow the user to display the Voucher Document Number As a default the option Display Voucher Number for AP Vouchers is checked this will display the document number as the Voucher number in the Project Tracking Inquiry window However if unchecked the document number will display as the voucher document number Project Tracking Build Notes Page 26 of 52 To return to Table of Contents click Here PM Project Tracking Inquiry Distributions by Project File Edit Tools Additional Help Debug sa Dextordinary Inc 05 29 2015 v OF Ea Summary ae Project ID PAYABLE TEST Project File Open History Description testpayable 234 Display C Wok Posted Both Customer i i Bitae as mio DL Document Number Transaction Type Proposal Number Test al ASDFASDF235423 APVoucher actuaL cost LABOR om s a ssDessne cs APVouche ACTUAL COSTLABOR oon 5 fpoctestev srveche___ eerunL costwaren 00 50 BP Voucher ACTUAL COST MATERI am 33 28 Sa payables Transaction Entry Zoom l Fie Edit Tools View Options Additional Help Debug sa Dexbordinary Inc 05 29 2015 Op OK ged Print Voucher No OOOOOO0ON0000001 1
25. 0 ACTUAL COST MATERIA 3535 25 Tt TEST 0 00 8 Improved Summary Report for Project Variance Reporting Summary Variance Report will now display a project Total which consists of as a sum of all pt distributions for the project which is the same sum displayed on the detailed report Total Revenue will now be calculated on the summary report New label added to report to signify that amount type grouping is a required field for the Total Revenue Total Cost and Gross profit Calculations amp Print SendTo Modify A Completed 2 Pages Actual Budget Amount Amount a nnn nnn anon Total for City NEW YORK 52 50 50 000 00 City PALM BEACH Amount Type EXPENSE MATERIAL Total for Breakdown ACM3 ACM3 750 00 0 00 Total for Amount Type EXPENSE MATERIAL 750 00 0 00 2 Total for City PALM BEACH 750 00 0 00 city PEUBLO Amount Type EXPENSE MATERIAL Total for Breakdown ACMZ ACM2Z 59 50 0 00 Total for Amount Type EXPENSE MATERIAL 59 50 0 00 Total for City PEUBLO 59 50 0 00 Total for Project ID PROJECT BUDGET 5 727 19 6 050 000 00 below require Amount Type Grouping Total Revenue 0 00 0 00 Total Cost 5 727 19 6 050 000 00 Gross Profit 5 727 19 6 050 000 00 1 Resolved issue Payables Quick Entry Screen Issue noted where User Defined Fields failing to default in quick entry should user have Vendor Breakdown setup Issue has since been resolved and User De
26. 00 C i 06 19 2015 e ee a ara A Project ID GLAccount Amount Type Breakdown Amount D ast ii ee escription Work Order Number Proposal Number e Manager Ciy Province User Defined 4 User Defined 5 User Defined 6 User Defined 7 02 PT00038 2015 1000 0000 0000 1300 0100 800 00 a v pan S Dab Prono 2015 ine dese gz Distribution Reference DOUG GILMOUR MONTREAL ac i 1000 1000 0000 1100 0005 0 1 E Dz OE i4 Total 800 A H Difference Intercompany nN CAN x ed 5 Project Tracking Inquiry window Redesign Previous windows Project Tracking inquiry Distributions by Project and Project Tracking Inquiry Distributions by Document have been replaced by one window called Project Tracking Inquiry This window combines both windows with additional range filters Users can search by Project Amount Type Document Number range Date Range Amount type range and Account number or a combination of any the prior mentioned ranges Summary option in window will still require a project ID be selected Project ID has also been brought into the Line details in this window for quick review of multiple projects using range filters Simple view for one line will display Project ID Document Number Transaction Type Date Amount type Breakdown and Transaction Amount More detailed view allows users to review Description GL account Number Master ID Name or WO PO Number hours Units and User Defined Fields
27. 00 Operating Co 0 00 Miscellaneous 0 00 Estimated Cost of Material 40 00 Sales Tax 53 89 Estimated Cost of Labor 0 00 Derbi Cr SF l 40 00 l Actual Cost of Labor 35 58 Projected Profit 0 00 Adjustments 0 00 Cash Receved 40 00 i ok 7 Resync Option on AP Vouchers New ability added to project Tracking distributions for AP Vouchers Should the user create PT distributions but then update the AP Voucher they can now resync the Distributions to pull in the updates in the PT distributions window Project Tracking Build Notes Page 11 of 52 To return to Table of Contents click Here Encore i O ALY ee Mi Project Tracking Distribution File Edit Tools Options Help sa Dextordinary Inc 08 31 2011 Delete Default Document Murniber gogogooooooooooz8 Document Date 0873172015 Transaction Type AP Voucher l Posting Date 083172015 Document Amount F08 25 Amount Distributed 508 25 Amount Remaining 0 00 Cost Amount 0 00 Cost Distributed 0 00 Cost Remaining 0 00 ProjectID GL Account Amount Type Breakdown Amount Proposal Number work Order Number Units Manager City 0 State S A User User Defined 4 z JO User User Defined 5 a JO User Defined 6 Defined 6 p JO User Defined 7 Defined 7 a TN 1000 1000 0100 1200 0000 ACTUAL COST MATERIA 500 00 TEST 1000 1000 0000 1200 0005 ACTUAL COST MATERIA 25 00 TEST n 0 TEST 1000 1000 0000 2290 000
28. 0000000015 AP Voucher 06 01 2015 ACTUAL COST LABOI ACL2 20 00 PAYABLES 00000000000000015 AP Voucher 06 01 2015 ACTUAL COST LABOI ACL3 26 60 PT00027 2015 0000000000000001 AP Voucher 05 20 2015 ACTUAL COST LABOI ACL2 25 00 PT00027 2015 0000000000000001 AP Voucher 05 20 2015 ACTUAL COST LABOI ACL3 33 25 TESTA 00000000000000013 AP Voucher 06 22 2015 ACTUAL COST LABOI ACLI 500 00 ld 4 gt bl Project ID lt Legend Work transactions V Void transactions iy Project Tracking Build Notes Page 15 of 52 To return to Table of Contents click Here Encore 6 New Project Tracking Distributions Inquiry Quick View window Users can now use the new Zoom into option next to Document number to access the Quick View for PT distributions from Project Tracking inquiry window This will allow the users to review the PT distributions for the Transactions quickly while reviewing the project inquiry Au Project Tracking Inquiry File Edit Tools Additional Help ok Clear B Redisplay Project ID FS Description E Summary Transacation Type Sales Order Processing Customer Document Number Te Display Wok Posted Both Date 00 00 0000 To 00 00 0000 7 I Display GL Posting Date Amount Type To V Display Voucher Number for AP Vouchers Account Number I Display Master ID Name in W0 Proposal Number emen BET Jans
29. 1 003 February 21 2013 Enhancements 1 Improved messages Removing the message Please fill in at least one amount before entering project distribution screen when opening Project Distribution screen from Sales Transaction Screen 2 Update Table Corrections Update ME table corrections of table that are a copy of GP so that they match GP s version of the table a ME SOP HDR WORK SOP10100 b ME POP Receipt POP10300 c ME _GL Account _MSTR GL00100 d These table references were initially updated but they later removed as couldn t find any place where they were being used in the code ae 7 woe a aa i a Project Tracking Build Notes Page 50 of 52 To return to Table of Contents click Here Encore ME_RM_HISTORY RM30101 SS ME_SOP_HDR_HIST SOP30200 Updated in GP 13 3 Enhanced Project Tracking installer Included latest PT User manual in the installer 4 Updated Table conversion For Table Conversion process Updated the messaging in the progress windows so that the complete are useful Also did some code cleanup removing commented code Build 1 002 Feb 7 2013 Enhancements 1 Updated GP SL Maintenance Window In GP SQL Maintenance window we are now only displaying PT tables therefore excluding those tables which are a copy of tables of GP 2 Improved Installation file The Install now includes Advance Analytics None of the AA components will be installed if the Program F
30. 1000 0100 4500 0003 ACTUAL COST LABOR ACLI 600 00 0 00 BOBSEAGERTS CALGARY AB z 0 00 0 00 Default Project ID USE a 13 Improved Project Tracking Check Links Should Check Links be performed for Project tracking and PT distributions exist for a Project that does not exist then the operation will no longer delete the PT distributions Instead these PT distributions will be logged in the error report and the Project ID associated to them will then be created Any Project created by Check Links will be given the Description Project added by Check Links amp Print SendTo Modify iz Completed 1 Page 077 1372015 Dextordinary Inc Page Errors logged in table pptsclnk log in your local dynamics directory No Project ID table Header for Open Transaction Project Number PPPPP Added Project to table header Project ID PPPPP ME Trx Type Sales Order Processing TRX Amount 4000 00000 Hours Worked O Document Number IvcZ0028 Document Date 06 01 2015 Work Order Number Description 10 3 M Safe Stripper Master ID WOW Amount Type SALES Proposal Number Breakdown SALESZ UD1 DOUG GILMOUR UDZ MONTREAL UD3 QC UD4 UDS UD6 UD Summary Bucket Difference for project JJJJJJ Transaction type Actual Sales Before 8 000 00 After 4 000 00 Summary Bucket Difference for project PPPPP Transaction type Actual Sales Before 0 00 After 4 000 00 Pr
31. 58 2015 vc10018 Sales Order Processing 06 19 2015 ACTUAL COST LABOI ACL1 5 50 1 1 Craftsman Brush 3 Paint 1000 1000 0100 4500 0003 PT00058 w001 PT00058 PRONO1 BOB SEAGERTS CALGARY PTO0058 2015 i C10018 Sales Order Processing 06 19 2015 SALES SALES2 1 Craftsman Brush 4 Varnish 9999 9999 9999 9999 9999 PT00058 w 001 PTO0058 PRONO1 DOUG GILMOUR MONTREAL PT00058 2015 vc10018 Sales Order Processing 06 1 9 2015 ACTUAL COST LABOI ACL2 1 Craftsman Brush 4 VYamish 1000 1000 0100 4500 0003 PTO00S8 w001 PT00058 PRONO1 DOUG GILMOUR MONTREAL PT 00058 2015 i C10018 Sales Order Processing 06 1 9 2015 TRADE DISCOUNT TD1 26 27 Trade Discount 1000 1000 0000 4175 0000 PTOO058 WO01 PTO0058 PRONO1 i 0 00 BOB SEAGERTS MONTREAL 19 Improved Validation for Dummy Deferral Project ID on Project Tracking Setup Users will no longer be able to set a nonexistent Project ID for Deferral Dummy Project ID in the PT Setup window Should a nonexistent ID be set the users will receive a validation message to add the Project ID Project Tracking Build Notes Page 23 of 52 To return to Table of Contents click Here Encore Tr PM Project Tracking Setup File Edit Tools Options Help sa Dextordinary Inc OF 13 2015 W Enable Project Tracking Require Full Ask to Enable Use for Constant Cuetibution Nea OT Dh nale C abri T rana cokes Paar Da
32. Entry E E o E E ee E G gau E E E E Ei Subscription Billing M No Warning on Partial Distributions V Require Breakdowns I Add distributions from GP Inquiry Suto Lreate Project from Auto generate Project Numbers Next Project ID 5 7 Next Adjustment Number PPTOOOOOOOON00000007 08 31 2015 sa Dextordinary Inc Use for Constant Transaction User Defined Field Titles Budgets Yalue User Defined Title 1 Manager E f User Defined Title2 City E E User Defined Title3 State B E User Defined Title 4 User Defined 4 E E User Defined Title5 User Defined 5 E E User Defined Title6 User Defined 6 E E User Defined Title 7 User Defined 7 E E Post Actuals to Budgets based on GL Posting Date Disable Cross Project Budget Reporting Document Date Automatically Calculate Operating Cost Revenue 1 11 Labor Cost 2 22 Material Cost 3 33 Auto Create Distributions for Deferrals Deferral Dummy ProjectID DUMMY DEFERRAL Security User Defined Field Titles Options roe Project Tracking Build Notes To return to Table of Contents click Here Page 6 of 52 Er Payables Transaction Entry Zoom File Edit Tools View Option Additional Help Debug E v OK Print Project Distribution Inquiry Ctrl a oogaoooo000000023 Invoice Batch ID intercompany Doc Date 08 19 2015 Date Yoided 00 00 0000 P O Nurnber PTOOO8 2013 TESTS wa OD Vo
33. Enty UserUehned Title 3 User Delined 2 Hl E Invoicing Tratsection Entry E v UseDefined Tile4 User Defined 4 E E Sale Order Processing E E User Defined Tile5 User Defined 5 E E Purchase Dider Processing gl User Oehned TiteE User D elined amp E Pavol C o UseDecfned Tile User Defined 7 C C wand cecil Erim m m Post Actuals bo Budgets based on tlors ont ol Inventory Ent D E GLPostng Date Pani id pec Powe a E C Disable Cross Project Budge Aepoting D Hao Warming on Partial Distibutions Automatically Calculate Operating Coz fe Regue Breakdowns Revenue T Requie Descriptions fexcept on tax and freight Labor Cost Material Gost Bf lees ole a tuls M Auto Create Distributions for Deferrals Auto generate Project Numbers Deferal Durie Praec 0 i3 Hest Project ii Nest Adjustment Number FP TOOOOOOOOOoOOCNoo02 Securky User Defined Field Tites Options e T Cancel With the Ask to open PT checked when saving closing and posting a transaction the user will be asked if they would like to setup Project Distributions for the transaction Project Tracking Build Notes Page 43 of 52 To return to Table of Contents click Here Encore ld Save Aciorg D Luoe Tene ID lavoice STDINV oe Date 4 12 2017 aly Document No STOINV2412 iJ Jj Batch iD BATCHI4 D gt Customer iD AARONFITOOOT gas Dalm Ste iD WAREHOUSE Dy Customer Narre Aaron Fiz Electecal Customer PO Number Shao Lo Adkhers WAREHOUSE 0 11403 4551 S
34. L Account History table This allows users to access the GL transaction that has been posted and the period is now Closed in fiscal periods and flagged as historical m Project Tracking Inquiry Distributions by Project Ioi x Customize Fie Edit Tools Additional Help sa Dextordinary Inc 10 06 2014 a OK Summary p opona Reports Project ID SA Project File Open History Pr oject Analysis a Diae Wok E Poad I Boh ustomer ispi d i or oste o 7 BA Journal Entry Inquiry Efe x I Display GL Posting Date File Edit Tools View Additional Help sa Dextordinary Inc 10 06 2014 N W Document Number Transaction Type Amount Type Units Transaction Amount Al V OK EM zA Date Proposal Number Work Order Number Description MAEN 5 Audit Trail Code GLTRX00000024 Breakdown manager city User Defined 3 User Defined 4 Fiscal Year aK Batch ID pcos alil Leiteira GL Account Number Transaction Date 11 21 2013 Reference gladjusttest3 4 GL Adjustment ACTUAL COST MATERI 0 00 1 000 00 a ee GJ Cunency 1D USA 4 GL Adjustment ACTUAL COST MATERI 0 00 1 000 00 a ae 5 GL Adjustment ACTUAL COST MATERI 0 00 1 500 00 7 GL Adjustment ACTUAL COST MATERI 0 00 2 000 00 T z INVOOS Sales Order SALES 0 00 86 67 Account Debit Credit INYOOS Sales Order EST COST MATERIAL 0 0
35. Project Tracking 2013 Build Notes ENCORE BUSINESS SOLUTIONS www encorebusiness com twitter com encorebusiness com encore encorebusiness com Microsoft Partner Gold Enterprise Resource Planning Silver Customer Relationship Management Silver Application Development Encore Business Solutions Encore Copyright Build Notes copyright 2015 Encore Business Solutions Inc Printed in Canada All rights reserved Your right to copy this documentation is limited by copyright law and the terms of the software license agreement As the software licensee you may make a reasonable number of copies or printouts for your own use Making unauthorized copies adaptations compilations or derivative works for commercial distribution is prohibited and constitutes a punishable violation of the law Trademarks Microsoft Microsoft Excel Microsoft Dynamicse GP and Microsoft Dynamics GP are either registered trademarks or trademarks of Microsoft Corporation or its affiliates in the United States and or other countries The names of actual companies and products mentioned herein may be trademarks or registered marks in the United States and or other countries of their respective owners The names of companies products people and or data used in window illustrations and sample output are fictitious and are in no way intended to represent any real individual company product or event unless otherwise noted Warranty disclaimer Enc
36. action Type Date Amount Type Breakdown Transaction Amount 2 Distribution Description GL Account Number Ce e a Manager sity Province User Defined 4 User Defined 5 User Defined 6 User Defined 7 Au Project Tracking Distributions Inquiry Quick iew File Edit Tools Additional Help sa Dextordinary Inc 07 13 2015 F Document Number IVC20045 I Display Master ID Name in WO Proposal Number Document Date 06 01 2015 PT Transaction Type Sales Order Processing l Posting Date 0070070000 py Document Amount 511 25 Amount Distributed 511 25 Amount Remaining 0 00 TE Cost Distributed 25 00 Poea een O amott bedon Ame Work Order Number Proposal Number Hows Uris UserDefned4 UserDefned5 UserDefned6 User Defined PT00058 2015 9999 9999 9999 9999 9999 SALES SALES1 550 00 1 3M Cleaning Solvent PTOO058 PRONO1 PTO0058 WO01 BOB SEAGERTS CALGARY PT00058 2015 1000 1000 0100 4500 0003 ACTUAL COST LABOR ACL1 1 3M Cleaning Solvent PTOO058 PRONO1 PTO0058 WO01 BOB SEAGERTS CALGARY AB PTO0058 2015 1000 1000 0500 2292 0000 SALES TAX STX2 MTA MMMM MTAAArA am 7 Improved Project Analysis Reporting Project Analysis Reporting can now be customized to display the Voucher Document Number for AP Vouchers by adding the field Reference Document into the report Au Payables Transaction Entry Zoom File Edit Tools view Options Addi
37. and PT tables being out of sync for line item seq number Issue noticed in back end where SOP distributions being recalculated causing Line seq to be out of sync on the ME_gl_ Distribution _L1_in field in PT tables This has been resolved Resolved Problem for US Payroll Issue noted with zooming into PT distributions from posted paycheck Should check contain multiple distributions when user clicks on the distributions in the inquiry window it will remove the distribution displayed indicating it was deleted by another process This has since been resolved Build 1 022 April 28 2015 Enhancements 1 Improved Breakdown Validations Should the environment have Project GL or Vendor Breakdowns setup then when attempting to assign a breakdown to a transaction line where they not be assigned to Project GL or Vendor level the user will now receive a warning advising them of such This warning will now provide the user the ability to add to this level Selecting Yes will open the appropriate Breakdown Maintenance Window to update the appropriate level wssn EIn l Jw wean 1 rane J a m Project Tracking Distribution Of x Fie Edit Tools Options Help Debug sa Dextordinary Inc 05 11 2015 A IA T ee T Document Number ooodooo0000000008 Document Date 05 11 2015 Transaction Type AP Voucher Pasting Date 05 11 2015 Document Am
38. ded another field called Original PO Number to the PT tables We have saved the original PO number to this new field for POP receipts The field will be stored in the PT Tables Project Tracking Build Notes Page 47 of 52 To return to Table of Contents click Here Encore making it available to pull onto the PT Budget Variance Report Since the field will be stored in the PT Table it will be available to pull onto any user created SQL Reports accessing the table 3 Enhancement New Feature creating project tracking distributions for deferral journal entries e Anew Option in the Project Tracking Setup window for Auto Create Distributions for Deferrals has been added This option would only be enabled when deferrals is activated e Ifthe user assigns deferral information to a distribution line that is assigned to a project the journal entries to future periods that GP s Revenue and Expense Deferrals creates will also include the Project Tracking Distribution using the project of the original distribution line o The system will not support a single distribution account that is split between two or more projects if this is done only the first project will be used in the deferral journal entry e The project tracking distributions are created as soon as the deferral journal entries are created which is at the time the SOP document is posted e When in the Transaction Entry GL or the Journal Entry Inquiry windows we have provided
39. der Comment id 1 Resolved problems with PM_Void_Payments form for GP2013 R2 Form has been updated in GP for R2 trigger was updated to ensure it is now compatible for R2 form updates Build 1 017 Oct 6 2014 Enhancements 1 Enhancement Units option Breakdown maintenance Units option updated to disallow users to make Units a required value for the following Amount Types Actual Cost of Material Estimated Cost of Material Actual Cost of Labor Estimated Cost of Labor Project Tracking Build Notes Page 33 of 52 To return to Table of Contents click Here Encore Pr Breakdown Maintenance 0 File Edit Tools Help Debug sa Dexbordinary Inc 04 01 2017 Save gt Clear ix Delete aA Amount Type ESI COST MATEHIAL n Breakdown ee Inactive Description Units Optional Decimal Places User Defined 4 User Detined 5 User Defined 6 User Defined 7 ld 4 gt gt 7 2 Enhancement Default option for PT distribution This enhancement is to improve the behaviour of the Default button to ensure that the Default Project ID is reset to the correct Default Project ID when selected For example user changes the Default project ID listed in PT distribution window however the Default Project ID in setup options is SA With this update should the user select Default it will change the Default Project ID back to the correct default of SA Project Tracking Build Notes Page 34 of 52 To return to Table
40. dgers would be eligible to have PT distributions Microsoft Dynamics GP To distribute this Journal Entry to Project Tracking the Source il A Document must either be GJ or an Audit Trail Code with an 5 Origin of General Entry 5 Improved Check link Messages Window previously labeled File Maintenance as such all messages were labeled to be file maintenance As window is now been updated to Check links all messages updated accordingly Microsoft Dynamics GP Check links process completed Errors logged in table pptseclnklog in your local dynamics directory Microsoft Dynamics GP Check Links must be marked forthe check links process to run Project Tracking Build Notes Page 10 of 52 To return to Table of Contents click Here lt Encore Microsoft Dynamics GP You must be the system administrator to open the Check Links wih ow 6 Relabeled fields on Project Maintenance Costs window Cost of Material and Cost of Labor relabeled appropriately between Estimated Cost and Actual Cost on window PA project Maintenance Costs Fie Edit Tools Options Help Debug sa Dextordinary Inc 08 31 2015 Project ID COSTTEST 0 00 Estimates 13 30 Sales l l EN 5 50 Operating Cost 2 of Revenue 0 00 Operating Cost of Labor f oot Actuals Operating Cost of Materials 000 Sales 025 00 Trade Discount 41 25 Original Estimated Costs Freight l i 0
41. dicate the Build version that was installed Microsoft Dynamics GP You have installed Project Tracking version 1 0 16 Run table conversion to complete the process Ask Later Project Tracking Build Notes Page 42 of 52 To return to Table of Contents click Here Encore Should user select Ask Later they will receive this notification the next time they log into GP if Table conversion has not been performed Should the user select Proceed the Table conversion window will appear PA Table Conversion Fie Edit Tools Help 09 16 2014 Project Tracking Table Conversion Upgrade 1 Project Tracking procedures updated to support Smartlists in GP 2013 SP2 2 Fixed issues with links on Encore product registration page Links will now direct user to appropriate website Build 1 015 April 29 2014 Enhancements 1 Enhanced Table Structure Updated table structure for Project Tracking to be compatible with Recurring Contract Billing updates 2 Enhancement to Project Tracking Setup Added Ask to open PT in GP transaction entry window feature sa Fabrikam Inc 12 2017 PM rroject Tracking Setup Fie Edt Tools Options Heap fn ee teens Require Ful fake to E nable Use lor Constant Dishisution UpenPT Quick Erti Transaction User D ehned Field T thes Budgets Yake General Ledger r E User Defined Title 1 Location r E Payables Trastaction E nirp E C E User Defried Tile2 Manager T E Asceradles Transaction
42. e in WO Proposal Number Au Document Number Lookup File Edit Tools Help sa Dextordinary Inc 10 08 2015 Filter By Document Number _ Clear F Find 1 Zoom 2 Filter By Transaction Type Filter By Project ID Filter By PT Location M Work V Open T History v View All Document Numbers by Document Number Document Number Transaction Type Project ID PT Location Document Date oooooooo000000008 AP Voucher DUMMY DEFERRAL Open 05 15 2015 oooooo00000000003 AP Voucher DUMMY DEFERRAL Open 05 15 2015 oooooooo000000009 AP Voucher PAYABLE TEST Open 05 15 2015 oooo0000000000011 AP Voucher DUMMY DEFERRAL Open 05 20 2015 ooo00000000000011 AP Voucher PT 0002 2015 Open 05 20 2015 oooo0000000000013 AP Voucher PAYABLES Open 06 22 2015 OO000000000000013 AP Voucher PTOOI00 2015T Open 06 22 2015 oooooo0000000001 4 AP Voucher PAYABLES Open 06 22 2015 ooooo000000000015 AP Voucher PAYABLES Open 06 01 2015 oooooo00000000021 AP Voucher AROO0007 2015 Open 07 17 2015 I4 4 b Pi coooooo0000000022 AP Voucher PTOO100 2015T Open 07 16 2015 Cancel 1 Resolved issue with Margin Report Issue noticed on subtotal displaying incorrect GP for Margin Report 1 5 and 7 Issue has since been resolved Resolved GL account Alignment issue on Project Tracking Distribution Entry and Adjust windows Issue noticed on window if GL account was not full 5 segments that should user tab off the GL account field it would shift the display to th
43. e left forcing the first digit of the GL account to appear cut off This has since been resolved Example of issue appears below Project Tracking Build Notes Page 4 of 52 To return to Table of Contents click Here Encore Ai Project Tracking Distribution GPDAT sa OK Delete Default Options File Tools Help Add v Note Actions Options File Tools Help Document Number l 13 Document Date 09 14 2015 _ Transaction Type Payroll Check Document Hours 800 Hours Distributed 800 Hours Remaining 0 00 Amount Type Breakdown Poito Gt Accomt P Description Proposal Number Work Order Number ACTUAL COST LABOR 8 00 4 TEST A PNOO ci 0 00 8 Carter Anthony Michael Build 1 025 Aug 21 2015 Enhancements 1 2 Enhanced PT adjustments for GL transactions Users will now have the ability to Add PT adjustments for GL Transactions When adding adjustments to the Journal Entry number the user will be sent to the PT Distribution Selection window to select which part of the Transaction they will be creating PT distributions for Pr Project Tracking Distribution Selection File Edit Tools Help Debug sa Dextordinary Inc 08 31 2015 Journal Transaction Date 087 3172015 Mark AllDebis All Credis D Al Lines Account Description 1000 1000 0000 1200 0000 O ACCOUNTS RECEIVABLE 1000 0000 0000 1300 0100 INVENTORY 7 Continue Cancel Improve PT
44. eate Distributions for Deferrals M Use RM Cost Entry Assists unc with GE Guantity a Fol oligos lan ok Deferral Dummy Project ID E Next Project ID Next Adjustment Number PPT00000000000000001 Securty User Defined Field Tiles a o _ Comet Payroll Distributions from Gross Net Breakdown Maintenance The setting for Units in PT distribution is done in Breakdown Maintenance window As a default once installed the Units field is Blank which is the same as optional The user can adjust this to be Required and set the number of Decimal places 7 B Breakdown Maintenance Fa lel x File Edit Tools Help sa Fabrikam Inc 4 12 2017 ij Save Clear Delete mA Amount Type SALES Breakdown SALET Inactive Description SALES 1 TEST Location WINNIPEG Units Manager TOM HANKS User Defined 3 Decimal Places 1 X User Defined 4 User Defined 5 User Defined 6 m User Defined 7 ld 4 gt bl J Please note that setting Unit to required does not affect existing transactions As such any existing un posted transactions may require to have PT distributions manually adjusted Unit Default options available to user Sync with GP Quantity Unit defaults should always sync with the GP Quantity Unit value will default to the quantity from the GP transaction window if this setting is turned on Messages will pop up upon changing the value of the Unit or upon saving or posting the GP transaction if uni
45. eeaeeeeeesseeeeeeeaeseeesaeeseeeaeeseeseeaseeenanes 46 Bud TOOG J0ne I e740 Ec erence rent ene ener eee S 46 BAVA elie IE 00SM 20 lee merase st ne rete rene cere ree ener ee eer ee eee ane a ere rere 47 Buld O07 Ob ge 9 ee 28 e eR 49 Build 1003 Fepruary 21 201 Saaana EE EEEE aca aet 50 BOING AZ Fe 720l orr E E 51 BUIT ROOF J nI O e E E E E E AA 51 Additional Product Support Resources cccceccceccesecseccsecencceuccseceneceuceseceneceeeuceeceseeeueeeeeeeeaeeeees 52 Project Tracking Build Notes Page 3 of 52 To return to Table of Contents click Here Encore Build 1 026 Oct 8 2015 Enhancements 1 OK gt Clear Z Redisplay Improved Add PT Adjustment window be removing Zoom into Link With addition of new Add Project Tracking Distributions window the zoom into option was no longer needed on the Add PT Adjustments As such this has been removed Enhanced Adjust Project Tracking Distributions and Project Tracking Inquiry for Document Number Lookup Users can now use a lookup feature to lookup the specified document in their range filter Au Project Tracking Inquiry Fie Edit Tools Additional Help SOSSE pS a Project ID P Description pm Summary Transacation Type x ustomer eae Tree To Display C Work Posted Both Date m To M l Display GL Posting Date Amount Type PO Te On MV Display Voucher Number for AP Vouchers Account Number z R 52 Display Master ID Nam
46. eecccccssseccceeeeeeeeeeeeeeeeeeeeeeeeseeeeeeseeeeeeeseeeeeeeseeeeeesaeseeesaeeseessaaseesseaeeeesanes 13 UT Ce jp 1 023 oe r 27 2015 ga ee ee een eee en 24 Build 1 022 April 28 2015 0 ecccccssseccceseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeseeeeeeeeeseeesseeseeeaeaseeseaaeeeesaees 28 LUT Ce Il Be 67 MIr I2 00 b gt eee ere ce ee ere ere re ee eee ee ee ee ere 29 BOI ROZO F232 O10 o saaesocasanacecasanacocacanscocaaanscossaanocossasncansnanecasanosecasasonecanneoesdanacsocssanete eee dusaciaeass 30 PLOT Ce led BR Oh Ro Fep Oc ape a rere nre ee rere CEPR re CE ECE eee neT EERE CT TREE rEC EET CECE E E errr ete Tree 31 BU Gl 1 018 repuild Jan 12 20I S a 32 Build 1 018 Jan 5 201 D ecicsctcnsvecetasuvencteantancteastausbsastavabsaseeesbapatenssiesteastientansiventansinastiduveieatonsaancnsavacnenals 32 Bald TO IZ OCT G 20 lA eE E E E EE 33 SUV Ce TOG Spp I On E 36 BUda FOLE APII ZONA aa 43 DUC TOTS Reo L 20A ee ee E 44 Build 1 013 Jan 28 2014 oo eccccccsssecccceeseeeeeeeeeeeeaeeeeeeeseeeeeeeeeeeeeeseeeeeeeseeeeeeseeseeessaeseesaeeeeseeaeeeesaees 44 Bud TOR JA20 ee eee ee ee ee ee ee ere 45 BUTI oie WR OSS a eo eee 0 Es eee ee eee ee ee ee eee een ee ener ere tre tree 45 BIG VOTO NOW 15 2013 st cccitctacct sacha EE EEEE S E E 45 Bulad TOO ag 16 ies is 710 is enn eee A eee eee eee EE ae ee eee E eer ener 45 SUI eli G10 Seas ciclo 1s eee 46 Build 1 007 June 19 2013 2 eecccccsessccceeeeeeeeneeeeeeeaeeeeeeeseeeeeeseeeee
47. fined Fields will default correctly 2 Resolved issues with Project Tracking Analysis reporting Project Tracking Build Notes Page 12 of 52 To return to Table of Contents click Here Encore Issue noted with PT analysis failing to display results for Salesperson ID range Issue has since been resolved 3 Resolved problem with Project Maintenance Costs Issue noted where Project Maintenance Costs failed to update accordingly when PT adjustment amount changed or deleted Problem has since been resolved 4 Resolved Issue with PT Distribution Selection window for GL transactions Issue noted that user receives pop up message if attempt to re access PT distribution selection window when they already had Distribution selection window open for the transaction Issue has since been resolved and user would not be returned back to distribution selection window Build 1 024 July 13 2015 Enhancements 1 Improved Quick Entry Window Payables Quick Entry will now default to the Vendor default breakdown code should environment have Vendor Breakdown default set Au Payables Transaction Entry File Edit Tools Options Additional Help ql Save lx Delete m Post Pint Voucher No o0000000000000013 Intercompany Batch ID Document Type Invoice Doc Date 07 10 2015 F Description Vendor ID amp 2010 i Currency ID USA l Name American Airlines Cargo Document Number Address ID PRIMARY
48. g Contracts This has since been resolved Resolved issues with Project Tracking Importer and security Should GP environment be limited user was unable to import using PT importer as they received error indicating they did not have permissions to delete tables This has since been resolved Fixed issues with Sales Order Processing Batch Edit list report Report failed to display Distributed Costs for Actual Cost of Labor and Actual Cost of Material This has since been resolved Build 1 023 May 27 2015 Enhancements 1 Improved PT Advanced Analytics for R2 Ribbons Compatibility With this latest update Users can now use Project Tracking while having windows Command display set to Action Pane and Action Pane strip This allows the product to be fully compatible with the Ribbons feature Project Tracking Build Notes Page 24 of 52 To return to Table of Contents click Here Encore 2 Enhanced Project Tracking Compatibility with Binary Stream s Multi Entity Management product With this latest update PT distributions will update accordingly while M E M is enabled 3 Optimized Adjust Project Tracking Distributions window The optimization has improved performance in loading the data for the Adjustment window 4 Improved Table Structure for line items The improved structure allows Project Tracking to be more compatible with Subscription Billing product as the line items are now decoupled from the Subscription Billing line items 5
49. hancement but the user had the option to add the Units Colum to their modified reports The field name is TRX Unit Project Analysis Variance Reports Receivables Outstanding Balances GL Reconciliation Summary Reports Adjustments Units field added to Adjust Project Tracking Distributions and Add Adjustments window Project Tracking Build Notes Page 39 of 52 To return to Table of Contents click Here Encore F Adjust Project Tracking Distributions File Edit Tools Options Help sa Fabrikam Inc 4 12 2017 Testa OOOO s SALES TAX WINNIPEG MR MANAGER iY a a a S s74500 0 SAT wwe onas O l C Ooo y O O oa acTwarcost SURREY feosnewron OOOO T a 1 KREZO m Project Tracking Adjust Distribution Fie Edit Tools Options Help sa Fabrikam Inc 4 12 2017 Document Number STDINW 2640 471272017 Transaction Type Sales Order 42 2017 Document Amount 1 587 69 Cost Amount 890 00 a a A S n O O ET 583000 TESTA O00 2300 00 SALES TAK SALES TAx 0 00 Total Document Amount Distributed 1 887 69 87 69 Total Cost Distributed a oo Default Project ID TESTA Delete Default Project tracking Importer Functionality added for Units and Units Decimal Place fields on Import Setup Project Tracking Build Notes Page 40 of 52 To return to Table of Contents click Here lt Encore m Project Tracking Import Setup File Edit Tools Help sa Fabrikam Inc 4 12 2017
50. iles AA is not selected A step in the install process Build 1 001 Jan 10 2013 Enhancements 1 Project Tracking implemented into GP2013 Code was rolled up from PT Build 36 of GP2010 Project Tracking Build Notes Page 51 of 52 To return to Table of Contents click Here Encore Additional Product Support Resources Access the latest Product Builds htto www encorebusiness com downloads Request registration keys regkeys encorebusiness com Visit our Project Tracking product page here on our website to access e User Manuals click on the Manuals tab e Product demos click on the Demo tab Product Support Email Support encorebusiness com Phone 1 888 898 4330 Online submission form http www encorebusiness com support encore a Support Request Tip To assist in expediting the review of any issues please ensure that the following information is provided with a support request e What product is the support inquiry for e What Version of GP is used e What is the build number installed for the product e this can be found by logging into GP as SA and going to Microsoft Dynamics GP gt Tools gt support gt system gt Encore product registration Once there locate the product from the list and the Build number would be listed on the right hand side under Version Project Tracking Build Notes Page 52 of 52 To return to Table of Contents click Here
51. ion page Added Project Tracking menus to the Navigation Pane Allows PT to be accessed from the menus within Webclient 2 Enhancement Description field Project Tracking Inquiry Increased Character limit on Description filed to 255 by changing description field to description field 255 on Project Tracking inquiry window Build 1 006 June 13 2013 Enhancements 1 Updated User Manual and online help files are included Project Tracking Build Notes Page 46 of 52 To return to Table of Contents click Here Encore 2 Enhancement Project Tracking Description field Updated Description field to Description field 255 this allowed the description field to be increased in size 3 Enhancement PT distributions no longer matching Refined logic for new warning when saving a document transaction in GP and it has been distributed to PT but the distributions no longer match GP 4 Enhancement PT for Deferrals Auto Create distributions for Deferral Checkbox added and a Project ID field added with the label Deferral Dummy Project ID Piproject Tracking Setup File Edit Tools Options Help sa Fabrikam Inc 4 12 2017 i Enable Project Tracking Require Full Ask to Eneble Use lor Constant Distribution Open PT Quick Entry Transaction User Defined Field T ites Budgets Value General Ledger fis Ca User Oehned Tite 1 Locabon a E Payables Trangachon Entry m E User Dehned Tite 2 Manager w Fiecewables Transaction Enirg le User Dehned Tite
52. isting Budget M Mark Imported Budget Amounts as Confirmed Reference Budget Import Last Import Date Last Imported by User 7 Cancel Clear 1 Fix issue with Summary report giving long integer out of range error Changed local variable from an integer to a long Build 1 009 Oct 15 2013 Enhancements 1 Enhancement Project Tracking Project Tracking Build Notes Page 45 of 52 To return to Table of Contents click Here Encore Implemented the GL Breakdown functionality Defaulting Selecting breakdown based on account segment Cards El Reports ions Project Project Analysis Breakdown Variance Reports Vendor Breakdown Receivables Outstanding GL Breakdown GL Reconciliation Budget Summary Reports ani Breakdown Maintenance IDX Fie Edt Tools Help sa Fabrikam Inc 4 12 2017 lal Save B Cancel GL Option z sount Account Amount Type X l Display Assigned Breakdowns Only T Assign Default Breakdown Description 4 la 4 gt di 7 1 Fixed the issue in PT Import When updating the Project Master we should update only the fields that are specified in the import Build 1 008 Sept 3 2013 Resolved Issues 1 Correct logic SOP Orders and Fulfillment Orders for new warning when saving a document transaction in GP and it has been distributed to PT but the distributions no longer match GP Build 1 007 June 19 2013 Enhancements 1 Enhancement navigat
53. istribution entry window The amount and Cost remaining would update accordingly Project Tracking Build Notes To return to Table of Contents click Here Page 19 of 52 Encore showing amounts that have not been distributed yet By selecting The Resync option will Resync PT distributions for the transaction The process will update all existing PT distributions accordingly for any changes to GL account and Amount It will also insert any new PT distributions for any new line details added to transaction or Sales Distributions Note any new rows being added will be set to the default user Project ID during Resync and may need to be adjusted W dii Project Tracking Distribution Ee ES File Edit Tools Options Help Resyne Dist Document Number SALESOO01 Document Date 07 13 2015 i i i Delete Default Transaction Type AR Invoice Document Amount 559 08 Amount Distributed 508 25 Amount Remaining 50 83 Cost Amount 600 00 Cost Distributed 600 00 Cost Remaining 0 00 Proposal Number Work Order Number Units TESTC 9999 9999 9999 9999 9999 SALES SALESI 500 00 4 0 00 BOBSEAGERTS CALGARY AB TESTC 1000 1000 0000 4175 0000 TRADE DISCOUNT TD1 25 00 l 0 00 BOBSEAGERTS MONTREAL MB TESTC 1000 1000 0000 2290 0000 SALES TAX STXI 33 25 0 00 BOBSEAGERTS CALGARY AB TESTC 1000
54. l C10031 Il Display Master ID Name in WO Proposal Number Document Date 07 08 2015 Transaction Type Sales Order Processing Posting Date 07 08 2015 Document Amount 538 50 Amount Distributed 538 50 Amount Remaining Cost Amount 5 50 Cost Distributed 5 50 Cost Remaining Project ID Breakdown Aamot O Desciption Woke Proposa Number Hows Umts Manager Ciy Province User Defined 4 User Defined 5 User Defined 6 User Defined 7 TESTA 1000 1000 0400 4100 0000 500 00 1 Craftsman Brush 3 Paint BOBSEAGERTS CALGARY AB TESTA 1000 1000 0400 4500 0000 ACTUAL COST LABOR 1 Craftsman Brush 3 Paint BOBSEAGERTS CALGARY AB TESTA 1000 1000 0000 2290 0000 SALES TAX Sales Tax BOBSEAGERTS CALGARY AB 10 Improved Default Behavior on Project Tracking Entry window and Entry window Redesign When selecting Default the Project ID will be updated to the Default Project ID listed in the window The Entry window has also been redesign to match the layout format of Project Tracking Inquiry Project Tracking Build Notes Page 18 of 52 To return to Table of Contents click Here Au Project Tracking Distribution File Edit Tools Options Help Delete Default Encore sa Dextordinary Inc 07713 2015 Document Number IWC20049 n Document Date 08 01 2015 Transaction Type Sales Order Processing Posting Date 07 02 2015 Document Amo
55. length 255 while reading from the external file Project Tracking Build Notes To return to Table of Contents click Here Page 48 of 52 6 10 Encore e Saving the description to both Description and Description255 fields Enhancement Project tracking work table Enabled option for users to delete the project tracking work table Enhancement to Quick Entry window Reposition the docking of the Quick Entry window a little better next to the PM Transaction Entry window Enhancement warning message when saving When saving a document transaction in GP and it has been distributed to PT but the distributions no longer match GP provided a warning message to refresh the Project Tracking Distribution window in the following screens Sales Module SOP transaction entry Invoice Entry Receivables Transaction Entry Inventory Module Inventory transaction entry Purchasing Module Receiving transaction entry Purchase Order Entry Payables Purchase Entry For GL the validation is usually done with just the debit or the credit Whatever side Credit Debit has been entered the system will then warning if it is fully distributed to it Improved Logic Changed the logic for the following feature e When saving a document transaction in GP and it has been distributed to PT but the distributions no longer match GP provided a warning message to refresh the Project Tracking Distribution window e This warning message will be shown only
56. nc 07 13 2015 i Delete Default e e a a Document Date 07 13 2015 Transaction Type Sales Order Processing Posting Date 07 13 2015 Document Amount 31 00 Amount Distributed 31 00 Amount Remaining 0 00 Cost Amount 26 95 Cost Distributed 26 95 Cost Remaining 0 00 _ Project ID Amount Type Breakdown Pamot A Proposal Number Work Order Number Units Manager Pw Province O User Defined 4 Defined 4 J9 0 User Defined 5 Defined 5 P User Defined 6 Defined 6 Js User Defined 7 Defined 7 E 9999 9999 9999 9999 9999 SALES 30 50 Tz 4 Stepladder 0 00 TESTC 1000 1000 0100 4500 0003 ACTUAL COST LABODA 26 95 1 4 Stepladder 0 00 TESTC 1000 1000 0000 41 75 0000 TRADE DISCOUNT TRADE DISC 1 53 Trade Discount 0 00 TESTC 1000 1000 0000 2290 0000 SALES TAX SALES TAX 2 03 2 Sales Tax 0 00 2 m v 0 00 0 00 vr Default Project ID TESTC D Improved Messaging for Add Project Tracking Distributions Posted Documents Project Tracking Distributions can only be added by selecting OK Closing the window will result in no PT Distributions being created Once the user select OK they will be provided with a message box confirming to create PT distributions for the transaction Selecting OK creates the PT distribution Delete will return the user to the Add Project Tracking Distributions Posted Documents window here the distributions are deleted
57. oject Tracking Build Notes Page 20 of 52 To return to Table of Contents click Here lt Encore li Aii Project Maintenance i sare iS Clear lx Delete Project ID PERRE Froje Description Heck LINKS Estim Proposal Number E stim Work Order Number a Actu Status gf ctui Diskamer IM p ol 14 Improved Check Links process for Work table ME97706 As with previous noted update Should Check Links be performed for Project tracking and PT distributions exist for a Project that does not exist then the operation will no longer delete the PT distributions for transactions on the work table Instead these PT distributions will be logged in the error report and the Project ID associated to them will then be created Any Project created by Check Links will be given the Description Project added by Check Links 15 Improved Project Tracking Distributions for Subscription Billing Documents Markdown amounts on Project Tracking Distributions create for Subscription Billing Documents appeared as Positive value in the front end window This has been updated so it would appear as a negative amount Note that this will automatically be updated to any existing contracts when table conversion is performed Au Project Tracking Distribution sa Dextordinary Inc 07 13 2015 File Edit Tools Options Help
58. olved Issues 1 Resolved problems with GL breakdown failing to display in Breakdown lookup on PT distribution for GL account breakdown and GL Segment Breakdown 2 Fixed issues quick entry window failing to limit breakdown Breakdown lookup will now display the breakdowns assigned at project and Vendor Breakdown levels Project Tracking Build Notes Page 31 of 52 To return to Table of Contents click Here Encore Build 1 018 rebuild Jan 12 2015 Enhancements 1 Improved SmartList Objects SmartList objects will no longer default with 5 decimal places for price It will now display based on the setup for currency and item Build 1 018 Jan 5 2015 Enhancements 1 Enhancement Added SmartList Objects Improved added to Project Tracking to now include SmartList objects for SB with Goto functionality from the SmartList The PT SmartList will also include SmartList objects for Budgeting for PT Budgeting which users may not have Ue Search th Refresh LO Columns Ea Favorites cs Print id Excel w Word Company Breakdown Maintenance FieldService Breakdown Code PT Description ra Financial ACTUAL COST LABTEST1 Mo labtest1 i Ed Fixed Assets ACTUAL COST LABTESTZ Mo labtest AS Human Resources ACTUAL COST ACTMATCOST Mo Actual Cost of Mat A E Inventory ADJUST ADJUST No ADJUST Ei Manufacturing ADIUST ADIUSTMEMT Mo adjustments ES Payroll CASH CASH No Cash aS Project Accounting CASH CASHY Mo SaS
59. ood Drive Currency ID Aii Project Tracking Distributions Inquiry Mi a File Edit Tools Additional Help s Dextordinary Inc 07713 2015 Adjust Distributions Ctril k Document Number l Display Master ID Name in Proposal Number Transaction Type Document Amount Amount Distributed Cost Amount Cost Distributed Project ID Description Manager 1 Craftsman Brush 3 Paint BOB SEAGERTS PT OOOS9 2015 000 1000 0100 4500 0003 ACTUAL COST LABOR 1 Craftsman Brush 3 Paint ae PTANNAA 2N15 9999 9999 9999 9999 9999 Sal FS SAL FS FaN 4n 06 19 2015 06 19 2015 Document Date Posting Date Amount Remaining Cost Remaining Au Adjust Project Tracking Distributions File Edit Tools Help sa Dextordinary Inc 07 13 2015 ok 5 Clear AddAdiustment Mass Change Select by Project ID 1vC10018 Project Description Customer ID Amount Type z Transaction Type Z Il Display Posting Date Breakdown code Account Number MV Display Youcher Number for AP Vouchers Additional Filters Display Master ID Name in WO Proposal Number Manager UserDefined4 J User Defined5 J User Defined6 User Defined 7 PT 00058 2015 ivC10018 Sales Order Processing 06 19 2015 SALES SALES1 450 00 1 Craftsman Brush 3 Paint 9999 9999 9999 9999 9999 PTo0058 w001 PT00058 PRONOI 0 00 0 00 BOB SEAGERTS CALGARY i PTO00
60. ore Business Solutions Inc disclaims any warranty regarding the sample code contained in this documentation including the warranties of merchantability and fitness for a particular purpose Limitation of liability The content of these build notes are furnished for informational use only is subject to change without notice and should not be construed as a commitment by Encore Business Solutions Inc Encore Business Solutions Inc assumes no responsibility or liability for any errors or inaccuracies that may appear in this Build notes Neither Encore Business Solutions Inc nor anyone else who has been involved in the creation production or delivery of this documentation shall be liable for any indirect incidental special exemplary or consequential damages including but not limited to any loss of anticipated profit or benefits resulting from the use of this documentation or sample code License agreement Use of this product is covered by a license agreement provided by Encore Business Solutions Inc If you have any questions please call our office at 204 989 4330 or toll free 888 898 4330 North America only Publication Date Oct 2015 Project Tracking Build Notes Page 2 of 52 To return to Table of Contents click Here Encore Table of Contents SLOT ell 04 5 so 6 mote 0 bo een a ee 4 Bud LO e lve OB ener cee cere eee eee cere eee ee ree eRee eee cere Terre Tere E eee eee receee eer S 5 Build 1 024 July 13 2015 oo
61. ount 508 25 Amount Remaining 0 00 Cost Amount 0 00 Cost Remaining 0 00 Project ID gt GL Account 2 Amount Type Breakdown A Description JO City J Amount Y Province are field 0 UD fields OF UD field UD field p Proposal Number Work Order Number Units DEFAULTS 1000 1000 0100 1200 0000 ACTUAL COST MATER ACM2 a eon nn Jricrosott Dynamics GP Breakdown ACM2 has not been assigned to Vendor amp 2010 Do CEA LOCAS Ci you wish to assign this breakdown tovendor 2010 l F DEFAULTS 1000 1 F F F F Total Document Amount Distributed 508 25 Total Cost Distributed 0 00 3 Default Project ID DEFAULTS x Delete Poa 1 Resolved issue with Deferral PT Distribution Associating Master ID and Master Name incorrectly Previously Master ID and Master Name were being associated to GL account number Master ID and Master Name 2 Resolved problems with GL Reconciliation report Issues noticed when adding filter ranger for GL posted Date Issue resolved for filter 3 Resolved issues with Dummy deferral failing to associate GL created to correct Project ID Issue noticed when originating Transaction had multiple rows with same GL accounts Project Tracking Build Notes Page 28 of 52 To return to Table of Contents click Here Encore 4 Resolved issues with US payroll Posted Transaction Project Tracking Distributions Issue noticed with previous update causing PT distributions to overwrite each other when m
62. outh 7 Cumency ID Zuss y Ly 2 r EE we GP Esterdad Price 7n a o Would you like to set up Project Distribution for this transacton 0 0 9 00 No Subtotal pass Tems Discourt Taken nwo gt Trade Discount as X gt On Account 242 75 rong peed 1 comer pobi a 1 Resolved SQL error issues in Project Tracking Budget Maintenance if Project contained a single quote Build 1 014 Feb 12 2014 Enhancements 1 Enhancement Implemented the functionality of opening up Project Tracking Inquiry for PT Adjustment records from Advanced Analytics inquiry screen 2 Enhancement to Budget Import Setup Increased the Amount Type length to 35 in Budget Import Setup 1 Fixed the issue of Document Type being saved as 0 for Project Distributions of AP vouchers 2 Fixed the issue of Project Distributions not defaulted for posted AP vouchers 3 Fixed get change first error in Budget Maintenance window Unclosed quotation mark after the character string ME_Budget_Exists_For_Project_Breakdown script modified 4 Fixed the issue in Budget Import when period duration is Fiscal 5 Fixed the issue of string truncated in the Budget Import Error report 6 Fixed a typo error for a message in Budget Maintenance Screen Build 1 013 Jan 28 2014 Enhancements 1 Enhancement Project Tracking importer Implemented the Project Tracking Budget Header import functionality 1 Fixed the issue within budget maintenance window of restricting
63. pt Entry E E ations g E E E E I No Warning on Partial Distributions MV Require Breakdowns Require Descriptions except on tax and freight I Auto Create Project from SOP Number Auto generate Project Numbers Nent Project 1D PPTOOOOOOCOOO0000005 Next Adjustment Number 12 Resync option for AR documents Bm E 07 13 2015 sa Dextordinary Inc Use for Constant Transaction User Defined Field Titles Budgets Value User Defined Titel Manager E E User Defined Title2 City f f User Defined Title3 Province E User Defined Title 4 User Defined 4 T_ E User Defined Title5 User Defined 5 E E User Defined Title6 User Defined 6 E E User Defined Title 7 User Defined 7 E a Post Actuals to Budgets based on GL Posting Date l Disable Cross Project Budget Reporting Document Date Automatically Calculate Operating Cost Revenue Labor Cost 7 Material Cost IV Auto Create Distributions for Deferrals Deferral Dummy Project ID DUMMY DEFERRAL p Security User Defined Field Titles Options ro With this new feature should a AR transaction already have Project Tracking Distributions created and a user make changes to an AR transaction prior to posting they can now Resync PT Distributions for the transactions Note users would need default on Sales Transaction Distribution Entry prior to Resync in Project Tracking entry The user would then access PT d
64. ral setup Line deferrals on SOP will now match based on Item description and Amount This will ensure that correct Breakdown and UD fields match when deferral journal entries are created for SOP documents with multiple line items Project Tracking Build Notes Page 30 of 52 To return to Table of Contents click Here Encore SILI I ee 9 NAJ war DID Vr CSIRO mire PA Journal Entry Inguiry Miei x i File Edit Tools View Additional Help Debug sa Fabrikam Inc 4 12 2017 o t s Joumal Entry 3 738 Audit Trail Code GLTRXODO0OFO1 Fiscal Year 2015 Batch ID ALTANOOOUO0034 j Transaction Date B71 2015 Reference STEIN Y00000 2507 i Source Document ALTAN Currency ID eae 7m Account L Account Description Exchange Rate 6 Distribution Reference 000 4100 00 1 500 00 4 ales 128 meg SDRAM 000 8610 00 1500 00 Project Deferred Revenue 128 meg SDRAM Total 1 500 00 1 500 00 i Difference 0 00 L Intercompary t lida bl in Project Tracking Distributions Inquiry File Edit Tools Help Debug sa Fabrikam Inc 4 12 2017 Document Number 3738 Document Date 6 1 2015 Transaction Type OGL Adjustment a Posting Date 5 2015 oO Document Amount 1 500 00 Amount Remaining 3 000 00 Cost Amount 0 00 Cost Remaining 0 00 Deterred 1 1298 meg SDRAM VANCOUVER BOB SEAGERTS 1 500 00 Build 1 019 Feb 09 2015 Res
65. ser Defined Field Titles Budgets Value ER E r r User Defined Title1 Location j m Fie Edit Tools Options Help sa Fabrikam Inc 4 12 2017 Payables Transaction Entry c C r User Defined Title 2 Manager Vv rm Receivables Transaction Enty I E User Defined Title 3 User Defined 3 E E Defaults Amount Types Breakdowns Invoicing Transaction Entry E E User Defined Title 4 User Defined 4 E j General Ledger ADJUST a P Sales Order Processing j E User Defined Title User Defined 5 E E Payables Transaction Entry ACTUAL COST LABOR P Purchase Order Processing E E User Defined Title User Defined 6 E E Receivables Transaction Entry SALES esl P Payroll E T User Defined Title 7 User Defined 7 E E Invoicing Transaction Entry SALES x P Cash Receipt Entry E T PAAA SALES ja Post Actuals to Budgets based on 220 Wider rocessng SALE ie Allocations out of Inventory Entry D E GL Posting Dat TD Dat Purchase Order Processin ACTUAL COST MATERIAL Sa p Fiscuring Contacts r 7 osmg Date ae Payroll ACTUAL COST LABOR P J Disable Cross Project Budget Reporting Cash Receipt Entr Sas sl A ral 2 I No Waming on Partial Distributions Automatically Calculate Operating Cost Inventory meee COST delete V Require Breakdowns Revenue Cost in Sales Modules EST COST MATERIAL 8 Require Descriptions except on tax and freight Labor Cost Material Cost J Suppress Distrution line if Cost of Sales is 0 00 Units Defaut _ Auto pate oer from SOR Number J Auto Cr
66. set ppoe one ecko IO E Desin incon J Manas Derda p a p eera SP Ua bod e J Proposal Number Work Order Number sm TESTA 000 8610 00 SALES 6 SOMETHING NEW WINNIPEG TOM HANKS 1 379 70 3 0 000 4510 01 ACTUAL COST MATER ACTMATCO ammam suey BOB NEWTON psn 0 00 TESTA 000 2300 00 SALES TAX SALES TAX Sales Tax WINNIPEG ce MANAGER 82 79 gt 00y Total Document Amount Distributed 1 463 18 Total Cost Distributed 1 485 00 Ey DetautProectiO TESTA Lok oee oen Wi Sales Transaction Entry File Edit Tools view Options Additional Help sa Fabrikam Inc 4 12 201 Actions v Type Type ID Invoice IE Date 4 12 2017 Document No STDINV2636 Batch ID BATCHTESTI Customer ID AARONFITOOOI Default Site ID WAREHOUSE Customer Name Aaron Fitz Electrical Customer PO Number Ship To Address WAREHOUSE 11403 45 St South Currency ID ZUS v Line Items by Order Entered HemNunbs OPS Dluodm P Invice Quantiy gt A fitPiee tended Pie 256 SDRAM Cleef 52395 5137370 a Description SOMETHING NEW Site ID WAREHOUSE PIL Price Level RETAIL PIL 0 00 gt Billed Quant ri Cos A 7 O warevouse p meee nae poi LOCAL DELIVERY Shipping Method Req Ship Date 4 12 2017 Qty Canceled E Racers Quantity Available Date Shipped 4 12 2017 E Qty to Back Order 2 og S 4 Previous Next
67. t value is not equal to the GP quantity Set Initial From GP Quantity Unit value will initially default to the GP quantity but is not required to be in sync with the GP transaction quantity No Default no default unit distribution is set in PT distributions Warning pop up messages e Upon Save Please Synchronize Units in Project Tracking system before posting Sent when user selects Save on transaction and Units in PT distribution does not match the GP quantity Project Tracking Build Notes Page 38 of 52 To return to Table of Contents click Here Encore Microsoft Dynamics GP Please synchronize Units in Project Tracking system before J posting Open PT Dist Cancel e Upon posting Please Filling Units before posting Sent when Units in PT distribution does not match the GP quantity Microsoft Dynamics GP i Please fillin Units before posting e Upon Field Change Unit Value Should Sync with GP Quantity Sent when Units in PT distribution is changed and no longer matches the GP quantity Microsoft Dynamics GP i Unit value should syne with GP Quantity e Upon exiting PT Distribution Window Please fill in Units before posting Sent when Units in PT distribution is required but not defaulted and does not match GP quantity Microsoft Dynamics GP o Please fill in Units before posting Reporting The following Project Tracking Reports are not modified by this en
68. tan Cinld Tihana Oirdasaka italia Microsoft Dynamics GP General Ledger Payables Transaction Entry Froject ID PROJECTIDNMOTEXI does not exist Receivables Transaction Entry Invoicing Transaction Entry Sales Order Processing Purchase Onder Processing Payroll Cash Receipt Entry Cancel Allocations out of Inventory Entry E a A a a a a a a Subscription Billing No Warning on Partial Distributions Automatically Calculate Operating Cost IY Require Breakdowns Revenue Require Descriptions except on tax and freight Labor Cost Material Cost Auto Create Project from SOP Number Auto generate Project Numbers wl E Deferral Dummy Project ID PROJECTIONOTES Hest Project ID Next Adiustment Number PPTOOOOOO00000000001 Security User Defined Field Titles Options x i Cancel Resolved issue Trade discount displayed in Project Tracking Entry Trade discount was previously being displayed as positive amount in entry screen Issue resolved and Trade discount updated to display its correct negative value Resolved issue with Default Distribution for PO when invoices amount set to less than ordered amount Issue noticed when invoiced amount adjusted from ordered amount and pt distributions created This has since been resolved Resolved issues with Project Tracking Check links Issue noticed when Check Links was performed it was removing Project Tracking Distributions from Subscription Billin
69. tional Help sa Dextordinary Inc 07 13 2015 O OK Ein Voucher No 00000000000000015 Batch ID Document Type Invoice M Intercompany Doc Date Description _AMERTEST23432 Date Voided 00 00 0000 P O Number pohist0233 Vendor ID amp 2010 Name American Airlines Cargo Address ID PRIMARY ono Metres Remit To ID PRIMARY Tax Schedule ID P N NO P Payment Terms 2 EOM Net 15th 1099 Amount 380 00 gt Purchases 400 00 Trade Discount 20 00 Total Payments 406 60 Freight 0 00 Terms Disc Taken 0 00 Miscellaneous 0 00 On Account 0 00 Tax 26 60 gt Total 406 60 Distributions Project Tracking Build Notes Page 16 of 52 To return to Table of Contents click Here lt Encore fee Toolbox Mel ES fee Report Layout ME Breakdown Report 1 Page Header Layout Arrange R Company Name Project Analysis Report Leqend Description Text Report ME_Breakdawn_Re Project Analysis Report PH ME_User_ Defined 2 Legend 7 Legend l1 Z Z i O ME_User_Defined_ Grouped By Leqend l ME_User_Defined_ Files Included Project Status E ME_User_Defined_ ME_User_Defined_ RHI H1 H2 EB l ME_Vork_Order_Nu Ranges Project ID Customer ID L Completion Date Salesperson ID L GL Posted Date Document Date
70. ts click Here Encore posting date is from transaction If posting date is from batch then posting Date will clear on unposted invoices Resolved problems with SOP invoices created from Subscription Billing module missing GL COS accounts on PT distributions SOP invoices will now have the appropriate GL account set on the PT Distributions for the COS GL accounts for all amount types Issue was visible only on amount types Est Cost Labor Actual Cost Labor Actual Cost Material Resolved problems using GP lookup options on PT SmartList objects for Project Distributions Issue was result of incorrect search values being displayed when using GP search option on the 3 SmartList object Closed Project Distributions Posted Project Distributions and Unposted Project Distributions Resolved issues for Dummy Deferral process on the following modules Receivables Management Invoicing Payables Management and Purchase Order Processing Dummy deferral process will now distribute Project Tracking distributions appropriately to GL entries created for these modules Resolved issues for US Payroll posted PT Distributions Posted PT distribution inquiry will now be accessible when reviewing Payroll Check Inquiry Previous issue was Causing users to receive error indicating no PT Distributions were set Issue caused by transaction alignment issues Build 1 020 Feb 23 2015 Enhancements 1 Improved SOP Deferals Deferrals improved for Dummy Defer
71. ucher Ho Document Type Description Vendor ID PRIMARY Currency ID Document Number Shipping Method Tas Schedule ID PTOOOS 2013 TESTS MAIL P N NO 2P 7 1099 Amount 855 00 Total Payments Address ID Remit To ID Payment Terms Purchases Trade Discount Freight Miscellaneous Terms Disc Taken On Account Distributions ili I Microsoft Dynamics GP There are no project distributions for this transaction Click Add Distrib if you wantto create the PT distributions to be attached to this transaction File Edit Add Tools Options Help Debug sa Dextordinary Inc 08 31 2019 Delete Default Cancel Document Number 00000000000000023 j Document Date 08 19 2015 Transaction Type AP Voucher Posting Date 08 19 2015 Document Amount 914 65 Amount Distributed 914 55 Amount Remaining 0 00 1 Cost Amount 0 00 Cost Distributed 0 00 Cost Remaining 0 00 Project ID P gt GLAccout Amount Type Breakdown Proposal Number Work Order Number Units 1000 1000 0100 1200 0000 ACTUAL COST MATERIA 900 00 TEST 0 00 P 1000 1000 0000 1200 0005 ACTUAL COST MATERIA 45 00 TEST 0 00 1000 1000 0000 2290 0000 ACTUAL COST MATERIA 59 85 TEST 0 00 TE ae 0 00 0 00 3 Redesign Add
72. ultiple transactions were posted to the same Check 5 Resolved problem with US payroll drilling back to PT distributions on posted transactions Issue noticed of unable to drill back to PT distributions appropriately when viewing Check inquiry This has since been resolved 6 Resolved issue with GL transactions Issue noticed with GL transaction receiving pop up indicating transaction changed since PT distribution was assigned Build 1 021 Mar 12 2015 Enhancements 1 Enhancement Optimized posting delays for GL JE When posting GL Batches process will only review transactions in the ME _GL_TRX_HDR_WORK_Cache table that have PT distributions set This will reduce time to process posting batches for GL JE 2 Enhancement GL Breakdown Maintenance Amount Type pulldown field has been increased in size to ensure full amount type is displayed PA ci Breakdown Maintenance File Edit Tools Help sa Dextordinary Inc 03 12 2015 Save X Cancel GL Option GLAccount 1000 0000 0000 1300 0000 p INVENTORY Account Amount Type EE as Display Assigned Breakdowns Only Assign Default Breakdown Description ACLI ACLI ACL ACLS ACL4 LABOR 44 gt bl 7 1 Resolved issue with SOP invoice obtaining GL post date on unposted invoices in PT distribution Tables The GL Post Date will now populate accordingly for unposted invoices if Project Tracking Build Notes Page 29 of 52 To return to Table of Conten
73. unt i 705 86 Amount Distributed 705 86 Amount Remaining 0 00 Cost Amount 80 00 Cost Distributed 30 00 Cost Remaining 0 o0 PooiectID GL Account Amount Type Breakdown PAm Description Proposal Number Work Order Number a ue Mme On 2s OT a AOE FT P Tae 1000 1000 0400 4100 0000 SALES 700 00 a 1 Craftsman Brush 4 Varnish TEST A PNOO1 TESTA WOO001 0 00 TESTA 1000 1000 0400 4500 0000 ACTUAL COST LABOR 80 00 1 Craftsman Brush 4 Varnish TEST A PNOO TESTA WOOOT 0 00 TESTA Sales Tax 1000 1000 0000 2290 0000 TEST A PNODI SALES TAX SALES TAX 5 60 TESTA W0001 0 00 TESTA 000 2000 0000 2292 0000 SALES TAX SALES TAX 0 26 Sales Tax TEST A PNOOI TESTAWOOO 0 00 0 00 Default Project ID 0 00 11 Renaming of Module in Project Tracking Setup Recurring Contract Billing label in Project Tracking Setup relabeled to be Subscription Billing to be in line with the add on module name change Ai Project Tracking Setup File Edit Tools Options Help pretereererrerirtr tir raa Require Full Ask to Enable Distribution OpenPT Quick Entry General Ledger E E Payables Transaction Entry E E Iv Receivables Transaction Entry E E Invoicing Transaction Entry i E Sales Order Processing E E Purchase Order Processing E E Payroll E E Cash Recei

GP 2013 - Encore Business Solutions Inc.

Contents

Download Pdf Manuals

Related Search

Related Contents