MoneyWorks Community

Try using right(detail.stockcode,2)=`01`

It is showing the average cost of the items sold at the time they were sold, not the current average. So you may have sold 99 items at a cost of $10 (ie out of the first batch purchased) and then purchased 10 more at $12, giving an avg cost now of $11.82. Then if you sold another 1 at avg cost 0f $1...

Why not just create a "Misc" Miscelaneous item that you use for all the one-offs? You can change the descripton and the price in the quote/invoice or wahtever transaction is you are doing. Once the quote/sales order has been changed to an invoice you can switch it from a item invoice to se...

Good suggestion.

The work around for names would be to put the account on Hold. This would stop any new transactions using that name being posted.

You could use the Head Office billing feature to create multiple contacts that are linked.

yes

Each report and form in MW has its own margin and page setup. The margins are by default quite generous, so when you are in the settings page when running a report (the bit where you select the date rabge, and choose to preview, print etc). click on the page thumpnail where you see a printer icon an...

It can look meessy, but there are several good reasons to not be able to delete transactions. For example... say you have reconciled the bank account and then a couple of months later you decide that a transaction has been miscoded so you delete. But then you forget to re-enter it or re-enter it for...

You need to do a related search:

[detail:detail.stockcode=`ABC123`][transaction]

Depends on why you are writing off the invoice. If it is a bad debt then that would be the place to write it off too, otherwise it may be a discount which you may chose to write off to a discounts given account, or it could be a small under payment, which again it could be written off as a discount ...

YOur profile shows you are using cashbook, which doesn't have a stock moduel. Therefore you can only enter the value of the closing stock. YOu need to to do this as a journal entry - DR Stock on Hand, CR Purchases/Cost of Goods Sold. If you have last years closing stock in MW then you will need to r...

The customised columns are user specific rather than by computer. Rahter than recreate the column for each user it would be easier to set it up for one user and then copy the user settings to the other users (in Sharing and Users).

Doesn't answer your original question but should fix your problem..

We are using Win8 with MW with no problems

The ledger report is a built-in report that can't be modified. You will need to build a report from scratch or pay someone to do it for you...

Having you P&L accounts balance to 0 at the end of the financial year is the nature of accounting so not really MW's fault. There are ways to report what you want to see though. A prime example is a report that is already in MW - under the Profit and Loss folder look at "Profit 12 Months Ac...

Entering an opening balance jnl won't create the opening balance in the reconciliation. The first bank rec will start with a zero balance, make the closing balance what the opening should be and then in the reconciliation select the journal from the unreconciled items. You should now have a balance ...

You are best to startt with of the existing standard Remittance forms. Look in the MW Standard Plugins/forrms. Open one of the forms of type "Moneyworks Cheque Form". Use this as a template to start with and to see how it works. Make sure you save the changed form into your custom plugins ...

If you insert the "~" (also known as a tilda) before the code the item code will not show in any choices lists but will still retain its history. Before you change the code make sure in the Document Preferences the option to "Alter Existing" records is selected (on the Data Entry...

Rather than use the Head Office billing feature (if the 2 clients are actaully associated) you could use the Banking feature. Enter the receipt as 2 seperate amounts - one to each debtor, and use the bank account "UnBanked". Then "Bank" then as one amount.

If you are wanting to export to Solution6 format for your Accountant then the Accountants Export is the option you want. You need to know which version of Solution6 your accountant wants, then enter the date range for the period of transactions to export. This will create a text file for your accoun...