Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Technical
    • Sage 100 New Features ( Brief )
  • Sage 100 Support

Check For Bad Dates (Vendor Code 9) In Sage 100 Files With This Free Utility

August 27, 2018 by Wayne Schulz

Sage has issued a new utility which can be helpful for uncovering pesky bad dates (Vendor Code 9) which can crop up unexpectedly in Sage 100 data tables.

As you may know, once your system finds a bad date it may stop processing further and prompt you with a Vendor Code 9 error message.

These bad dates may be tough to locate. Most people try to create a Crystal Report to read the data table and uncover the bad date(s) however even Crystal Reports may stop reading data unless you modify your SOTAMAS90 to allow for NULL Dates.

Now Sage has a new utility which will scan your data files searching for bad dates. It then creates a data file XXX (where XXX is your 3-character Sage 100 company code) XXX_CheckDate.txt in your \MAS90\HOME\Textout\

Once you locate the problem data file(s) you can then use the Data File Display and Maintenance to locate and fix the problem record(s).

 

Sage 100 CheckDate Utility

Here’s the list of tables reviewed by the utility:

 

*OK* AP_ACHCheckEntry

*OK* AP_ACHGenerationAddenda

*OK* AP_ACHGenerationHeader

*OK* AP_ACHInterface

*OK* AP_Analysis

*OK* AP_ARClearingHeader

*OK* AP_ARClearingRestart

*OK* AP_Audit

*OK* AP_CheckDetail

*OK* AP_CheckDetailPosting

*OK* AP_CheckHeader

*OK* AP_CheckHeaderPosting

*OK* AP_CheckHistoryDetail

*OK* AP_CheckHistoryHeader

*OK* AP_CheckRestart

*OK* AP_DailyPostingWork

*OK* AP_Division

*OK* AP_ExpenseDistTableHeader

*OK* AP_InvoiceDetailPosting

*OK* AP_InvoiceHeader

*OK* AP_InvoiceHeaderPosting

*OK* AP_InvoiceHistoryAsset

*OK* AP_InvoiceHistoryDetail

*OK* AP_InvoiceHistoryHeader

*OK* AP_InvoiceHistoryMemo

*OK* AP_InvoiceMemo

*OK* AP_InvoiceRestart

*OK* AP_JobDistributionDetail

*OK* AP_ManualCheckDetail

*OK* AP_ManualCheckHeader

*OK* AP_ManualCheckRestart

*OK* AP_OpenInvoice

*OK* AP_OpenInvoiceTaxSummary

*OK* AP_Options

*OK* AP_PreNoteApprovalRestart

*OK* AP_PreNoteSelectionRestart

*OK* AP_RepetitiveInvoiceHeader

*OK* AP_RepetitiveInvoiceMemo

*OK* AP_SalesTax

*OK* AP_SummaryDrillDownWork

*OK* AP_TaxSummaryWork

*OK* AP_TermsCode

*OK* AP_TransactionPaymentHistory

*OK* AP_Vendor

*OK* AP_Vendor1099Payments

*OK* AP_VendorContact

*OK* AP_VendorCustomerLink

*OK* AP_VendorDocumentContacts

*OK* AP_VendorDocuments

*OK* AP_VendorElectronicPayHistory

*OK* AP_VendorElectronicPayment

*OK* AP_VendorMemo

*OK* AP_VendorPDFLog

*OK* AP_VendorPurchasesHistory

*OK* AP_VendorRemit

*OK* AR_AlternateInvoice

*OK* AR_Analysis

*OK* AR_Audit

*OK* AR_BillToSoldTo

*OK* AR_CashReceiptsDeposit

*OK* AR_CashReceiptsHeader

*OK* AR_CashReceiptsHistory

*OK* AR_CashReceiptsRestart

*OK* AR_CashSales

*OK* AR_Customer

*OK* AR_CustomerContact

*OK* AR_CustomerCreditCard

*OK* AR_CustomerDocumentContacts

*OK* AR_CustomerDocuments

*OK* AR_CustomerMemo

*OK* AR_CustomerPDFLog

*OK* AR_CustomerSalesHistory

*OK* AR_CustomerSalespersonHistory

*OK* AR_DailyPostingWork

*OK* AR_DepositHistory

*OK* AR_Division

*OK* AR_FinanceCharge

*OK* AR_FinanceChargeJournalRestart

