• AR Invoice History file size limits or performance hits

    Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…
  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…
  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…
  • SO VI Import not importing Quantity or Price

    Hello, I've created a VI job to import Sales Orders. All fields work perfectly with the exception of the Quantity and Price. The import log shows both fields as blank, even though the amounts are in the selected columns. I also tried setting the amounts…
  • How to Chain VI Export Job to Import Job

    It looks like the Chain utility only allows chaining multiple Import jobs OR multiple Export jobs. Is there a way to chain an Import job to an Export job or vice versa?