Welcome to the Sage 50 Accounts UKI 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.
What I wanted to do was accrue income to a project then reverse the accrual the month later as tax point of the sales invoice is in the month following when the work was carried out.
Hello,
I have a "previous 12 months stock usage" report that I use to help with predicting stock reorder levels.
Its set up with a pre-set date range that I have to change every so often to reflect usage of items that fall outside of the original…
I was looking for a 'Delivered Purchase order report' - basically one that had all of the Goods Received Note details on it, but it also included POP items too from the original PO.
The standard GRN reports exclude things like price, etc. which is…
Hi,
I have a report set up that I use to check supplier deliveries and I want to add another document to the printout so that I get the Sage report and a Word document print together.
Is this possible?
Regards
Andy
Hi All! I'm trying to edit our purchase orders so that it works with both types of orders we do. Sometimes we don't add a code for items we're ordering in on a one off basis and we just use the S1 - Special Item code. When using STOCK.SUPPLIER_PART_NUMBER…
Hello
If the recently added (3) Analysis fields now found in Customer Record in V29. were also built into the Sales Order and Invoicing Modules this would allow a greater analysis of sales data which for us would be a wonderful addition
We are restricted…
On most of our reports the default report date is 31/12/2050 but since V29 some have reverted back to 2019???
I have tried the fix on the help centre following the instructions but it just not working.
Current Situation:
On 'stock' items track activity.
Non-stock items and Service items have no activity
Problem
We are a repair company who provide services and subcontract out some services.
Without tracking, we cannot easily see e.g. how…
The ability to change the default text in the "message body" that is self populated when you select your file format the drop down menu. This would give you the ability to amend multiple layouts in one action rather that having to save each layout with…
Hi, I essentially I want to see my nominal ledger, split by department.
I'm building a report in Excel that uses the connection properties and command type of SQL to extract data from the SAGE databases, but I'm not seeing any links between departments…
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…
After completing the monthly CIS return it would be very helpful if Sage automatacially pushed out the CIS statement to the contractors included on the return, as the current process is very long.
Example
Order 1 - 3x product A, 1x product B, 5x product D
Order 2 - 2x product A, 3x product C, 3x product D
Is there a report which can list what products are live orders, such as...
5x product A
1x product B
3x product C
8x product…
Hi,
To import orders to our new warehouse system we need to export them from sage as CSV files with headers. CSV file headers have to be exact and some of these include a space. In the report designer I can choose to Generate Header Row and headers…
Add further company e-mail fields to allow using multiple/different mailboxes for directional customer and supplier communications. This will ensure the e-mail is not hard coded into reports and allows easier amendments as required.
Did you know that all customers with a Sage Cover membership can download reports and layouts from our standard Report Library?
Our guide explains how to access these free additional reports. To help you decide which report or layout to use, we've included…
Hi,
We need to export our sales orders to import to our warehouse system, but the new system requires CSV files to have the first row of headers.
However I would try to create headers - they would only appear on excel forma, but not CSV.
Please…
Hey everyone,
Here's the scenario:
My company gets invoices every day, and we want to do reports each week for how much we spent on invoices for the week before.
However, sometimes an invoice may arrive a week late (or more).
What would be the…
I'm looking to create a report, or (preferably!!) doctor an existing report, that will show me products that have had ZERO sales within a specified time period. Any ideas?
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…
Is there a way to printer 2/3 copies of the same invoice? I have a custom designed report; which works fine. I'm looking to print this 2/3 collated copies without changing the settings - i.e. by clicking the Quick Print Button
I have tried to change…
Bill of Materials to be recorded accuratley on Product Records
Sales Tab to either include the BOM sub-compnents in the actuals, or even better add an additional column to show BOM quantities and sales cost
The Graph to include sales of BOM sub-components…
