SAP Crystal Reports FAQs

Home|FAQs & Troubleshooting

 

Expand/Collapse all Show/Hide All

Click a question below to view the answer.

General

 

Expand/Collapse item What version of SAP Crystal Reports is bundled with my Sage 100 system?

The following versions of SAP Crystal Reports are included with your Sage 100 system.

Crystal Reports Version

Sage 100 Version

XI Release 2

4.50

2011

2013

2011 2014
2011 2015
2011 2016
2011 2017
2016 2018
2016 2019
2016 2020
2020 2023

 

 

Expand/Collapse item How do I get additional help regarding SAP Crystal Reports?

SAP Crystal Reports has a comprehensive Help system to assist you during each step of the report development process. Because SAP Crystal Reports is designed to run with many types of programs, some information in its Help system does not apply when running SAP Crystal Reports with Sage 100.

For a question specific to using table and column names, see File Layout and Program Information.

 

Expand or collapse item How do I determine where the data for my reports resides?

Use the table and field references in the File Layout and Program Information to help determine where the data for your report resides.

  • SAP Crystal Reports reads Sage 100 data files as "tables" through the MAS90 4.0 ODBC driver. For example, the AR_Customer.M4T data file is read when the ODBC driver reads the AR_Customer table.

  • Each Sage 100 Standard data item is referenced as a "field" in a "table" when accessed through the ODBC driver. Many of the table and field names in the Sage 100 Standard schema are self-explanatory; for example, the CustomerNo field is the customer number field.

 

Expand/Collapse item How do I create a share?

To create a share

  1. Locate where Sage 100 Advanced is installed on the Windows 2003 or 2008 server. For example, Sage 100 Advanced is installed at C:\Apps\Acct\MAS90.

  2. Create a share off of a parent folder to the MAS90 folder. In this example, it could be off of the Acct folder, the Apps folder, or the root of C:\.

To avoid errors, you cannot share the MAS90 folder itself. You can share a parent folder. For example, if Sage 100 Advanced is located at C:\MAS90 from the server's perspective, and the MAS90 folder is shared instead of a parent folder, errors may occur.

 

Expand/Collapse item Should Key fields be linked?

In general, all Key fields should be linked.

 

Expand/Collapse item Why are temporary worktables used?

To simplify the required linking of tables and to maximize report performance, temporary worktables are created. Temporary worktables are data files that are populated with data to be used by SAP Crystal Reports when printing a form. The worktables are populated when you click Print or Preview in the form window, and are cleared after the last form is sent to the printer or when the Preview window is closed.

Note Because worktables are temporary, the data is not available for browsing in SAP Crystal Reports.

 

Expand/Collapse item What are the printer requirements for printing MICR encoding?

The printer requirements for printing MICR encoding are as follows:

  • The printer must be capable of printing bitmap fonts (most printers capable of printing in Windows can do this).

  • The option to add a magnetic ink cartridge must be available (many laser printers are capable of this; check with the manufacturer).

A laser printer is commonly used for MICR printing. Some financial institutions may not require magnetic toner if their scanning equipment uses Optical Character Recognition (OCR) software. Contact your bank for details on MICR requirements. If possible, run a test sample check through your financial institution to ensure compliance.

 

Expand/Collapse item  Why are the reports showing a date of 1753?

Date columns in regular Sage 100 Premium tables are not allowed to have a null value; therefore, empty dates are stored as 17530101. In Sage 100 Premium, 17530101 dates are replaced with an empty string, and visa-versa. When accessing these records outside of Sage 100 (for example, ad-hoc SAP Crystal Reports), you will need to implement a formula to replace the 1753 date with an empty string.

 

Forms

 

Expand or collapse item Is there anything I need to do before modifying or creating a SAP Crystal Reports form or report?

Before modifying or creating a SAP Crystal Reports form or report, perform the following:

  1. Review the linking procedures and other topics in the SAP Crystal Reports Help system.

  2. Review the file layouts information in File Layout and Program Information.

  3. Review the information for using Report Manager.

  4. Disable the Smart Linking feature in SAP Crystal Reports. For more information, see the SAP Crystal Reports Help system.

  5. Verify that the correct version of SAP Crystal Reports is installed.

 

Expand/Collapse item What are the different form types used?

The form name is the name of the program used to print the form, and the format type is assigned based on the style of the form. In general, the format types are:

  • Preprinted Forms

  • Plain Forms

  • Marbled Forms

  • Dot Matrix

 

Expand/Collapse item Which sections are used to generate each of the check form types for Accounts Payable?

The following table summarizes which sections are used to generate each of the check form types.

Check Form Type

Detail Sections

Crystal Form Section Descriptions

Stub, Check

B, C

Stub 2, Check

Check, Stub, Check

C, D, E

Check, Stub 3, Stub 4

Stub, Check, Stub

B, C, D

Stub 2, Check, Stub 3

Stub, Stub, Check

A, B, C

Stub 1, Stub 2, Check

 

 

Expand/Collapse item Which sections are used to generate each of the check form types for Payroll?

The following table summarizes which sections are used to generate each of the check form types.

Check Form Type

Detail Sections

Crystal Form Section Descriptions

Stub, Check

A, C

Stub 1, Check

Check, Stub, Stub

C, D, E

Check, Stub 3, Stub 4

Stub, Check, Stub

A, C, E

Stub 1, Check, Stub 4

Stub, Stub, Check

A, B, C

Stub 1, Stub 2, Check

 

 

Expand/Collapse item Where are form templates installed, and what naming system and folder structure are used?

Form templates are installed in the ..\MAS90\Reports folder during module installation.

For all modules, form templates use a naming system similar to the following example:

File Name

Description

AR_Invoice1.rpt

Plain Form

AR_Invoice2.rpt

Preprinted Form

AR_Invoice3.rpt

Marbled Form

AR_Invoice4.rpt

Dot Matrix Form

When a new form code is entered, you are prompted to select a form template if there are multiple form templates available. If the Designer is selected, the .rpt file for the form template you selected is then copied from the Reports folder to a path determined by the company code, task name, and the form code name. The .rpt file for a specific company is copied to MAS_xxx (where xxx represents the company code), and the file for all companies is copied to MAS_SYSTEM. For example, the Accounts Receivable Invoice Printing form template for company ABC is copied to ..\MAS90\MAS_ABC\Reports\AR_INVOICEPRINTING\FormCode\.rpt.

Warning The default form template in the Reports folder ( ..\MAS90\Reports\AR_Invoice1.rpt) must not be modified. To restore a form template to its default state, you must reinstall the application.

 

ODBC Drivers

 

Expand/Collapse item What are the Sage 100 levels/versions and corresponding ODBC drivers that must be used?

Sage 100 levels/versions and the corresponding ODBC drivers that must be used are listed below. Note the version number in the title bar. Verify that the ODBC version you are running is compatible with the corresponding Sage 100 level/version shown in the following table.

ODBC Driver Version

DSN Name

Corresponding
Sage 100 Standard Level/Version

Corresponding
Sage 100 Advanced Level/Version

Corresponding
Sage 100 Premium
Level/Version

3.21

SOTAMAS90

3.70

3.70

N/A

3.32

SOTAMAS90

4.00/4.05

4.00/4.05

N/A

4.10

SOTAMAS90

4.10

4.10

N/A

4.1001

SOTAMAS90

4.20

4.20

N/A

4.21.1

SOTAMAS90

4.30

4.30

N/A

4.22

SOTAMAS90

4.40

4.40

N/A

SQLOLEDB

N/A

N/A

N/A

4.45

4.40.01

Connection String

2013

2013

 

 

 

Expand/Collapse item What SQL joins are supported by the Sage 100 Standard 4.x ODBC driver?

Note The following information does not apply to Sage 100 Premium.

The SQL join types that are supported by the Sage 100 Standard 4.x ODBC driver are Equal, Left Outer, and Not Equal To. The use of any other join types can result in SQL syntax errors. Only one Left Outer join can be used per report. Using more than one Left Outer join may cause SAP Crystal Reports to generate an incorrect SQL statement. When more than one Left Outer join per report is required, subreports must be used.

 

Dictionary Changes

 

 

Expand or collapse item Which dictionary changes could not be mapped from Level 3.x to Version 4.x in MASCRCW.INI?

The following files and fields do not have mappings.

