• SO_SalesOrderHistoryDetail has records with a null SalesOrderNo

    I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…
  • How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
  • VI Import Job Unable to open [wdx][odb]<dsn_name>

    I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…
  • General Journal Posting - duplicating

    Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    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…
  • Best option for extracting data out of Sage 100 into Third-Party software

    We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
  • How to automatically create Work Ticket in Production Management from Sales Order using BOI

    I have built an order importer that automatically creates sales orders based off of an EDI file from our customers. It works great. We are currently upgrading Sage 100 to include Production Management Plus and I want to be able to add in the ability to…
  • Sage 100 Premium 2020 SQL Server Transactional Replication for Reporting

    Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…
  • Sage 100 BOI Script to Create Inventory Transactions

    I'm writing a BOI script to create Inventory Adjustment Transactions. I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script. What I can't figure out is what the "refNo$" needs to be. Does anyone have…
  • Missing record to calculate taxes

    I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI. Has anybody faced this issue before? OR anyone has some idea how to solve this. Appreciated your help
  • Intermittent "[ProvideX][ODBC Driver]Internal error"

    I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…
  • Unable print _Manual check and payment register_databace connector error

    Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!
  • Open PO Qty vs On PO qty discrepancy

    Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…
  • Work order

    Where I can find the work order header & material details in C# language?( help-sage100.na.sage.com/.../index.htm In which table I can find those? Eg: For purchase order I fetch the details from PO_PurchaseOrder_bus. Where I can find the details of…
  • Sales Order Import Error

    HELP!!! 'm getting a runtime Error 440 < Error: 0 in Method ADDLINE> after the MsgBox "Add Lines" What's the issue? im Answer As String Dim MyNote As String 'Place your text here MyNote = "Import Orders into Sage?" 'Display MessageBox Answer…
  • Import into the BM_ComponentReportSelection.M4T!!!!

    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. https://solitaire.onl/ https://9apps.ooo/ https://bluestacks…
  • BOI SETVALUE/CLEAR Error Handling

    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…
  • Script to import lot/serial into so_invoicetierdistribution

    Does anyone have a vbscript sample for importing serial numbers into so invoicing? We currently have a script to import into so invoice but need to add serial numbers.
  • querying summarized bill of materials

    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…
  • Why am I getting this error trying to write credit cards into sales orders?

    I am following the example in Knowledgebase article 85796 regarding how to add cards to an existing order. I just want to capture the card information as a zero dollar deposit. SalesOrderNo = "W123456" PaymentType = "MC/V" ccNo = "4111111111111111…
  • Sy_ActivityLog not showing CompanyCode field.

    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…
  • What does Commit Check Clear Utility actually do?

    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…
  • Reverse Item Merge

    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…
  • Nightly backup failing

    FormerMember
    FormerMember
    The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.
  • Inventory Categories. Data Corruption? A mystery

    Sage 100 Version 5.20 Crystal 2011 for Sage Window server 2012 R2 Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…