x Want to participate? Join the group to interact

  • Connect multiple UDFs so selecting one will display extra info to be used in Crystal Reports

    I added a tab to my Invoice Data Entry panel with UDFs I want to be able to select an option in "SCAC Code" which will then display the proper name of the carrier outside of the SCAC Code dropdown. I want the SCAC Code and CARRIER NAME to be separate…

  • Generate PDF from UDF and create save/email functions from Sales Order/Invoice Data Entry custom tab

    Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…

  • Script or import to take AP Invoices off of hold

    I have a customer who wants to take AP invoices off of hold based on the condition that the AR invoices that go to that invoice have been paid. I ran into an issue with VI importing where I can't get it to let me take an invoice off of hold (This is for…

  • Business Insights explorer

    Is there a way to tell what tables the different views are using?

  • Jet Reports and SAGE ERP 2013

    Howdy, have a customer that has created a new balance sheet for entire year using jet reports. The issue is performance. The report is complex with adding debits and credits for each balance sheet account, for each period of the year. The report takes…

  • Update Purchase Order line UDF during receipt of goods entry

    I am trying to update a UDF in Purchase Order entry lines during a receipt of goods. The issue I am having is that the purchase order record is locked while a receipt of goods / invoice records exist referencing the purchase order. Here is the code I…

  • SAGE ERP 100 2013 64-bit ODBC errors on SQL server 2008 64-bit

    Howdy, I am trying to create a linked server on a SQL 2008 64-bit server. Using the SAGE ERP 100 64-bit ODBC. I want to link some of my MAS tables with SAGE CRM. The Linked server is setup to not use a security context. The query reads like…

  • How to write User Defined Script to calculate Discount?

    I need to let the system to calculate a discount based on Sales Order Header - 4. Totals -Order Total. The formula will be 5% * Order Total . I need to create a UDF, UDF_DISCOUNT, under Sales Order Header - 4. Totals Tab to show this amount. I don…

  • RE: How to Add UDF to PO Detail Table from PO Header Table

    Thank you very much. It works. However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table. Also, what are all abbreviation of different type of tables, such as header table, wrk…

  • Crystal Reports for Sage 100 2013 does not print the MICR font

    I just upgraded a client from 4.3 to 2013 and their AP Checks print correctly with the MICR font in 4.3, but the MICR font does not print in 2013. I checked the form to make sure the MICR font is selected (even tried the MICR Std font) and it won't print…

*Community Hub is the new name for Sage City