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.
Hi,
I'm trying to find a way to remove the price overrides someone created for a single customer, which has over 3,000 price overrides. It's too much to delete manually. I'm wondering if there's an easy way to simply delete all of the price overrides…
Hello,
I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns.
What im trying to do is have the ShipExpireDate be 5 business days added to the order…
On Sage 100 Advanced 2018, 6.00.5.0. Most of my experience with VI has been rather basic, updating or adding customer accounts, but I also have written scripts to import to Repetitive Invoicing Entry and Cash Receipts. However that is using data that…
i have created a VI Job that I am trying to use to reverse a large amount of checks. Each check has one invoice. I do not want to recall original invoices but create a distribution amount to a GL acct.
When the job is ran it automatically recalls the…
Is there any way to populate the BM_ComponentReportSelection.M4T without manually keying it in the Gross Requirements Report? It is not an available table to import into for Bill of Materials.
We just updated our Sage 100 to the 2019 Advanced version. We also use Sage payroll and downloaded the latest version. In previous versions, there was an ODBC database file named PR1_EmployeeMaster. I don't see that file is available in the 2019 version…
I need to know if there is a script or perform logic that can help my situation.
- I have a VI Import Job importing Invoices from Sales Orders
- The source file does NOT contain the Misc or Charge items from the SO
Can this be done without the…
Under what circumstances does the AR_Customer SalespersonNo2...5 populate? I am trying to determine if we can use this field for tracking.
Thank you for your input!
We are in the process of trying to merge 2 separate product catalogs. I suggested starting off fresh and either staring with all new inventory items or just starting the "company" over. Deleting items that have a history creates a problem. We are planning…
I'm looking for a way to mass edit/delete memos in customer maintenance in accounts relievable. I'm trying to clean up and delete memo codes so it will be more organized to pull reports. I currently have to look up everyone's account and manually delete…
Hello,
We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#:
// Loop though AP invoices a batch
foreach (var invoice in batch.NonInventoryInvoices) { try {
service.Call("nCLEAR"); service…
When we import by Visual Integrator to update certain records it adding on another line instead of updating.
Needed to update price_columns on AR_PriceLevelByCustomerPriceCode, where expected it will update the 'pricelevel' by looking the combination…
For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…
Able to export and save the positive pay file to the Application Server or the Terminal Server, but unable to save the file to another location on the local network or tsclient. We can export other files and even the ACH file to a local network or tsclient…
The only option I have on the VI import to BR_Transaction EntryNo field is Incr Assign. It tells me Next is invalid for this column name. I'm attaching a pic of my VI import. I'm in Sage 100c 2018 Premium. What's happening is our imports are copying over…
Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?
