Sage 100

I'm on Sage 100 Standard 2020 (v6.20.1.0). We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…

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…

The original statement we have is as follows - Temp001$=“458” I want to include "459". How should the formula look? Temp001$=“458, 459" or Temp001$=“458” or Temp001$=“459”

I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016. The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are…

Hi, Couldnt find anything in KB so thought i would post a question. was looking to create an import that would maintain the Standard Price in Item Maintenance. is there a way to create a VI Job to CI_ITEM? has anyone done this? wanted to just…

We are using a cloud based project management system. All employee time is entered into this system. However, Sage Timesheet (9.85) is used to feed our billing, which is currently done through MAS 200 (4.40). I can grab the time entries from the project…