added also a commit fixing the SQL that is failing on the oracle server - it has a semicolon at the end that is not supported by oracle

Created pull request 2474 to reorganize the dashboard from this:

Open

to this:

Open

reported by @Jesús Castillo

https://groups.google.com/g/idempiere-es/c/1j5XXWMRUdw/m/8luURF2uAwAJ

The initial sequence for payment receipt is wrong in GardenWorld

Pull request 1491 creates GardenWorld periods from 2023 to 2030

Closing this as Resolved, anyways, if there are more fixes for GW data, please feel free to use this ticket.

Yes, that will make things a lot easier. I will change the Mexico locations to France and just add a Purchase Import price list in EUR.

Hi Tony, yes, your proposal sounds great.

Maybe it will make things easier if you change the locations from Mexico to an EUR country, that way we don’t need to setup price lists and exchange rates to MXN

The Furniture Warehouse already has a location in Mexico and the Fertilizer Warehouse has a location in Germany. However their linked Organizations have no location entered. I would propose that Warehouse location be copied to the respective linked organization.

The existing Vendors ‘Wood, Inc’ and 'Chemical Product, inc’ have no location entered and are the current vendor for some products with MXN and EUR currencies. I propose to create locations for these vendors in Mexico and Germany respectively.

This would also require adding currency exchange rates for USD to MXN and EUR to MXN and creating purchase price lists for EUR and MXN.

For the customer side there is already a sales price list in EUR, so I could easily add a new customer, perhaps in Germany.

If this is OK with everyone I can start to work on this.