Many thanks for a most useful and helpful reply, Bruce.
Max
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
- - - - - - - - - - - - - - - - - - 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
- 13 Oct 2015, 19:42
- Forum: Bookkeeping and Management Accounting
- Topic: Budget variance report for inpayments against budget
- Replies: 2
- Views: 6411
- 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...
- 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...
- 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...
- 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.
- 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...
- 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...
- 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...