Hello fellow Sagers!
Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
Need help with new custom field formula. I create custom field "Net Available Stock"
I have added the custom field to below screens, functions. now I need the field to work accordingly. I create a custom script for net availability and still having…
From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card.
First I actually…
I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker.
Essentially, instead of the user typing the invoice # they would type the sales order…
We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…
I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…
When trying to generate the positive pay file - we experience the following error - file return error - no checks selected. There are checks generated and printed.
Is there a way to select the field and sort direction (ascending/descending) for a list box such as Invoice History or Item Transactions?
If a script is needed, what method/property should be used?
How does Sage determine the default field and sort…
I'm writing a script to expose or hide selected controls based on user. I would like the script to be operational ONLY in Maintenance mode, not Inquiry. In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?
I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium
…
Hello,
I am in the process of building a "Change Tracking" system for Sales orders which tracks any changes to a specified list of fields. To do this, on a Table Pre-Write script I simply gather the information from the So History record and compare…
Is it possible to automatically email our customers when their invoices become past-due? We are trying reign in our A/R and at 45 days after the invoice is issued, it would be awesome to have our system auto-send a notification/reminder to the debtor…
Hi all, i have a problem with this function:
Funprog SUM_TOTAL(PROJECT,BUDGET) Value Char PROJECT Value Char BUDGET Local Decimal TOTAL If !clalev([F:PJBU]) Local File PJMBUD [PJBU] : Endif If !clalev([F:PJLB]) Local File PJMBUDLIG [PJLB] : Endif If…
Hi
I have a customized report ZSORDERS
I have a script that renames the pdf generated by report (SO#) and saves it in destination.But I need to modify the script so that when the user opens the report in preview the report is renames and the user…
KB article 19387 "How to create a short-cut or Windows batch file to run Visual Integrator import job, export job, or other Sage 100 ERP task outside the program," implies this can be done but the examples given are for VI jobs only, where the "APP Name…
I located KB 19387 which describes how to create a batch file to run a VI import program. The routine requires the name of the the VI job which is readily available on the job listing and panel.
I'm thinking I could use the same/similar batch file format…
Hello everyone,
I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…
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…
I'm trying to add an MS Script button to the SO Invoice Data Entry panel. In the script I need to access the LOCAL cCurrentPaymentTypeMethod$ property inherited from Class SO_CommonEntry_UI. Can this be done and, if so, how would it be coded?
