Heart-Profit ERP
October 05, 2024, 09:30:49 am *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: Journalize Debtor Receipt at original invoice rate  (Read 1149 times)
0 Members and 0 Guests are viewing this topic.
Heart Informatisering B.V.
Partner
******
Offline Offline

Posts: 27469


View Profile WWW
« on: June 10, 2010, 11:46:36 am »

As from this Releasenote, a Financial Parameter "Valuate Debtor Receipts at original Currencyrate" has been added (Main Menu, 7-8-1-1 Page 2).

The parameter triggers new functionality for a customer in Poland.

Every financial invoice will now be supplied with the invoice rate at which this invoice was created. For example, if we would send someone an invoice for EUR 1.000,- at a PLN rate of 4.00, the system now nows that this invoice was invoiced at a rate of 4.00.

The parameter now causes an Debtor Receipt allways to be valuated at the original rate of the Invoice. Meaning, allthough the current rate of the EUR is 4.2 PLN, when the Debtor pays, the Debtor account will be valuated at the rate of PLN 4.0.

The Debtor who is originally debited for EUR 1.000,- x 4.0 will than also be credited for EUR 1.000,- x 4.0.

When the parameter is set to Yes, Debtors will not be revaluated in the Currency Revaluation run. All Debtor (but only the Debtors) will be skipped during this proces. A currency result will only be booked on payment of the invoice (and another PLN is written to your bankaccount than the rate at which the Debtor should be booked).

 Important:

The parameter only involves Debtor Payments on Debtor Accounts. Profit allows you to also book Foreign Currency's on other General Ledger Accounts, like f.e. your Bankaccount.

All other bookings (Creditors, Bankaccounts etc.) will not be effected by this Releasenote, and will not contain an original rate or so.

Meaning, if the Debtor pays EUR 1.000,- at a rate of 4,20 on your PLN Bankaccount, your journalisement will look like:

Bank           PLN 4.200,-

To Debtor                     EUR 1.000,- x 4,0 = PLN 4.000,-

To Currency Results                               PLN   200,-

But, if your debtor pays EUR 1.000,- into a EUR bankaccount, it will be journalised as EUR 1.000,- and the Journalisingdefinition books the EUR currency at the rate of 4.0 in this example.

Debtor Distribution Receipts are disabled when this parameter is set to Yes. This, because more than one currency rates are involved in this situation, cause we will probable want to register a Debtor Receipt at a rate of PLN 4.1 and while the actual rate is 4.2 book the 4.1 receipt on an invoice which was created at a rate of 4.0

Combine this with a payment discount of 2%, and the Debtor needs to be booked at EUR 1.000,- x PLN 4,0, the Distribution account should be booked at EUR 980,- x PLN 4,1, there is a discount of EUR 20,- x PLN 4.1 and we have a currency difference of EUR 1.000,- x PLN 0,10. Anyhow, too many variables for the current Journalising functionality. When using Batchbookings, this could work. As for now, it will not, and it's left out of this design.

This functionality is explicitly developped like this, and should only be used if you are happy with this.

In order to be able to register Debtor Receipts at their original Invoice rate, the Journalisingmodule had to be changed in order to have a subadministration set the Currencyrate at which should be journalised (also in Batchbookings). At this moment journalising at a different Currency rate is only used for Debtor Receipts.

FunktieOmschrijvingDtm.Vl.WyzDtm.L.Wyz
ADBKALRA    Raadplegen Fakturen op Bedrag/Deb.    11-11-2008    10-06-2010
ADBKBLRA    Raadplegen Faktuur betalingen    11-11-2008    10-06-2010
ADBKBLVW    Verwijderen Faktuurbetalingen    13-10-2009    10-06-2010
ADBKBO1     Doorboeken gegevens Dagboekjournalisering    15-05-2009    10-06-2010
ADBKDRV1    Omschrijving (nog) niet bekend    13-10-2009    10-06-2010
ADBKFURA    Raadplegen Uitgaande Fakturen    11-11-2008    10-06-2010
ADBKUORA    Raadplegen Openst.Fakt.Dagboek    11-11-2008    10-06-2010
ADBKUOTG    Omschrijving (nog) niet bekend    11-11-2008    10-06-2010
ADBOBBRA    Raadplegen Batchboekingen    21-01-2010    10-06-2010
ADBOTV1     Journaliseren    18-02-2010    07-06-2010
ADBOTV2     Omschrijving (nog) niet bekend    21-02-2008    07-06-2010
ADBOTV3     Omschrijving (nog) niet bekend    02-03-2007    07-06-2010
ADBOTV4     Genereren Batchboekingsregel    23-05-2008    10-06-2010
ADBOTVW2    Journalisering    28-05-2009    07-06-2010
ADBOTVW3    Omschrijving (nog) niet bekend    02-03-2007    08-06-2010
ADCBDERA    Distributie Ontvangsten    04-09-2007    09-06-2010
ADCBDETV    Toevoegen Distributie Ontvngst    03-02-2006    09-06-2010
ADCBDEVW    Verwijderen Distributie Ontvangst    13-08-2008    09-06-2010
ADCBUORA    Raadplegen Openstaande Fakture    04-09-2007    09-06-2010
ADDOVW      Verwijderen Debiteuren Ontvangst    18-02-2010    08-06-2010
ADFUDERA    Raadplegen Uitg. Fakturen op Debiteur    05-02-2010    08-06-2010
ADFURA      Raadplegen/Onderhoud Fakturen    05-02-2010    07-06-2010
ADINBE      Omschrijving (nog) niet bekend    16-04-2009    07-06-2010
ADINV       Omschrijving (nog) niet bekend    20-10-2009    07-06-2010
ADOVBK      Omschrijving (nog) niet bekend    21-08-2008    08-06-2010
ADPA        Parameters    09-03-2010    04-06-2010
ADPROADE    Printen Ouderdomsanalyse Deb.    22-07-2009    08-06-2010
ADPROAGN    Omschrijving (nog) niet bekend    22-07-2009    08-06-2010
ADPROPDE    Openstaande posten Debiteuren    09-04-2009    08-06-2010
ADUOAL      Afletteren Openst. Fakturen    04-09-2007    08-06-2010
ADUOALRA    Raadplegen Openst. Fakturen    31-12-2009    08-06-2010
ADUORA      Raadplegen Openst. Fakturen    05-09-2007    08-06-2010
ADUOTG      Omschrijving (nog) niet bekend    13-02-2006    08-06-2010
ADVAHV      Herwaarderen Valuta    22-10-2008    04-06-2010
ADVAHVOF    Omschrijving (nog) niet bekend    30-12-2008    04-06-2010
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1 RC2 | SMF © 2001-2005, Lewis Media Valid XHTML 1.0! Valid CSS!
Page created in 0.117 seconds with 20 queries.