Skip to content
logo Knowledgebase

Import A/P Manual Checks Using Visual Integrator in Sage 100

Created on  | Last modified on 

Summary

This article explains how to import A/P manual checks using Visual Integrator in Sage 100. It covers setup steps for single and multiple invoice scenarios.

Description

Use these steps to import Accounts Payable manual checks through Visual Integrator in older versions of Sage 100.
These versions include the Change Next On option on the Records tab.

Cause

You can import A/P manual checks in two scenarios:
  • A check with one invoice and multiple G/L distributions
  • A check with multiple invoices and one G/L distribution

Resolution

Import a check with one invoice and multiple G/L distributions

Create the import job

  • Create an import into AP_ManualCheckHeader

Configure settings

  • Go to the Configuration tab
  • Leave Header Separate From Line Record cleared
  • Select it only if header and line data exist on separate rows

Define data fields

Include these fields in the Data tab:
  • H.BatchNo, if batch processing is enabled
  • H.BankCode
  • H.CheckNo
  • H.CheckType
  • H.CheckAmt
  • H.APDivisionNo
  • H.VendorNo
  • L.InvoiceNo
  • L.InvoiceAmt
  • LL.AccountKey
  • LL.DistributionAmt
  • Ensure all fields match for each check, except distribution fields
  • Add optional fields when you need to override defaults

NOTE:

Each row represents the same check, except for LL.AccountKey and LL.DistributionAmt.

 

Set record processing

  • Go to the Records tab
  • Define Change Next On since header and line records are together

Verify totals

  • Confirm the invoice amount equals total distribution amounts
  • Confirm the check amount equals the invoice amount

CAUTION:

Out-of-balance totals cause import errors.

 

Import a check with multiple invoices and one G/L distribution

Create the import job

  • Create an import into AP_ManualCheckHeader

Configure settings

  • Go to the Configuration tab
  • Leave Header Separate From Line Record cleared
  • Select it only if header and line data exist on separate rows

Define data fields

Include these fields in the Data tab:
  • H.BatchNo, if batch processing is enabled
  • H.BankCode
  • H.CheckNo
  • H.CheckType
  • H.CheckAmt
  • H.APDivisionNo
  • H.VendorNo
  • L.InvoiceNo
  • L.InvoiceAmt
  • LL.AccountKey
  • LL.DistributionAmt

Configure calculated field

  • Set H.CheckAmt properties:
    • Operation = Calculated
    • Calculation = {AP_ManualCheckHeader.CheckAmt}+NUM(IMP$[x])
  • Replace x with the invoice amount column

Prevent balance errors

  • Add L.LineKey with operation set to Incr Assign if errors occur

NOTE:

Use LL.AccountKey and LL.DistributionAmt when creating invoices during import.

 

Set record processing

  • Go to the Records tab
  • Do not include Change Next On

Verify totals

  • Confirm invoice totals match distribution totals
  • Confirm check total matches invoice totals

CAUTION:

Ensure all amounts balance before import to avoid failures.