• VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…
  • Updating UDF in SO Line

    i am trying to update a UDF in line level using script on a button click Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…
  • Modifying Invoice History Lines screen using Custom Office

    Looking to show Quantity Ordered, Quantity Shipped, and Quantity Backordered in Invoice History Inquiry for SO invoices. Currently it just shows "Quantity" which is the quantity shipped. I opened the panel for SO Lines in Custom Office, and it's just…
  • AR Payment term due 15th or 30th of the following month

    I need some help wrapping my head around creating this AR Terms Code. This is what I need: Invoice dated 1st - 15th payable 15th following month Invoices 16th-31st payable 30th following month Thanks for any suggestion!
  • Questions on InvokeLookup

    Hello, I have create a UDF called Item code in Cash Receipt detail table and add it on the Grid. I want to create a Button script using the invokelookup which will fire off the item code list and can select the item code from the list, then set the…
  • AR Invoice History Inquiry

    When I have AR Invoice History Inquiry open is there a button to click to find out payment information, date inv paid, check number, amount, etc? Besides going to AR Customer Maint or Inquiry, finding the invoice and clicking on it that way.
  • Can a custom panel be created for the customer memo inquiry & maintenance screens?

    I am trying to add a custom panel onto the customer memo inquiry and maintenance screens so I can see both the create date and the auto display field (to quickly distinguish old notes from current notes). Currently in maintenance I only see the memo code…
  • Clearing a problem invoice in A/R

    I was trying to change a customer number, but when I went to Utilities and tried to use Delete/Change, I got the message that I was unable to proceed with unposted data in A/R Invoice Entry. When I looked at the A/R invoices, I was unable to select…