Editing Inventory Setup

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 1: Line 1:
 +
<br>Click the link below to view inventory setup options in the SME Setup module:
 +
<br>http://high5software.com/mediawiki/index.php?title=Company#Inventory
 +
 +
 +
<br>[[File:AutoDeliverAllocatedOnCloseSetting.png]]
 +
<br>'''Auto Deliver Allocated on Close''' - With this option checked, any material on an order with the Item Status of Allocated will be changed to Delivered when you close the order and stock will be depleted. This saves a step from having to manually reserve stock to deplete stock.
 +
 +
  
 
== Maintaining Inventory Items in both SME & QuickBooks, or in SME Only ==
 
== Maintaining Inventory Items in both SME & QuickBooks, or in SME Only ==
Line 4: Line 12:
 
<h3>Maintaining Inventory Items in both SME & QuickBooks</h3>
 
<h3>Maintaining Inventory Items in both SME & QuickBooks</h3>
 
If your inventory items are in both SME & QuickBooks, each of your inventory items in QuickBooks will have the accounts set on them.  
 
If your inventory items are in both SME & QuickBooks, each of your inventory items in QuickBooks will have the accounts set on them.  
−
<br>- On your initial sync between SME & QuickBooks, your inventory items will sync to SME with the quantities
+
<br>On your initial sync between SME & QuickBooks, your inventory items will sync to SME with the quantities
−
<br>- Going forward, to increase the quantity of inventory items in SME, you'll either have to place a PO in SME and receive the items, or manually add stock to the item in SME.
+
<br>Going forward, to increase the quantity of inventory items in SME, you'll either have to place a PO in SME and receive the items, or manually add stock to the item in SME.
−
<br>- The QB Item quantities increase when you create a PO in SME, receive the item in SME, and send the bill for the items received over to QB. The PO Bill increases the stock in QB.
+
<br>The QB Item quantities increase when you create a PO in SME, receive the item in SME, and send the bill for the items received over to QB. The PO Bill increases the stock in QB.
−
<br>- The QB Item quantities decrease when you create an invoice in SME for the item and sync the invoice to QB. The invoice depletes the stock in QB.
+
<br>the QB Item quantities decrease when you create an invoice in SME for the item and sync the invoice to QB. The invoice depletes the stock in QB.
−
<br>- If you manually add stock or adjust stock in SME, you'll have to manually adjust in QuickBooks.
+
<br>If you manually add stock or adjust stock in SME, you'll have to manually adjust in QuickBooks.
  
 
<h3>Maintaining Inventory Items in SME Only</h3>
 
<h3>Maintaining Inventory Items in SME Only</h3>
−
If you choose to keep your inventory items in SME only, then you can turn on the option to let SME make General Ledger entries in QuickBooks to your COGS and Inventory Asset Accounts. If this setting is setup:
 
−
<br>-When an item is purchased in SME, when the item is received a Bill will be sent to QuickBooks and the following GL Entries will be made:
 
−
<br>[[File:GLENtriesone.png]]
 
−
<br>When an item is invoice in SME, the following GL Entries will be made in QuickBooks:
 
−
<br>[[File:MaterialInvoiceGL.png]]
 
  
−
<br>Go to the '''[[GL Entries for SME Inventory]]''' page to read about the options for setting up maintaining inventory in SME only.
+
<br>Go to the '''[[GL Entries for SME Inventory]]''' page to read about setting up maintaining inventory in SME only.
  
−
== PO Syncing to QuickBooks options ==
 
−
There are two options for how SME Purchase Orders sync to QuickBooks.
 
−
<br>1) PO created in SME syncs to QuickBooks as a PO.
 
−
<br>2) Items received on the SME PO will be sent to QB on a bill for what you owe the vendor.
 
−
<br>Below is a video showing the two options.
 
