x

Start now

Schedule a demo

  • Date Format: MM slash DD slash YYYY
  • This field is for validation purposes and should be left unchanged.
sysSpec: Audit Log – OneSource: Inventory for QuickBooks Online sysSpec: Audit Log – OneSource: Inventory for QuickBooks Online

Have a Question?

sysSpec: Audit Log

You are here:
< All Topics

Overview

This tool audits the following types of things:

  • Deletions of records from certain key tables.
  • Changes to certain key field values on certain tables.
  • When the user logs in or out of the system.

 

What We Audit

We audit the deletion of records from the following tables (and field changes from the fields listed below each table):

  • Customers
    • Company Name
    • Contact Name
    • Address 1
    • Address 2
    • City
    • State
    • Zip
    • Phone #
    • Fax #
    • Type
    • SubType
    • Status
    • Website
    • Email Address
    • QBO Sync fields
  • Vendors
    • Vendor Name
    • Contact Name
    • Address 1
    • Address 2
    • City
    • State
    • Zip
    • Phone #
    • Fax #
    • Website
    • Email Address
    • QBO Sync fields
  • Quotes / Quote Line Items
    • Date
    • Entered By
    • Sales Rep
    • Shipped Via
    • Customer PO Number
    • Item Number
    • Description
    • Qty Ordered
    • Price
    • Discount
    • QBO Sync fields
  • Sales Order / Sales Order Line Items
    • Bill To
    • Ship To
    • Date
    • Entered By
    • Sales Rep
    • Shipped Via
    • Status
    • Customer PO Number
    • Item Number
    • Description
    • Qty Ordered
    • Qty Shipped
    • Price
    • Discount
    • Cost
    • Sales Tax Authority
    • QBO Sync fields
  • Invoices / Invoice Line Items
    • Bill To
    • Ship To
    • Date
    • Entered By
    • Sales Rep
    • Shipped Via
    • Customer PO Number
    • Item Number
    • Description
    • Qty Ordered
    • Qty Shipped
    • Price
    • Discount
    • Cost
    • Sales Tax Authority
    • QBO Sync fields
  • Credit Memos / Credit Memo Line Items
    • Bill To
    • Ship To
    • Date
    • Entered By
    • Sales Rep
    • Shipped Via
    • Customer PO Number
    • Item Number
    • Description
    • Qty Ordered
    • Qty Shipped
    • Reason for Return
    • Price
    • Discount
    • Cost
    • Sales Tax Authority
    • QBO Sync fields
  • Purchase Order / Purchase Order Line Items
    • Bill To
    • Ship To
    • Date
    • Entered By
    • Sales Rep
    • Shipped Via
    • Customer PO Number
    • Item Number
    • Description
    • Qty Ordered
    • Qty Shipped
    • Price
    • Discount
    • Cost
    • Sales Tax Authority
    • QBO Sync fields
  • Items
    • Item Number
    • Description
    • Item Qty Adjustments
    • GL Accounts
    • Item List Price
    • Item Cost
    • Item Vendor Costs
    • QBO Sync fields
  • Jobs
    • Job Short Description
    • Job Date
    • Job Type
    • Job Sub Type
    • Job Status
    • Job Exp Completion Date
    • Job Completion Date
    • Job Value

How to Make the Audit Log (which is maintained with Triggers) Become Readable

  • We will insert these fields in every table that we log changes from:
    • AuditLogScreenName
    • AuditLogRecordType

How the Audit Log will LOOK on Master Records (like Customer, Vendor, and Items) or Transaction Screens

User Date/Time Screen Record Type Record # Record User Friendly Identifier Field Name  Change Type  Old Value New Value
 Customer Customer Header C12345 ABC Company Customer Type  Edit Customer Great Customer
 Customer Custom Header C12345 ABC Company Default Pricing Type Discount Markup
Default Pricing Value 10 20
Quote Quote Header Q12345 ABC Company Quote Date 5/6/19 5/8/19
Quote Quote Header Q12345 ABC Company Tax District OC-123
Tax value 0 7.23 %
Quote Quote Line Item Q12345 AC1000101 (item number) Description ABC XYZ
AC1000101 Price
AC1000102 Item Number AC1000101 AC1000102
AC1000103 Item Number Delete AC1000103
Description
Qty Ordered
Qty Shipped
Price
Discount
Net Price
Taxable

 

  • User Name (the ID can be in the table but will not be visible to the user)
  • Date/Time
  • Screen
  • Record #
  • Item Number
  • Field Name
  • Old Value
  • New Value

 

 

 

 

Previous screenSpec: Sales > Quick Price Check (QPC) – Standard
Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Table of Contents