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…
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…
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…
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…
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?
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…
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…
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…
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…
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
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
New to Sage CRM. A: Have excel sheets of donors with first and last name and email and many more fields but can hold off on that- what is the quickest way to import the data- can you provide an excel template for fields and code.
Cheers
Jen
Hello, I am running into an issue when importing vendors. We are mass importing items along with the vendors, but are running into a block on the vendor import.
It appears that this popup might be blocking the vendors from being imported. Is there…
I am trying to import ACH template that has leading zeros in the routing numbers that keep getting dropped off when I convert the excel to a csv. Additionally, very large numbers are condensing to scientific notation with the wrong values when in csv…
