Project:
| View Revisions: Issue #30036 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0030036: Remittance including an order does not properly manage accounting if the remittance is reactivated (same applies to sales) | ||
| Revision | 2015-05-28 13:06 by psanjuan | ||
| Steps To Reproduce | 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 |
||
| Revision | 2015-05-28 09:56 by psanjuan | ||
| Steps To Reproduce | 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. 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 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. 889.71 (2110) Accounts Payable - Debit 889.71 (1120) Funds in Transfer - Credit 1210.00 (40000) Proveedores - Debit 1210.00 (40100) Proveedores efectos - Credit |
||
| Revision | 2015-05-28 09:53 by psanjuan | ||
| Steps To Reproduce | 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. 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 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. 889.71 (1410) Vendor Prepayment - Debit 889.71 (1120) Funds in Transfer - Credit 1210.00 (40000) Proveedores - Debit 1210.00 (40100) Proveedores efectos - Credit |
||
| Revision | 2015-05-28 09:42 by psanjuan | ||
| Steps To Reproduce | 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. 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 (PO 128) 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 = 20-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 128. 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 889.71 (1120) - Credit |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |