pnatc.com cias-quickbooks.com english logo english logo english logo english logo english logo

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player

Mass changes to your QuickBooks forms!

It’s not uncommon for us to hear about companies that are using QuickBooks that want to make a mass change to their data.  Believe it or not, there is an app for that!

The app is called the Mass Updater and was written by the same guy that developed the Data Transfer Utilities and other apps.  The Mass updater allows you to mass update transaction headers and rows. In addition, this program can transfer data from the Other 1 and Other 2 fields to Custom Fields so that you can see the data on reports and filter for the data.

Here is a list of what information it can update for you:

Txn Type

Header Field

Row Field

Bill

APAccountRef

 

Bill

DueDate

 

Bill

ExchangeRate

 

Bill

Memo

 

Bill

RefNumber

 

Bill

TermsRef

 

Bill

TxnDate

 

Bill

VendorRef

 

Bill

 

Amount

Bill

 

BillableStatus

Bill

 

ClassRef

Bill

 

Cost

Bill

 

CustomerRef

Bill

 

Desc

Bill

 

ItemRef

Bill

 

Memo

Bill

 

Quantity

Bill

 

UnitOfMeasure

BillPaymentCheck

BankAccountRef

 

BillPaymentCheck

ExchangeRate

 

BillPaymentCheck

IsToBePrinted

 

BillPaymentCheck

Memo

 

BillPaymentCheck

TxnDate

 

Charge

Amount

 

Charge

CustomerRef

 

Charge

Desc

 

Charge

ItemRef

 

Charge

Quantity

 

Charge

Rate

 

Charge

RefNumber

 

Charge

TxnDate

 

Charge

UnitOfMeasure

 

Check

AccountRef

 

Check

ExchangeRate

 

Check

IsToBePrinted

 

Check

Memo

 

Check

PayeeEntityRef

 

Check

RefNumber

 

Check

TxnDate

 

Check

 

AccountRef

Check

 

Amount

Check

 

BillableStatus

Check

 

ClassRef

Check

 

Cost

Check

 

CustomerRef

Check

 

Desc

Check

 

ItemRef

Check

 

Quantity

Check

 

UnitOfMeasure

CreditCardCharge

AccountRef

 

CreditCardCharge

ExchangeRate

 

CreditCardCharge

Memo

 

CreditCardCharge

PayeeEntityRef

 

CreditCardCharge

RefNumber

 

CreditCardCharge

TxnDate

 

CreditCardCharge

 

AccountRef

CreditCardCharge

 

Amount

CreditCardCharge

 

BillableStatus

CreditCardCharge

 

ClassRef

CreditCardCharge

 

Cost

CreditCardCharge

 

CustomerRef

CreditCardCharge

 

Desc

CreditCardCharge

 

Memo

CreditCardCharge

 

Quantity

CreditCardCharge

 

UnitOfMeasure

CreditCardCredit

AccountRef

 

CreditCardCredit

ExchangeRate

 

CreditCardCredit

Memo

 

CreditCardCredit

PayeeEntityRef

 

CreditCardCredit

RefNumber

 

CreditCardCredit

TxnDate

 

CreditCardCredit

 

AccountRef

CreditCardCredit

 

Amount

CreditCardCredit

 

BillableStatus

CreditCardCredit

 

ClassRef

CreditCardCredit

 

Cost

CreditCardCredit

 

CustomerRef

CreditCardCredit

 

Desc

CreditCardCredit

 

ItemRef

CreditCardCredit

 

Memo

CreditCardCredit

 

Quantity

CreditCardCredit

 

UnitOfMeasure

CreditMemo

ARAccountRef

 

CreditMemo

ClassRef

 

CreditMemo

CustomerRef

 

CreditMemo

DueDate

 

CreditMemo

ExchangeRate

 

CreditMemo

FOB

 

CreditMemo

IsPending

 

CreditMemo

IsToBeEmailed

 

CreditMemo

IsToBePrinted

 

CreditMemo

Memo

 

CreditMemo

PONumber

 

CreditMemo

RefNumber

 

CreditMemo

SalesRepRef

 

CreditMemo

ShipDate

 

CreditMemo

ShipMethodRef

 

CreditMemo

TemplateRef

 

CreditMemo

TermsRef

 

CreditMemo

TxnDate

 

CreditMemo

 

Amount

CreditMemo

 

ClassRef

