Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

Search found 8 matches

by decomplexity
13 Oct 2015, 19:42
Forum: Bookkeeping and Management Accounting
Topic: Budget variance report for inpayments against budget
Replies: 2
Views: 6411

Re: Budget variance report for inpayments against budget

Many thanks for a most useful and helpful reply, Bruce.
Max
by decomplexity
10 Oct 2015, 12:05
Forum: Bookkeeping and Management Accounting
Topic: Budget variance report for inpayments against budget
Replies: 2
Views: 6411

Budget variance report for inpayments against budget

A sports club uses Sage Instant. Its income is mainly subscriptions. Subscribers are set up as customers in the sales ledger, and dummy invoices raised and paid when annual subscriptions are received. Budgets are set against nominal codes for the various subscription types. A few subscribers pay the...
by decomplexity
05 Jan 2012, 20:11
Forum: Sage 50 Report Designer
Topic: Sage 50 Report designer - IF THEN ELSE expression syntax
Replies: 1
Views: 10187

Sage 50 Report designer - IF THEN ELSE expression syntax

I am trying to print a detail line where an entry in a particular column is printed or left blank not by whether it is (e.g.) Debit or Credit but by the evaluation of an expression. Example: One column in the detail line is for sales invoice values (SI) or sales credit values (SC). In the variable s...
by decomplexity
28 Aug 2011, 16:05
Forum: Sage 50 UK version General Help
Topic: Custom reports - subtotalling groups
Replies: 1
Views: 1603

Custom reports - subtotalling groups

I am trying to produce a report showing invoices and payments against those invoices - in customer order. I have joined: SALES_LEDGER table to AUDIT_SPLIT table on ACCOUNT_REF AUDIT_SPLIT table to AUDIT_USAGE table on ACCOUNT_REF The report is intended to look something like (with extraneous details...
by decomplexity
18 Aug 2011, 09:23
Forum: Sage 50 UK version General Help
Topic: Payment as well as invoice totals on Nominal Balance report
Replies: 6
Views: 5066

Re: Payment as well as invoice totals on Nominal Balance rep

Thanks Bruce. A brilliant and most useful diagram - perhaps it should be put (with some explanatory text) as a 'sticky' post at the front of the forum. It is information which is otherwise very difficult to come by.
by decomplexity
16 Aug 2011, 21:12
Forum: Sage 50 UK version General Help
Topic: Payment as well as invoice totals on Nominal Balance report
Replies: 6
Views: 5066

Re: Payment as well as invoice totals on Nominal Balance rep

Many thanks Bruce - I now (much to my surprise) have a working report ! I only encountered two oddities on which someone might be able to shed some light: a. when I defined the relationships between invoice_split => usage <= payments_split, the Join mechanism refused to accept my specifying both rel...
by decomplexity
11 Aug 2011, 15:18
Forum: Sage 50 UK version General Help
Topic: Payment as well as invoice totals on Nominal Balance report
Replies: 6
Views: 5066

Re: Payment as well as invoice totals on Nominal Balance rep

Very many thanks Bruce. Light is (very) slowly dawning... Am I then right in thinking that because not only is the invoice-to-payment relationship n-to-n but also the relationship between invoice line [=invoice split] and payment [='part payment'] n-to-n, a usage record's SPLIT-NUMBER and SPLIT-CROS...
by decomplexity
10 Aug 2011, 18:21
Forum: Sage 50 UK version General Help
Topic: Payment as well as invoice totals on Nominal Balance report
Replies: 6
Views: 5066

Payment as well as invoice totals on Nominal Balance report

A Sage Instant (V15) query, but I hope someone can help. How, please, can I add to a Nominal Balances report a column of total received payments (as allocated to invoiced line items and hence to Nominal codes)? The obvious problem is that neither side of a payment transaction nor the transaction its...