Browse By Tags

Hello, I can't import products correctly in SAGE. It works if I only have the coloumns this way : Exporting and importing inventory and services data using CSV format (sage.com) withtout the cost or category or anything But if I do it this way…

using (DispatchObject poObject = new DispatchObject(pvx.InvokeMethod("NewObject", "PO_PurchaseOrder_bus", oSS.GetObject()))) Could any one of you suggest, which dll or nuget to be used for this dispatch object. We are using the below object management…

Dear, I trying to import sale/invoice to SAGE50, but I getting warning message each row, but all row still success import. The reference number "TP24-0304C" is available, but getting warning. The data CSV below: anyone know the problem?

Hello everyone, Are there any differences in importing data into Sage 50 Cloud vs Sage 50 Desktop? Such as General Ledger Journal Entries and Vendor Invoices. Any information or advice would be greatly appreciated. Thank you, all. Mike S.

Good day We have a customer that wants all data (including the attached supporting documents.) from Oracle migrated to Sage. We proposed Using Sage Import template but they insisted they prefer using a data migration tool( for efficiency and data integrity…

Hello, I have over 2100 items. In IC>Parts>Maintain Parts there is a section to turn "Picture On." Is there a way I can add all of the images of my items in a bulk upload of images? Instead of adding the images one-by-one over 2100 times? Thanks…

Hi All, can we import Qty Cancel at PO Receipt? Or any macro or tools for this?

Hi Sage 100 Community, I'm trying to help our warehouse cut some manual entry time with their UPS tracking numbers. There is currently a process in place with UPS Worldship that exports a CSV at EOD to our Sage server and then a series of VI Import…

We use a custom made application that stores our invoices. Is there a way to import these transactions? The files can be converted to CSV or Microsoft Excel. Is there an application that do the import? Are there templates available showing how to…

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…

Buenas tardes: Estoy utilizando el fichero SPNORMA43, para subir el fichero que me ha entregado el cliente. Banco español en euros. En el campo de cuenta bancaria del banco, ( del txt entregado por el cliente) me muestra la cuenta sin el digito verificador…

Hello everyone, I'm trying to import multiple files thanks to a reccuring task but the task gets stuck after the 1rst import. Here is the import part of the script I made for my task: Call LISFIC(YOS,YMACHINE,YDOSFIC,YNBRFIC,YLISTFIC) From SELFICREP…

Hello, I am importing invoices into Sage from a report, using the import/export function. This is a monthly activity and nothing has changed since the last time I did it. The invoices are all showing in Sage after the import with the correct totals…

Hi, I'm having an EDI PO import error that says zip code "33966" for Fort Myers FL is used in more than one country. I exported the SY_ZipCode table and found it listed for both US and USA. Would someone be willing to suggest a method for removal…

We recently had two customers combine and now have a new company name. I am trying to use visual integrator to update their ship-to address names (all of them - not just primary) and I cannot figure it out. Thank you in advance for any info.

Bonjour J'ai créer un fichier scv (exporter) pour mettre a jour mes prix. Mais a chaque fois que je charge le fichier un message d'erreur. Pourriez vous svp m'aider.

Hi, Before importing the AP invoice with PO, the Purchase Order # 100 was Received (qty ordered = qty received) and marked as "Waiting on Bill". Let's call this transaction A. I have then successfully imported the AP Invoice# 200 with PO #100 through…

Hi, I have successfully imported an AP invoice with Purchase Order. I have a Purchase Order that is already Received (all qty ordered have been received) and marked it as "Waiting on Bill". When importing the AP invoice (which includes the PO #) I would…

I'm currently running SAGE 100 version 7.10.5.0. I can run VI Import jobs no problem via a .bat file or through command line. However I'm looking to get some output back from running the job. Ranging from: Successful or unsuccessful login (right…

Shouldn't we have a forum for just this (Importing Data)? :) So.... everything was going along fine until I realized that the descriptions are not showing up in reports. Why? I find that if I open each transaction, save it, then go back to the report…

We recently purchased Sage software to manage inventory items. I have a few questions, 1) is a way to upload inventory items from an excel spreadsheet? If yes, could you please send me instructions? Or do we have an email for support? 2) If we are only…

I am trying to import a .txt file that seems to be correct, but all lines are rejecting with the reason "non printable character found (fld 1, col 1)." I have checked and double-checked my file, but cannot figure out why or what "non printable character…

Hi, I have tried to import PO Receipt Entry using Single CSV file format. The data import showing no error message. However, when I call out the receipt number, only header with data but line details showing blank. Choosing the Single CSV file for…

Normally I import into PO Receipt Entry using an ODBC connection to the tables. Recently I've run into a issue where the receipts will import but upon checking the receipt, the header populates but is missing the PO line details and Export SetID. This…

Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number. Manual entry allows to enter an invoice number followed by the check number. This automatically…