Search found 166 matches

by Simon
28 Jan 2011 09:40
Forum: General MoneyWorks
Topic: Selling pre-pay items and unearned revenue: best way?
Replies: 3
Views: 2605

Another way to do this would be as a Sales Order. Enter an order for 10 classes and then receipt a Deposit for the prepayment. Each time they take a class you ship 1 class and MW will automatically match the Depost against the Order. Looking back at the sales order you see straight away the remainin...
by Simon
26 Jan 2011 13:23
Forum: General MoneyWorks
Topic: Changing System Currency Rate
Replies: 7
Views: 3589

When you change the currency rate this becomes the default rate as of the date you enter. Other then this there is no other rate that MW looks at. Any new transaction will match the transaction period with the applicable last exchange rate set in that period. If your creditor invoices are picking up...
by Simon
25 Jan 2011 14:49
Forum: General MoneyWorks
Topic: Changing System Currency Rate
Replies: 7
Views: 3589

command, change currency rate. do a search in the help topics for the specifics
by Simon
23 Jan 2011 10:28
Forum: Reports and Report Writing
Topic: How can I make a Top Products Report - over a value
Replies: 1
Views: 1915

there is a standard report for Top sales. this won't do exactly as you want (it just picks the top x not based on a specified value) but if you open it in the report writer you can see how it works and modifiy it
by Simon
23 Jan 2011 10:23
Forum: General MoneyWorks
Topic: Multiple delivery
Replies: 1
Views: 1521

You need to use Sales Orders (only available in Gold). With a sales order you can "ship" individual items as seperate invoices.
by Simon
23 Jan 2011 10:19
Forum: General MoneyWorks
Topic: Persistent Customized List Views?
Replies: 2
Views: 1954

Customised list views can be created for all lists. Go to the apporiate list and right click and select Customise List View from the sub-menu (or from Command in the top menu) Though it sounds like have you managed to set up cutomised list views but are you saying they disappear when you log out? Li...
by Simon
16 Dec 2010 09:01
Forum: General MoneyWorks
Topic: Customize Products List View
Replies: 2
Views: 2039

The formula to show unposted creditor invoices would be SumDetail ("Detail.stockqty","detail.stockcode=`"+code+"`","type=`Ci@` and Status=`U`") You will need to be careful when the price of a new purchase differs from the average value for that product if you sell it before posting the creditor invo...
by Simon
16 Dec 2010 08:34
Forum: General MoneyWorks
Topic: TRIAL BALANCE
Replies: 2
Views: 1911

Tick "Print Movements" which will result in all the transactions showing, alternaltively print a Ledger Report.
by Simon
01 Dec 2010 16:32
Forum: Reports and Report Writing
Topic: Balance Sheet year over year comparison
Replies: 1
Views: 1869

Could be that the periods are not set up correctly or the balances from last year were not entered into the correct period. Start by looking at the account balances - From the top menu, go Show, Balances. This will show you which month has been set up as the yr end and the balances for each account ...
by Simon
24 Nov 2010 16:09
Forum: General MoneyWorks
Topic: Finding products whose buy price is less than sell price
Replies: 2
Views: 1787

yes, do an Advanced Find (under Select)

Formula = BuyPrice>sellprice
by Simon
18 Nov 2010 11:30
Forum: General MoneyWorks
Topic: Cost of Goods Accounting
Replies: 1
Views: 2056

The effect on the cost of goods sold is due to the way your landing costs product is setup. Look at the code used for Cost of Good Sold in the product details. Ordinarily for landing costs I would assume this should be set to a GL code called Freight or Landing Costs. When you are entering the costs...
by Simon
04 Nov 2010 12:22
Forum: Forms and Forms Design
Topic: Invoice form
Replies: 1
Views: 2020

you must have the MW Std Plugins folder otherwise you wouldn't see the Serivce Invoice1. Go to About MW System, Info and the location will be shown. The easiest way to enter the payment message is via the messages on the print settings screen. After you have typed in the msg click on the Drawing Pin...
by Simon
04 Nov 2010 12:18
Forum: General MoneyWorks
Topic: Need Help With Recurring Transactions...please
Replies: 3
Views: 2690

Don't do it as the #th friday of the mth but as every 7 days.

recurring transactions show with little pages icons next to them in the transaction lists. you can do a find for them by using "Recurring" is "True"
by Simon
04 Nov 2010 12:14
Forum: General MoneyWorks
Topic: More for accounting issues
Replies: 1
Views: 1760

YOu could set yourself up as a creditor and enter an invoice in the period the expenses incurred. Then match the payments against this invoice.

Otherwise just do it as a normal cash payment and let it fall into the period it was paid.
by Simon
04 Nov 2010 12:11
Forum: General MoneyWorks
Topic: multi currency multi bank accounts
Replies: 1
Views: 1802

Go Show accounts, click on New, choose type = Bank Account and then change the Currency. It will only show the currencies you have set up, so you may need to go to your currency settings first. You can setup Currencies that are not "Real" - MW calls them "Psuedo Currency" and are at the bottom of th...
by Simon
04 Nov 2010 12:03
Forum: General MoneyWorks
Topic: OFX of QIF pros and cons
Replies: 1
Views: 1772

AFAIK Mw only recognises the QIF format
by Simon
04 Nov 2010 11:54
Forum: General MoneyWorks
Topic: seeing receipts in posted banked transactions
Replies: 1
Views: 1465

Find the jnl, and click on Related - Banked Receipts. This will take you to the receipts that make up the jnl.

Similarly you can click on a receipt and go Related Banking Jnl
by Simon
22 Oct 2010 14:34
Forum: Reports and Report Writing
Topic: How to make a Top 15 products Report?
Replies: 2
Views: 2541

there is a report in MW called Top Sales. It is under Sales in the reports menu. You can run this for Customers or Products.

Or you can customise this report if it is not quite to your liking (or we can do it for you at a price)
by Simon
22 Oct 2010 14:31
Forum: General MoneyWorks
Topic: MW Gold Setup of Multiple Businesses on Cash Basis
Replies: 3
Views: 2464

Do the separate business relate to a seperate legal entity (eg registered company, or do you file seperate tax returns for each business). If so then you probably need seperate data files. Otherwise if you are using the same Data file then departments is probably your best option. But as has been su...
by Simon
22 Oct 2010 14:26
Forum: General MoneyWorks
Topic: How to show what a customer owes?
Replies: 3
Views: 2492

I think you are looking at the Debtor Invoices, not the customers. Try going Show, Names (from the menu at the top of your screen) and click on Debtors