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…
We are looking to edit the way our format for the schedule of values outputs & prints, is there a way to edit this? Or is this a default that is unable to change? The same goes for our estimate template.
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…
As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all!
I am working with the Open Sales Order Report now and stuck on suppressing some items in the report.
The end goal…
Hey everyone,
We do have many dashboards with different reports telling us what to do next, which are missed deadlines and what my daily performance is.
Now I'm wondering if there is a way to change the background color of a field or line based on…
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…
Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…
Hi,
I would like to create more representations using Views/Tables. Requestors are very quick to create in X3V12 using Views/Tables, but very limited functionality specially on Landing Pages. The goal is to give user far more interactive dashboards…
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…
Hello!
I am trying to find a way to automatically export sales order data (specifically ship date) from business insights sales order view into a locked excel document provided by my customer.
It would be nice if i could filter a whole list of orders…
I have 2 different reports one is a Statement of Financial Position while the other is an Income statement, how can I get calculated fields value from my Income Statement Into my Statement of Financial Position noting that the IS has it's Data Model just…
Created a custom crystal report for client with Date from and Date to and customer number as parameters in order for sending all invoices to a particular customer for a specific month or range of dates.
The custom crystal report on the sage server…
I have modified the original invoice footer with 2 format options by parameter field on Bill Type for user to select the format when printing. Example Footer A for Standing Billing Footer B for Tenant Billing Below is the formula from the existing sage…
Trying to figure out how to invoice clients who have flat rate task and hourly task on one bill
Example file application- flat $1400 report application as filed $18/ hrly
can I invoice a flat rate task and an hourly task?
Can I invoice a flat rate…
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
…
I need to add our clients number (Nickname 2) to the WIP reports, anyone have experience with this? I have had no luck creating from scratch and was hoping to use our current WIP report and add the field (but the option doesn't show)
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…
I've created a number of reports intended for Facility Managers to access through a link I made on their Landing Page. What I would like to do is pass their default facility through to the report to restrict the data they can retrieve to just that which…
I need to make a minor change to the L-PB Detail with Stored contract invoice format. The CNAME in TS Billing Field Names is giving our group name instead of the Company name. We have 5 companies and I need it to give the correct Company name based on…
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 wondered if I could tap in to sage city for some advice, as I am frustrated with support.na.sage
The whole reason I am here, is that when I search the support site, I get to a issue, on the topic I want to learn about, and the article has a an…