Note These files/fields may have been removed or broken out into numerous files.

Expand/Collapse item GL_10DelRenMergeDataEntry

DeleteGL1

DeleteGL5

DeleteGL8

DeleteGL_20

 

Expand/Collapse item GL_11DelRenMergeWork

Operation

OperationComplete

DeleteGL1

DeleteGL5

DeleteGL8

DeleteGL_20

 

Expand/Collapse item GL_99MasterfileAuditDetail

GLId

AccountName

 

Expand/Collapse item GL0_Parameters

AccountNoSegment1

AccountNoSegment2

AccountNoSegment3

AllowBdgtMaintInAccountMaint

PeriodEndAllocationStatus

CurrFiscalYrPer1EndDate

CurrFiscalYrPer2EndDate

CurrFiscalYrPer3EndDate

CurrFiscalYrPer4EndDate

CurrFiscalYrPer5EndDate

CurrFiscalYrPer6EndDate

CurrFiscalYrPer7EndDate

CurrFiscalYrPer8EndDate

CurrFiscalYrPer9EndDate

CurrFiscalYrPer10EndDate

CurrFiscalYrPer11EndDate

CurrFiscalYrPer12EndDate

CurrFiscalYrPer13EndDate

NextAllocationNumber

Segment2Description

Segment3Description

Budget3Description

YrsToRetainSummPostHistory

LengthOfAccountNo

Segment2Format

Segment3Format

RecordNo

AssetsDescription

LiabilitiesDescription

EquityDescription

RevenueDescription

ExpenseDescription

CostOfGoodsDescription

GrossProfitDescription

NetIncomeDescription

RetainedEarningsCurrentDesc

OtherIncomeAndExpenseDesc

EarningsBeforeIncomeTaxDsc

IncomeTaxesDescription

NetIncomeFromOperationsDesc

 

Expand/Collapse item GL2_JournalPostingHeader

LinkToFirstDetailRecord

 

Expand/Collapse item GL3_JournalPosting

LinkToPreviousLine

LinkToNextLine

TemporaryVariable

CommentIndicator

PostingComment

 

Expand/Collapse item GL8_BudgetAndHistory

RecordTypeActualBudgets

ActualPeriod2

ActualPeriod3

ActualPeriod4

ActualPeriod5

ActualPeriod6

ActualPeriod7

ActualPeriod8

ActualPeriod9

ActualPeriod10

ActualPeriod11

ActualPeriod12

ActualPeriod13

BudgetPeriord1

BudgetPeriord2

BudgetPeriord3

BudgetPeriord4

BudgetPeriord5

BudgetPeriord6

BudgetPeriord7

BudgetPeriord8

BudgetPeriord9

BudgetPeriord10

BudgetPeriord11

BudgetPeriord12

BudgetPeriord13

Budget2Period1

Budget2Period2

Budget2Period3

Budget2Period4

Budget2Period5

Budget2Period6

Budget2Period7

Budget2Period8

Budget2Period9

Budget2Period10

Budget2Period11

Budget2Period12

Budget2Period13

Budget3Period1

Budget3Period2

Budget3Period3

Budget3Period4

Budget3Period5

Budget3Period6

Budget3Period7

Budget3Period8

Budget3Period9

Budget3Period10

Budget3Period11

Budget3Period12

Budget3Period13

 

Expand/Collapse item GLA_RecJournalEntryHeader

LastPeriodRun

LinkToFirstDetailRecord

 

Expand/Collapse item GLB_RecJournalPostingLine

LinkToPreviousLine

LinkToNextLine

CommentIndicator

 

Expand/Collapse item GLC_FiscalYrMasterfile

Period1EndingDate

Period2EndingDate

Period3EndingDate

Period4EndingDate

Period5EndingDate

Period6EndingDate

Period7EndingDate

Period8EndingDate

Period9EndingDate

Period10EndingDate

Period11EndingDate

Period12EndingDate

Period13EndingDate

 

Expand/Collapse item GLE_SourceJournal

PriorBatchNumber

PriorBatchUpdateDate

PadForFurtureDate

PriorBatchNumber2

PriorBatchUpdateDate2

PadForFutureDate2

PriorBatchNumber3

PriorBatchUpdateDate3

PadForFutureDate3

DoesASavedJrnlExistInGLG

 

Expand/Collapse item GLG_StdJournalEntries

HeaderRecord

AskBeforeMergeStandEntries

TransactionComment

CommentLine

 

Expand/Collapse item GLH_TransJournalHeader

LinkToFirstDetailRecord

 

Expand/Collapse item GLI_TransJournalLine

LinkToPreviousLine

LinkToNextLine

 

Expand/Collapse item GLJ_AllocationHeader

LinkToFirstDetailRecord

 

Expand/Collapse item GLK_AllocationDetail

LinkToPreviousLine

LinkToNextLine

LineType

CommentType

 

Expand/Collapse item GLN_BudgetRevisionEntry

BaseFiscalYr

BaseFigures

RevisionMethod

RoundingFactor

PercentageOrAmountChg

 

Expand or collapse item Which dictionary changes could not be mapped from Version 4.05 to Version 4.10 in MASCRCW.INI?

The following files were temporary Crystal work files and do not have mappings.

Expand/Collapse item Crystal Work Files

AR_20CrystalStmntPrinting

AR_21CrystalInvoiceHeader

AR_22CustomerMailingLabels

AR_23InvoiceLineCrystalPrint

AR_24CustomerStmntInvoiceLine

RA_20CRWRMAandReceiverHeader

RA_21CRWRMAandReceiverDetail

RA_29CRWExtendedDescription

SO_20CRWSalesOrderDetail

SO_21LineItemExtDescriptions

SO_22ShippingLabelPrint

SO_23CRWInvoiceDetail

SO_24CRWPickingSheet

SO_25LotSerialDist

SO_26CRWInvoiceDataHeader

SO_27CRWSalesOrderHeader

SO_28CRWCODLabelPrinting

SO_29CRWShippingLabelPrint

SO_60CRWPackingListHeader

SO_61CRWPackingListDetail

SO_63CRWAddlPackingListHeader

SO_64CRWAddlPackingListDetail

 

The following extended description files only have a mapping for the CommentText field.

Expand/Collapse item Extended Description Files

AR_08HistoryExtItem

RA_06RecptsHistExtItemDesc

RA4_RMAEntryExtLineDescription

RAD_ReceiptsEntryExtdLineDesc

SO_01SalesOrderExtdLineDesc

SO_02InvoiceExtdLineDesc

SO_05SOExtdItemDescription

 

The following files and fields do not have mappings.

Expand/Collapse item AR0_Parameters

RecordNo

PeriodEndCode

PasswrdCommCrdtLimitOverride

StmntDefaultMinimumBalance

StmntDefaultZeroBalanceCust

StmntDefaultPrintCrditBal

StmntDefaultAgingCategory

StmntDefaultIncludeTemp

CurrentArCalendarYr

StmntDefaultZeroBalInvoice

StmntDefaultFormsCode

AllowBatchEntryInvoices

PsswrdInvoiceBatchEntry

NextInvoiceBatchNumber

MemoInquiryDataEntry

BatchEntryCashRecpt

PsswrdCashRecptEntry

NextCashRecptBatchNo

UseGUIInvoices

UseGUICustomerStatements

UseGUICustMailingLabels

PurgeCashReceiptsAtPeriodEnd

BatchRecord

TerminalID

Application Code

ProgramName

KeyOfRecordQuickPrint

VRecord

ApplicationCode

 

Expand/Collapse item AR1_CustomerMasterfile

SalesPTD

SalesYTD

SalesPYR

COGSPTD

COGSYTD

COGSPYR

CashReceivedPTD

CashReceivedYTD

CashReceivedPYR

FinanceChrgPTD

FinanceChrgYTD

FinanceChrgPYR

NumberOfInvoicesPTD

NumberOfInvoicesYTD

NumberOfInvoicesPYR

NumberOfFinanceChargesPTD

NumberOfFinanceChargesYTD

NumberOfFinanceChargesPYR

UnpaidServiceChrgNextYear

SalesNextPeriod

COGSNextPeriod

CashReceivedNextPeriod

FinanceChargesNextPeriod

NoInvoicesNextPeriod

NoFinanceChargesNextPeriod

 

