Openbravo Issue Tracking System - Modules
View Issue Details
0030036ModulesRemittancepublic2015-05-28 09:422015-08-21 09:39
psanjuan 
AtulOpenbravo 
urgentmajoralways
scheduledopen 
20Ubuntu 8.04.1
 
 
0030036: Remittance including an order does not properly manage accounting if the remittance is reactivated (same applies to sales)
Remittance including an order does not properly manage accounting if the remittance is reactivated (same applies to sales)
Install Remittance module and apply remittance dataset in F&B España organization.
All steps described below need to be done in F&B España.

Go to Conversion rate window and make sure that below conversion rates are configured:
From 01-04-2015 to 30-06-2015 EUR to USD 0.735294
From 01-07-2015 to 30-09-2015 EUR to USD 0.571429

Navigate to payment method window and create a new one with below setup:
Name = Payment Out remittance
Payment Out Allowed = Yes
Execution Type = Automatic
Execution Process = In Remittance
Deferred = Yes

Navigate to remittance type and create a new one with below setup:

Name = Payment Out Remittance
Payment Method = Payment Out remittance
Posting Allowed = Yes

Accounting tab:
F&B España - Settlement account (57200), Sent Account (40100)
F&B International - Settlement account (1110), Sent Account (1120)

Go to purchase order window and create a new one (ie PO 129) for Bebidas Alegres, dated on 28-05-2015, Product = Cerveza Ale 0.5L, for a total line net amount = 1000.00 EUR
Book the order

Navigate to Remittance window and create a new one with below setup:
Remittance Type = Payment Out Remittance
Transaction Date = 28-05-2015
Expected Date = 30-07-2015
Name = Remesa PO
Save

Click on Select Orders or Invoices. Once in that new window select "Orders" in the field "Document". Click on "Show payments for alternative payment methods" and select purchase order just created PO 129. Press Process.

Process and Post the remittance. Check below posting which is correct:

1210.00 (40700) Anticipo proveedores - Debit
1210.00 (40100) Proveedores efectos - Credit

889.71 (1410) Vendor Prepayment - Debit (1210.00 *0.735294)
889.71 (1120) Funds in Transfer- Credit

Go to Purchase Invoice window and create a new one dated on 30-07-2015 for Bebidas Alegres. Add lines by using "Create Lines From" process button. Select order 129 in our example.

Complete and post the Invocice.

Invoice posting would look like:

1000.00 (60000) Compra de mercaderías
210.00 (47200) HP IVA sop
1210.00 (40700) Anticipos a proveedores

Above posting is correct.

Realize that no amount is shown in the field "Prepayment Amount" in the purchase invoice and that is not correct.

Go back once again to the remittance, Unpost it and reactivate it.

After that, Process and Post it again.

This time posting would look like below, which is NOT correct, as no Vendor Prepayment account is being used while it should be.

889.71 (2110) Accounts Payable - Debit
889.71 (1120) Funds in Transfer - Credit

1210.00 (40000) Proveedores - Debit
1210.00 (40100) Proveedores efectos - Credit









Last posting after remittance has been reactivated should point once more to vendor prepayment accounts.

Correct last posting is:

889.71 (1410) Vendor Prepayment - Debit
889.71 (1120) Funds in Transfer - Credit

1210.00 (40700) Anticipo proveedores - Debit
1210.00 (40100) Proveedores efectos - Credit
No tags attached.
Issue History
2015-05-28 09:42psanjuanNew Issue
2015-05-28 09:42psanjuanAssigned To => Triage Finance
2015-05-28 09:53psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8685#r8685
2015-05-28 09:53psanjuanProposed Solution updated
2015-05-28 09:56psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8686#r8686
2015-05-28 09:56psanjuanProposed Solution updated
2015-05-28 13:06psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=8693#r8693
2015-05-28 13:44psanjuanSummaryRemittance including an order does not properly manage accounting if the remittance is reactivated => Remittance including an order does not properly manage accounting if the remittance is reactivated (same applies to sales)
2015-05-28 13:44psanjuanDescription Updatedbug_revision_view_page.php?rev_id=8699#r8699
2015-08-21 09:39AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2015-08-21 09:39AtulOpenbravoStatusnew => scheduled

There are no notes attached to this issue.