Search found 166 matches

by Simon
14 May 2010 09:20
Forum: General MoneyWorks
Topic: Unbanked/Banked
Replies: 2
Views: 1984

Yes, if you have already entered the receipt and done the banking in MW then you do not need to enter the deposit on the bank statement.
by Simon
12 May 2010 10:39
Forum: General MoneyWorks
Topic: Cannot unlock a period
Replies: 1
Views: 1577

Is it locked or closed? Locked is a green x closed is Red shading (if is just white then the period doesn't exist) If it is locked then click on the period in the time line and click unlock. If it closed then this can't be re-opened. If you are multi-user you will need to be the only user in MW.
by Simon
07 May 2010 18:17
Forum: Scripting and Extensions
Topic: Price Book
Replies: 3
Views: 2670

Price Book

I have a client who have run out price codes in the product file. Each of their customers negotiates a price for the each product so therefore there could be as many price codes as there are customers (smallish product range of high value). Unfortunately is not a simple accross board discount. So I ...
by Simon
10 Mar 2010 16:32
Forum: Forms and Forms Design
Topic: Purchase Order to show Supplier Item Code
Replies: 2
Views: 2859

lookup(detail.stockcode,"product.supplierscode")
by Simon
28 Feb 2010 20:31
Forum: Reports and Report Writing
Topic: stock valuation report
Replies: 3
Views: 3028

Be vary wary of using the Stock History report, especially if you use multi currency. The report doesn't take into account the different currency. Also due to the complexities involved in Average Costing the report can be quite inaccurate after a period of time.
by Simon
17 Nov 2009 14:51
Forum: Ideas and Suggestions
Topic: Invoice creation - Service quantity
Replies: 8
Views: 6214

"but a wide range of items, so do not want to create a product each time" There's no need to create a new product each time you want to sell something different. Create a generic "miscellaneous" product and alter the description and the selling price at the time of invoice. "A subsequent suggestion ...
by Simon
17 Nov 2009 14:37
Forum: Scripting and Extensions
Topic: Import of order detail from excel or text
Replies: 3
Views: 3714

This can be done quite successfully and even automated. First you need to get a handle on how MW imports and using the import maps. You can see this by highlighting a transaction and copying it and then pasting it back into MW. The import field order map will pop up. On the left is the stuff you are...
by Simon
17 Nov 2009 14:13
Forum: General MoneyWorks
Topic: How to close an open period?
Replies: 1
Views: 1757

Opening periods can't be undone, so you will need to live with it until you catch up.

as a work around you can create a list filters to show the current period using a formuala something like:

"Period = (periodoffset(CurrentPeriod(),-12)"
by Simon
02 Nov 2009 07:44
Forum: General MoneyWorks
Topic: Dealing with a bounced cheque
Replies: 1
Views: 2066

You need to cancel the original receipt. Find it in the transaction list, and click cancel on the tool bar (or Command, Cancel Transaction from the menu bar)
by Simon
22 Oct 2009 11:00
Forum: Scripting and Extensions
Topic: Daylight MW Connector Plugin
Replies: 4
Views: 4808

Try looking in the Moneyworks Custom Plugins\scripts folder. MW generates a "scripted import error log" when these types of automated imports fail. This should tell you the exact cause of the failure and the record that caused it. I know nothing about Daylite but when using other scripts to import s...
by Simon
21 Oct 2009 16:20
Forum: General MoneyWorks
Topic: Recording Mileage
Replies: 3
Views: 2960

The simple method would be to "pay" your self and then put the money back into the bank account as Funds Introduced. ie create a payment coded to vehicle expenses. then create a receipt for the same amount coded to funds introduced. no money needs to actually change hands as the transactions cancel ...
by Simon
21 Oct 2009 16:17
Forum: General MoneyWorks
Topic: Calculating prompt pay before shipping?
Replies: 2
Views: 2560

In the settings for the freight product make sure the "Cost of Goods Expense" account is set to something different than your discountable products. Now go to the Account codes and in the Cost of Goods expense code specified above untick the "Discountable" check box. Now when the prompt payment disc...
by Simon
19 Oct 2009 16:25
Forum: Ideas and Suggestions
Topic: Invoice creation - Service quantity
Replies: 8
Views: 6214

Enter this as a "product" invoice, with the product being your time (which is what you are selling so in a way it is a product)
by Simon
13 Oct 2009 10:26
Forum: General MoneyWorks
Topic: RE: Stock valuation report vs. Stock History Report
Replies: 4
Views: 3061

The work around would be to not Post any transactions post balance date until you have finalised the stock adjustments. Stock is only updated once the transaction is posted.
by Simon
12 Oct 2009 09:37
Forum: General MoneyWorks
Topic: RE: Stock valuation report vs. Stock History Report
Replies: 4
Views: 3061

You are best to use the valuation report, which will give an accurate value of the inventory as at the date/time you run it.

The Stock History report attempts to recalculate the stock value for a prior period, but is not accurate.
by Simon
29 Sep 2009 11:14
Forum: Scripting and Extensions
Topic: XML Import
Replies: 7
Views: 5070

I have found a solution (thanks Grant). The XML needs the arguments in " not `. So the correct syntax is

DoIt = mwimp.importtext(details,"<?xml version=""1.0"" ?><args file=""transaction"" map=""LCImp.impo""/>")
by Simon
28 Sep 2009 13:14
Forum: Scripting and Extensions
Topic: XML Import
Replies: 7
Views: 5070

Digging a bit deeper I have managed to get an error message saying the named import map can not be found.

I have tried referencing the full path to the map eg `c:\LCImp.impo` but still get the same error.

Is my sytanx incorrect or where would it be looking for the map?
by Simon
27 Sep 2009 20:40
Forum: Scripting and Extensions
Topic: XML Import
Replies: 7
Views: 5070

I am trying to replace a creditor invoice but the replace option isn't the issue. At the moment I would be happy if I could at least get the transaction imported using xml.

As per my previous posts, even if I remove all the options the transaction does not import at all using the xml map
by Simon
27 Sep 2009 15:49
Forum: Scripting and Extensions
Topic: XML Import
Replies: 7
Views: 5070

Any ideas anybody?
by Simon
26 Sep 2009 14:12
Forum: Ideas and Suggestions
Topic: Paying from the payables list
Replies: 6
Views: 5941

the tutorial deals with using MW. I think what you are struggling with is the book-keeping function it self.

See the answer to your other post on the same subject

http://www.cognito.co.nz/community/viewtopic.php?t=525