2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
Panel

Multi-select UOM configuration

This section illustrates a typical QuickBooks Unit Of Measurement configuration for all the ITEM List and how the same can be replicated in Salesforce under Products which is an equivalent of QuickBooks ITEMS List. The following section illustrates Unit Of Measure, Base Unit and Related Unit

Panel

Unit of measure set, base unit, related unit

Panel

Base unit

The first unit defined in a unit of measure set and is usually the smallest unit of measure used for an item when purchasing it, tracking it in inventory, and selling it. In QuickBooks, the base units of items are used to count inventory, generate most inventory reports, and perform quantity-related calculations.
Important: When you create an inventory item, the cost, sales price, and on hand quantity you enter are all for the base unit.

Panel

Related unit

A unit defined by the number of base units it contains. For example, if the base unit is foot, a related unit might be yard, which is defined as containing three feet.
Related units make it possible to show quantities of the same item in different measurements in different places in QuickBooks. For example, you might purchase an item called Cable in spools, count that item in inventory by the foot, and sell it by the yard. By creating a unit of measure set with a base unit of foot and related units of spool (containing 500 feet) and yard, you can enter a quantity of spools on a purchase order, show the item in feet on inventory reports, and enter a quantity of yards on an invoice.

Panel

Unit of measure set

Consists of a base unit and any number

Anchor
_GoBack
_GoBack
of related units.
When you create a unit of measure set, you can also specify which unit of measure should appear by default when adding an item to a purchase form, a sales form, and a shipping pick list. You also give the set a name, such as "Length by the foot."
Once you've created a unit of measure set and assigned it to an item, you can easily convert to other units of measure within the set when you add the item to a transaction. Continuing with the previous example, if you add the Cable item to an invoice with a quantity of 10 yards, you could then convert that quantity to 30 feet or 0.06 spools.
Note: Unit of measure sets are available only when Multiple U/M Per Item is selected as the unit of measure mode.

...

MaxLength - 31
This is the qbxml name for selecting a UOM for a given transaction line item. For a given UNIT, there are several RELATED UNITS based on which the Quantity and Rate changes.For a given ITEM LINE, if the right BASE UNIT name, corresponding QUANTITY and RATE should be provided at all times for a successful integration of an Invoice transaction. A corresponding field on the OpportunityProducts object can either be a Picklistor Text field and data needs to be populated at all times.

Panel

Field Mappings for Invoice integration with Sales Tax

This section illustrates the field mappings required for QuickBooksInvoice integration based on SalesTaxCode configuration in QuickBooks.
In order to ensure a seamless integration of a transaction with SalesTaxCode DBSync will require the following information from Salesforce to integrating the same into QuickBooks.
| Salesforce | R | QuickBooks | R | Comments |

...