*OK* AR_InvoiceHeader

*OK* AR_InvoiceHistoryDetail

*OK* AR_InvoiceHistoryHeader

*OK* AR_InvoiceHistoryMemo

*OK* AR_InvoiceHistoryPayment

*OK* AR_InvoiceMemo

*OK* AR_InvoiceRestart

*OK* AR_OpenInvoice

*OK* AR_OpenInvoiceSplitCommissions

*OK* AR_OpenInvoiceTaxSummary

*OK* AR_Options

*OK* AR_PaymentType

*OK* AR_PriceLevelByCustPriceCode

*OK* AR_PriceLevelByCustShipTo

*OK* AR_RepetitiveInvoiceHeader

*OK* AR_RepetitiveInvoiceMemo

*OK* AR_Salesperson

*OK* AR_SalespersonCommission

*OK* AR_SalespersonHistory

*OK* AR_SalespersonLink

*OK* AR_SalesTax

*OK* AR_SummaryDrillDownWork

*OK* AR_TermsCode

*OK* AR_TransactionPaymentHistory

*OK* AR_TransactionPosting

*OK* BR_DailyPostingWork

*OK* BR_Options

*OK* BR_Transaction

*OK* BR_TransactionRestart

*OK* CI_CommodityCode

*OK* CI_ConversionHistory

*OK* CI_ExtendedDescription

*OK* CI_InactiveReasonCode

*OK* CI_Item

*OK* CI_ItemHistoryByPeriod

*OK* CI_ItemTransactionHistory

*OK* CI_Options

*OK* CI_StandardCostAdjustmentWork

*OK* CI_StandardCostAdjustRestart

*OK* CI_StandardCostAdjustSelection

*OK* CI_UnitOfMeasure

*OK* CU_ActivityLog

*OK* CU_CRMServerOptions

*OK* CU_Opportunity

*OK* CU_Options

*OK* CU_OrderQuoteDetail

*OK* CU_OrderQuoteTracking

*OK* GL_Account

*OK* GL_AccountHistory

*OK* GL_AccountMemo

*OK* GL_AllocationHeader

*OK* GL_AllocationSelectionHeader

*OK* GL_AllocationSelectionOptions

*OK* GL_AllocationSelectionRestart

*OK* GL_Audit

*OK* GL_CompanyActiveBatch

*OK* GL_DailyPosting

*OK* GL_DailyTransactionRestart

*OK* GL_DataExchange

*OK* GL_DetailPosting

*OK* GL_FiscalYear

*OK* GL_FiscalYearDetail

*OK* GL_GeneralJournalHeader

*OK* GL_GeneralJournalHistory

*OK* GL_GeneralJournalMemo

*OK* GL_MainAccount

*OK* GL_MainAccountMemo

*OK* GL_Options

*OK* GL_PayActivity

*OK* GL_PayTransactionHeader

*OK* GL_PeriodBudgetDetail

*OK* GL_RecurringJournalHeader

*OK* GL_RecurringJournalHistory

*OK* GL_RecurringJournalRestart

*OK* GL_SourceJournalHistory

*OK* GL_StandardJournalHeader

*OK* GL_SubAccount

*OK* GL_SummaryDetailDrillDown

*OK* GL_TransactionJournalDetail

*OK* GL_TransactionJournalHeader

*OK* GL_TransactionJournalHistory

*OK* GL_TransactionJournalMemo

*OK* GL_TransactionJournalRestart

*OK* IM_AliasItem

*OK* IM_AlternateItem

*OK* IM_Audit

*OK* IM_BuyerPlannerCode

*OK* IM_CountCardHeader

*OK* IM_DailyPostingWork

*OK* IM_DataEntryCostCalcCommit

*OK* IM_ItemCost

*OK* IM_ItemCostCalcSource

*OK* IM_ItemCustomerHistoryByPeriod

*OK* IM_ItemMemo

*OK* IM_ItemTransactionHistory

*OK* IM_ItemTransactionRecalc

*OK* IM_ItemValuationSelection

*OK* IM_ItemValuationUpdateRestart

*OK* IM_ItemValuationUpdateWork

*OK* IM_ItemVendor

*OK* IM_ItemVendorHistoryByPeriod

*OK* IM_ItemWarehouse

*OK* IM_ItemWhseHistoryByPeriod

