eOne Extender - New solutions do not import correctly. Old solutions do not delete properly.

I had experienced problems loading new solutions even after deleting old solutions.
I resolved the issue by running the grant.sql on all databases, and then manually going into the extender tables and deleting any data i found in them pertaining to the old solutions.

Once the tables were cleared out, the new solution imported correctly.

truncate table ext01200
truncate table ext01201
truncate table ext01203
truncate table ext01211
truncate table ext01212
truncate table ext01213
truncate table ext20010
truncate table EXT00900
truncate table EXT10200
truncate table EXT20010
truncate table EXT20021
truncate table EXT20110
truncate table EXT20200
truncate table EXT20400
truncate table EXT20401
truncate table EXT20402
truncate table EXT20403
truncate table EXT20500
truncate table EXT20700
truncate table EXT21000
truncate table EXT21010

eOne Extender SQL Tables

Each of the tables in this series holds data for a different data type

EXT01200
EXT01201
EXT01203
EXT01211
EXT01212
EXT01213

EXT00900 - Lookup table values
EXT10200 - Lookup Tables
EXT20010 - Window Field Layout
EXT20021 - Item List Values
EXT20110 - Windows
EXT20120 - "Additional" Menu Entries - Check here if you get duplicated menus
EXT20200 - Resource list
EXT20400 - Event List - update the companyid here if restored
EXT20401,2,3 - Event Actions
EXT20500 - Views
EXT20700 - Imports
EXT21000 - Solutions
EXT21010 - Extender Solution Details


When restoring from one company to another, run these scripts to update any company references. Replace "TEST" with your new database id.

 update [EXT20401] set interid = 'TEST'

Dynamics GP - How to do a Stock Count

1. Understanding Inventory Setup options
1. Inventory>Setup>Inventory Control
2. Sales>Setup>Sales Order Processing
2. Understanding how other transactions affect the Inventory Quantities
1. What affects Allocated Quantities?