Expand/Collapse item AR6_TransPaymentHistory

CreditCardCVV2Number

 

Expand/Collapse item AR7_InvoiceDataEntryHeader

LinkToFirstDetailRecord

 

Expand/Collapse item AR8_InvoiceDataEntryLine

LinkToPreviousLine

LinkToNextLine

LineIndex

 

Expand/Collapse item AR9_CashRcptDataEntryHeader

BankCode

DepositOrPostingDate

CreditCardAuthorization

RecordType

LinkToFirstDetailRecord

 

Expand/Collapse item ARA_CashRecptDataEntryLine

BankCode

DepositOrPostingDate

LinkToPreviousLine

LinkToNextLine

 

Expand/Collapse item ARD_SalespersonMasterfile

SalesPTD

SalesYTD

SalesPYR

ProfitPTD

ProfitYTD

ProfitPYR

CommPTD

CommYTD

CommPYR

SalesNextPeriod

ProfitNextPeriod

CommNextPeriod

 

Expand/Collapse item ARG_SalesCodeMasterfile

EnterDescription

EnterCostAmount

 

Expand/Collapse item ARH_SalesAnalysisBySlsprsn

SalesPTD

SalesYTD

SalesLYR

SalesNextPeriod

CostOfSalesPTD

CostOfSalesYTD

CostOfSalesLYR

CostOfSalesNextPeriod

 

Expand/Collapse item ARK_InvStmntMsgMaster

PackingListMessageLine1

PackingListMessageLine2

RAPrintingMessageLine1

RAPrintingMessageLine2

RAReceiverPrintingMessage1

RAReceiverPrintingMessage2

RAHistoryPrintingMessage1

RAHistoryPrintingMessage2

 

Expand/Collapse item ARL_RepetitiveInvoiceHeader

LinkToFirstDetailRecord

 

Expand/Collapse item ARM_RepInvoiceLineDetail

LinkToPreviousLine

LinkToNextLine

 

Expand/Collapse item ARN_InvHistoryHeader

SoldToName

CustomerPONumber

SalespersonCode

ShippingMethod

GLBatchNo

CustomerNameSort

CustomerPOSort

SOOrderNoSort

TaxableSalesAmount

NonTaxableSalesAmount

FrghtAmount

SalesTaxAmount

CostOfSales

SalesSubjectToComm

CostSubjectToComm

RetentionAmount

CreditCardCVV2Number

OrderNo

ApplyToInvoiceNumber

SOComment

ARRepetitiveInvoiceRefNo

ARJobNumber

SOInvoiceDueDate

SODiscountDueDate

SOSourceJournal

GLBatchNo

TransDate

FaxNumber

ShippingInvoice

BatchFax

CommRate

ARSalesSubjectToComm

CostSubjectToComm

CommAmount

ARRetentionAmount

SOTaxSchedule

SOTermsCode

 

Expand/Collapse item ARO_InvHistoryDetail

TierSeqNumber

ARSalesCode

ARSalesCodeDesc

ARSalesCodeGLSalesAcct

ARSalesCodeGLCOSAcct

ARSalesCodeGLInvAcct

ARSalesCodeUnitOfMeasure

ARSubjectToExemption

ARSalesCodeComm

ARTaxClass

LineIndex

ARQty

ARUnitPrice

ARUnitCost

ARExtdAmount

LineType

ARMiscLineFlag

ARMiscLineDesc

ARMiscLineGLSalesAcct

ARSubjectToExemption

ARMiscLineComm

ARTaxClass

LineIndex

ARMiscLineAmount

ARCommentLineFlag

ARCommentLineDesc

SOExtdItemNumber

SOSalesKitOptions

ExtendedItemDescription

SOSpecialItemNumber

SOMiscChrgCodeFlag

SOMiscChrgCode

SOCommentCodeFlag

SOCommentCode

SOCommentCodeDescLine1

SOCommentCodeDescLine2

SOMiscItemFlag

SOMiscItemCode

SOLotNumber

SOLotItemRecptQty

SOSerialNumber

SOSerialItemRecptQty

 

Expand/Collapse item ARP_CustomerMemoHeader

SeqNumber

MemoSize

 

Expand/Collapse item AR_05BatchMasterfile

BatchNumber

PrivateBatch

UserCodeSysSecurity

 

Expand/Collapse item AR_07SlsprsnCommEditExRec

Division

SalespersonCode

CustomerDivision

CustomerNumber

InvoiceNumber

InvoiceType

HasCommRecordBeenEdited

 

Expand/Collapse item AR_10DelRenMrgDateEntry

DeleteAr1

DeleteAr4

DeleteArn

DeleteArp

DeleteArs

DeleteSOH_and_IM_13

 

Expand/Collapse item AR_11DelRenMergeTempWork

Division

CustomerNumber

Operation

NewMergeIntoDivision

NewMergeIntoCustomerNumber

OperationCompleted

DeleteAr1

DeleteAr4

DeleteArl

DeleteArn

DeleteArp

DeleteArs

DeleteAr_12

DeleteSo1

DeleteSob

DeleteSoh

DeleteIT2_and_SY1UID

DeleteAR_31

DeleteAR_32

DeleteRA1

StatusErrorMessage

 

Expand/Collapse item AR_14DepTransHistory

CreditCardCVV2Number

 

Expand/Collapse item AR_18CashReceiptsBatchFile

BatchNumber

PrivateBatch

UserCode

CreditCardAuthorization

 

Expand/Collapse item AR_31CustomerCreditCard

CreditCardCVV2Number

 

Expand/Collapse item AR_99CustMasterAuditDetail

AR

 

Expand/Collapse item BR0_Parameters

RecordNo

InterfacedToGL

AllowMemoInquiry

AllowPurgeOptionInGLRecap

 

Expand/Collapse item IT0_Options

NoOfDecimalsInCost

IntialB2BPage

MinToPollForCust_UIDChange

SmtpServerAddress_URL

MinutesToPollForSCEntries

SmtpServerPort

 

Expand/Collapse item IT4_HTML_Template

SSLFlag

 

Expand/Collapse item IT8_UID_CustomerChange

EMailUpdateFlagForRestart

 

Expand/Collapse item IT9_ShoppingCartItems

Division

CustomerNumber

SOLineType

Discount

Commission

SubjectToExemption

ExtendedDescription

AliasItemNumber

TaxClass

 

Expand/Collapse item ITA_ShoppingCartHeader

InvalidTaxCalc

EMailUpdateFlagForRestart

CommissionRate

 

Expand/Collapse item ITB_ShoppingCartLines

Commission

ExtendedDescription

CommentLine2

Warehouse

 

Expand/Collapse item ITE_CategoryMaintenance

ReduceImage

ThumbnailImageFile

ThumbnailWidthInPixels

ThumbnailHeightInPixels

 

Expand/Collapse item ITI_UID_CustomerChangeLog

Status

 

Expand/Collapse item ITJ_SC_SubmissionsLog

Status

ReasonCode

InvalidTaxCalculationFlag

ShipZoneMaintained

ShipZoneActual

ITUserType

BillingName

BillingAddress1

BillingAddress2

BillingAddress3

BillingCity

BillingState

BillingZipCode

BillingCountryCode

TelephoneNumber1

Extension1

TelephoneNumber2

Extension2

FaxNumber

ShippingName

ShippingAddress1

ShippingAddress2

ShippingAddress3

ShippingCity

ShippingState

ShippingZipCode

ShippingCountryCode

ShippingTelephoneNumber

ShippingFaxNumber

EMailAddress

Password

FreightCalculationMethod

EncryptedCreditCardNumber

CreditCardCVV2Number

Last4UnencryptedCreditCardNos

CreditCardAuthorizationCode

CreditCardTransactionID

AuthorizationDate

AuthorizationTime

CCExpirationYear

CCExpirationMonth

SaveCreditCardNumberinAR1

CreditCardPreAuthorizationAmt

CommissionRate

 

Expand/Collapse item ITK_SC_SubmissionsLogLines

UnitOfMeasureConversionFactor

 

Expand/Collapse item ITL_EMailPending

EMailMessageSequence

 

Expand/Collapse item ITQ_ItemLongDescription

ItemNumber

ItemSource

SeqNumber

CommentSize

CommentText

 

Expand/Collapse item ITR_CategoryLongDescription

CategoryCode

SEQNumber

