• What module would be best for new services?

    We currently use all the core modules (GL, AP, AR, BR, PR, IM, PO,  plus Job Cost and Time Card. I am looking for something, for example - we may have 1-3 jobs at a time (up to 90 days each), each job will have 2-3 work tickets, and each work ticket generates…

  • How to get business object names for table from Sage 100 BOI

    Is there a way to get a list of all the business object names for a table from the Sage 100 BOI? The SY_File object from the FileObj property on the session object seems to have methods to get a list of all the table names. Looking to expand on that where…

  • Crystal Reports: Adding a UDF for each Item Number on a Picking Ticket.

    OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing.

    I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket…

  • VI Export Job: Issue Linking Tables

    I am needing to run an Open Balance Export job that contains specific headers that are located on different tables. The primary table I'm using is the `AR_OpenInvoice`, to which I am attempting to link to the `AR_InvoiceHistoryHeader` table. The problem…
  • Is the a way to summarize the invoice totals to a customer or suppress the detail from the view?

    I am a new controller to the company, and I have very little experience with Sage 100. We need a solution to send a customer one invoice (containing multiple jobs), and only show a summary as if it were one job.

    Our business is in manufacturing, and management…

  • misc items

    Miscellaneous Codes:

    can a service item be entered into "inventory" since there is nothing to physically count so we can assign a vendor and costing. And just make it a drop ship only item.

    Thanks

  • Serialized device floating in limbo.

    I was in the middle of Transferring two Serialized Devices from one Warehouse to another. While in the middle of this sage crashed. Now when I go back in the devices still say they are in the same warehouse but they are not available. How do I fix this…

  • Sage v2022 Production Management

    feeling brave (or foolish?), I installed v2022 on client with the WO module.  Prior to installing, I looked up the registration keys for this client so had the most recent.  The module listing on the portal indicated that production management with three…

  • Period End - multiple years need to be closed

    I have a situation where Period End Processing has NOT been done in over 10 years. I am trying to get things cleaned up. Is there a way to close multiple years without having to close out each module for each period for over 10 years? That would be 120…

  • Looping a table while batches enabled

    Hi,

    I want to loop through all my not-registered invoices.

    What I do (in general) is:

    dynamic obj = pvx.NewObject("AP_ManualCheck_bus", oSession);
    
    obj.nMoveFirst();   //To get to the first record 
    
    //Rest of code

    The problem is that I have…

  • WIP was turned off and it affected our GL postings. Is there a way to fix these without looking at each S/O Journal?

    Currently we use payroll for expensing the labor expense on our setup.  There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O.  When WIP got turned off the offsetting transaction for the…

  • Access PO_ReceiptReturnMatRqByPO

    How can I access the table object PO_ReceiptReturnMatRqByPO? I need to delete a record from this table which refers to a ghost receipt and locks my PO.

    There isn't a file with _bus or _svc, so using NewObject returns "NewObject Error 90".…

  • Upgraded to Sage 100 2021 No Paperless Button in Customer Maintenance screen

    Upgraded to Sage 100 2021, I am not seeing paperless options in my Customer Maintenance screen, is there a new right I need to activate to get that back??

  • Sage 100: Announcing Sage 100 2021.0-2021.3 Program Fix LM7010T

    The fix addresses an issue where Bank Feeds checks are not matching Sage 100 checks when downloading Bank Feeds transactions in Bank Reconciliation, Check, Deposit and Adjustment Entry.

    Download Sage 100 2021.0-2021.3 Program Fix LM7010T

  • VI Cash Receipt with only Invoice #

    Client is running Sage 100 v2018 and have asked for a VI import of cash receipts.  They scan in information and save it as a csv.  However, the information does not include Customer Number...only Invoice Number.  Within the Sage 100 Company where the data…

  • I am getting an error message while trying to import AR_InvoiceHistoryDetail records into Sage 100 2021 from Sage 100 2018. Error #112 Keyed File Error (Record Key Size Invalid)

    I am getting an error message while trying to import AR_InvoiceHistoryDetail records into Sage 100 2021 from Sage 100 2018. Error #112 Keyed File Error (Record Key Size Invalid), I got an error during month end close about an open invoice in the system…

  • Script message won't display

    Can't determine what the problem is for the script message not displaying in SO Entry.   Here is my script.  Client is Premium version 2021

    ' -------------------------SCRIPT START ------------------------------------
    If oSession.CompanyCode <> "ZZZ…

  • Delete or reverse a JE

    I am new to Sage and need to delete a couple JE's that were in the previous (March) period-I have figured out how to reopen the period- however only 1 or 2 have deleted-the others tell me that they can't be deleted until all information is removed from…

  • Looking for a Microsoft Power App expert

    Looking for a Microsoft Power App expert who can develop a power app application that will fetch data from the SQL database in bulk and then send that data to Sage 100 ERP via Sage 100 API connector which is already installed. Data to be picked and sent…

  • Azure migration from MSP hosted 2019 VM

    Currently we have an MSP host a Server2019 VM where anywhere from 15-20 people log in to access Sage 100. I am looking to migrate it over to an Azure Instance. Are there any recommended instance types or configuration resources I can read into?

    Thanks…

  • How can I verify where items are committed? Sales Orders/Backorders/Etc.

    My company manufactures products that we categorize by Lot #. As an example, I have an item with Lot # ABCD that we delivered into Sage 4,143 bottles. Of that Lot #, I can confirm that 3,628 have been invoiced and sold, leaving 515 left, which is exactly…

  • Item Valuation Change Selection: Phantom Connected Users

    We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog:

    When I click More…

  • SAGE Formula

    I have a formula in my SO picking sheet it puts different words on the header depending on the number of days between the order date and the ship expire date.

    I want to edit this formula that the < 4 is actually 0 to 3 Business days.  before the wording…

  • Crystal Reports QuantityDecimal formula for 2 decimal places

    What formula would be used in QuantityDecimal to set the number of decimals to 2?  We need 4 decimals for qty for BOMS only, so would like all forms to only display 2 decimals.

    Thanks.

  • How do I enter account Partner_Account Number on Sage University as the website does not have an option to update it?

    Hi All,

    I have placed an order for a course on Sage university but the system is not allowing me make the payment. Hence, we reached sales customer service via email and they reset the same and asked us to try and purchase the course again to redirect…