Home Button  Buy Button 

Topic:   Currency on Invoice

By: GuestPosted on: Dec 21 2022 at 02:47:40 AM
When I set an Invoice currency to GBP and press save, it comes up with a message saying:

"An unexpected error ocurred and the delivery could not be saved. Data too long for column 'DText2' at row 1. Nothing was done. You can try again."

How do I get it to save as GBP?

By: GuestPosted on: Dec 22 2022 at 07:58:13 AM
I somehow managed to get one to save with the GBP value on the invoice but then it messed up the MRP. It moved the completed order back into open, removed it from closed, but kept a "Completed Delivery" entry which couldn't be opened. It also booked the item back into stock. Once I managed to delete the "Completed Delivery" entry and restarted the program it was back to normal again.
What is going on here? Why can a currency not be set on an invoice without it breaking the MRP?

By: SupportPosted on: Dec 23 2022 at 09:01:00 AM
I think we're looking at two separate issues here. You just happen to have hit them both at the same time.

The error message mentioning "DTEXT2" is something to do with the comments box in the lower left corner of the customer order.

This does sound like a bug that we need to fix.

I've tried changing or adding currency to an invoice and I can't make it fail. Changing something like the currency, the tax or shipping cost - things that don't change inventory - should not affect the open/closed status of an order/delivery.

Changing the shipped quantity obviously needs to undo the previously shipped quantity and ship the new quantity. This could reopen a closed order because now the shipped quantity no longer matches the ordered quantity. But, as I said, it should not happen when just changing the currency or tax etc.

I need to look at both of these issues but, as I said, I can't make the currency fail. But I'll keep trying.
That mix up where the open/closed status of the order changes incorrectly does sound like a bug. Nobody else has reported this but we do need to get this checked and fixed ASAP

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Currency on Invoice

Enter the numbers.

Your name here is optional