Annual report 347 filling in when vendor changes cash accounting schema to normal VAT in the Spanish version of Microsoft Dynamics 2012 R3 and Microsoft Dynamics AX 2009 SP1

This article applies to Microsoft Dynamics AX for the Spanish (es) region.

When the supplier (vendor) changes taxation policy from cash accounting schema to general one in the Spanish version of Microsoft Dynamics AX 2012 R3 and Microsoft Dynamics AX 2009 SP1, the 347 report for year must reflect amounts posted under different taxation policies separately.

In case when the supplier (vendor) changes his taxation policy from cash accounting schema to general one (for instance, 2014 – CAS, 2015 – non-CAS), the 347 report for year 2015 must reflect amounts posted under different taxation policies separately. Current implementation does not support this scenario, the amounts under cash accounting regime for the previous year are not reported in the reporting year on 347 report.

This hotfix resolves this issue: in case when the supplier (vendor) had a cash accounting schema in previous year, then in current year all invoices posted in previous year that stayed open (not fully settled) up to the beginning of the reporting year are collected and reported under cash accounting regime.

With this hotfix, the processing of prepayments is updated as well: they are reported independently of the cash ledger accounts setting.

To store history of taxation policy switching, instead of a check box Special regime for cash accounting method in General ledger parameters and in Vendor form a new form of the same namewas introduced. It is called from:

For Microsoft Dynamics AX 2009 SP1:
General ledger > Setup > Parameters > Sales tax tab > Special regime for cash accounting method button
Accounts payable > Vendors > Setup button > Special regime for cash accounting method menu item

For Microsoft Dynamics AX 2012 R3:
General ledger> Setup > General ledger parameters > Sales tax tab > Special regime for cash accounting method 
Accounts payable > Vendors > Invoice and Delivery fast tab > Special regime for cash accounting method link under Spanish VAT books group 

This new form Special regime for cash accounting method has three fields From year, To Year, and Enable. In case the policy should be changed, add a new record in there.

When changing policy for the 1st time, set the From Year field with the value when a new policy is enforced. The To year field is left blank and not editable. Enable check box is set to Yes (it is also not editable).

When you need to change policy once more, you should create one more record and set From Year with the value when a new policy is applied. The system updates the To year field for the previous record (policy) automatically, the Enable check box is also updated automatically, depending on the value in the previous record, it switches to the opposite value.

It is allowed to delete records in a chronological order only, starting form the greatest value of the year.

NOTE Before installing a fix you need to identify all vendors with a Cash accounting check box switched on, and store a list of them. After installing the fix, you should update the state for these vendors manually or you can utilize the sample of the script below. In case your company applies a Cash accounting regime, you should update the table in the General ledger parameters.

Sample of the update script which creates a record in the new table for Microsoft Dynamics AX 2012 R3:

staticvoid updateCashAccounting(Args _args)
{
    container vendAccounts = ['AAA', 'BBB', 'CCC']; //List of vendor accounts in single or double quotes
    int sinceYear = 2014; //set the start year for applying a Cash accounting policy
    int i ;
    VendTable   vendTable;
    CashAccountingRegime_ES cashAccountingRegime;   
    for (i = 1; i <= conLen(vendAccounts); i++)
    {
        vendTable = VendTable::find(conPeek(vendAccounts, i));
        cashAccountingRegime.clear();
        cashAccountingRegime.Party = vendTable.Party;
        cashAccountingRegime.VendAccount = vendTable.AccountNum;
        cashAccountingRegime.FromYear = sinceYear;
        cashAccountingRegime.Enable = true;
        cashAccountingRegime.insert();
    }   
}