QuickBooksHow to Turn On Advanced Inventory in QuickBooks?

August 28, 2019by jsxCs5YWxv0

By using Advanced Inventory you can track your Inventory at multiple locations. It a advanced features and can be used in QuickBooks enterprise Only. When you purchase or subscribe to Advanced inventory in QuickBooks Enterprise, you will able to use these features given below after turn on advanced inventory: 

  • Sales order fulfillment process (Site Operations)
  • Bar code scanning
  • FIFO costing
  • The bin or lot tracking
  • Multiple location inventory
  • Serial or lot numbers

QuickBooks is accounting software that is geared mainly towards small and medium-sized businesses and offers on-premises accounting applications as well as cloud-based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks is marketed by Intuit. 

Intuit also offers a cloud service called QuickBooks Online (QBO). The user pays a monthly subscription fee rather than an upfront fee and accesses the software exclusively through a secure logon via a Web browser. Intuit provides patches, and regularly upgrades the software automatically, but also includes pop-up ads within the application for additional paid services.

Importance of advanced inventory?

When you turn on advanced inventory you will be able to track inventory stored at different sites or locations. 

For example:

  1. To make sure your quantity on hand by the site is accurate.
  2. Store inventory at different warehouses.
  3. You can store them in different areas within a warehouse.
  4. You can store them at consignment locations or at outside manufacturers.

Turn On Advanced Inventory

In order to turn on Advanced Inventory follow the steps:

Step 1: Set up the inventory sites

The first step to track multiple inventory sites is to tell QuickBooks Desktop where you track inventory. These sites can be warehouses having different addresses, trucks, or staging areas. These can be large or small. 

  1. In the lists, the menu selects the inventory site list.
  2. Select new on the site button.
  3. Enter the relevant information.

Step 2: Conversion of your previous method of tracking inventory sites.

People use various methods to follow the tracks of multiple inventory sites. Before using multiple inventory sites, you need to assure that your inventory numbers are correct so you can comfortably change to using the Advanced Inventory.

Hanging on to your current method, you may need to take supplemental steps to switch to Advanced inventory. For detailed knowledge, locate your current method from the list, if it is not listed look at the option “you use another method”.

People use various software for example Excel to follow inventory at multiple sites.

With this process, you can use different software to track how much stock you have at each site.

To switch to the Advanced Inventory method:

  1. Using your other software, run a report to identify the quantity on hand at each site.
  2. Set up the inventory items in QuickBooks if they are not.
Creating separate items for each site.

With this technique, you utilize a naming strategy or structure to recognize things at various locales. For instance, on the off chance that you have 3 stockrooms, you utilize 3 things to speak to a similar thing situated at each distribution center.

Follow these steps to switch to the Advanced Inventory method.
  • Ascertain the amount close by (QOH) for everything at each site. You ought to likewise know the worldwide QOH (the all-out amount overall sites ). Record these numbers or print a report from QuickBooks.
  • “Clean up” your item list. The objective is to have just a single thing on the rundown for everything you sell. 
  • Choose which things to use later on. Keep in mind that you just need one thing in QuickBooks Desktop. In the model above, assume you pick WH1 Widget 1.
  • Alter the amounts to zero for the repetitive things you won’t utilize. At that point make the comparing increment for the item that you will utilize. In the example:
  • Decrease the QOH for WH2 Widget 1 from 20 to 0.
  • Decrease the QOH for WH3 Widget 1 from 40 to 0.
  • Increase the QOH for WH1 Widget 1 from 100 to 160.

In the wake of making all alterations, the net impact on the change record ought to be zero. In any case, if everything that speaks to a similar thing at various areas has diverse normal costs, the net impact won’t be zero. There are 2 different ways to deal with this issue.

If the value differences are small

Converse with your bookkeeping proficient. In the event that the worth contrasts are little made an uncommon stock modification represents this exchange, and makes your alteration. At that point have your bookkeeping expert discount this sum.

If the value differences are important

Note the estimation of these alterations for the subsequent stage.

  • Alter the amount of the item you are keeping. Increase the estimation of the modification by the sum you noted in the step above.
    • In the inventory, menu select the adjust quantity/value on hand
    • In the Adjustment Type drop-down, select the Quantity and Total Value.
    • Select the account you normally use in the Adjustment Account dropdown.
    • Go to the inventory site drop-down and select the inventory site you set as default when you turned on the Advanced Inventory.
    • Move to Add Multiple Items and select the items that represent the same item across multiple sites
    • Enter 0 in the New Quantity columns where the rows that contain the redundant items(the ones you’re NOT keeping)
    • For all these redundant items, calculate the total of the QTY Differences.
    • For the rows that contain the item you are keeping, add the quantity derived from step 7 in the Qty Difference column.
    • In the New Value column set all the values to 0.
    • In the bottom right of the window note down the total value of the Adjustment amount.
    • Enter the amount you noted in step 10 from the New Value column. The total value of Adjustment should now be 0.
    • Select Save & New and repeat these steps for the next set of items.

Step 3: Setting reorder points for each site(Optional)

With the Advanced Inventory, you can track site-explicit reorder focuses on everything. This implies you can have an alternate reorder point for each site, and QuickBooks Desktop can caution you when you’re running low at a particular site.

  1. In the Lists menu select the Inventory Site List.,
  2. Select Set Reorder Points in the Activities drop-down.
  3. Click on the Set reorder point for site drop-down arrow and select the site you want to set a reorder point for.
  4. In the Site Reorder Point column, for each item enter the reorder point.
  5. Select the Set to Reorder point from the drop-down arrow and select another site to set Reorder points for other sites.
  6. Select OK.

Step 4: Move opening amounts of items to each site

When you turned on the Advanced Inventory, QuickBooks Desktop incited you in the first place a solitary, brief beginning site. Thus, QuickBooks Desktop demonstrates that your whole stock is put away at one location.

Now you may be ready to transfer your inventory from the starting site to their actual sites. To do this step, you need current inventory counts for each site.

  • For Transfer Inventory goto the Inventory menu.
  • Enter the date of the transfer in the Date Field (this can be the date you begin tracking multiple sites).
  • Enter the relevant transfer number in the Reference No. field.
  • Goto Transfer from the drop-down to select your temporary inventory site.
  • For an actual inventory, site clicks the To drop-down menu.
  • To transfer to the site select the inventory items.
  • To transfer for each item enter the number in the Qty to Transfer column.
  • Enter the reason for this transfer in the Memo field. (Optional)
  • If you need a printed copy of the transfer select Print.

Step 5: Add a site column to your printed sales and purchase forms(Optional)

A site section shows up on all structures (solicitations, buy orders, etc) you see onscreen. Be that as it may, this segment doesn’t show up when you print the structure.

you can customize your form template so you can add or remove columns:

  1. Open the sales or purchase form.
  2. For customizing the Data Layout goto the Formatting.
  3. Select the columns to tab from the Additional Customize window.
  4. Put a checkmark in the box for the inventory site in the Print column.
  5. Select OK.

After applying these steps given above you are able to turn on advanced inventory and using its features. If you need help and have any confusion to apply these steps or still unable to turn on advanced inventory then call our toll-free QuickBooks Enterprise support number to get connected to our support team.

Leave a Reply

Your email address will not be published. Required fields are marked *

Call Now