• Importing purchase requistion details from an external csv file into the grid field

    Newbie here. I am entering items details manually into the different fields of a purchase requisition. I have a csv file with data from an MSC shopping cart. How do I transfer this data into the Purchase requisition grid without copy and pasting field…
  • Adding quantity from invoice lines to project lines view/explorer screen.

    We are starting to you use Project accounting, and find the explorer window great. However, the quantity invoiced in the vdvproject lines view, seems to be inaccurate. Infact, we would like to quantity from invoices lines view. I have tried a couple joins…
  • AP Voucher Entry - Shortcut to go Back in to Grid?

    When I'm in the AP enter vouchers window, if I'm on the Totals tab, is there a keyboard shortcut to enter back into the grid on the Details tab? I know that I can do Alt + D to go back to the tab, but I'm hoping to find a way to enter back into the grid…
  • Duplicate account numbers in consolidated report (Accounts S500 1-0)

    Changed a report to pick up 3 of our companies (A,P and C) (Created consolidated connector then exported and imported the report using the consolidated connection) The accounts union report (Accounts S500) is one of the many that are included in it…
  • Auto-Signature maintenance

    How do I adjust the rules for accounts payable check auto-signatures?
  • Adding new Document Type for Doc Transmittal

    Hello, Using customizer, we are able to add a new document type for document transmittal into the 'other contacts' window (from maintain customers). We have created a custom table to store the value and can join back to tcicontact through the cntctkey…
  • Blank stock AP check printing and signature, Sage 500?

    Is there a way to print blank stock checks in Sage 500? My AP person doesn't want to use pre-printed checks. Also, how do I add a signature to the AP check print form, Sage 500? I'm so used to having source code, I was a former developer, so I'm having…
  • Invalid characters in Item and SO ids

    We are running into issues where a user copies a part ID from an excel sheet only to get a space at the end of the item ID or SO tranno. Sage support didn't have a good suggestion to keep this from happening. Has anyone else run into this? If so what…
  • Explanation of differences between MaterReqPer and MatReqPc?

    FormerMember
    FormerMember
    We use Sage and write software that integrates our book information system with Sage for inventory and finance functionality. The information in Sage about Mat Req Pc is clear, but I can't seem to find information about MaterReqPer and how it relates…
  • How to add What's This? help to a custom field?

    I am missing the link (secret handshake) somewhere and would appreciate someone pointing me to the right direction. My goal is to enable What's This? right-click context-sensitive help for a new screen that I am building with the Sage 500 framework…
  • Maintain Items custom fields disappearing

    Today as well as last Friday, my company reported all our custom-designed and added fields on the Maintain Items screen disappeared. On Friday, I readded them based on a snapshot from a previous DB version... this morning, they were all gone again. …
  • How to disable toolbar button and load another item on item maintenance form

    I have a customization project to create a customized item copy function on Inventory Item Maintenance form. A custom command button is added to the form. When user clicks the button, it fires stored procedure I created to copy the current item with a…
  • Is there a way to access the db connection(for temp tables) that Sage uses in vbscript?

    On the customization of the SO form, can we access the db connection that Sage is on for updating the temp tables, which otherwise are not accessible from another connection.
  • Looking for way to restrict labor progress entry to certain users.

    I'm looking for a method to restrict labor progress entries to certain users, user groups, ect... Possibly a vb script through customizer?
  • Cannot change script language from VBScript to JScript

    I would like to change the scripting language in an event in a Form Script Editor, when when I change the Language pulldown menu from VBScript to JScript, I get an error dialog with the text Script language changed. Modify existing script's syntax to…
  • Looking for Form_Save Event documentation

    I am trying to find documentation on what is in the oDM parameter ("data manager object") in the Form_Save subroutine in the Save Event, specifically in the Enter Receipt of Goods Form (PO Module). Can someone post info on what what I have available to…
  • Error calling DLL code from VBScript

    Back again with a specific bug... I have customized the Save Event in the frmBatch object in the Process Receipt of Good form: Sub Form_Save(oDM, bSave) Dim objApp, result Set objApp = CreateObject("LMNO.PrintNewLabel.FormSave") result = objApp.PrintBatchLabels…
  • AR Commission Report by Line Item

    Our AR department is asking IT for a way to calculate commissions by line item from the invoice. We cannot find a way to customize a report that pulls both Sales History and Invoice History. Is there anyone out there that has accomplished this or is it…
  • Change default PDF Attachment on Customer Statement

    Is there a way to change the default naming convention on the PDF attachments when performing document transmittals in the AR module? MAS500 by default uses the customer number. We would like to use the customer's name so that the email looks more business…
  • Enter Sales Orders and Quotes / Customizer

    Hello! A textbox has been added to Maintain Customer so that we can add custom notes. We would like to have these notes displayed in the Enter SO and QO task when the customer is selected. I added a textbox and did a databind on custkey between my…
  • How to implement Dashboards

    I'm new and would like to implement so i can learn, business insights dashboards. sage 500 7.40.8.0