Parts with No Cost
Here’s another report that can be used to audit for parts without costs.
January 2016
Read More
Parts with No BOM
Occasionally you may need to check to see if there are parts in your database that are not contained in a Bill of Material. You can import this SSRS .RDL file to your Visual Studio project and deploy it to the SQL Server Reporting Services web site.
Exact MAX Transaction Codes & Debit / Credit References
Transaction Transaction Code Debit Credit Adjustment to Stock (Favorable) A INVENTORY ADJCHRG Adjustment to Stock (Unfavorable) A ADJCHRG INVENTORY Customer Shipments (CU Orders) S CSTOFSLS INVENTORY Customer Shipments (CR Orders) S INVENTORY CSTOFSLS Cycle Count Adjustment (Favorable) C INVENTORY CYCCHRG Cycle Count Adjustment (Unfavorable) C CYCCHRG INVENTORY Post Time Ticket Completion P or Q WIP…
MAX Default GL Account Table Chart
Here’s a chart of the Exact MAX GL Account Table Default Codes. You can use this in comparison with the GL Account Report in financial integration to audit the table. GL Default Account ID Account Name Normal Balance Type ACCTPAY Accounts Payable Credit ACCTREC Accounts Receivable Debit ADJCHRG Adjustment (Reduction or increase) to Stock Expense…
Here’s a handy checklist for Pilot Testing after updates and upgrades to MAX and Dynamics GP
Pilot Testing Checklist.docx
MRP Command Line Batch Sample with Log File
1) Open the txt file and edit the file as needed. 2) Rename the sample file to .BAT. 3) Copy to the Server and place in the \EXACT\RMCLIENT\EFW folder 4) Enter a Scheduled Task in Windows to run it. MRP
Configuring the MRP Command Line
Configuring the MRP Command Line 1) First create a user called EXPLOSION with password EXPLOSION (or other) with access to the MRP Explosion in the MRP module. All other selections can be set to Read or No Access. 2) Reg Update (not required in 5.5.6 update) NOTE!! 5.5.6 Has the capability to specify the company…
How to Backup and Restore your MAX Suite Databases on SQL Server
It is quite common to backup and restore. Here’s a procedure to help you do it in SQL 2012. Backup 1) Log into SQL Server Management Studio on your Database Server (server that has SQL Server Loaded) 2) In the Object Explorer expand the databases tree and right click on the database name that you…
How to Manage Custom Crystal Reports
In the RMServer\NET\Updates folder there is a new folder named CustomReports. This folder is where customized versions of the reports should be kept. A check is done each time System Manager is launched, this check will copy any updated reports from RMServer\NET\Updates\CustomReports to the client machines C:\Exact\RMClient\EFW folder. This is a significant change in functionality…
How to Add a Purchase Order
Once the orders have been approved in MRP and the Purchase Requisitions have been created, Purchase Orders can be added. Note: That you can manually add an unplanned PO or Non-Inventory PO in the Purchasing Module at any time. To create Purchase Orders, do the following: 1) Log into MAX 2) From the System Manager…