x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 4 replies
  • Subscribers 108 subscribers
  • Views 143 views
  • Users 0 members are here
Browse Forums
Announcements
293
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
3k
replies
Partner Cloud
45
topics
91
replies
Payroll, Time Tracking, and Job Cost
777
topics
1k
replies
Reporting and Analytics
962
topics
3k
replies
Sage CRM for Sage 100
164
topics
357
replies
Technical and Installation
2k
topics
9k
replies
Year-end Forum
89
topics
237
replies
T. Smith

Multi-Line Invoice Import through Visual Integrator

Posted By

While importing a job through VI for AP Invoices - if there are multiple lines on the same invoice, the job will not work correctly. Is there an easy fix to this.  The invoice will either not show up in Invoice Data Entry or Sage will need to be prompted to "remember" there was a VI job and the invoice lines will have doubled.  This is only happening on invoices that has numerous lines on the lines tab. 

Parents
  • 0

    Steps to get to Visual Integrator (VI) and create a import job

    1. Open Modules, Visual Integrator, Mainmenu, Import Job Maintenance
    2. Enter the name of the job in Job Name field
    3. Select the table AP_InvoiceHeader in the Table Name field
    4. Click Accept
    5. Click Yes to confirm this is a new job
    6. Select the Data tab
    7. The import should contain the following fields on the Data tab in this exact order:
      1. H.BatchNo (only required if Batch Entry is enabled in Accounts Payable Options
      2. H.APDivisionNo
      3. H.VendorNo
      4. H.InvoiceNo
      5. H.Comment
      6. H.InvoiceDate
      7. H.InvoiceDueDate
      8. L.AccountKey
      9. L.DistributionAmt
      10. L.CommentText
    8. Click Accept and click Yes to execute the job
    9. Click the Browse button to browse to the sourcefile to be used for the import job
    10. Click Accept to run the import job and click Yes to confirm it is importing into the correct company
Reply
  • 0

    Steps to get to Visual Integrator (VI) and create a import job

    1. Open Modules, Visual Integrator, Mainmenu, Import Job Maintenance
    2. Enter the name of the job in Job Name field
    3. Select the table AP_InvoiceHeader in the Table Name field
    4. Click Accept
    5. Click Yes to confirm this is a new job
    6. Select the Data tab
    7. The import should contain the following fields on the Data tab in this exact order:
      1. H.BatchNo (only required if Batch Entry is enabled in Accounts Payable Options
      2. H.APDivisionNo
      3. H.VendorNo
      4. H.InvoiceNo
      5. H.Comment
      6. H.InvoiceDate
      7. H.InvoiceDueDate
      8. L.AccountKey
      9. L.DistributionAmt
      10. L.CommentText
    8. Click Accept and click Yes to execute the job
    9. Click the Browse button to browse to the sourcefile to be used for the import job
    10. Click Accept to run the import job and click Yes to confirm it is importing into the correct company
Children
No Data

*Community Hub is the new name for Sage City