|
Notes |
|
|
(0088610)
|
|
psanjuan
|
2016-07-21 10:56
(edited on: 2016-07-21 16:33) |
|
Issue verified by following Step by step process below:
- Install the Cash VAT module
- Go to Account tree window and select F&B España account tree. Go to element value an create a new one with below setup:
Search Key = 47700T
Name = HP IVA repercutido transitorio
Element level = Subaccount
Account Type =Liability
- Create another more with below setup:
Search Key = 47200T
Name = HP IVA soportado transitorio
Element level = Subaccount
Account Type =Asset
- Select now F&B Internation Group account tree. Go to element value an create a new one with below setup:
Search Key = 2260T
Name = Sales Tax Payable Transitory
Element level = Subaccount
Account Type =Liability
- Create another one with below setup
Search Key = 7410T
Name = Tax Expense Transitory
Element level = Subaccount
Account Type =Expense
- Go to General ledger configuration window, select F&B España one. Go to Defaults tab and enter below accounts in below listed fields.
Tax Due Transitory = 47700T
Tax Credit Transitory = 47200T
- Go to General ledger configuration window, select F&B International one. Go to Defaults tab and enter below accounts in below listed fields.
Tax Due Transitory = 2260T
Tax Credit Transitory = 7410T
- Go to tax rate window and create a new tax rate with below setup:
Name = Adquisiciones IVA 21% IVA de Caja
Valid from = 01-01-2016
Tax Category = IVA Normal
Rate = 21
Sales/Purchase Tax = Purchase Tax
Cash VAT Tax = Yes
Country/Destination Country = Spain
- Go to accounting tab and enter the ledgers accounts previously created for both general ledgers.
- Go to Purchase order window and create 3 new purchase orders set as Cash VAT = Yes (under More Information group of fields), for F&B España org and Bebidas Alegres BP.
Purchase order 1 - for instance (1000190). Product = Cerveza Ale 5L, 100 units.
Make sure cash vat tax rate just created is being used.
Book the order.
Purchase order 2 - for instance (1000191) - Product = Cerveza Larger 0.5L, 200 units. Make sure cash vat tax rate just created is being used.
Book the order.
Purchase order 3 - for instance (1000192) - Product = Vino Blanco, 50 units.
Make sure cash vat tax rate just created is being used.
Book the order.
- Go to Purchase Invoice and create 3 separate invoices set as CAsh VAT = Yes, from the purchase order created above (Create Lines From).
Purchase Invoice 1 (i.e. 10000897) with below data:
Total Gross Amount = 164.56
Total Net Amount = 136.00 (Taxable Amount)
Tax Amount = 28.53
Complete and Post the invoice and check below posting is shown:
F&B ESPAÑA EURO general ledger:
136.00 (60000) Compras DEBIT
28.56 (47200T) HP IVA soportado transitorio DEBIT
164.56 (40000) Proveedores CREDIT
F&B International Group Dollar general ledger:
142.80 (5360) Product Expense DEBIT
29.99 (7410T) Tax Expense Transitory DEBIT
172.79 (2110) Accounts Payable CREDIT
Purchase Invoice 2 (i.e. 10000898) with below data:
Total Gross Amount = 425.92
Total Net Amount = 352.00 (Taxable Amount)
Tax Amount = 73.92
Complete and Post the invoice and check below posting is shown:
F&B ESPAÑA EURO general ledger:
352.00 (60000) Compras DEBIT
73.92 (47200T) HP IVA soportado transitorio DEBIT
425.92 (40000) Proveedores CREDIT
F&B International Group Dollar general ledger:
369.60 (5360) Product Expense DEBIT
77.62 (7410T) Tax Expense Transitory DEBIT
447.22 (2110) Accounts Payable CREDIT
Purchase Invoice 3 (i.e. 10000899) with below data:
Total Gross Amount = 214.78
Total Net Amount = 177.50 (Taxable Amount)
Tax Amount = 37.28
Complete and Post the invoice and check below posting is shown:
F&B ESPAÑA EURO general ledger:
177.50 (60000) Compras DEBIT
37.28 (47200T) HP IVA soportado transitorio DEBIT
214.78 (40000) Proveedores CREDIT
F&B International Group Dollar general ledger:
186.38 (5360) Product Expense DEBIT
39.14 (7410T) Tax Expense Transitory DEBIT
225.52(2110) Accounts Payable CREDIT
- Go to Payment Out window and create a new payment for F&B España, Bebidas Alegres BP. Select the 3 invoices above through button Add Details.
Post the payment.
Below error is shown.
Correct posting should been:
805.26 (40000) Proveedores DEBIT
37.28 (47200) HP IVA soportado DEBIT
73.92 (47200) HP IVA soportado DEBIT
28.56 (47200) HP IVA soportado DEBIT
805.26 (57200) Bancos CREDIT
37.28 (47200T) HP IVA soportado transitorio CREDIT
73.92 (47200T) HP IVA soportado transitorio CREDIT
28.56 (47200T) HP IVA soportado transitorio CREDIT
|
|
|
|
|
|
It also fails with 2 invoices. |
|
|
|
(0088716)
|
|
hgbot
|
|
2016-08-02 08:53
|
|
Repository: erp/devel/pi
Changeset: 429081c6bccb9c9992499c4c472615e8d1df7dcd
Author: Mark <markmm82 <at> gmail.com>
Date: Tue Jul 26 14:43:28 2016 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/429081c6bccb9c9992499c4c472615e8d1df7dcd [^]
Fixes issue 33508: Error posting Cash VAT payment if pays more than one invoice
When trying to post a Cash VAT payment that pays more than one invoice, process was failing and an error was shown. It was caused by a clearing of the session when iterating on the cash vat invoices list. To avoid it, list of cash vat ids are retrieved instead a list of InvoiceTaxCashVAT_V.
---
M src/org/openbravo/erpCommon/ad_forms/DocLineCashVATReady_PaymentTransactionReconciliation.java
M src/org/openbravo/erpCommon/utility/CashVATUtil.java
---
|
|
|
|
(0088717)
|
|
hgbot
|
|
2016-08-02 08:53
|
|
Repository: erp/devel/pi
Changeset: 7ebe0a53a4253297fe27348f86a445297f567bdb
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Aug 01 13:21:44 2016 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/7ebe0a53a4253297fe27348f86a445297f567bdb [^]
Related to issue 33508: Code review improvements
Set invoiceTaxCashVAT_V variable as private.
Keep getInvoiceTaxCashVAT_V and setInvoiceTaxCashVAT_V methods as deprecated to avoid API change.
Add distinct to setInvoiceTaxCashVAT_V query to avoid retrieve duplicated ids.
---
M src/org/openbravo/erpCommon/ad_forms/DocLineCashVATReady_PaymentTransactionReconciliation.java
M src/org/openbravo/erpCommon/utility/CashVATUtil.java
---
|
|
|
|
(0088749)
|
|
hgbot
|
|
2016-08-02 15:11
|
|
Repository: erp/mods/org.openbravo.module.cashvat
Changeset: febb490051c5ac0b318ebfa71dfbbe104b723201
Author: Mark <markmm82 <at> gmail.com>
Date: Tue Jul 26 14:46:44 2016 -0400
URL: http://code.openbravo.com/erp/mods/org.openbravo.module.cashvat/rev/febb490051c5ac0b318ebfa71dfbbe104b723201 [^]
Related to issue 33508: Adapt DocManualSettlementCashVAT to API change
When trying to post a Cash VAT payment that pays more than one invoice, process was failing and an error was shown. It was caused by a clearing of the session when iterating on the cash vat invoices list. To avoid it, list of cash vat ids are retrieved instead a list of InvoiceTaxCashVAT_V and DocManualSettlementCashVAT is adapted to this change of the API.
---
M src/org/openbravo/module/cashvat/accounting/DocManualSettlementCashVAT.java
---
|
|
|
|
(0088750)
|
|
hgbot
|
|
2016-08-02 15:11
|
|
|
|
|
(0088751)
|
|
hgbot
|
|
2016-08-02 15:12
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Issue_33508.png (120,380) 2016-07-21 16:30