home

ACS

RealmMinistryPlatformPDSACSAccountingGivingConnectShepherdGrowth MethodGo MethodMissionInsiteGatherHeadMaster ChildcareTrust CenterData Governance and Business DocsACST Content Standards
RealmMinistryPlatformPDSACSAccountingGivingConnectShepherdGrowth MethodGo MethodMissionInsiteGatherHeadMaster ChildcareTrust CenterData Governance and Business DocsACST Content Standards

What would you like to know more about?

Show Contents

thumbnailACS

Account Receivable Troubleshooting

Null Variant Conversion Editing Customer Records

This troubleshooting guide addresses the error "Could not convert variant of type Null into type Olestr or String" that occurs when editing customer records in Accounts Receivable. The error is related to mismatches in EmailID, phone numbers, and addresses between various tables. The guide provides a step-by-step solution to identify and rectify these mismatches.

When editing a customer record in Accounts Receivable, this error displays:

Could not convert variant of type Null into type String.

  • Products affected: Accounts Receivable

  • Versions Affected: Any

This error involves the EmailID, but also occurs with phone numbers (awglphone) and addresses (awgladdress). It happens when the values in the tables do not match those in awarfamilyemail, awarfamilyphone, and awarfamilyaddress.

  1. Go to Add/Edit Customers and get Customer Code.
  2. Go to awarcust.
  3. Filter by code column and get the following values:
    • Primary Family ID
    • Street Address ID
    • Primary Phone ID
    • Primary Email ID (normally the cause)
  4. Go to awarfamilyaddress, and look for Family ID, then get All Address ID.
  5. Go to awgladdress and look for address ids.
    If they are not there, delete from awarfamilyaddress
  6. Go to Awarfamilyphone, and look for Family ID.Get the following values:
    • emailID
    • Go to awglemaillook for phone id
    If they are not there delete them from awarfamilyphone.
  7. Go to Awarfamilyemail, and look for Family ID. Then get
    the emailid.
  8. Then go to awglemail look for email id.
    If it is not there delete from awarfamilyemail.
    Warning: Never delete anything from awgl* tables.
Troubleshooting
ACS
Financial Suite

Last updated: March 3, 2026