Sage 100

Consulting and Upgrades

  • Home
  • Services
  • Contact

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:

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 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 News

  • Can Sage 100 Premium ( SQL ) Be Migrated Back To Non-SQL ( Providex?)
  • Sage 100 2022 Requires New Activation Key for Production Management Installation
  • Sage Releases Sage 100 v2022
  • What File Prerequisites are Required by Sage 100 v2021?
  • Error #0 Sage 100 – When Printing Registers After Microsoft Update
  • Is Sage 100 Compatible With Microsoft Windows Server 2022?
  • What’s New in Sage 100 Version 4.4 to 2021
  • What Is The Most Recent Product Update For Sage 100?
  • What’s Coming in Sage 100 2022?
  • Enhance Your Sage 100 Warehouse Processing With ScanForce WMS

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657.8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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