Editing GL Entries for SME Inventory
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 100: | Line 100: | ||
If you are an existing SME customer syncing SME items with QB items, you can run the following script to "disconnect" SME items from QB item. | If you are an existing SME customer syncing SME items with QB items, you can run the following script to "disconnect" SME items from QB item. | ||
Note: USE WITH CAUTION, Run backups prior, should be ONLY done by qualified database administrators or SME support. | Note: USE WITH CAUTION, Run backups prior, should be ONLY done by qualified database administrators or SME support. | ||
+ | Run these queries: | ||
+ | - To find the SMP_Item QB UID | ||
+ | Select UID, Name, InventoryID From Inventory Where Name Like 'SMP_Item%' | ||
− | + | ||
+ | - Put the QB Item InventoryID in the Where and run the query. | ||
− | + | Disable Trigger All on Inventory; | |
− | + | Update Inventory Set QBExport = 'false', QBInventory = 'false', QBModified = NULL, QBItem = 'false', InventoryID = '' | |
− | + | Where Name Not Like 'SMP_Item%'; --- or whatever your default item is named | |
− | + | Enable Trigger All on Inventory; | |
− | Disable Trigger All on Inventory; | ||
− | Update Inventory | ||
− | Set QBExport = 'false', | ||
− | QBInventory = 'false', | ||
− | QBModified = NULL, | ||
− | QBItem = 'false', | ||
− | InventoryID = '' | ||
− | Where | ||
− | Name Not Like 'SMP_Item%'; --- or whatever your default item is named Enable Trigger All on Inventory; |