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.
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…
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…
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…
Hello,
I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table.
When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…
I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items.
After researching in the Knowledge Base, I came across the following steps to clear out the issue:
Update all transactions…
Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging.
Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…
