Browse By Tags

  • Imported a GL acct number with dashes

    I am having a tough time importing GL account number for an asset update. My account numbers are 620-01-01 for example and no matter what I do to the import file, it imports them as 01/01/0620. Here's what I've tried: 1. In .csv formatted column to…
  • Stock Allocation Via Import

    Is it possible to allocate stock to a sales order line via import/webservice ?
  • Delete VI AP Invoice Batch

    I use VI to import invoices and have now run a duplicate batch but realized it is a duplicate before completing the process. The A/P Invoice Data Entry Batch is "available" but has not yet been processed. How can I delete this batch without processing…
  • VI Cross Reference Customer Email to Customer Number

    I am trying to use VI to import Sales Orders from a e-Commerce platform but the only customer-unique field that the source file has is the customer's email address. I would like to use those emails as a cross-reference to assign the customer number to…
  • Import facture d'une commande de vente type facturation directe

    Bonjour, Nous vendons des produits en lignes. La facture est donc générée au moment du règlement sur un outil tiers. Cet outil envoie la commande de vente et la facture de vente. Le type de commande est à facturation directe. Problème, je n'arrive pas…
  • paramétrage en comptabilité suite à reprise d'un nouveau dossier au 01/01/2024 sur sage50

    Bonjour je récupère de mon expert mes dossiers comptables (3 sarl) que je vais décidé de gerer jusqu a la révision et je ne parviens pas, malgré mes recherches dans l'aide, à créer les 137 clients dont j'ai le grand livre avec les soldes AN au 01/01…
  • Import of miscellaneous receipts for inventory

    We are importing inventory receipts into a new warehouse. We are using the import template FTIMSR. It works fine. The issue we are having is dealing with errors and the subsequent creation of multiple misc receipt records in Sage X3. If we build a long…
  • Sales Ledger Import Error

    I am importing invoices using the template and I keep getting the error: The tax goods analysis total does not match transaction net value. What causes this issue?
  • BWGAccess

    How do I obtain BWGAccess? Does it come standard as part of the BusinessWorks kit or is it a separate paid for application?
  • Planning work order material import for BOM change

    What is the best way to update planning work order material based on the updated BOM? There is no standard import template for MFGMAT. Users requested that they have three old components that is in 189 open work orders that "builds" phantom part# to…
  • VI General Ledger Journal Entry Import - JournalComment Issues

    Hello Sage 100 Community, I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout: Account No. Debit Credit Posting Comment Journal Comment 6570-00 500.00 0.00 Test comment…
  • How to import and export data from Sage 50 using PowerShell?

    Hello, I need some help with importing and exporting data from Sage 50 using PowerShell. I received an email from a service consultant from Sage that contained a PowerShell script that runs an import or export state with a command line launch. The script…
  • Payroll / Equipment Tracking Systems and importing data

    We are coming up on our renewal date with ExakTime. It does an adequate job of tracking labor hours but we need a system that tracks equipment hours and is capable of importing them to Sage 100 Contractor. Does anyone have experience and recommendations…
  • Sage 50 CA Error with SDK "Customer Ofen pay late. see the advice topic Handling Overdue accounts" for suggestion

    hi all, I am getting this error while importing Orders. can anyone suggest how to resolve it?? Sage 50 CA Error with SDK "Customer Ofen pay late. see the advice topic Handling Overdue accounts" for suggestion Thanks, SF
  • EBWS/Sage Zip Code/Default Country Code Issue

    We have completed an upgrade from 2019 Advanced PU4 to 2023 Advanced PU2 but are having issue with bringing in CAN country zip codes. Ebusiness web services/Sage appears to be appending USA in front of all CAN orders as that was set by Sage as the default…
  • Microsoft Excel, or a 32 bit compatible version of Microsoft Excel is not installed

    Recently my workstation was upgraded from Windows 10 to Windows 11, shortly thereafter I started experiencing issues importing excel files into Ship Orders (Tairox). Whenever I try to import an excel file into ship orders I get the error "Microsoft Excel…
  • Import Error

    I am receiving an error message when clicking on any template in the task scheduler. Here is what happened. How it happened: Library Master > Task Scheduler > I ran IMPORTITEMS (worked great until I put all the imports into script). It has been…
  • AR Invoice History file size limits or performance hits

    Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…
  • How do you import items into a database?

    Hello everyone, I am trying to import items into a database. I have exported them into a CSV file within Sage Estimating, but I can not find out where you can import them. I was trying to merge 2 databases with the database editor, but they have different…
  • 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…
  • Import AP Invoice from own excel file failed

    Hi all. I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below. However, copy pasting the content to an exported excel file seems to works fine. The issue is: I am going…
  • G/L Journal Entry import from spreadsheet not working after Microsoft 365 version of Excel installed

    Our regular import of a payroll GL JE has failed with the error message: Description: External table is not in the expected format Source: 12:20:40 - 1071.80004005.503.914 The only identifiable change is upgrading from old Excel (version unknown…
  • VI Error, L record AddLine() Failed. Missing or invalid header.

    I am trying to import payroll as I do every pay period. But for some reason I keep getting this error today. My VI import job for payroll has not changed, and has worked for years...until today. Any direction where I could get some help to fix the issue…
  • Copying an Employee's Report Setting

    Hello, I have been asked to copy the Report Setting that a specific employee that is no longer with the company had created and to bring it to the main company's account. The reason for this being is that the company's account, for some reason, is printing…
  • VI Job for Inventory Adjustments

    Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…