5.5.3 Costing Update Details

5.5.3 Costing Update Details

1. Current MAX Version – Must be running Exact MAX 5.0.8 or later.
2. QuickBooks Integration – Must NOT be using QBI to integrate MAX with QuickBooks
3. Synergy/InterConnect version – Synergy/InterConnect version 251 is the ONLY version compatible with MAX 5.5.3
4. Microsoft SQL Server 2005 SP2 – Microsoft SQL Server 2005 SP2 is NOT supported with MAX 5.5.3
5. Microsoft SQL Server 2012 – If the MAX database is on Microsoft SQL Server 2012, .Net 4.5 is required on the server only
6. Microsoft SQL Server Compatibility Level – Microsoft SQL Server Compatibility Level for all MAX Company Databases must be set to 100 (SQL Server 2008) or later prior to upgrading to MAX 5.5.3. Please perform the following instructions to check or change the Microsoft SQL Server Compatibility Level of your MAX Company Databases.
7. REQUIRED Posting of AR, AP and GL PRIOR TO INSTALLATION of MAX 5.5.3
8. Run From To Charge Report and Post ALL GL, AP AR (Vouchers and Sales Orders)
9. System Configuration
   1. Set Cost Set information and Maintain Cost Set in Costing for Average and Last Purch Price
   2. Ask if Dist Reval is desired
   3. Set PO and SO Default Currency
   4. Ask if Ref Required is Desired
10. Add Dist Reval Default GL Accounts
11. PO Preference – Update Cost and Recommended Cost
    1. If you change the quantity in the line and you have price breaks in Part Vendor then the price will update on theline item
12. Inventory Control Reference Field is now Browsable – Ctrl- B
13. Financial Integration Management Option: Close All MAX – QuickBooks Open Sessions has been added to Financial Integration Module Options Menu. This closes open MAX – QuickBooks sessions so that QuickBooks can be switched to single-user mode in order to maintain QuickBooks setup items.
14. Cost Set Master (Costing > Activity > Cost Set Master): Cost Set Master is a new dialog that is used to link Cost Set Code with a Cost Set Description.
15. Reference Master Data (Inventory > Activity > Inventory Data > Reference Master Data): Reference Master Data is a new dialog that is used to maintain libraries of references for each inventory transaction type/subtype.
16. Cost Set Master Data grid: Cost Set Master Data grid has been expanded to support more than eight cost sets. Transaction Type Subtype
17. Part Master Accounting Tab: Part Master Accounting Tab now includes fields for the Labor Burden, Material burden, and Yield costs.
18. Sales Order Form: Additional Customer information – Billing Address Code field has been added to select from multiple bill-to addresses.
19. From To Charge Report: The following Report Options have been removed:
20. 1. Use Transaction History Cost option is not needed because the report now uses the correct cost based on the system cost method.
21. 2. Report now includes an error list after the summary page.
22. FIM (QuickBooks) FIM Configuration Editor: The following fields have been added:
    1. 1. Default Taxable Sales Tax Code
    2. 2. Default Non-Taxable Sales Tax Code
    3. 3. Limit One Tax Per Order in MAX
23. Commodity Code, Class Code, Planner ID, Buyer ID, and Customer Type: Commodity Code, Class Code, Planner ID, Buyer ID, and Customer Type are now entered through browsers on all dialogs where these fields can be selected.
24. Ship Code and Ship Through: Ship Code and Ship Through drop downs have been replaces with browsers.
25. Sales Order Processing Currency Code Maintenance: QuickBooks Currency Browser has been added to the Sales Order Processing Code Maintenance.
26. Tax Code Maintenance: Double clicking on GL Account in Tax Code Maintenance will open a Dynamics GP or QuickBooks GL Account Browser based on the integration setup.
27. Service Navigator: Undo Assignment selection has been added to the Service Navigator.
28. MRP Detail: User defined reference and key fields have been added to the supply and demand sides of the MRP Detail grid.
29. Stock Revaluation: The Stock Revaluation Module has been improved to create revaluation transactions for all cost changes to both inventory and WIP. When COST_01 of the Part Master changes an E transaction will be created for each instance described below using the reason code REASON_15
    1. A – SUBBOM RECEIPT – Open Subcontract BOM order for the changed part
    2. B – SUBBOM ISSUE – Open Subcontract BOM order to which the changed part has been issued
    3. M – INVENTORY – Stock ID with inventory of the part
    4. T – SUBRTG TRANSFER – Open order for the changed part with Subcontract routing steps
    5. V – SHOP RECEIPT – Open shop order for the changed part
    6. W – SHOP ISSUE – Open shop order to which the changed part has been issued
    7. Z – SUBRTG RECEIPT – Open order for the changed part with Subcontract routing steps REASON_15 When MATL_01 of the Part Master changes an E transaction will be created for each instance described below using the reason code in the column to the left
    8. X – SUBBOM SHIPMENT – Open Subcontract BOM order for the change part REASON_15 When SUBCST_01 of the Part Master changes an E transaction will be created for each instance described below using the reason code in the column to the left
    9. S – SUBBOM SUBCNTC – Open Subcontract BOM orders for the change part (SUBCST_01) REASON_15 When MATLXY_01 of the Part Master changes an E transaction will be created for each instance described below using the reason code in the column to the left
    10. C – BULK RECEIPT – Open order for the part with receipts (changes to MATLXY_01)
    11. D – BULK SHIPMENT – Open Subcontract BOM order with shipments (changes to MATLXY_01) REASON_15 An E transaction will also be created by MAX separate from changes to the Part_Master for each instances below using the reason code in the column to the left
    12. K – AVG COST CHANGE – PO Receipt when Costing Method is set to Average
30. NOTE: If System Manager > Activity > System Configuration > Costing > Distribute Reval is set to Y, each transaction in the table above could be replaced by as many as 6 transactions distributing the inventory/WIP revaluation to material, material overhead, labor, labor overhead, Subcontract, and yield revaluation accounts.
31. Currency Decimal Place Settings: Each currency code now has settings for Purchasing Unit Decimal Places, Sales Unit Decimal Places, Extended Decimal Places, and Costing Unit decimal Places. We recommend setting these as follows:
32. Purchasing Unit Decimal Places – According to your Purchasing Department preference
33. Sales Unit Decimal Places – According to your Sales Department preference
34. Extended Decimal Places – To match your accounting system setting
35. Costing Unit decimal Places – 8, which is the default value and that used by MAX in its internal calculations
36. Costing Method: Both Average Cost and Last Purchase Cost can now be stored in cost sets while running in any of the costing modes. Consider setting this up as soon as you upgrade to 5.5.3 so you will have the information available even if you are not sure whether you will use it. Please note that with MAX 5.5.3 you now have a nearly unlimited number of cost sets available and can use two character alpha numeric codes to identify them.
37. Copy all custom crystal reports to new customer reports folder and run the validator to check the dates. \EXACTSHARED\RMServer\NET\Updates\CustomCrystal
38. If Using Repetitive then Ref document 23.582.213
39. All users must be off MAX for the update
40. If updating from a release prior to 5.5.1 3000 then you MUST run ExactMAXAutoUpdate.exe on Each Client
41. If using Max Update for custom applications be sure to copy the new MAX update .DLLs to the custom app folder.