CommentSize

CommentText

 

Expand/Collapse item RA0_Parameters

AllowCustMemoInquiry

AllowBatchEntry

BatchEntryOverridePassword

NextBatchNumber

SpecialItemReturnPassword

PriceOverridePassword

UseGUICustomerRMAs

UseGUIRMAReceivers

ReceiverPrintRMAsOnHoldOption

ReceiverPrintMiscChgsOption

TrackRepairItemsThruInvent

SetRepairItemUnitCostToZero

RecordType

TerminalID

RMAEntryDefaultOptions

RepairsInProcessAccount

RepairsClearingAccount

RestockChargeOverridePassword

AllowRepairWarehouseChanges

RepairDefaultWarehouse

ApplicationCode

 

Expand/Collapse item RA1_RMAEntryHeader

UserID

LinkToFirstDetailRecord

 

Expand/Collapse item RA2_RMAEntryLine

LinkToPrevLine

LinkToNextLine

ExtendedItemNumber

SalesKit_StanadardOptions

ExtendedDescription

DescriptionLine2

ReplacementRepairOptions

ARLEntityLineIndex

MiscSlash

MiscCode

subjectToCommission

 

Expand/Collapse item RAA_ReceiptsDataEntryHeader

UserID

LinkToFirstDetailRecord

 

Expand/Collapse item RAB_ReceiptsDataEntryLineFile

LinkToPrevLine

LinkToNextLine

ExtendedItemNumber

SalesKitStandardOptions

ExtendedDescription

DescriptionLine2

ReplacementRepairOptions

ARLEntityLineIndex

Description

MiscSlash

MiscCode

ExtensionChargeAmount

LotSerialFullyDistribuited

 

Expand/Collapse item RAI_RepairDetail

RecordType

MiscSlash

MiscCode

 

Expand/Collapse item RAM_ReturnReasonDetail

MiscSlash

MiscCode

 

Expand/Collapse item RA_03ReceiptsHistoryHeader

UserID

LastLineSeqNumber

 

Expand/Collapse item RA_04ReceiptsHistoryLineDtl

ExtendedItemNumber

SalesKit_StandardOptions

ExtendedDescription

LineIndex

DescriptionLine2

ReplacementRepairOptions

ARLEntityLineIndex

Standard_KitBill

MiscSlash

MiscCode

RabLineIndex

 

Expand/Collapse item SO0_ParameterRecord

DfltCustSalesHistoryOpt

CustSalesHistOptByCustType

PickSheetPrtngDfltOptions

PriceOverridePsswrd

CustomerType1

CustomerOpt1ProdLine

CustomerType2

CustomerOpt2

CustomerType3

CustomerOpt3

CustomerType4

CustomerOpt4

CustomerType5

CustomerOpt5

CustomerType6

CustomerOpt6

CustomerType7

CustomerOpt7

CustomerType8

CustomerOpt8

CustomerType9

CustomerOpt9

CustomerType10

CustomerOpt10

WarrantyOverridePassword

AllowBatchEntry

PssWrdBatchEntry

NextBatchNumber

CrdtLimitMrgnToPrntWrnngMess

Field1

TermId

InvoiceEntryDefaultOptions

Field2

OrderEntryDefaultOptions

RecordNo

Field9

AllowMemoInquiryDataEntry

AllowPurgeOptInGLRecapRpt

ProfitMarginPercOverridePsswrd

UseGUISalesOrders

UseGUISOInvoices

UseGUIPickingSheets

UseGUIShippingLabels

UseGUICODlabels

ShippingDocumentToPrint

PrintPackingListsWithContents

AutomaticallyPrintShippingDoc

AllowAltItemsDuringShipping

AlternateItemsPassword

AllowOvershipsDuringShipping

OvershipmentsPassword

DeleteEntriesBatchesPassword

DefaultShipperIDOnNextShipNo

PromptForBOOnPartialShipment

AllowChangesToUMOnLines

PrintShippingExceptionReport

AllowChangesToShipToLocation

AllowChangesToShipVia

AllowChangesToWhseOnLines

ShipToShipViaWhsePassword

AllowEntryOfFreightWeight

DisplayInvoiceTotal

AutoIncrementQty

ShippingFunction

UseGUIPackingList

SIAddFreightToCOD

SIBillingMethod

ShippingIntegration

SIDefaultDeclaredValue

SIFreightToInvoiceFrt

NextPackageIncrementKeyword

AutoIncrementKeyword

BackorderOverridePassword

SIFixedDeclaredValue

SICOGSMarkupPercent

 

Expand/Collapse item SO1_SOEntryHeader

LinkToFirstDetailRecord

 

Expand/Collapse item SO2_SOEntryDetailLine

LinkToPrevLine

LinkToNextLine

ExtdItemNumber

ExtendedDescription

SalesKitOptions

SpecialItem

DescriptionSpecialItem

GLSlsAcctSpecialItem

MiscSlash

MiscCode

DescriptionMiscChrg

GLSlsAcctMiscLine

ChrgAmount

DescriptionLine2

IndexOfSalesKitLineCommnt

DescriptionMiscItem

GLSlsAcctMiscItem

 

Expand/Collapse item SO5_InvoiceDataEntryHeader

LinkToFirstDetailRecord

 

Expand/Collapse item SO6_InvoiceDataEntryDetail

LinkToPreviousLine

LinkToNextLine

ExtdItemNumber

ExtendendDescription

SalesKitOptions

SpecialItem

DescriptionSpecialItem

GLSalesAcctSpecialItem

MiscSlash

MiscCode

DescriptionMiscChrg

GLSalesAcctMiscLine

ChrgAmount

DescriptionLine2

OrderLineIndex

IndexOfSalesKitLineCmmnt

DescriptionMiscItem

GLSalesAcctMiscItem

 

Expand/Collapse item SO7_MiscChargeCode

StdChrg

TotalChrg_PTD

TotalChrg_YTD

TotalChargesLY

TotalChrgNextPeriod

CommentDescriptionLine2

Qty_PTD

Qty_YTD

QtyLY

QtyNextPeriod

Sales_PTD

Sales_YTD

SalesLY

SalesNextPeriod

CostOfGoodsSold_PTD

CostOfGoodsSold_YTD

CostOfGoodsSoldLY

CostOfGoodsSoldNextPeriod

 

Expand/Collapse item SO8_ShippingRate

Blanks10

ProductLineType

ShipZoneKey

ShipWeight

ActualShipZone

FreightCharge

ProductLine

Blanks6

Type

BaseCharge

AdditionalChargePerIMStdQty

Amount

 

Expand/Collapse item SOC_InvEntryTempTierCostCalc

ExtdItemNumber

InverseOfRecptDate

 

Expand/Collapse item SOE_SOLotSerialHistDetail

ExtdItemNumber

 

Expand/Collapse item SOG_MonthlyRecapProdWhse

ProdLine

WhseCode

DailyQtyShipped

DailyDollarsSold

DailyCostOfGoodsSold

PtdQtyShipped

PtdDollarsSold

PtdCostOfGoods

YtdQtyShipped

YtdDollarsSold

YtdCostOfGoods

NextPeriodQtySold

NextPeriodDollarsSold

NextPeriodCostOfGoodsSold

 

Expand/Collapse item SOH_CustSlsHistory

Division

CustomerNumber

RecordType

ProdLineForType

QtyShippedPeriod1

QtyShippedPeriod2

QtyShippedPeriod3

QtyShippedPeriod4

QtyShippedPeriod5

QtyShippedPeriod6

QtyShippedPeriod7

QtyShippedPeriod8

QtyShippedPeriod9

QtyShippedPeriod10

QtyShippedPeriod11

QtyShippedPeriod12

QtyShippedPeriod13

DollarsSoldPeriod1

DollarsSoldPeriod2

DollarsSoldPeriod3

DollarsSoldPeriod4

DollarsSoldPeriod5

DollarsSoldPeriod6

DollarsSoldPeriod7

DollarsSoldPeriod8

DollarsSoldPeriod9

DollarsSoldPeriod10

DollarsSoldPeriod11

DollarsSoldPeriod12

DollarsSoldPeriod13

CostOfGoodsSoldPeriod1

CostOfGoodsSoldPeriod2

CostOfGoodsSoldPeriod3

CostOfGoodsSoldPeriod4

