Invoice is displaying incorrect values when previewed/printed

With the introduction of Softbase release version 3.10, invoices are reflected in the currency of the customer rather than the domestic currency of the organization.

With this, the conversion used for the work order is held in the rates/taxes tab of the work order.  If the work order is populated with a value other than 1, the totals of the invoice will be adjusted to account for that conversion listed on the work order.

There are some instances/scenarios where a work order may have been created with a null value in the conversion rate field.  This can occur when using Softbase 2.1 to create work orders, or when the value is carried over from a quote or credit. This will cause a display issue in the invoice, and we recommend updating any null values for this conversion to be a rate of 1 to correct this issue.

You can correct on an individual basis by manually updating the value to a 1.0 in the field and updating the work order, or we can update all work orders created with this value via a database script.

We will provide the script below, or if you would like to contact support we can implement the update for you.

update wo set conversionrate = '1' where conversionrate is null

• Related Articles

• How do I edit a recurring AP invoice?

  To edit or stop a recurring invoice, you will need to select the invoice within AP inquiry that you created. If you double click on the invoice line in AP inquiry that is set to be recurring, Softbase will open AP Invoice Recurring Maintenance and ...

• How to enter an AP invoice that utilizes currency.

  AP Invoice Entry- To begin, you should make sure that the currency exchange setup for Accounts Payable has been completed (See knowledge article). To enter an invoice with currency, you will open AP invoice entry under the accounting tab and add a ...

• Paying an AR customer invoice with a credit memo from a vendor.

  This process is often used when you have a vendor account that is also a customer. If the vendor issues a credit to issue against an invoice on the AR side, you can apply the credit within the AP process to apply it against an AR invoice. This will ...

• How do I stop an invoice from creating another open order every time it is invoiced?

  To stop that invoice from auto opening another one upon closing, you will need to uncheck the "Reoccurring Document" box in the Add'l Info tab in the work order and ensure that the rental end contract date (if populated) is not set for a future date.

• How do I apply a credit and debit invoice in AP payments against each other?

  In AP payments, we can see vendor ZIO000 has two “invoices” that offset each other, but the system is unable to match them because the invoice numbers are different. Because the system is unable to clear them for you, you can accomplish this using AP ...