• Use VI to Import So Invoices and create So Invoice batch

    I am looking to import sales orders either into sales order invoice and create an invoice batch or import into sales order shipping data entry. Of course it would be ideal if it would pull the lines in without having to give each line item its own line…
  • AR_CashReceiptsDetail table missing in VI Import Job Maintenance

    I'm working on an import job to enter cash receipts and don't have the AR_CashReceiptsDetail table in the table list. I see it when I'm in export job maintenance, just not import. What am I missing?
  • VI Import Job Expression Builder IF THEN ELSE Statement

    How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error. For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…
  • Append Date and Time to VI export using Perform function?

    Running SAGE 100 v2018 and exporting a file using VI that requires the current date and time be appended to the file. Is there a way to accomplish this using the Perform option within the VI Export job or do I need to create a separate batch process once…
  • VI job to change all customers for a sales person to email invoices - Paperless Delivery

    I am trying to figure out how to create a VI job to be able to change all of the customers for a sales person to email Sales Order & S/O invoices. I've tried exporting AR_CustomerDocuments and AR_CustomerDocumentsContacts, but neither of those seem to…