Pastel inventory decimals problem

[Braamh]

Hi everyone,

I have seen a similar post but no real answer and I am unable to sort out my issue so I hope someone can help! (Neville please.....)

In Sage Pastel Xpress V19, some (not all) of my inventory items appear on my invoices with a ".99" Eg, Plastic Bag selling price is R150.00, but when I enter it on the Quote or Invoice it displays as R149.99!
In the Inventory is is displayed as R150.00 incl vat and the excluding price is R130.43 so all seems perfect but not when Quoted or Invoiced, then it rounds to R149.99...

Its a small but very annoying problem as not all staff members change it to the correct value and it creates issues.

Any advise will be appreciated please.

Regards
Braam

[Neville Bailey]

Hi Braam,

Using your example, if the VAT exclusive price is R130.43, then the VAT inclusive price calculates to R149.99 (R130.43 x 1.15 = R149.9945), which is what you are seeing.

However, if you start with the VAT inclusive price of R150.00, then the VAT exclusive price calculates to R130.43 (R150.00 / 1.15 = R130.4348).

The way to overcome this issue is to set your customer accounts to VAT inclusive (Edit...Customers...Accounts, then open the Processing tab and select "Inclusive" in the Tax section). When you process an invoice, the system will use the VAT inclusive price of R150.00 instead of the VAT exclusive price of R130.43.

[Braamh]

[SOLVED]
Hi Neville,

Thank you for your reply, I had everything exactly as you mentioned so I new I had to be very close but with no success.

What I did was under the Processing then Tax I changed the Default Tax to: Force tax type and that immediately fixed it so that must have been my last simple missing piece of the puzzle...

Thank you so much for assisting me and getting me into the right direction!!!

Regards