Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0030036
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Remittancemajoralways2015-05-28 09:422015-08-21 09:39
ReporterpsanjuanView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionopenFixed in Version
StatusscheduledFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0030036: Remittance including an order does not properly manage accounting if the remittance is reactivated (same applies to sales)

DescriptionRemittance including an order does not properly manage accounting if the remittance is reactivated (same applies to sales)
Steps To ReproduceInstall 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









Proposed SolutionLast 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-05-28 09:42 psanjuan New Issue
2015-05-28 09:42 psanjuan Assigned To => Triage Finance
2015-05-28 09:53 psanjuan Steps to Reproduce Updated View Revisions
2015-05-28 09:53 psanjuan Proposed Solution updated
2015-05-28 09:56 psanjuan Steps to Reproduce Updated View Revisions
2015-05-28 09:56 psanjuan Proposed Solution updated
2015-05-28 13:06 psanjuan Steps to Reproduce Updated View Revisions
2015-05-28 13:44 psanjuan Summary Remittance 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:44 psanjuan Description Updated View Revisions
2015-08-21 09:39 AtulOpenbravo Assigned To Triage Finance => AtulOpenbravo
2015-08-21 09:39 AtulOpenbravo Status new => scheduled


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker