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…
Is it possible to display a page number in a report that displays the count pertaining to each individual company within that report? i.e. Is it possible to reset the page count for the next company within the same report?
For example,
Company AAAA…
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.
Backgound on the challenge I am facing:
A vendor sends us an import file that combines three customer data fields into one, separated by a ‘/’. (These are Unit No / Account No / Order Reference)
This combined field is imported into our Sage Line…
When running the report for supplier turnover, subcontractors who are nett and pay CIS tax, as it is a credit note automatically produced on your system, it is deducted from the turnover figure.
We need subcontractor turnover figures to give to the…
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…
I have been asked to print out reports for meetings. This report specifically is for SOPS - printing out an itemised quote list.
I usually enter an "M" Message line on the first line of every quote which I input the customer's enquiry reference. I sometimes…
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…
I want to be able to display different text in a text box based on the result of an expression. So far so good, but the text I want to display needs to be displayed as a multi line, and I can't find a way of including a linefeed or carriage return character…
I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…
The August Report of the Month is now available for download
The new report is "Sales by Invoice Analysis Code 1". This Invoice report can be run for a date range and will group invoices together by the Invoice Analysis 1 field. It shows net sales per…
Our business is driven around using the Project Module within Sage. What I cant seem to do is find any report within Report Designer that enables me to simply print my Cost Code Budgets (Set pre start of Project) against the actual Spend figures.
It…
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 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…
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…
