Welcome to the Sage 200 Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I'm trying to build a report that includes each stock item's next purchase order delivery requested date. So I'm trying to create a SQL view ideally returning
ItemID
NextRequestedDeliveryDate
(Purchase Order) DocumentNo.
I'll then add the…
Does anyone know how to get the number of days between 2 dates, as an integer? Just doing (Date1 - Date2) gives a timespan; I need a number!
I'm trying to show the average daily sales of a stock item. I have an expression PeriodSalesQty, and a date…
The report could not be generated.
No applicable method 'StartsWith' exists in type 'DynamicClass13'
I'm using a modified zero value order lines report to get invoice item descriptions and their respective invoice numbers into columns. When I try…
Unfortunately in the current Sage 200 Professional API there doesn't appear to be an endpoint that would provide an approximation of the data stored in dbo.StockItemPeriodBalance. Altough these tables have great data within them.
One example,of Period…
I am trying to create a reminder letter based on the default 'Statements and Advice (Single)' layout in Sage 200 report designer. At the moment the statement layout shows all unallocated transactions whether they're due or not.
What I need is to only…
Hi,
Using Sage 200c and Sage Report Designer, I am making a report to produce invoice from my custom table. I have apply criterion to print specific row based on my criterion value.
However, even after applying criterion as in image, my report still…
Hi Guys,
We have recently moved to Sage200 and working through everything - mostly gone well and getting there, but we have an issue with one of our Workspace Reports for web users - when they click on a report, the filters do not all appear, only one…
In Crystal Decisions you can test run a report and view the commands as the report steps through them during runtime – this is really useful to see where a bespoke report is falling over.
It would be very beneficial to have such a tool for the Sage…
When you export the VAT transaction report to csv (so that you can create a proper table in excel) it exports Credit Notes as positive figures rather than negative.
The EXCEL extract is not a usable alternative, due to the spaces / extra lines / etc…
If you upgrade from 200c v2016 or before to 200c 2018 Winter edition you lose spooler access to your previous reports.
Surely it cannot be impossible to convert these files?
Do you not think it would be appropriate to warn end-users of this "fault…
I am running a report; only showing the account name and net value for various different suppliers and I want each supplier chosen to show even if the transaction in a given period is "0".
In the report designer the "Include Records with no transactions…
Hi
Our supplier and customer accounts use a numerical reference for their ID, rather than letter based. This means that when it comes to running a report for VAT transactions it is hard to identify the supplier or customer names for the transactions…
Hi,
I'm trying to put a delivery address on my invoice in Report Designer.
I'm using the following variables:
SOPInvCredAddresses.C_AddressLine# - invoice address
SOPInvCredDelAddresses.C_AddressLine# - delivery address
I want to put in…
I'm trying to add custom data fields to a report using Report Designer but am unable to select a different data provider as was possible in previous versions of Sage 200, I'm currently using Sage 200c
The data providers available in this version is…
We run Sage 200 and I'm trying to produce a report that shows our Customers average time to pay. The Account Details report under SL - Reports - Account Analysis gives me the information I need, however it shows the Average Time to Pay for the entire…
In our POP Purchase Order Report the data is grouped by DeliverToGroup. When printing some Purchase Orders we have the value in this field set as 0, 1 or 2 even though we do not group our orders by different delivery points, at least not intentionally…
