sihaysistema / cambiare-gtq Goto Github PK

This doctype is a single doctype to generate multiple cambiare cheque print set

Company
Transaction Start Date
Transaction End Date
Button: Generate Cambiare Cheque Print Set
[ ] Add logic to create multiple cambiare check print sets from the child table bank account table.
Table: "cheque print set bank account"

Currency Exchange DocType
valid_from: datetime
valid_to: datetime

Custom field: export fixtures [Custom Field]

remember to clean all hooks.py form Other apps before exporting!

Obtener tipo de cambio USD GTQ
Crear dos registros por evento uno de Moneda origen a moneda destino, y otro de moneda destino a moneda origen.
Ambos son para compra y para venta simultáneamente.

usar API propio

Add these currencies to automatically create a currency exchange in ERPNext.
Sourced from Banco de Guatemala.

• Add custom field to currency doctype: currency_textual_name

• Load to test server the translations as data import, including currency_textual_name field

• Factor code to obtain currency_textual_name based on ISO code, fed by user (from report filter) and finally search translation of the obtained string.

Enable functionality to read currency pairs and create the required records.

• Monthly Average Exchange Rate

This is meant to use the average exchange rate for the month of the transactions.
Thus, if 2 transactions belong on november 2019, and 4 transactions belong on december 2020, the 2 transactions will be applied the average exchange rate for november 2019, and the 4 transactions will be applied the exchange rate for december 2019.

• Code: ER-MA

"Exchange Rate Monthly Average"

• Yearly Average Exchange Rate

This is meant to use the average exchange rate for the year for the transactions. Thus, if 3 transactions belong in 2019, and 4 transactions belong in 2020, the 3 transactions will be applied the average exchange rate for 2019, and the 4 transactions will be applied the exchange rate for 2020.

• Code: ER-YA

"Exchange Rate Yearly Average"

• Year to date Average Exchange Rate
  This is meant to use the average exchange rate for the year-to-date, using a user specified date as the last date in the period.

• Code: ER-YTD

"Exchange Rate Year To Date "

• End of the month exchange rate
  This is meant to use the exchange rate for the end of the month, for all applicable transactions: If 3 transactions are available for January 2020, those 3 transactions will use the exchange rate of January 31, 2020.

• Code: ER-EOM

"Exchange Rate for End Of the Month"

• Exchange Rate date of Report Issue Date
  This is meant to use the average exchange rate for the month, for those transactions belonging to that month. Example: 5 transactions belong on November 2019, and 2 transactions belong on december 2019. 5 transactions will use the average exchange rate for the month of november 2019, and 2 transactions will use the average exchange rate for the month of december 2019.

• Code: ER-RID

"Exchange Rate for Report Issue Date"

• Historical exchange rate (exchange rate per day of each transaction)
  This is meant to pair the transaction date with the exchange rate for the same date as the transaction.

• Code: ER-HIST

"Exchange Rate, Historical"

• Report Range Average Exchange Rate
  This is meant to use the average exchange rate for all the dates contained in the report, with the earliest date being the first date of transaction data, and the latest date the latest date available for transaction data.

• Code: ER-RR

"Exchange Rate Report Range"

Modify generation of two doctypes to pass through USD on its way to the currency from and to.

• Currency Exchange
• Currency Exchange GTQ

Transaction ID: Doctype J.E. o P.E.
Cheque #: reference number read only
Amount: Amount read only
Third Party: Party read only
Party Type: Party Type. read only

Function will check currency exchanges that exist in ERPNext.
Will ask user to indicate begin date and end date for checking and obtaining amounts.

• Function to verify monthly that all exchange rates have been loaded.
  If they haven't, create them
• Function to verify daily that all exchange rates for the period have been loaded.
  If they haven't, create them

Bank Account: Link Bank Account
Bank Account Currency: Link Currency Read Only

• In configuration doctype, for each currency required, user can select to create records from that currency to GTQ
• In configuration doctype, for each currency required, user can select to create records from GTQ to that currency

For example if user wants USD to GTQ exchange rate (1 USD = 7.76 GTQ) but not GTQ to USD exchange rate, user can select that exchange pair only, and that exchange pair only is created.

Fields:
Date: creation_date
Source Bank Account: link. Company. source_bank_account
Company: Link. Company. company
Currency: Link. Read Only update from Source Bank Account
Transaction Start Date: Date start_date
Transaction End Date: Date end_date

Button: "Get Cheque Payments"

• Logic for button to obtain the cheque payments from J.E. and P.E.where Mode of Payment = Cheque. If no Cheque, do not include any payments.

Table: Table Options: "Cheque to Print"

Documentation must warn:
One check per Journal Entry
One check per Payment Entry

Create a massive loading file to be inserted after install, when installing cambiare_gtq
This will load translations from en to es and en to es_GT and also the field values for currencies in their custom fields. If currency does not exist, it will not write data.

Field: Title, data, fieldname:title