x Want to participate? Join the group to interact

  • 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 job for PO receipt of goods - T Record Invalid or Write Failed

    I've been working on a VI Import job for PO receipt of goods, serialized items. I think I am close, but I am running into this error: T Record Invalid or Write Failed. I've scoured the net, Sage City, Knowledgebase for a solution but no luck. Does anyone…

  • 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…

  • PPP Loan Forgiveness Application Data

    Sage 100 - P/R 2.20 After reviewing the Loan Forgiveness Application and Instructions, I am finding I need data which should be in P/R but am unable to locate. It appears all of the Reports are for quarter summaries and I need to access data from…

  • VI Job - Convert Date/Time to Order Date

    Hi, using Sage 100 Standard ERP 2014 I am writing a VI job to import a Customers Sales Orders, the source file is a CSV file, Loading into SO_SalesOrderHeader the field i am having trouble with is OrderDate The date on the CSV file comes across…

  • Invoice Inquiry History lookup during VI Job Invoice import?

    i have a VI job importing invoices using table SO_InvoiceHeader During import, it correctly "skips over existing records" if an invoice exists in "Invoice Data Entry". However, if i happen to have an invoice updated into the system and now resides…

*Community Hub is the new name for Sage City