Browse By Tags

  • Visual Integrator; Importing into SO_InvoiceHeader and Leaves Back Order

    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…
  • Sales Order Import

    I can import new Sales Orders however is it possible to leverage the import function to update existing sales orders? If so, where can I find information on how to accomplish? Any insight would be greatly appreciated!
  • Uploading an excel spreadsheet/csv of multiple sales orders

    Hello all, Our company is currently running Sage X3 and we are looking to build a small B2B WooCommerce website for about 30 products for our customers to purchase through. Woocommerce, with the help of some plug ins, can generate spreadsheets/csv's in…
  • Import of Sales Order with new ship-to address

    I am attempting to import sales orders where the ship-to address is not already defined in the customer record. I added the following fields to the standard SOH import template: BPDADDLIG, ADDLIN2, BPDCTY, BPDSAT, BPDPOSCOD, BPDCRY. I expected that the…
  • importing salesorder error

    FormerMember
    FormerMember
    Hi, I have been trying to import new or exisiting sales order into SalesOrderHeader. However, when importing. i get these errors. it seems creating the new SO was fine. the only problem right now is the LotSerialNo.
  • Visual Integrator Sales Invoice Import

    We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…
  • Export sales order out of sage 50 US Edition?

    How do i export sales /purchase order out of sage 50 US edition? I have done this with sage 100 using visual integrator and i am in need to do that with sage 50.
  • VI Importing Sales order with CSV file

    we use visual integrator to import sales orders. I have a customer that sends us a csv file and on that file we have header and detail information on each line. so i would see something like: PO#, Vendor#, Shipto, item#, model#, sku#, ship date, qty…
  • Importing Sales Order With Existing Pre-Auth

    Has anyone had experience importing data into Sales Order Entry for a credit card order that has already been pre-authorized outside of Sage 100 ERP? In particular, we're working with Sage 100 ERP Advanced 2013 PU3 and an online store that uses a third…