The credit limit includes sales invoice tax and excludes order tax in Sales Order Processing in Microsoft Dynamics GP

To determine whether a document will put a customer over the credit limit, Microsoft Dynamics GP uses the following formula for a credit check: To obtain each amount in this formula, open the Customer Summary window. To open the Customer Summary window, click Cards, point to Sales, and then click Summary.

These amounts are defined as follows.If you have a document held in a batch, orders update the "On Order Amount" value by using the remaining subtotal that is in the document. This remaining subtotal does not include the following amounts:

• Trade discount
• Freight
• Miscellaneous
• Tax

If the remaining subtotal did include the amounts that are in this list, the "On Order Amount" value would be inaccurate. Therefore, Microsoft Dynamics GP does not consider the amounts in this list when the credit check is completed.

Steps to reproduce the behavior

Note The following steps refer to the Fabrikam company. Fabrikam is a fictitious company name that is used for demonstration in Microsoft Dynamics GP.

1. Create a customer. To do this, click Cards, click
   Sales, click
   Customer, and then specify the following settings:
   • Customer ID: Credit Test
   • Name: Credit Limit Test
   • Address:
     Primary
2. Set a credit limit. To do this, click
   Options in the Customer Maintenance window, and then specify the following setting:
   
   Credit Limit: Click the Amount option, and then type
   $106.00 in the field that becomes active.
3. Click OK.
4. Click Save. Then, close the
   Customer Maintenance window.
5. Create a sales order. To do this, click Transaction, click
   Sales, click
   Sales Transaction Entry, and then specify the following settings:
   • Type/Type ID: Order
   • Document No.: This field is populated by the default value.
   • Customer ID: Credit Test
   • Batch ID: SOP ORDERS
   • Currency ID: Z-US$
   • Item Number: 128 SDRAM
   • Unit Price: 100.00
   • Tax: 5.00
6. In the Sales Tax Summary Entry window, specify the following settings:
   
   • Tax Detail ID: AUSSTE-PS20N0
   • Tax Amount: $5.00
7. Click OK.
8. In the Sales Transaction Entry window, click Save.
9. Create a sales invoice. To do this, click
   Transaction, click Sales, click
   Sales Transaction Entry, and then specify the following settings:
   
   • Type/Type ID:
     Invoice
   • Document No.: This field is populated by the default value.
   • Customer ID: Credit Test
   • Batch ID: SOP ORDERS
   • Currency ID: Z-US$
   • Item Number: 128 SDRAM
   • Unit Price: 2.00
   • Tax: 7.00
10. In the Sales Tax Summary Entry window, specify the following settings:
    
    • Tax Detail ID: AUSSTE-PS20N0
    • Tax Amount: $7.00
    • Click OK.
11. In the Sales Transaction Entry window, click Save.
    
    Note In this second credit check, the override credit limit does not appear until after you complete steps 10 and 11. The tax amount on the order is not applied to the credit limit.
12. Delete the SOP ORDERS batch. To do this, click
    Sales on the Transaction menu, and then click
    Sales Batches.
13. In the Sales Batches Entry window, click SOP ORDERS in the Batch ID field, click
    Delete, and then close the Sales Batches Entry window.
14. Create a sales invoice. To do this, click
    Sales on the Transaction menu, click
    Sales Transaction Entry, and then specify the following values:
    
    • Type/Type ID: Invoice
    • Document No.: This field is populated by the default value.
    • Customer ID: Credit Test
    • Batch ID: SOP INVOICES
    • Currency ID: Z-US$
    • Item Number: 128 SDRAM
    • Unit Price: 100.00
    • Tax: 5.00
15. In the Sales Tax Summary Entry window, specify the following information:
    
    • Tax Detail ID:
      AUSSTE-PS20N0
    • Tax Amount: $5.00
      
16. Click OK.
17. In the Sales Transaction Entry window, click Save.
18. Create a sales invoice. To do this, click Transaction, click
    Sales, click
    Sales Transaction Entry, and then specify the following settings:
    
    • Type/Type ID: Invoice
    • Document No: This field is populated by the default value.
    • Customer ID: Credit Test
    • Batch ID: SOP INVOICES
    • Currency ID: Z-US$
    • Item Number: 128 SDRAM
    • Unit Price: 2.00
    Note In this second credit check, the override credit limit appears.