Rule of Thumb Series (Quick Notes and Fixes)
Macro Generator Essentials Series
- Corrupted Enter/Match Invoice
- Negative Quantity Sold on Item Maintenance Window
- Merging Line Items When Migrating a Requisition into Purchase Order
- Closing Fiscal Period per Transaction Type
- Keeping Track of the Actual Ship Date of Shipments
- Maintain Requisition History
- Item Maintenance - Item Category Setup
- Sales Order Processing - Unit Price, Extended Price and Decimal Places
- Analytical Accounting Account Access
- AA Dimensions Relations and Validations
- AA Dimensions Order and Default Values
- The importance of using AA Alias
- Copy Paste General Ledger Journals with AA Details
- HITB Reset Tool Deployment
- HITB Reset Tool and SEE Tables Details
- HITB Report - Per Period
- HITB Report - Per Period (Cumulative)
- Clear Date for the Inventory Module - The proper Approach
- Cost Adjustment (1 out of 4) - Override Documents
- Cost Adjustment (2 out of 4) - Shipment and Enter Match Invoice
Macro Generator Essentials Series
- Analytical Accounting Entry (Excel to Dynamics GP) - Free Tool
- Macro Code changes regarding the new “Window Ribbon” - Dynamics GP 2013 R2 and 2015
- Inventory Adjustment Macro Generator (Beta version) - Free Tool
- Stock Count Macro Generator (Beta Version) - Free Tool
- Inventory Transfer Macro Generator - Macro Essentials Series (Free Tool - Beta Version)
Data Cleansing Essentials Series
- Chart of Account Analysis - Unused Accounts
- Dummy Item-Site assignment - Cleaning Unused Assignments
Best Regards,
Mahmoud M. AlSaadi
Hi All,
ReplyDeleteGP2016-620(R2) I am having similar issues in Samrtlist designer where most of the columns are changed into the different type of data after exporting to Excel where in smartlist it is ok, once exported to excel all the data is shared and codify in a strange manner below are few examples:
=DATE(2018,1,1),(suppose to be doc date )
#NAME? (suppose to be Account Description)
#NAME? (suppose to be TaxDetail Id)
0.00000 (suppose to be A Negative number) (-9000.00)
to mention there is no special character used anywhere in data
apart from this smart list is not sorting the data column by clicking on a column heading a usual practice, any idea what is going on