x Want to participate? Join the group to interact

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

  • VI job to import cash receipts

    I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience. I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…

  • Calculate Running Total per Invoice in a VI Job

    My client imports SO Invoices, and would like to calculate the quantity of one line based on the running total of the other lines, and then assign that quantity to the item line. Here's the scenario: 1. Accumulate the quantity of all the items that…

  • increment and create new sales order number vi import

    I have a file with Amazon orders, TSV, that can have multiple orders and multiple line items per order. Since the Amazon order number is 20 characters and Sage only allows up to 7 characters for its order number, I need to create my own order number and…

*Community Hub is the new name for Sage City