Schulz Consulting

Consulting and Upgrades

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

by

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.

Sage 100 ERP FRx Conversion Utility Assistant Now Available Free

by

Sage have just posted their Sage 100 ERP FRX Conversion Utility Assistant into their private partner file area. This utility assists users in converting FRX reports to Sage MAS Intelligence 4.5 reports.
Sage MAS Intelligence is Sage’s rebadged (and since acquired) solution from Alchemex. Although marketed as a replacement to the since retired Microsoft FRX Report Writer, SMI is widely viewed as a good Business Intelligence tool and a complex financial report writer.

 

The release of this conversion tool is meant to ease users in migrating their FRX reports to SMI and remove some of the grumbling people have about complexity of SMI.

The documentation explains in a little more detail what role the FRX Conversion Utility Assistant plays:

The FRx Conversion Assistant is a utility that is designed to aid Sage Business Partners and consultants in transitioning customers from Microsoft® FRx 6.7 to Sage MAS 90/200 Intelligence 4.50 (Only available for Sage MAS 90/200 4.50). As with most conversions this utility does not perform an automatic perfect conversion but rather speeds up the recreation process for existing FRx reports within Sage MAS Intelligence (SMI). As Microsoft FRx and Sage MAS Intelligence provide Financial Reporting in a different manner there is often no direct way to directly convert concepts found within Microsoft FRx to SMI as there will be different mechanisms to handle the same concepts within the two applications.

 

System requirements (as noted in the conversion guide accompanying the utility):

 

  • Microsoft FRx 6.7 Service Pack 11 (6.7.11027)
  • Sage ERP MAS 90/200 4.50 ProvideX or MAS 200 SQL 4.50
  • Sage ERP MAS 90/200 Intelligence 4.50 or MAS 200 SQL Intelligence 4.50
  • Active  Manager License
  • Active Report Designer Site License
  • Active Connector Site License

This utility will only work if SMI 4.50 is installed. As Reports from FRx are converted into Report Designer enabled reports within SMI you will need to have obtained a license for the SMI Report Manager and Report Designer components to use this utility. Additionally to cater for consolidated FRx reports, this utility requires an active Connector license to be obtained. If converted reports only draw data from one company then customers can import them against the regular (non‐consolidation) ‘MAS Auto Connect’ connection within SMI.

 

Sage Partners can download the utility from the Partner File Center

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.