CreditMemo

 

Desc

CreditMemo

 

ItemRef

CreditMemo

 

PriceLevelRef

CreditMemo

 

Quantity

CreditMemo

 

Rate

CreditMemo

 

SalesTaxCodeRef

CreditMemo

 

ServiceDate

CreditMemo

 

UnitOfMeasure

Deposit

DepositToAccountRef

 

Deposit

ExchangeRate

 

Deposit

Memo

 

Deposit

TxnDate

 

Deposit

 

AccountRef

Deposit

 

Amount

Deposit

 

CheckNumber

Deposit

 

ClassRef

Deposit

 

EntityRef

Deposit

 

Memo

Deposit

 

PaymentMethodRef

Estimate

ClassRef

 

Estimate

CustomerRef

 

Estimate

DueDate

 

Estimate

ExchangeRate

 

Estimate

FOB

 

Estimate

IsActive

 

Estimate

IsToBeEmailed

 

Estimate

Memo

 

Estimate

Other

 

Estimate

PONumber

 

Estimate

RefNumber

 

Estimate

SalesRepRef

 

Estimate

TemplateRef

 

Estimate

TermsRef

 

Estimate

TxnDate

 

Estimate

 

Amount

Estimate

 

ClassRef

Estimate

 

Desc

Estimate

 

ItemRef

Estimate

 

Other1

Estimate

 

Other2

Estimate

 

PriceLevelRef

Estimate

 

Quantity

Estimate

 

Rate

Estimate

 

SalesTaxCodeRef

Estimate

 

UnitOfMeasure

InventoryAdjustment

AccountRef

 

InventoryAdjustment

ClassRef

 

InventoryAdjustment

CustomerRef

 

InventoryAdjustment

Memo

 

InventoryAdjustment

RefNumber

 

InventoryAdjustment

TxnDate

 

Invoice

ARAccountRef

 

Invoice

ClassRef

 

Invoice

CustomerRef

 

Invoice

DueDate

 

Invoice

ExchangeRate

 

Invoice

FOB

 

Invoice

IsPending

 

Invoice

IsToBeEmailed

 

Invoice

IsToBePrinted

 

Invoice

Memo

 

Invoice

Other

 

Invoice

PONumber

 

Invoice

RefNumber

 

Invoice

SalesRepRef

 

Invoice

ShipDate

 

Invoice

ShipMethodRef

 

Invoice

TemplateRef

 

Invoice

TermsRef

 

Invoice

TxnDate

 

Invoice

 

Amount

Invoice

 

ClassRef

Invoice

 

Desc

Invoice

 

ItemRef

Invoice

 

Other1

Invoice

 

Other2

Invoice

 

Quantity

Invoice

 

Rate

Invoice

 

SalesTaxCodeRef

Invoice

 

ServiceDate

Invoice

 

UnitOfMeasure

ItemReceipt

APAccountRef

 

ItemReceipt

ExchangeRate

 

ItemReceipt

Memo

 

ItemReceipt

RefNumber

 

ItemReceipt

TxnDate

 

ItemReceipt

VendorRef

 

ItemReceipt

 

AccountRef

ItemReceipt

 

Amount

ItemReceipt

 

BillableStatus

ItemReceipt

 

ClassRef

ItemReceipt

 

Cost

ItemReceipt

 

CustomerRef

ItemReceipt

 

Desc

ItemReceipt

 

ItemRef

ItemReceipt

 

Memo

ItemReceipt

 

Quantity

ItemReceipt

 

UnitOfMeasure

JournalEntry

ExchangeRate

 

JournalEntry

IsAdjustment

 

JournalEntry

RefNumber

 

JournalEntry

TxnDate

 

PurchaseOrder

ClassRef

 

PurchaseOrder

DueDate

 

PurchaseOrder

ExchangeRate

 

PurchaseOrder

ExpectedDate

 

PurchaseOrder

FOB

 

PurchaseOrder

IsManuallyClosed

 

PurchaseOrder

IsToBeEmailed

 

PurchaseOrder

IsToBePrinted

 

PurchaseOrder

Memo

 

PurchaseOrder

Other1

 

PurchaseOrder

Other2

 

PurchaseOrder

RefNumber

 

PurchaseOrder

ShipMethodRef

 

PurchaseOrder

TemplateRef

 

PurchaseOrder

TermsRef

 

PurchaseOrder