CostOfGoodsSoldPeriod5

CostOfGoodsSoldPeriod6

CostOfGoodsSoldPeriod7

CostOfGoodsSoldPeriod8

CostOfGoodsSoldPeriod9

CostOfGoodsSoldPeriod10

CostOfGoodsSoldPeriod11

CostOfGoodsSoldPeriod12

CostOfGoodsSoldPeriod13

PriorYrQtySoldPeriod1

PriorYrQtySoldPeriod2

PriorYrQtySoldPeriod3

PriorYrQtySoldPeriod4

PriorYrQtySoldPeriod5

PriorYrQtySoldPeriod6

PriorYrQtySoldPeriod7

PriorYrQtySoldPeriod8

PriorYrQtySoldPeriod9

PriorYrQtySoldPeriod10

PriorYrQtySoldPeriod11

PriorYrQtySoldPeriod12

PriorYrQtySoldPeriod13

NextPeriodQtyShipped

NextPeriodDollarsSold

NextPeriodCostOfGoodsSold

 

Expand/Collapse item SOI_SlsOrdRecapDivWhse

RecordType

Division

DailyDollarsSold

DailyCostOfGoodsSold

PtdDollarsSold

PtdCostOfGoods

YtdDollarsSold

YtdCostOfGoodsSold

NextPeriodDollarsSold

NextPeriodCostOfGoodsSold

WhseCode

 

Expand/Collapse item SOJ_DailyCustomerSalesRecap

DailyDollarsSold

DailyCostOfGoodsSold

 

Expand/Collapse item SOO_SalesOrderBatchMasterfile

BatchNumber

PrivateBatch

UserCode

CreatedInShippingDataEntry

 

Expand/Collapse item SO_03SOHistoryHeader

CreditCardCVV2Number

LastLineSEQ

 

Expand/Collapse item SO_04SOHistoryDetail

ExtendedItemNumber

ExtendedDescription

SalesKitSTDOptions

SpecialItemNumber

Spec_MiscChrg_MiscItemDesc

Spec_MiscChgItemGLSalesAcct

MiscSlash

MiscCode

MiscChargeAmount

CommentDescriptionLine2

CommentLineIndexSalesKitLn

 

Expand/Collapse item SO_08SOHistoryARInvoiceLink

InvoiceLineExtensionAmount

 

Expand or collapse item Which dictionary changes could not be mapped from Version 4.10 to Version 4.20 in MASCRCW.INI?

The following files were temporary Crystal work files and do not have mappings.

Expand/Collapse item Crystal Work Files

AP_20CrystalCheckHeader

AP_21CrystalCheckLine

AP_22CrystalLabelPrinting

 

The following tables do not have mappings.

Expand/Collapse item Tables

APB_CheckHistory

APD_Batch

 

The following files and fields do not have mappings.

Expand/Collapse item AP_10DelRenMrgeDataEntry

DeleteAP1

DeleteAP4

DeleteAPB

DeleteAPP

DeleteAPR

DeletePO1

DeletePOB

DeleteIM1

DeleteAP_12

 

Expand/Collapse item AP_11DelRenMergeTemp

OperComplete

DeleteAP1

DeleteAP4

DeleteAPB

DeleteAPP

DeleteAPR

DeletePO1

DeleteIM1

DeleteAP_12

 

Expand/Collapse item AP_12InvHistoryHeader

SrceBtch

APTaxClass

ALEVendorNameSort

ALEPONumberSort

POPrepaidAmount

POTaxableAmount

PONonTaxAmount

POSlsTaxAmount

POFrghtAmount

PODiscountAmount

 

Expand/Collapse item AP_13InvHistoryDetail

TBGLAcct

TBEmployeeCode

TBClientCode

TBEngagementCode

TBWorkCode

TBCatagoryCode

TBBillType

TBTaxable

TBComment

TBExtendedComm

TBRateMethod

TBSalesTaxCode

TBUnits

TBExtendedAmount

TBMarkupPercent

TBHourlyRate

TBMrkUpAmtEmplCost

POItemExtendedItemNumber

POItemUM

POItemJobNumber

POItemCostCode

POItemCostCodeType

POItemType

POItemBalBckOrdOrigOrdQty

POItemUnitCost

POItemEntryRecvdInvExtd

POSpecialItemNo

POSpecialExtensionItemNo

POSpecialRequiredDate

POSpecialDescription

POSpecialUnitOfMeasure

POSpecialJobNumber

POSpecialCostCode

POSpecialCostCodeType

POSpecialGLAcct

POSpecialWorkOrderNo

POSpecialStepNumber

POSpecialSubStepPrefix

POSpecialSubStepSuffix

POSpecialType

POMiscItemCode

POMiscItemRequiredDate

POMiscItemDescription

POMiscItemUnitOfMeasure

POMiscItemJobNumber

POMiscItemCostCode

POMiscItemCostCodeType

POMiscItemGLAcct

POMiscItemWorkOrderNumber

POMiscItemStepNumber

POMiscItemSubStepPrefix

POMiscItemSubStepSuffix

POMiscItemType

POMiscVendor_AliasItemNumber

POCommentCode

POCommentDescLine1

POCommentDescLine2

POMiscChargeCode

POMiscChrgMiscChargeDesc

POMiscChrgJobNumber

POMiscChrgCostCode

POMiscChrgCostCodeType

POMiscChrgGLAcct

POMiscChrgWorkOrderNumber

POMiscChrgStepNumber

POMiscChrgSubStepPrefix

POMiscChrgSubStepSuffix

POMiscChrgType

POMiscChrgChargeAmount

 

Expand/Collapse item AP_23VendorRemitTo

OpenString

 

Expand/Collapse item AP_99VendMasterAuditDetail

AP

 

Expand/Collapse item AP0_ParameterRecord

PeriodEndCode

NoOfMthsToRetainCheckHistory

IntegratedToTimeBilling

CurrentAPCalendarYear

ExtdStubFormCodeLastPrinted

CheckFormTypeLastPrinted

CheckFormCodeLastPrinted

AllowBatchEntry

PsswrdForBatchEntryOvrride

NextBatchNumber

GraphicalFormTypeLastPrinted

VendorMaskDiv

LengthOfVendorKey

RecordNo

AllowMemoInquiryDataEntry

AllowPurgeOptInGLRecapRpt

UseGUIChecks

UseGUIVendorMailingLabels

 

Expand/Collapse item AP1_VendorMaster

PurchasesPTD

PurchasesYTD

PurcahsePYR

PaymentsPTD

PaymentsYTD

PaymentsPYR

DiscountsTakenPTD

DiscountsTakenYTD

DiscountsTakenPYR

DiscountsLostPTD

DiscountsLostYTD

DiscountsLostPYR

PurcahsesNextPeriod

PaymentsNextPeriod

DiscountsTakenNextPeriod

DiscountsLostNextPeriod

 

Expand/Collapse item AP5_InvoiceDataEntryHeader

LinkToFirstDetailRecord

 

Expand/Collapse item AP6_InvoiceDataEntryLine

LinkToPreviousLine

LinkToNextLine

TBRateMethod

TBEmployeeCode

TBClientCode

TBEngagementCode

TBWorkCode

TBCategoryCode

TBBillType

TBTaxable

TBComment

TBExtdComments

TBStateSalesTaxCode

TBCountySalesTaxCode

TBLocalSalesTaxCode

TBUnits

TBExtension

TBMarkupPercentMethod

TBRate

TBMarkedUpAmtEmployeeCost

 

Expand/Collapse item AP7_ManualCheckHeaderDetail

InvoiceNumber

InvoiceType

JobNumber

_1099Form

_1099Box

TaxSchedule

TaxClass

InvalidTaxCalculation

UseTax

DiscountAmount

RetentionAmount

LinkeToFirstDetailRecord

TaxableAmount

NonTaxableAmount

FreightAmount

TaxAmount

NonRecoverableAmount

 

Expand/Collapse item AP8_ManualCheckGLDist

InvoiceNumber

LinkToPreviousLine

LinkToNextLine

GL_JC_LineType

TBEmployeeCode

TBClientCode

TBEngagementCode

TBWorkCode

TBCategoyCode

TBBillType

TBTaxable

TBComment

TBExtdComments

TBRateMethod

TBStateSalesTaxCode

TBCountySalesTaxCode

