Search found 166 matches

by Simon
11 Apr 2013 09:05
Forum: Reports and Report Writing
Topic: Simple Profit report?
Replies: 2
Views: 2120

Re: Simple Profit report?

If the 4101 is set as account type = Sales and 6301 as cost of Sales the standard MW P&L will give you that (plus a bit more). Is this not what you want?
by Simon
05 Apr 2013 11:28
Forum: Forms and Forms Design
Topic: Adding an additional description column
Replies: 2
Views: 2071

Re: Adding an additional description column

You can use the "slice" function to split the description field. In your custom invoice create a new column and use the expression slice(detail.description,"-",2) This will grab all the text after the first "-". For the first part of the description use slice(detail.des...
by Simon
04 Apr 2013 12:15
Forum: Jobs and Time Billing
Topic: Multi currency jobs
Replies: 3
Views: 3886

Re: Multi currency jobs

As you have found MW will always convert the jobsheet items to the base currency and then convert it to the invoice currency at time of billing. There is no way around this and from an accounting perspective you wouldn't want in the invoice currency (work in progress, exchange fluctuations etc). So ...
by Simon
23 Nov 2012 11:41
Forum: Forms and Forms Design
Topic: Showing period name on invoice
Replies: 1
Views: 1545

Re: Showing period name on invoice

Do you want to display the MW accounting period name or the calendar month and year relative to the invoice date? If it is the MW Period name then PeriodName (Transaction.Period) should work. Otherwise to show the Month and Year is a little more tricky. You could try Texttodate() and then the Mid ()...
by Simon
23 Nov 2012 11:31
Forum: General MoneyWorks
Topic: Transaction import
Replies: 3
Views: 2205

Re: Transaction import

Did you get this sorted? If not.. The import file must have equal number of fields on all lines. Each line that you want joined as one transaction must have something that 'ties' them together - eg reference, date or name code. In the import map match the fields as you would for a normal one line im...
by Simon
23 Nov 2012 11:23
Forum: General MoneyWorks
Topic: forgot to tick 'we stock it'
Replies: 1
Views: 1439

Re: forgot to tick 'we stock it'

If you just dupliucated the original transaction then even though "we stock it" is now ticked MW doesn't go back to check the stock record. You will need to force it to relook at the new product settings by re-entering all or part of the item code in the duplicate transaction.
by Simon
12 Nov 2012 09:48
Forum: Forms and Forms Design
Topic: Columns in forms to calculate with Product custom fields
Replies: 4
Views: 3151

Re: Columns in forms to calculate with Product custom fields

lookup(detail.stockcode,"Product.SellpriceB")
by Simon
12 Nov 2012 09:43
Forum: Forms and Forms Design
Topic: Printing SO# on Invoices?
Replies: 7
Views: 5990

Re: Printing SO# on Invoices?

If you are referring to the Invoice data entry form then no you can't add any fields there. But you can add a column to the Invoice List with a calculation of lookup(OriginatingOrderSeq,"Transaction.OurRef"). You can also use the same formula in a field on the printed invoice.
by Simon
11 Nov 2012 13:26
Forum: Ideas and Suggestions
Topic: Multi Price List
Replies: 1
Views: 1518

Re: Multi Price List

There is a plugin available to do just this.

You need to contact these guys

http://www.moneyworks.sussol.net/Support/
by Simon
11 Nov 2012 13:13
Forum: General MoneyWorks
Topic: Importing Invoices
Replies: 1
Views: 1417

Re: Importing Invoices

If you are not interested in the stock you could force an account code in the import map instead of using the stock code. YOu put the stock code in the description or leave it our completely and just import the description. Alternativly you will need to import the stock file first - just flag them a...
by Simon
11 Nov 2012 12:56
Forum: General MoneyWorks
Topic: Upgrading to v6
Replies: 5
Views: 2504

Re: Upgrading to v6

You just need to rename the existing Moneyworks folder so that it doesn't get overwritten when you install V6.

We do alot of support so have versions 2 to 6 installed..

I don't think you will have any issues with going from 5 to 6 though..
by Simon
25 Jan 2012 12:55
Forum: General MoneyWorks
Topic: Exported data - full description of fields?
Replies: 1
Views: 1315

Re: Exported data - full description of fields?

U= User created data
S= System created data

When you export a transaction from MW you will see the s.detail fields, but you can't import into them. When importing it is the u.detail fields that you want
by Simon
17 Jan 2012 15:46
Forum: General MoneyWorks
Topic: Importing CR's - howto auto generate OurRef???
Replies: 1
Views: 1340

Re: Importing CR's - howto auto generate OurRef???

You don't need to specify it in the file being imported but in the import map - change the setting from OurRef to "Work it Out"
by Simon
25 Nov 2011 13:10
Forum: Ideas and Suggestions
Topic: Including Shipping and other costs in COGS - Money Works Gol
Replies: 5
Views: 4111

Re: Including Shipping and other costs in COGS - Money Works

Apologies for the 6 month delay in replying to this post... The plugin works by taking the supplier invoice and latering the product costs to include the landing charges, pro-rated by Qty, Value or Weight, and adds a line to the transaction to balance it to the original supplier invoice. Cost is $NZ...
by Simon
30 May 2011 14:08
Forum: Ideas and Suggestions
Topic: Including Shipping and other costs in COGS - Money Works Gol
Replies: 5
Views: 4111

Re: Including Shipping and other costs in COGS - Money Works

What you need to do is in the Invoice from your supplier gross up the purchase price of the items purchased to include the landing costs and then add a line as a negative for the total of the costs added (so the invoice total still agrees to the supplier invoice). You can enter the landing charges (...
by Simon
01 Apr 2011 10:18
Forum: General MoneyWorks
Topic: Accountant Export
Replies: 3
Views: 2704

Accountants Office is a accountants specific software, not MYOB as the consumer knows it. AFAIK AO was originally produced here in NZ by a 3rd party and then bought by MYOB and rebranded. The AO export from MW is made to be imported into MWOB AO, not opened as a stand-alone file. So if your accounta...
by Simon
06 Mar 2011 09:18
Forum: General MoneyWorks
Topic: Can you make preferred field attributes "stick"?
Replies: 2
Views: 1970

It should stick, but is related to your user login. Check that you have password protection on in sharing and users.

If this is not selected, you are still prompted for a user name and password but it isn't actually recording it.
by Simon
06 Mar 2011 09:11
Forum: General MoneyWorks
Topic: Changing System Currency Rate
Replies: 7
Views: 3540

Update on this... if you change a rate for a prior period it doesn't carry that rate forward, but only applies it to the current period. all subsequent periods will still be at the old rate.

So you need to change the rate for each subsequent month right up to the current mth.
by Simon
23 Feb 2011 07:51
Forum: General MoneyWorks
Topic: Adding "The Last Transaction Date" into the names
Replies: 2
Views: 1818

From the top menu - command, customise list view.

The field you want is "DateofLastSale"
by Simon
23 Feb 2011 07:50
Forum: General MoneyWorks
Topic: Inventory
Replies: 4
Views: 2723

What MW version do you have? Invesntory is only available in Gold. So assuminhg you do have Gold, when you set up a product, on the details page tick We Buy It, We Sell It and We Stock It (you will need a corrsponding Ledger code for each). Now you when you buy the product the inventort will go up a...