Tag Archives: Template

How to print a payment voucher from the MoneyWorks accounting software?

Software: MoneyWorks #accounting software

Open the payment transaction, click the Print icon and follow by the OK button, to print a payment voucher. The payment voucher is using the Cheque/Remittance Advice form designer to create, which has a *.remt extension.

Payment

The cheque specific fields such as payment reference number, payment date, and payee can be picked up from the special cheque pseudo-file via a Calculation Box Tool. Whereas the related invoices paid, which are the transaction fields, can be printed using a List Box Tool from the form designer.

Reference:

  • Form Designer – MoneyWorks v7 User Guide Page G-379.
  • Calculations and Things – MoneyWorks v7 User Guide Page G-405.
  • The Cheque/Remittances form information – MoneyWorks User v7 Page 407.

It is not too difficult for a user to amend the system template such as adding a logo, lines, additional text, and those available fields from the box tool. However, you may consider engaging a MoneyWorks consultant near your area if you have a complex form requirement.

 

How to insert the discounted amount into an invoice template of the MoneyWorks accounting software?

Software: MoneyWorks #accounting software

In our previous post, we discussed how to record a trade discount given to a customer in the MoneyWorks Sales Invoice transaction. We recorded the discount percentage in the Discount field and the Extension (which is the detail line total) will calculate based on the Unit Price less the discount given multiplied by the quantity sold.

Besides printing the percentage discount on the invoice form, you can print the discounted amount by inserting a discount field to the form.

From the template designer, add a Calculation Box. You need to use a Sum() function together with an ExpandList() function to calculate the discounted amount. Enter the below formula into the Calculate Box:

Sum(ExpandList (“list”, “detail.unitprice * detail.stockqty – detail.net “))

The “List” in the above formula is referring to the list box name, which contains all the item detail lines. You can get the gross amount of the detail line by multiplying the product unit price with the quantity sold. You will get the discounted amount of the detail line by subtracting the gross amount of the detail line with the net amount of the detail line (discounted value of the product sold). Then, total them up with a Sum() function.

If you prefer to view the discounted amount as a negative value instead of a positive value, then amend the formula to:

Sum(ExpandList (“list”, “detail.net – (detail.unitprice * detail.stockqty)”))

The net amount of the detail line (the discounted amount) subtract the gross amount of the detail line will give you a negative value.

You can use a Text tool from the Form Designer to add a field label such as “Less Discount” or “Discount” before the discounted amount field.

MoneyWorks accounting software - Discounted Amount

Refer to the MoneyWorks version 7 User Guide page G-379 for “Form Design” and page G-405 for “Calculation and Things” if you like to know more on form design.

Invoice Reference Number

Software: MoneyWorks #accounting software

The default Sales Invoice template, such as the Product Invoice 1, in MoneyWorks prints the Sales Invoice reference number after the Tax Invoice form title. To have the Sales Invoice reference number separated from the form title, you need to break them up into two separate fields.

Sample:

Tax Invoice 1875

Sales Invoice Template.png

Refer to MoneyWorks version 7 User Guide page G-379 — Forms Designer

The Transaction.OurRef in the database is the field used to capture the sales invoice reference number. The formula of the existing Invoice_Number field is:

if(!CN, InvoiceTxt, if(left(locale, 1) = “A”, “Adjustment Note”, “Credit Note”)) + ” ” + Transaction.OurRef

The ” “ is the formula for a space between the form title and the reference number, and the Transaction.OurRef is the Sales Invoice reference number field. To separate the form title and the form reference number, first remove

+ ” “ + Transaction.OurRef

from the Invoice_Number Calculation Box. The amended formula in the Invoice_Number calculation box will be:

if(!CN, InvoiceTxt, if(left(locale, 1) = “A”, “Adjustment Note”, “Credit Note”))

Add a Text Box for the invoice Number field label and a Calculation Box for Transaction.OurRef, which is the Sales invoice reference number field.

Sales Invoice Number

The Transaction.OurRef is a field capturing the reference number of the internal documents such as Sales Invoice, Sales Order, and Purchase Order. If you need to print the Purchase Invoice, which is an external document, then Transaction.TheirRef should be used.

After amending the invoice template, you need to save it into the Custom Plug-ins folder of the company file and sign the template for users to access it. If you are using the MoneyWorks DataCentre, then you are required to upload the template to the DataCentre server. For the MoneyWorks Gold-Client environment, you need to copy the template to the user’s MoneyWorks Custom Plug-ins folder.