*OK* IM_LotSerialTransactionHistory

*OK* IM_NegativeTierRegisterWork

*OK* IM_NegativeTierRestart

*OK* IM_Options

*OK* IM_Physical

*OK* IM_PhysicalRestart

*OK* IM_PriceCode

*OK* IM_ProductLine

*OK* IM_SalesKitHeader

*OK* IM_SalesPromotion

*OK* IM_TransactionHeader

*OK* IM_TransactionPosting

*OK* IM_TransactionRestart

*OK* IM_TransactionTierDist

*OK* IM_Warehouse

*OK* IM_WarehouseRestricted

*OK* IM_WarrantyCode

*OK* IT_Category

*OK* IT_Customer

*OK* IT_EMail

*OK* IT_EMailReasonCode

*OK* IT_HTMLTemplate

*OK* IT_Item

*OK* IT_ItemAttachment

*OK* IT_ItemCategory

*OK* IT_Options

*OK* IT_OrderCategoryTree

*OK* IT_ShoppingCartAutoLogHdr

*OK* IT_ShoppingCartHeader

*OK* IT_ShoppingCartItemsSelected

*OK* IT_StoreCategoryTree

*OK* IT_UIDCustomerChange

*OK* IT_UIDCustomerChangeAutoLog

*OK* IT_WebMenu

*OK* IT_WebTemplateOptions

*OK* PL_EmailMessage

*OK* PL_Form

*OK* PL_JournalPDFLog

*OK* PL_JournalRegister

*OK* PL_Options

*OK* PL_PeriodEndPDFLog

*OK* PL_PeriodEndReport

*OK* PL_Report

*OK* PL_ReportPDFLog

*OK* PO_AutoGenerateOrders

*OK* PO_AutoReorderSelection

*OK* PO_CancelReasonCode

*OK* PO_DailyPostingWork

*OK* PO_LandedCostType

*OK* PO_MaterialReqDetail

*OK* PO_MaterialReqHeader

*OK* PO_MaterialReqRestart

*OK* PO_Options

*OK* PO_PurchaseOrderDetail

*OK* PO_PurchaseOrderHeader

*OK* PO_PurchaseOrderHistoryDetail

*OK* PO_PurchaseOrderHistoryHeader

*OK* PO_PurchaseOrderHistoryMemo

*OK* PO_PurchaseOrderHistTaxDetail

*OK* PO_PurchaseOrderHistTaxSummary

*OK* PO_PurchaseOrderMemo

*OK* PO_PurchaseOrderRecap

*OK* PO_PurchasesHistory

*OK* PO_ReceiptDetail

*OK* PO_ReceiptHeader

*OK* PO_ReceiptHistoryDetail

*OK* PO_ReceiptHistoryHeader

*OK* PO_ReceiptHistoryMemo

*OK* PO_ReceiptMemo

*OK* PO_ReceiptRestart

*OK* PO_ReceiptVarianceCalculation

*OK* PO_ReturnDetail

*OK* PO_ReturnHeader

*OK* PO_ReturnMatRqTierCostCalcWork

*OK* PO_ReturnMemo

*OK* PO_ReturnRestart

*OK* PO_ReturnTaxAllocation

*OK* PO_ReturnTaxDetail

*OK* PO_ReturnTaxSummary

*OK* PO_ShipToAddress

*OK* PO_SummaryDrillDownWork

*OK* PO_VendorPriceLevel

*OK* PO_VendorPurchaseAddress

*OK* PR_ACAEmployee

*OK* PR_ACAEmployeeCoveredInd

*OK* PR_ACAEmployeeMonthlyDtl

*OK* PR_ACAEmployer

*OK* PR_ACAEmployerMonthlyDtl

*OK* PR_ACAEmployerOtherMembers

*OK* PR_Audit

*OK* PR_CompanyTaxGroup

*OK* PR_CompanyTaxGroupRates

*OK* PR_DeductionCode

*OK* PR_Department

*OK* PR_DepartmentDeduction

*OK* PR_DepartmentEarnings

*OK* PR_DepartmentSecurity

*OK* PR_DirectDepositBank

*OK* PR_DirectDepositSvcActivity

*OK* PR_DirectDepositTransDetail

*OK* PR_DirectDepositTransHeader

*OK* PR_EarningsCode

*OK* PR_Employee

