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…
The following will trigger the activation key: 1. if the SQL name and the SQL instance is changed or modified 2. the server name has changes 3. the domain name has changed 4. the Operating system has change ( Example from 2003 server to 2008 server) 5. the mother board of the Server has changed…
USE master GO IF OBJECT_ID (‘sp_hexadecimal’) IS NOT NULL DROP PROCEDURE sp_hexadecimal GO CREATE PROCEDURE sp_hexadecimal @binvalue varbinary(256), @hexvalue varchar (514) OUTPUT AS DECLARE @charvalue varchar (514) DECLARE @i int DECLARE @length int DECLARE @hexstring char(16) SELECT @charvalue = ‘0x’ SELECT @i = 1 SELECT @length = DATALENGTH (@binvalue) SELECT @hexstring = ‘0123456789ABCDEF’ WHILE (@i…
Exact MAX Support Dynamics GP Data Mart Currency Errors and Data Mart The official Knowledgebase article from MicroSoft is here: mbs2.microsoft.com/…/KBDisplay.aspx To install the Data Mart in Management Reporter you need to assign both a functional currency and an ISO code to each of your companies in Dynamics GP. Here are the steps: A Functional Currency…
1) Click Chart Area 2) Click Custom Palette Colors3) If you have prior added custom colors anywhere in the project you can then select them here or create them and add them to the custom palette. 4) Select Custom under “Palette” beneath the NoDataMessage property and you have your sutom set for the chart.
1) Open Event Manager 2) Click Alert Editor Tab 3) Select Connection Tab at the bottom left 4) Fill in Connection Builder (Gmail example) 5) For Domain Accounts
Note: Refine these based on your accounting system and internal procedures. These processes represent the steps to do in MAX to process accounting data. Your process may differ depending your own internal practices. Vouchering and Posting Sales Orders, Vouchers and GL PO Receipts, GL Transactions and Sales Order Shipments need to be processed. This section…
CREATE PROCEDURE SP_TakeOfflineAllDatabase AS BEGIN DECLARE @db sysname, @q varchar(max); DECLARE cur_db CURSOR FOR SELECT name FROM sys.databases WHERE owner_sid <> 0x01; OPEN cur_db; WHILE 1=1 BEGIN FETCH NEXT FROM cur_db INTO @db; IF @@FETCH_STATUS <> 0 BREAK; SET @q = N’ALTER DATABASE [‘ + @db + N’] SET OFFLINE WITH NO_WAIT’; EXEC(@q); END; CLOSE…
1) Log into MAX 2) Click on the Engineering Tab in the System Manager 3) Click on the ECO Module 4) Verify internal processes and codes by selecting Tools / Edit Codes – Verify your internal processes and procedure and all default codes to ensure these meet your internal processes and approvals. 5) ECRs (customer…
If you receive this error. Log into SSMS and right click your MAX DB. Select Properties and change the compatibility to SQL 2008 or to the version you’re currently running. Anything below 2008 will cause the error on he DB Update