1. Sales Order Quantities Allocated by Line Item or Batch
2. Unposted Purchase Return Quantities
3. Unposted Sales Invoice Quantities Allocated by Line Item or Batch
4. Unposted Inventory Transfer Quantities
5. Unposted In-Transit Transfer Quantities
6. Unposted Inventory Transaction Quantities
7. Unposted Inventory Assemblies
8. Unposted Manufacturing Issues
9. Processed Stock Counts WITHOUT Autopost ticked (Will generate unposted Inventory Transactions)
1. What Affects On Hand Quantities?
1. Posted Purchase Receipts
2. Posted Purchase Returns
3. Posted Sales Invoice Quantities Allocated by Line Item or Batch
4. Posted Sales Returns
5. Posted Inventory Transfer Quantities
6. Posted/Shipped In-Transit Transfer Quantities
7. Posted Inventory Transaction Quantities
8. Posted Inventory Assemblies
9. Posted Manufacturing Issues
10. Processed Stock Counts WITH Autopost ticked (Will generate and post Inventory Transactions)
2. What does not Affect Inventory Allocated, or On Hand Quantities?
1. Sales Quotes
2. Non-allocated Sales Orders
3. Non-allocated Sales Invoices
4. Unposted Purchase Receipts
5. Unposted Sales Returns
6. Stock Count Schedules
7. Unprocessed Stock Count Entries
1. Useful Inventory Inquiry Screens
1. Item - Shows quantities in locations
2. Item Transaction - Shows all item transaction history
3. Serial/Lot Trace - Shows movement of a serial/Lot through all transactions
4. Inventory All-in-One View - Shows all inventory transactions and their movement
5. Bin Quantities - Shows item quantities in bins
6. Item Allocation - Shows all item allocations
7. Item Stock - Shows all item transactions and a running stock total
8. Price Trace - Test extended pricing
2. Pre-Requisites
1. All transactions affecting inventory on hand should be entered into the system
2. Post as many Receivings Batches as possible
3. Post as many Inventory Batches as possible (Adjustments and Transfers)
4. Post as many Sales Batches as possible (Invoices and Returns)
5. Post as many Assembly Batches as possible
6. Post as many Manufacturing Issues as possible
7. Post as many Manufacturing Receipts as possible
8. Run a full check links
9. Run a reconcile against sales and inventory
3. Actual Stock Count
1. Create a Stock Count Schedule for a Site and collection of Items
1. Inventory>Transaction>Stock Count Schedule
2. Tick Reuse Stock Count if you want to always use this list as a template
3. Click Start Count when you're ready to snapshot your stock and begin counting
4. Print your stock count list 
2. Ideally, you should refrain from doing any transactions that will affect inventory until the stock count is completed. Why?
1. Stock that should not be allocated may become allocated, and may prevent the stock count adjustments from going through. Eg. Stock incorrectly shows 100, physical is 0. When they count, -100 adjustment must go through, but users may have allocated the incorrect 100, resulting in orders for stock that does not exist, and pushing available stock into negative when the stock count is posted. This is further compounded if serials and lots are in use.
3. Count your Stock
4. Enter your stock count
1. Select stock Count ID
2. For each line, you can review the stock data that was captured by pressing the expansion button on the right of the column labels
1. Captured Qty = On Hand Qty when "Start count" was clicked
2. On Hand Qty = Current On Hand Qty (Informational Only)
3. Allocated Qty = Current Allocated Qty (Informational Only)
3. Enter your count for each item
1. Variance is calculated as Captured Qty - Counted Qty
2. When your variance is posted, it will affect the Current On Hand Qty
4. Tick Verify
5. Enter Lot or Serial Numbers
6. If you tick "Autopost stock count variances", it will automatically post the adjustment when you click "process"
7. Process your stock count
4.  If you are finished with all transactions for the previous periods, you should close the fiscal periods accordingly.
1.  Tools>Setup>Company>Fiscal Periods
2. Select the year
3. Tick any periods you want to prevent posting to.

Dynamics GP - Change the PO Ship to Address. Modify PO to show company address by default as ship to.

The PO Ship to Address is taken from the Company Addresses that have been setup.
If you add additional company addresses, you can select them in the company ship to selection on the PO.

Delete the existing ship-to fields. Modify the PO form to use these fields as the ship-to fields.
These fields correspond to the ship to address id blue arrow in the Vendor Blue Arrow in the PO header. If a user changes the ship to address id in here, it updates the values in the ship to address id blue arrow.

• Purchase Order Work
• Company Name
• Address1
• Address2
• Address3

Dynamics GP - Error message when you try to write off documents by using the write-off process in Microsoft Dynamics GP: "No documents were found matching the criteria selected"

Check the customer cards>options, the customer is probably set to not allow writeoffs.

Use the customer class to update the status to unlimited, or set a limit to the allowed writeoffs

SQL Server - Connect to SQL server via internet connection

Determine what port your SQL server is listening on by running

USE master
GO
xp_readerrorlog 0, 1, N'Server is listening on'
GO

1433 is the default
Port forward this through your router/firewall

Connect to it by using a connection string in your odbc or code

Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=myUsername;Password=myPassword;

Dynamics GP - This Cost of goods sold distribution amount is incorrect and will not be posted

This problem occurs when the EXTDCST, OREXTCST column in the SOP10100 table for this transaction does not match the actual originating and functional total for the line items for this transaction.

Update this field to the value shown in the distribution window to resolve the issue.

SELECT     SUM(EXTDCOST) AS LineExtdCost, SUM(OREXTCST) AS LineOrigCost
FROM         SOP10200
WHERE     (SOPNUMBE = 'RTN000530')

select EXTDCOST, orextcst from sop10100 where SOPNUMBE='RTN000530'

update sop10100 set EXTDCOST = 33522.45
--, orextcst = 5157.30
where SOPNUMBE='RTN000530'