*OK* PR_EmployeeAutoEarnings

*OK* PR_EmployeeDeduction

*OK* PR_EmployeeDeductionHist

*OK* PR_EmployeeDirectDeposit

*OK* PR_EmployeeDocuments

*OK* PR_EmployeeEarningsHist

*OK* PR_EmployeeHistory

*OK* PR_EmployeeMemo

*OK* PR_EmployeePDFLog

*OK* PR_EmployeeTaxFilingStatus

*OK* PR_EmployeeTaxHistory

*OK* PR_EmployeeTaxHistoryOther

*OK* PR_EmployeeTaxProfile

*OK* PR_EmployeeTimeOffAccruals

*OK* PR_HRMSAttendanceTransfer

*OK* PR_LaborCode

*OK* PR_Options

*OK* PR_PayrollBurdenAllocationReg

*OK* PR_PayrollCycle

*OK* PR_PayrollDeductionRegister

*OK* PR_PayrollDetail

*OK* PR_PayrollDetailPosting

*OK* PR_PayrollDirectDeposit

*OK* PR_PayrollEarningsRegister

*OK* PR_PayrollEmployersExpenseTax

*OK* PR_PayrollEmployersExpenseWC

*OK* PR_PayrollEmployersExpOtherTax

*OK* PR_PayrollHeader

*OK* PR_PayrollHeaderPosting

*OK* PR_PayrollHistoryDetail

*OK* PR_PayrollHistoryDirectDeposit

*OK* PR_PayrollHistoryHeader

*OK* PR_PayrollHistoryMemo

*OK* PR_PayrollHistoryTaxDetail

*OK* PR_PayrollHistoryTaxDtlOther

*OK* PR_PayrollHistoryTaxReporting

*OK* PR_PayrollHistoryTaxRepOther

*OK* PR_PayrollHistoryWorkersComp

*OK* PR_PayrollLaborDistribution

*OK* PR_PayrollMemo

*OK* PR_PayrollPensionPlanRegister

*OK* PR_PayrollRestart

Schulz Consulting provides consulting services for all versions of Sage 100 and Sage 100cloud. Our office is located in Connecticut and we provide on-site consulting to all of Connectict, Rhode Island, South-West Massachussetts and Vermont.

Share this:

  • Share on X (Opens in new window) X
  • Share on Facebook (Opens in new window) Facebook
  • Email a link to a friend (Opens in new window) Email
  • Share on LinkedIn (Opens in new window) LinkedIn

Filed Under: Sage 100 ERP, Sage 100c Tagged With: date, sage 100, Utility

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage-certified consultant based in Connecticut. He has worked with Sage 100 since 1986 and provides remote consulting to companies throughout the United States. He is a founding member of the 90 Minds Consulting Group. To discuss working with Schulz Consulting, start with the Sage 100 inquiry page. Information is reviewed before follow-up about fit and next steps; technical work is scoped and priced separately.

Sage 100 Newsletter

Search Our Site

Sage 100 News

  • How to Fix: Sage 100 Desktop Launcher Closes Immediately After Login (No Error)
  • How To Update Sage Intelligence Keys as Sage Moves Away From Unlimited Licenses
  • Get More From Your Sage 100 Partnership
  • Sage Future 2025 Preliminary Agenda Released
  • Upgrading Sage 100 to 64-bit: Avoid These Integration Pitfalls
  • What’s New in Sage 100 2024? ( Video )
  • Sage 100 Users: Conquer Minnesota’s New Sales Tax & Delivery Fee Headache-Free
  • Elevate Your Sage 100 Expertise with SchulzSays: The Ultimate Newsletter for Users and Consultants
  • How To Purge Cleared Bank Reconciliation Transactions in Sage 100
  • 10 Exciting New Features in Sage 100 2024

Contact Us

Schulz Consulting · Connecticut Office · Available remotely nationwide.

Contact Schulz ConsultingPhone: 860-657-8544Email Us

We are a local branch of DSD Business Systems Connecticut.

Copyright © 2026 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

sage 100 email newsletter

Schulz Says Email Newsletter

Sent Thursday by 1pm

Join our Sage 100 email newsletter.

  • Sent weekly each Thursday 
  • Over 1,500 subscribers
  • No spam - leave anytime
  • Learn about pending updates, fixes, popular integrations
Become a Member

Never see this message again.