TBLocalSalesTaxCode

TBUnits

TBExtension

TBMarkupPercentMethod

TBRate

TBMarkedUpAmountEmployeeCost

 

Expand/Collapse item AP9_CheckDataEntryHeader

RetentionAmount

LinkToFirstDetailRecord

 

Expand/Collapse item APA_CheckDataEntryLineDetail

LinkToPreviousLine

LinkToNextLine

 

Expand/Collapse item APF_RepetitiveInvoiceHeader

LinkToFirstDetailRecord

 

Expand/Collapse item APG_RepetitiveInvLineDetail

LinkToPreviousLine

LinkToNextLine

 

Expand/Collapse item APK_InvEntryDetailComment

LineIndexOfComment

 

Expand/Collapse item APL_ManChkEntryDetailComnt

InvoiceNumber

SeqNumber

CommentSize

 

Expand/Collapse item APM_APFromARClearingEntry

SystemDate

LinkToFirstDetailRecord

 

Expand/Collapse item APN_APFrmARclearingDetail

SystemDate

LinkToPreviousDetailLine

LinkToNextLine

 

Expand/Collapse item APP_VendorMemoMaintenance

MemoSize

 

Expand/Collapse item APR_Vendor1099Payments

Country

DividendBox1a

DividendBox2b

DividendBox3

DividendBox4

DividendBox5

DividendBox6

DividendBox8

DividendBox9

DividendBox1aNextYr

DividendBox2bNextYr

DividendBox3NextYr

DividendBox4NextYr

DividendBox5NextYr

DividendBox6NextYr

DividendBox8NextYr

DividendBox9NextYr

DividendBox2d

DividendBox2c

DividendBox2dNextYr

DividendBox2cNextYr

DividendBox2y

DividendBox2yNextYr

DividendBox1b

DividendBox1bNextYr

DividendBox2x

DividendBox2xNextYr

InterestBox1

InterestBox2

InterestBox3

InterestBox4

InterestBox5

InterestBox1NextYr

InterestBox2NextYr

InterestBox3NextYr

InterestBox4NextYr

InterestBox5NextYr

StatePayerNumber

MiscBox1

MiscBox2

MiscBox3

MiscBox4

MiscBox5

MiscBox6

MiscBox7

MiscBox8

MiscBox10

MiscBox16

MiscBox1NextYr

MiscBox2NextYr

MiscBox3NextYr

MiscBox4NextYr

MiscBox5NextYr

MiscBox6NextYr

MiscBox7NextYr

MiscBox8NextYr

MiscBox10NextYr

MiscBox16NextYr

MiscBox13

MiscBox13NextYr

MiscBox14

MiscBox14NextYr

MiscBox18

MiscBox18NextYr

MiscBox15a

MiscBox15aNextYr

MiscBox15b

MiscBox15bNextYr

VARIANT__RECORD__FLAG

 

Expand or collapse item Which dictionary changes could not be mapped from Version 4.20 to Version 4.40 in MASCRCW.INI?

The following files were temporary Crystal work files and do not have mappings.

Expand/Collapse item Crystal Work Files

BM_21CRWLineItemExtDesc

BM_22CRWLabelPrinting

BM_24CRWPickingSheet

BM_25CRWLotSerial

BM_28CRWPickingSheetHeader

IM_22CrystalLabelPrinting

PO_20CRWPurchaseOrderDetail

PO_21CRWLineItemExtDesc

PO_22CRWRetOrderDetail

PO_23CRWRetEntryTierDist

PO_24CRWRetLineItemExtDesc

PO_25CRWPurchaseOrderHeader

PO_26CRWReturnOfGoodsHeader

 

The following tables do not have mappings.

Expand/Collapse item Tables

BM_01BatchFile

IM_13CustomerSalesHistory

IM_14ItemReceiptHistory

IM_15VendorReceiptHistory

IM9_ItemSalesDetailWhse

IMM_CompntUsageHistory

POD_POMessage

POV_Batchmaster

 

The following files and fields do not have mappings.

Expand/Collapse item BM0_BMParameters

AddItemFromBillMaintenance

HistoryPurgePsswrd

PrntMiscCodesOnPickSheet

PrntCommentLinesOnPickSh

DisassemblyType

AllowBatchEntry

PsswrdForBatchOverride

NextBatchNumber

RecordType

AllowMemoInquiryDataEnt

AllowPurgeOptionInGLRecap

UseGUIPickingSheets

UseGUIProductionLabels

 

Expand/Collapse item BM1_BillMaterialsHeader

OptionCategory

OptionCode

LinkToFirstDetailRecord

OptionDescription1

OptionDescription2

StepNumber

OptionPrice

 

Expand/Collapse item BM2_BillMaterialsDetail

OptionCategory

OptionCode

PreviousIndexNumber

LinkToNextLine

C

CommentCode

MiscCharge

MiscChrgCode

PostByWhse

 

Expand/Collapse item BM3_BillInteractionHeader

LinkToFirstDetailRecord

 

Expand/Collapse item BM4_BillInteractionDetail

PreviousIndexNumber

LinkToNextLine

CommentCode

MiscCharge

MiscChargeCode

PostByWhse

 

Expand/Collapse item BM5_MiscellaneousCodes

PostByWhse

CommentC

CommentCode

CommentOpen

 

Expand/Collapse item BM6_ChangeControlHeader

PriorEffectiveDate

LinkToFirstDetailRecord

 

Expand/Collapse item BM7_ChangeControlDetail

PreviousIndexNumber

LinkToNextLine

 

Expand/Collapse item BMA_ProductionEntryHeader

LinkToFirstDetailRecord

 

Expand/Collapse item BMB_ProductionEntryDetail

PreviousIndexNumber

LinkToNextLine

CommentC

CommentCode

MiscChrgCodeInd

MiscChrgCode

PostByWhse

 

Expand/Collapse item BMC_ProdEntryTierDistDetail

ItemType

UnitCost

SerialNumber

 

Expand/Collapse item BMD_TempInvEntryTierCostCalc

ExtendedItemNumber

InverseOfReceiptDate

 

Expand/Collapse item BME_ReplaceDelEntryHeader

LinkToFirstDetailRecord

 

Expand/Collapse item BMF_ReplaceDelEntryDetail

PreviousIndexNumber

LinkToNextLine

 

Expand/Collapse item BMH_ProductionLabels

ExtendedItemNumber

 

Expand/Collapse item BMI_ProductionHistoryFile

SequenceLineNumber

RecordType

ComponentItemCode

ComponentRevisionCode

ComponentWhse

ComponentLineGLAcct

Valuation

ItemNumber

Description

ComponentQtyPerAssembly

ComponentExtendedQty

ComponentUnitCost

C

CommentCode

Comment

MiscChrg

MiscChrgCode

MiscChrgDescription

MiscChrgChrgAcct

MiscChrgUM

MiscChrgQtyPerAssembly

MiscChrgExtendedQty

StandardCostPerUM

 

Expand/Collapse item BML_DisassemblyEntryHeader

LinkToFirstDetailRecord

 

Expand/Collapse item BMM_DisassemblyEntryDetail

PreviousIndexNumber

LinkToNextLine

CComment

CommentCode

CommentOpenString

MiscCharge

MiscChargeCode

MiscChrgOpenString

MiscChrgPostByWarehouse

 

Expand/Collapse item IM_03ItemEndedDescription

ItemNumber

SEQNumber

CommentSize

 

Expand/Collapse item IM_10DelRenMergeDataEntry

DeleteIM5

DeleteIM9

DeleteIMM

DeleteIMP

DeletePOO

DeleteSOE

DeleteIM_13

DeleteIM_14

DeleteIM_15

 

Expand/Collapse item IM_11DelRenMergeTempWork

DeleteIM5

DeleteIM9

DeleteIMM

DeleteIMP

DeletePOO

DeleteSOE

DeleteIM_13

DeleteIM_14

DeleteIM_15

 

Expand/Collapse item IM_99MasterfileAudit

App

 

Expand/Collapse item IM0_ParameterRecord

RecordType

DfltStockStatPOAvailOpt

CalendarMonthForPeriodOne

RetainTransactionHistory

NumberOfDecimalPlacesInPrice

NumberOfDecimalPlacesInQty

NumberOfDecimalPlacesInUM

SortPhyCountByBinLocation

