We have set up an outside App that calls the Generic Print Report (GWSGPRTRPT). You pass the report name, language, destination, and an array of parameter names and values separated by "~". We have gotten this process to work, but only if the specific…
So my attorney charges her clients a retainer fee based on the type of case she is handling (so each client can have a completely difference retainer amount), and on top of that, she is billing AGAINST the retainer. We were generating bills in Word format…
Hi, I am creating a simple SQL Requester which will pull back data from 2 tables - PREQUIS and ACLOB.
I wish to use a SQL Function I have to convert the CLOB Text from RTF to 'readable' text.
This works fine in SQL, but when I try in the SQL Requester…
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…
Hi, I wonder if you can help me please?
I'd like to create a report / pull data from SQL which would show a list of all User Profiles, along with all of the Functions they have access to - is this possible?
If so, which tables would I use?
Thank…
Hello! Thank you in advance!
I am attempting to pull payments received from 01/01/19 - 08/31/19 only for invoices dated 01/01/19 - 08/31/19. Any report I try to create ends up pulling in payments that I've recorded during that time frame, regardless…
I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…
Hi! i´m trying to edit the SBONFACP crystal report with the parameters values.
So i tried to print it in rpt format and later open with the SAP crystal reports.
When i tried to open it i have this error: "Unable to find language and/or path in…
Does anyone have details notes on how to add a new crystal report to show up in SAGEX3. The report has been developed on crystal but I want it to show up as an option under printer in PO. It is a copy of BONCDE report with a little modification but I…
I have a report I built from scratch. Pretty simple, only 4 tables and one parameter to fill.
I added it to the directory, then thereport dictionary, then set up the default values and then the print code.
The report is visible after I hit "Record…
How can I pull a report that will show the customer BP invoice. We have the sales invoice by lines report. But we want to connect information from the Customer BP Invoice.
We want all the information under this:
The inquiry does not output the…
We currently have customer that accept Back orders. On the sales order the user is able to input items that are on back order. However, if a product is on back order the invoice form drops that product.
The sales order:
This is the invoice: The…
We have instances where a customer accepts back orders. On the sales order, it will allow you to put all the product, even the ones on back order. However on the invoice, it will only show the products that are available and drop off the back order products…
I have a recurring task set up to run a shipping availability report for our warehouse. The report parameters include a date which needs to be the current date plus 14 days. Is there a way to set the report parameters to accomplish this?
The AP Open Invoice report does not provide GL detail.
The AP Invoice G/L Distribution Report does not given an option to run for only Open invoices.
I have played around with Exports in both AP and GL but don't see where I can get this data.
…
