Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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 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…
Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
Hi all,
I'm new to Sage 100 and trying to become more efficient at my job. I learned recently that it is possible to import a bank statement onto Sage 100 and automatically create invoice entries for them. After doing some preliminary research, there…
Hi,
I am pretty new to Sage 100 and I am still getting up to speed. We had a server crash at the office. I was able to reload Sage 100 and restore from backup. My problem now is getting into the archives for previous years that I do not have backups…
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”
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.
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…
Hello!
I am building a php eCommerce system for a client, and they would like to have inventory and product data synced from Sage 100 ERP 2016 to the eCommerce store.
They were previously using MAS90 when we had first looked into it, but between that…
Once every 1-2 weeks or so I have to get in after hours to rebuild sort files, in our old business system a similar process was scheduled to run each night. Does anyone out there have a script or other method that would allow for scheduling a rebuild…
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…
When importing a new Sales Order the Primary Ship To Code is assigned to the new order even though a different address is imported and Ship To code is not even used in the import. I don't want the Primary Ship To code to be assigned to an order that is…