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).
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.