NumberOfDecimalPlacesInCost

TransEntLifoFifoIssTrnInPo

PeriodEndOpt

PerEndRestartPoint

PerEndRestartKey

AllowMemoInquiryDataEntry

AllowPurgeOptionInGLRecap

UseGUIInventoryLabels

UseGUIReceiptLabels

 

Expand/Collapse item IM1_InventoryMasterfile

DetailSalesHistory

AlternateItems

PriceByItem

PriceByCustomerPriceLevel

PriceByCustomerNumber

ExtendedDescription

DetailReceiptHistory

 

Expand/Collapse item IM2_InventoryItemWhseDetl

BeginningAveCostAt

BeginningBalQty

QtyReceived

QtyAdjusted

QtySold

KitQtyReceivedNextPeriod

PtdQtySold

PtdQtyReturned

PtdDollarsSold

PtdCostofGoodsSold

YtdQtySold

YtdQtyReturned

YtdDollarsSold

YtdCostofGoodsSold

PriorYrQtySold

PriorYrQtyReturned

PriorYrDollarsSold

PriorYrCostOfGoodsSold

AveOnHandQtyAt

QtyIssuedPtd

QtyIssuedYtd

QtyIssuedPriorYr

QtySoldNextPeriod

QtyReturnedNextPeriod

DollarsSoldNextPeriod

CostOfGoodsSoldNextPeriod

QtyIssuedNextPeriod

 

Expand/Collapse item IM3_ItemCosting

RecptNumber2

RecptDate2

InverseRecptDate

 

Expand/Collapse item IM4_AlternateItem

AlternateItem2

AlternateItem3

AlternateItem4

AlternateItem5

AlternateItem6

AlternateItem7

AlternateItem8

 

Expand/Collapse item IM5_TransactionDetail

LotSerialLifoFifoNo

 

Expand/Collapse item IMA_ProductLine

DetailSalesHistory

DetailReceiptHistory

 

Expand/Collapse item IMB_PriceCode

ItemCustomerPriceLevel

ItemMethod

ItemCustomerRecordMethod

 

Expand/Collapse item IMG_TransDataEntryHeader

LinkToFirstDetailHeader

 

Expand/Collapse item IMH_TransDataEntryLine

LinkToPreviousLine

LinkToNextLine

ItemNumberRecord

Complete

DropShip

Taxable

EntryOfAdjDetailWExistingTier

LinkToPOLine

 

Expand/Collapse item IMK_TransEntryTierCostCalc

QtyOnHand

InverseRecptDate

 

Expand/Collapse item IMN_SalesKitMasterfile

LinkToFirstDetailRecord

 

Expand/Collapse item IMO_SalesKitDetail

LinkToPreviousLine

LinkToNextLine

CommentMiscCode

MiscCodeDescription

ChargeGL_Account

StdCostPerUM

 

Expand/Collapse item IMP_ItemMemo

MemoSize

 

Expand/Collapse item PO_01AutoGenPurchaseOrders

ExtendedItemNumber

 

Expand/Collapse item PO_02ExtendedLineDescrip

PurchaseOrderNumber

LineIndex

SEQNo

CommentSize

 

Expand/Collapse item PO_03ReturnExtendedLineDesc

ReturnNumber

LineIndex

SEQNo

CommentSize

 

Expand/Collapse item PO0_ParameterFile

RetainPurchaseHistory

PayableDeptAcct

ReceiptInvoiceVarianceAcct

GRecordReceiptOfGoods

IRecordReceiptOfInvoice

RRecordReturnEtnry

MRecordMaterialReq

PeriodEndFlag

AllowAddtnNewItems

AllowOverrideLineGL

AllowItemMemoInquiry

NumberDecimalsForQty

NumberDecimalsfForCost

PasswordForQtyRecGrtrThanOrd

PrepaidFrghtGLAcct

AllowBatchEntry

PsswrdForBatchOverride

NextBatchNumber

RecordNumber

AllowMemoInquiryDataEntry

AllowPurgeOptInGLRecapRpt

CostOverridePassword

UseGUIPurchaseOrders

UseGUIReturnOrders

 

Expand/Collapse item PO1_PurchaseOrderEntryHeader

LinkToFirstDetailRecord

 

Expand/Collapse item PO2_PurchaseOrderEntryLine

LinkToPreviousLine

LinkToNextLine

ExtendedItemNumber

ExtendedDescription

SpecialItem

SpecialMiscItemDescription

SpecialMiscUnitOfMeasure

SpecialMiscGLAccount

MiscSlash

MiscCode

MiscChrgDescription

DescriptionLine2

 

Expand/Collapse item PO5_ReceiptEntryHeader

ReceiptType2

LinkToFirstDetailRecord

 

Expand/Collapse item PO6_ReceiptEntryLineDetail

LinkToPreviousLine

LinkToNextLine

ExtendedItemNumber

CostCodeType

SpecialItem

SpecialMiscItemDescription

SpecialMiscItemUnitOfMeasure

SpecialMistItemChrgGLAcct

MiscSlash

MiscCode

MiscChrgDescription

MicellanousChrgAmount

CommentDescriptionLine2

CommentPOLineIndex

 

Expand/Collapse item PO7_MiscellaneousChargeCode

TotalChargesPTD

TotalChargesYTD

TotalChargesLYR

OpenStringKey

QtyReceivedPTD

QtyReceivedYTD

QtyReceivedLYR

QtyReceivedNextPeriod

PurchasesPTD

PurchasesYTD

PurchasesLYR

PurchasesNextPeriod

QtyIssuedPTD

QtyIssuedYTD

QtyIssuedLTD

DescriptionLine2

 

Expand/Collapse item PO8_AutoReorderSelection

ExtendedItemNumber

 

Expand/Collapse item POD_POMessage

StdMessageLine1

StdMessageLine2

 

Expand/Collapse item POE_ReturnDataEntryHeader

ReturnType2

LinkToFirstDetailRecord

 

Expand/Collapse item POF_ReturnDataEntryLine

LinkToPreviousLine

LinkToNextLine

ExtdItemNumber

ExtendedDescription

CostCodeType

SpecialItem

SpecMiscItemDescription

SpecMiscUnitOfMeasure

SpecMiscGLAcct

PreviousQtyReceived

MiscSlash

MiscCode

MiscChargeDescription

MiscChargeAmount

CommentDescriptionLine2

CommentPOLineIndex

 

Expand/Collapse item POH_MaterialReqHeader

MatReqType

LinkToFirstDetailRecord

 

Expand/Collapse item POI_MaterialReqIssue

LinkToPreviousLine

LinkToNextLine

ExtendedItemNumber

CostCodeType

ActualCost

MiscSlash

MiscCode

CommentDescriptionLine2

CommentIndexToPOLine

MiscUnitOfMeasure

MiscGLAcct

 

Expand/Collapse item POM_RecptHistoryLine

ExtendedItemNumber

 

Expand/Collapse item PON_RecptHistoryLotSerDetail

ExtendedItemNumber

Item Type

 

Expand/Collapse item POO_PurchaseHistory

ExtendedItemNumber

PeriodToDateAveDaysForRec

PeriodToDateNumberOfRecpt

YrToDateQtyPurchased

YrToDateDollarsPurchased

YrToDateAveDaysForRecpt

YrToDateNumberOfRecpt

PriorYrQtyPurchased

PriorYrDollarsPurchased

PriorYrAveDaysForRecpt

PriorYrNumberOfRecpt

NextPeriodQtyPurchased

NextPeriodDollarsPurchased

NextPeriodAveDaysRecpt

NextPeriodNumberOfRecpt

 

Expand/Collapse item POP_ReceiptHistoryHeader

NonTaxMiscChrgAmount

 

Expand/Collapse item POR_VendorPriceLevel

ExtendedItemNumber

 

Expand or collapse item Which dictionary changes could not be mapped from Version 4.40 to Version 2013 in MASCRCW.INI?

The following tables do not have mappings.

Expand/Collapse item Tables

CU_MASOptions

SY_CreditCardAuditLog

SY_CreditCardAuditLogWrk

 

The following files and fields do not have mappings.

Expand/Collapse item AR_CashReceiptsDetail

EncryptedCreditCardNo

 

Expand/Collapse item AR_CashReceiptsHeader

EncryptedCreditCardNo