TxnDate

 

PurchaseOrder

VendorMsg

 

PurchaseOrder

VendorRef

 

PurchaseOrder

 

Amount

PurchaseOrder

 

ClassRef

PurchaseOrder

 

CustomerRef

PurchaseOrder

 

Desc

PurchaseOrder

 

IsManuallyClosed

PurchaseOrder

 

ItemRef

PurchaseOrder

 

ManufacturerPartNumber

PurchaseOrder

 

Other1

PurchaseOrder

 

Other2

PurchaseOrder

 

Quantity

PurchaseOrder

 

Rate

PurchaseOrder

 

SalesTaxCodeRef

PurchaseOrder

 

UnitOfMeasure

ReceivePayment

ARAccountRef

 

ReceivePayment

CustomerRef

 

ReceivePayment

DepositToAccountRef

 

ReceivePayment

ExchangeRate

 

ReceivePayment

Memo

 

ReceivePayment

PaymentMethodRef

 

ReceivePayment

RefNumber

 

ReceivePayment

TxnDate

 

SalesOrder

ClassRef

 

SalesOrder

CustomerRef

 

SalesOrder

DueDate

 

SalesOrder

ExchangeRate

 

SalesOrder

FOB

 

SalesOrder

IsManuallyClosed

 

SalesOrder

IsToBeEmailed

 

SalesOrder

IsToBePrinted

 

SalesOrder

Memo

 

SalesOrder

Other

 

SalesOrder

PONumber

 

SalesOrder

RefNumber

 

SalesOrder

SalesRepRef

 

SalesOrder

ShipDate

 

SalesOrder

ShipMethodRef

 

SalesOrder

TemplateRef

 

SalesOrder

TermsRef

 

SalesOrder

TxnDate

 

SalesOrder

 

Amount

SalesOrder

 

ClassRef

SalesOrder

 

Desc

SalesOrder

 

IsManuallyClosed

SalesOrder

 

ItemRef

SalesOrder

 

Other1

SalesOrder

 

Other2

SalesOrder

 

PriceLevelRef

SalesOrder

 

Quantity

SalesOrder

 

Rate

SalesOrder

 

SalesTaxCodeRef

SalesOrder

 

UnitOfMeasure

SalesReceipt

CheckNumber

 

SalesReceipt

ClassRef

 

SalesReceipt

CustomerRef

 

SalesReceipt

DepositToAccountRef

 

SalesReceipt

DueDate

 

SalesReceipt

ExchangeRate

 

SalesReceipt

FOB

 

SalesReceipt

IsToBeEmailed

 

SalesReceipt

IsToBePrinted

 

SalesReceipt

Memo

 

SalesReceipt

Other

 

SalesReceipt

PaymentMethodRef

 

SalesReceipt

RefNumber

 

SalesReceipt

SalesRepRef

 

SalesReceipt

ShipDate

 

SalesReceipt

ShipMethodRef

 

SalesReceipt

TemplateRef

 

SalesReceipt

TxnDate

 

SalesReceipt

 

Amount

SalesReceipt

 

ClassRef

SalesReceipt

 

Desc

SalesReceipt

 

ItemRef

SalesReceipt

 

Other1

SalesReceipt

 

Other2

SalesReceipt

 

PriceLevelRef

SalesReceipt

 

Quantity

SalesReceipt

 

Rate

SalesReceipt

 

SalesTaxCodeRef

SalesReceipt

 

ServiceDate

SalesReceipt

 

UnitOfMeasure

VendorCredit

APAccountRef

 

VendorCredit

ExchangeRate

 

VendorCredit

Memo

 

VendorCredit

RefNumber

 

VendorCredit

TxnDate

 

VendorCredit

VendorRef

 

VendorCredit

 

AccountRef

VendorCredit

 

Amount

VendorCredit

 

BillableStatus

VendorCredit

 

ClassRef

VendorCredit

 

Cost

VendorCredit

 

CustomerRef

VendorCredit

 

Desc

VendorCredit

 

ItemRef

VendorCredit

 

Memo

VendorCredit

 

Quantity

VendorCredit

 

UnitOfMeasure

If you would like more information about this product, you know where to find us!

 

This entry was posted in Current Tips and Tricks and tagged . Bookmark the permalink.

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Spam protection by WP Captcha-Free

PNATC.com   -   Income Tax Preparation Services from Presti & Naegele