So, so I have a custom report to display a list of costs, and each list displays the total cost per category and there is a navigate function using the on-demand subreport to display detailed costs per category. when I want to export the custom report…
Customer wants a report to be run from Sage which gives the following 5 columns . Currently they export users and they print user authorizations report and then mix and match data but since its a bank involved in Identity access management and they want…
When I started with Sage, I took several classes online - Data File Structures, Crystal Reports, etc. I can't find any resellers that offer these programs anymore and Sage seems to only offer X3 classes. Yes, I see the YouTube offerings but I am looking…
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…
If this is not possible what would the best way to accomplish this?
I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not.
Thanks
V
I am trying to add the "JobDesc" field to our AR Aged Invoice Report so that we can see what job name corresponds with the invoice on the report. I'm a beginner in Crystal Reports, but here is what I've tried:
In Crystal Reports designer, I created…
We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
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 would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report.
I need to create a summary report that includes data from both tables. I'm hoping that someone has…
In Business Insights Explore, is there a way for me to have the Data Field information and the Preview Field information on the same report? I've got all my fields the way I want them, but I don't want to just see the Invoice History, I want to see the…
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…
Hello, I'm curious to know if I can create user defined fields in Sales Order Entry and the same fields in Invoice Data Entry?
The fields are populated in the Sales Order Entry window, and then transfer to the invoice. The fields are in be added to…
Has anyone installed the F9 software version 4.5 with Sage 2019? We currently have 2016 and it works fine but we are about to upgrade and before we make a change I thought I would check.
I'm trying to create a custom crystal report that shows Employee Number, Full Name, Gross wages, Pre-Tax Deductions, Post-Tax Deductions, Gross wages (excluding Pre-Tax Deductions).
I believe I need to use UPEMPL, UPCHKH, and UPCHKD to get the Employee…
Can anyone tell me where I can find step by step directions on creating a custom check history payroll report? We have 3 departments and within the departments employee work within department numbers. I can print the payroll check history report and break…
We have a parameter in our Sales Order form that changes what is printed based on the parameter. I would like to have it print to a particular printer based on the parameter selected. Actually I want to print from a particular tray in printer based on…
We have a customer group that is wholesale. In the Matrix Pricing GUI - the group is set to:
Method - Discount Amt
Base - List Price
Amount - 0
The customers in this price group do not show up in the timCustItemPrice table at all.
We have…
Hello
We share same infrastructure with another company.
They got IT, not my company.
Their IT refuse me to use crystal report and access database for security. So we do Microsoft Word for all Invoices, Orders, etc. Like t min per Word to do all…
Hello, I am having some issues with making a script to change the output setting for paperless office inside of sales order printing. I have some code below that I found searching the forum. The way it is now I do not get an error message and nothing…
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…
Has anybody tried printing a crystal report via web services by creating a subprogram? If so, could you please send some examples so I can take a look at what was done to get this accomplished? If not, anybody got any ideas on the best approach for this…
We are looking to utilize AR Customer Memos as a way to convey what special requirements a customer regularly has when they order. Ideally we want this on Sales Orders and Packing Lists. The issue is that when linking to the AR Customer Memo table, it…
I recall reading articles years ago about BV and its reliance on Pervasive 10 which reached its end of life a few years ago, and crystal reports which i think is no longer a thing?
I recall there being a limitation with BV that all database access would…
I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are. So, if a formula is being used, is it used in another formula, report, etc. I have 100's of formulas & reports…