CreditCardCVV2No

AVSAddress

 

Expand/Collapse item AR_CashReceiptsHistory

CreditCardNo

AVSAddress

 

Expand/Collapse item AR_CashReceiptsJournalWrk

FullCreditCardNo

 

Expand/Collapse item AR_Customer

EncryptedCreditCardNo

 

Expand/Collapse item AR_CustomerCreditCard

EncryptedCreditCardNo

AVSAddress

 

Expand/Collapse item AR_CustomerCreditCardEBMUser

EncryptedCreditCardNo

 

Expand/Collapse item AR_CustomerCreditCardListWrk

EncryptedCreditCardNo

PartiallyEncryptedCreditCardNo

AVSAddress

FullCreditCardNo

 

Expand/Collapse item AR_CustomerListingWrk

FullCreditCardNo

 

Expand/Collapse item AR_DepositHistory

EncryptedCreditCardNo

 

Expand/Collapse item AR_InvoiceHistoryHeader

CorporateCustIDPurchOrder

CorporateTaxOverrd

DepositCorporateTaxOverrd

CardholderName

ExpirationDateYear

ExpirationDateMonth

EncryptedCreditCardNo

Last4UnencryptedCreditCardNos

AuthorizationCode

AuthorizationCodeForDeposit

CreditCardTransactionID

CreditCardTransactionIDForDep

CreditCardPaymentBalanceAmt

DepositCorporateSalesTax

CorporateSalesTax

 

Expand/Collapse item AR_Options

DaysToRetainCreditCardHistory

TestNo

 

Expand/Collapse itemAR_OptionsListingWrk

DaysToRetainCreditCardHistory

 

Expand/Collapse item AR_PaymentType

CreditCardProcessorCode

ProcessorType

DisplayAVSResponse

DisplayCVV2Response

ValidationCodeLen

RequireValidationCode

 

Expand/Collapse item AR_PaymentTypeWrk

CreditCardProcessorCode

ProcessorType

DisplayAVSResponse

DisplayCVV2Response

ValidationCodeLen

RequireValidationCode

 

Expand/Collapse item AR_TransactionPaymentHistory

EncryptedCreditCardNo

 

Expand/Collapse item AR_TransactionPosting

EncrypstedCreditCardNo

 

Expand/Collapse item CU_Options

LogCRMCreation

LogARCreation

LogNoteCreation

LogSynchronization

CRMSQLServer

CRMSQLDatabase

CRMSQLUsername

CRMSQLPassword

CRMSQLIntegratedSecurity

CRMWebPortalAddress

CRMVirtualDirectoryPath

DataVersion

DataSublevel

 

Expand/Collapse item CU_OptionsWrk

ModuleCode

IntegrationEngineServer

IntegrationEnginePort

MAS_UserLogon

CRMWebPortalAddress

CRMVirtualDirectoryPath

CRMSQLServer

CRMSQLDatabase

CRMSQLIntegratedSecurity

CRMSQLUsername

MAS_AllowCustChange

MAS_AllowBillChange

MAS_AllowContactChange

MAS_AllowAddChange

MAS_AllowShipChange

LogCRMCreation

LogARCreation

LogNoteCreation

LogSynchronization

 

Expand/Collapse item IT_Options

TestNo

 

Expand/Collapse item IT_ShoppingCartHeader

EncryptedCreditCardNo

CreditCardCVV2No

AVSAddress

 

Expand/Collapse item SO_BatchAuthorizationWrk

UnencryptedCreditCardNo

 

Expand/Collapse item SO_InvoiceHeader

CorporateCustIDPurchOrder

CorporateTaxOverrd

DepositCorporateTaxOverrd

CardholderName

ExpirationDateYear

ExpirationDateMonth

EncryptedCreditCardNo

CreditCardCVV2No

Last4UnencryptedCreditCardNos

CreditCardAuthorizationNo

AuthorizationCodeForDeposit

AuthorizationDate

AuthorizationTime

PostAuthorizationProcessed

CorporateSalesTax

CreditCardTransactionID

CreditCardTransactionIDForDep

CreditCardComment

PayBalanceByCreditCard

AVSAddress

AVSCity

AVSState

AVSZipCode

CreditCardPreAuthorizationAmt

CreditCardPaymentBalanceAmt

DepositCorporateSalesTax

 

Expand/Collapse item SO_Options

TestNo

 

Expand/Collapse item SO_SalesOrderHeader

CorporateCustIDPurchOrder

CorporateTaxOverrd

DepositCorporateTaxOverrd

CardholderName

ExpirationDateYear

ExpirationDateMonth

EncryptedCreditCardNo

CreditCardCVV2No

Last4UnencryptedCreditCardNos

CreditCardAuthorizationNo

CreditCardTransactionID

AuthorizationDate

AuthorizationTime

AuthorizationCodeForDeposit

CreditCardTransactionIDForDep

PayBalanceByCreditCard

AVSAddress

AVSCity

AVSState

AVSZipCode

CreditCardComment

AuthorizationRequiredFlag

CreditCardPreAuthorizationAmt

CreditCardPaymentBalanceAmt

DepositCorporateSalesTax

CorporateSalesTax

 

Expand/Collapse item SO_SalesOrderHistoryHeader

CorporateCustIDPurchOrder

CorporateTaxOverrd

DepositCorporateTaxOverrd

CardholderName

ExpirationDateYear

ExpirationDateMonth

EncryptedCreditCardNo

Last4UnencryptedCreditCardNos

CreditCardAuthorizationNo

CreditCardTransactionID

AuthorizationDate

AuthorizationTime

AuthorizationCodeForDeposit

CreditCardTransactionIDForDep

PayBalanceByCreditCard

CreditCardPreAuthorizationAmt

CreditCardPaymentBalanceAmt

DepositCorporateSalesTax

CorporateSalesTax

 

Expand/Collapse item SY_Company

CreditCardServerIPAddr

CreditCardServerPortNo

CreditCardServerPath

CreditCardServerRequireRecon

CreditCardDefaultSettings

CreditCardKey

 

Expand/Collapse item SY_CompanyListingWrk

CreditCardDefaultSettings

CreditCardServerIPAddr

CreditCardServerPortNo

CreditCardServerPath

CreditCardServerRequireRecon

 

Expand/Collapse item SY_User

DisplayFormattedCreditCard

PrintFormattedCreditCard

DisplayFormattedCreditCard

PrintFormattedCreditCard

 

Troubleshooting

 

Expand or collapse item The "This report must be converted to the latest version of SAP Crystal Reports" message appears when I try to print or preview a customized report or form. How do I prevent the Crystal Report Conversion Wizard from appearing?

 

  1. Open the report or form in Crystal Designer.

  2. Select File menu > Summary Info. The Document Properties window appears.

  3. In the Document Properties window, in the Keywords field, type the following:
    Converted to version XXX (where XXX is the current Sage 100 Standard version number).
    For example, if you are using version 4.50, type the following: Converted to version 2013

 

Expand or collapse item The "Crystal print error: Error in File XXX: reports: ###-###: XXXXXXX.rpt! Failed to open a rowset" message appears when I try to print a form or report. How can I print this form or report?

 

  1. Open the form or report in SAP Crystal Reports.

  2. Select Database menu > Show SQL Query.

  3. Sign in to the database, and then click the Reset button.

  4. Select File menu > Save As to save the form or report.

This error message may appear if you upgraded from a prior version of Sage 100, and only for the following reports:

 

          Accounts Payable

  • Custom Reports

  • Accounts Payable Aged Invoice Report

  • Accounts Payable Trial Balance

  • Checks

  •  

    Mobility for Bar Code

  • Custom Reports

  • P/O Receiver Printing

  • B/M Picking Sheet

  •  

    Bill of Materials

  • Custom Reports

  • Single-Level Bill of Materials Report

  • Picking Sheet Printing

  •  

    Inventory Management

  • Custom Reports

  • Inventory Reorder Report

  • Inventory Valuation Report

  • Inventory Label Printing

  •  

    Purchase Order

  • Custom Reports

  • Purchase History Report

  • Open PO by Item Report

  • Open Purchase Order Report

  • Purchase Order Entry

  • Return Order Printing

  •  

    Payroll

  • Check Printing

  • Direct Deposit Stub Printing

  •  

    Work Order

  • Work Order Traveler Printing