Browse By Tags

Is there a PO Return of Goods History Report? I see Inventory Sales History, Inventory Receipts History, and Inventory Issue History Reports under IM module, but I don't see an Inventory Return of Goods History Report. Nor do I find one under the PO…

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…

Hello. Is it possible to run multiple general ledger detail reports at the same time, but have each account print on a separate page? I have to run up to 14 reports each month for 60 clients and if I could run 60 reports each month instead of 840 that…

What is the proper report to use to view orders invoiced but not shipped? We have tried to use Order Action Report and set the type to orders never shipped but it is not generating accurate data. Any insight will help! Thanks in advance.

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…

I just voided several checks for a vendor. How do I run a voided check report?

Form and Report Designer are still stuck in the1980's as text based editors. Isn't it time to upgrade them to a graphical UI? I'd like to be able to import an image of a preprinted form on a non-printing layer. This would make text and field alignment…

Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…

Under the Order Entry Module I was redesigning a sales order to use for a commercial invoice. After creating a db calculation it would only display the number with no decimal places unless there happened to be cents in the calculated answer. I wanted…

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…

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…

Hi, I'm using Sage 50. Could anyone help me on how to run a sales report which can show Item Description from the invoice? Thanks

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…

I got a problem regarding the sales order report printing , it keeps on loading but it never print . I'm just asking why was this happen . It only happen with this particular SO number.

Some fields in our X3 db were renamed. SEI process currently refers to old field names. Is it possible to remap field references in process? I was hoping to be able to update references in the relevant process files in CentralPoint. But this hasn…

I am trying to report on the invoice inquiry screen. The fields are exactly what i need. Anyone has an idea what those tables are that are running?

I did the following to the YSBONFAC Report. When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.

I had this same problem last year. My AP Aging for 12/31/13 does not match the GL Balance for AP at 12/31/13. I checked the setting in the report parameters to exclude future dated transactions but they still do not balance. Could someone help me with…

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. …

We have some 'straggler' projects from 2014 that are still active projects. It seems I cannot generate any Project Income report that uses a date earlier than Jan. 1, 2015 now that I have rolled over into 2016. That seriously sucks :( Are there any…

Hi, i get this error when open BI Report Manager I'm on Sage 2014 PU3 "The function GetDataValue can only service SQL calls that result in a single return value. Please modify the SQL statment accordingly. The SQL statment supplied was : - SELECT…