When you try to post a transaction in Purchase Order Processing on Microsoft Dynamics GP 2010 SP 1 or Microsoft Dynamics GP 10.0 SP 5 you receive an error message: **ERROR: The tax detail record doesn't exist or is assigned to two accounts.

Beginning with Microsoft Dynamics GP 2010 Service Pack 1 and Microsoft Dynamics GP 10.0 Service Pack 5, an additional check was put in place before posting a transaction to ensure that shipment/invoice or invoice documents with multiple lines that have a single tax detail with different distribution accounts assigned to them could not be posted. This was done as an interim fix for another issue that requires additional changes that could not be made in the service pack timeline. If this check fails, the following error message will be presented, and the transaction will not post. 

 

Although Purchase Order Processing shipment/invoice and invoice transactions allow multiple accounts to be assigned to the same tax detail, the data model of the Payables Tax table, PM10500, does not allow for a document to have a single tax detail with multiple distribution accounts. Because of this restriction, on previous versions, users with the same configuration encountering the message now received in Microsoft Dynamics GP 2010 Service Pack 1 and Microsoft Dynamics GP 10.0 Serivce Pack 5 would have received the following error on their posting journals:


With this error message on previous versions, the transaction posting would have processed and would have appeared to complete. However, the Payables tax table (PM10500) would have been incomplete as it would only have had the first account line and the additional account lines for the document and tax detail combination would not have existed.