−
<br>{{#ev:youtube| 9K5J9KmqIUs }}
 
  
−
<br>Click the link below to see how to setup the option you select:
 
−
<br>[[Default_Export_to_QuickBooks_Settings#Export_Options_for_Purchase_Orders]]
 
  
 
== SMP_Item Passthrough Item ==
 
== SMP_Item Passthrough Item ==
Line 41: Line 36:
 
<br>To read more about the passthrough items, go to the '''[[SMP Items]]'''. The one used for Inventory is SMP_Item.
 
<br>To read more about the passthrough items, go to the '''[[SMP Items]]'''. The one used for Inventory is SMP_Item.
  
−
== Inventory Setup Options ==
 
−
<h3>SME Setup Options</h3>
 
−
If SME Setup module > Company > Inventory you will see some settings related to inventory and purchase orders.
 
−
<br>[[File:InventoryDefaultSettings.png]]
 
−
<br>Click the link below to view inventory setup options in the SME Setup module:
 
−
<br>http://high5software.com/mediawiki/index.php?title=Company#Inventory
 
  
−
<br>Also another setting most SME User check is Auto Deliver Allocated on Close (image below):
 
−
<br>'''Auto Deliver Allocated on Close''' - With this option checked, any material on an order with the Item Status of Allocated will be changed to Delivered when you close the order and stock will be depleted. This saves a step from having to manually reserve stock to deplete stock.
 
−
<br>[[File:AutoDeliverAllocatedOnCloseSetting.png]]
 
  
 +
== PO Syncing to QuickBooks options ==
 +
There are two options for how SME Purchase Orders sync to QuickBooks. 1) PO created in SME syncs to QuickBooks as a PO 2) Items received on the SME PO will be sent to QB on a bill for what you owe the vendor (preferred method). Below is a video showing the two options.
 +
<br><videoflash>9K5J9KmqIUs</videoflash>
  
−
<h3>SQLink Setup Options</h3>
+
<br>Click the link below to see how to setup the option you select:
−
Open SQLink and click File > Setup to get to these options:
+
<br>http://high5software.com/mediawiki/index.php?title=Default_Export_to_QuickBooks_Settings#Export_Options_for_Purchase_Orders
−
<br>[[File:SQLink_InventorySettings.png]]
 
−
 
 
−
<br>'''Include SMP Items on Purchase Orders''' - Set this to transfer info to PO’s for items not in QB, either because you do SME only inventory, or some items have not made it to QB and are on a PO
 
−
<br>'''Use general ledger entries for Default Material Item''' - This setting is recommended to be checked if you keep your inventory items in SME only, not in both SME and QuickBooks. See the '''[[GL Entries for SME Inventory]]''' page for details.
 
−
<br>
 
−
<br>'''Purchase Order Options section'''
 
−
<br>If you are creating Purchase Orders in SME, you need to decide how your SME POs are going to sync with QuickBooks. You have the following options: 

 
−
<br>- Create PO in SME and SME will send the same PO to QuickBooks on the next sync. You would have to receive stock on both POs.
 
−
<br>
- Create PO in SME, receive items on the PO in SME, on next sync SME will put a bill in QB for the items received. The bill will increase the stock in QB. 

 
−
<br>- Create PO in SME and send both the PO and the Bill in QuickBooks.


 
−
 
 
−
<br>Click this link for details on setup in both SQLink and SME:
 
−
<br>
http://high5software.com/mediawiki/index.php?title=Default_Export_to_QuickBooks_Settings#Export_Options_for_Purchase_Orders
 
−
 
 
−

<br>'''Initialize PO Bill Date to from Received Item''': - If checked, the date on the bill that goes to QB will be the date you received the item, not the PO date. 

 
−
<br>'''Initialize by PO Item''' - Sets the date on the Bill in QB to the line item receipt date from the SME PO
 

Please note that all contributions to High5Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see High5Wiki:Copyrights for details). Do not submit copyrighted work without permission!

Cancel Editing help (opens in new window)
Retrieved from "https://www.high5software.com//mediawiki/index.php?title=Inventory_Setup"