Override MEA amounts

When you create an MEA allocation, you have the option to override the MEA amounts calculated by Sage Intacct with your own values. This is usually a straightforward task of just ensuring that the total MEA amount equals the total extended transaction value.

However, if the MEA allocation includes Debook contract lines, Intacct imposes restrictions to ensure that the revenue data is reclassified correctly according to ASC 606 guidelines when a subsequent contract posting event occurs. You may receive an error message if you try to give value to both negative and positive lines when editing MEA amounts.

Override the MEA amount in an MEA allocation that does not contain Debook contract lines

  1. Open a contract in Edit mode.
  2. Start creating the MEA allocation as applicable. See steps 2 - 12 of Define an MEA allocation.

    After you select Preview MEA, the MEA allocation - Preview table appears.

    MEA allocation - Preview

    MEA allocation preview
    Bundle noLine noItemRateQuantityMultiplierInclude with every invoiceExt txn valueFair value priceExt fair value priceMEA percentMEA amount
    11Item A10.00101--100.008.0080.0051.948051

    94.12

    12Item B50.0011--50.0045.0045.0026.47058852.94
    13Item B50.0011--50.0045.0045.0026.47058852.94
    Total200.0098.00170.00 200.00

  3. Select in the MEA amount field for a contract line and input the desired value.
  4. Repeat step 3 as applicable. The total MEA amount must equal the total Ext txn value.

    MEA allocation - Preview

    MEA allocation preview
    Bundle noLine noItemRateQuantityMultiplierInclude with every invoiceExt txn valueFair value priceExt fair value priceMEA percentMEA amount
    11Item A10.00101--100.008.0080.0051.948051

    110.00

    12Item B50.0011--50.0045.0045.0026.470588

    40.00

    13Item B50.0011--50.0045.0045.0026.470588

    40.00

    Total200.0098.00170.00 200.00

  5. Select Apply MEA & save.

Override the MEA amount in an MEA allocation that contains Debook contract lines

When you include a Debook contract line in an MEA, you must also include at least one corresponding Sale contract line for the same item. For example, if you want to include a Debook contract line for Item A, you must also include at least one Sale contract line for Item A. The total extended transaction value of the Sale and Debook lines for the same item must be equal to or greater than zero.

The rules for overriding MEA amounts for Sale and Debook lines for the same item are as follows:

  • The MEA amount for a Debook line must be less than 0.00. If you want a negative line to have a 0.00 value in the MEA allocation, use a Discount/Credit contract line instead of a Debook contract line.
  • The MEA amount for a Sale line must be greater than or equal to 0.00.
  • Debook lines can only give value to or receive value from Sale lines for the same item. Debook lines cannot receive value from Discount/Credit lines.
  • If you increase the MEA amount for a Sales line, you must either decrease the MEA amount for a Debook line or leave it as is.
  • If you decrease the MEA amount for a Sales line, you must either increase the MEA amount for a Debook line or leave it as is.

The examples in this section refer to the following starting MEA allocation. The contract line with a negative quantity is the Debook line.

MEA allocation - Preview

MEA allocation preview
Bundle no Line no Item Rate Quantity Multiplier Include with every invoice Ext txn value Fair value price Ext fair value price MEA percent MEA amount
1 1 Item A 10.00 10 1 -- 100.00 8.00 80.00 51.948051

93.50

1 2 Item A 10.00 -2 1 -- -20.00 8.00 -16.00 -10.389610 -18.70
1 3 Item B 50.00 1 1 -- 50.00 45.00 45.00 26.470588

52.60

1 4 Item B 50.00 1 1 -- 50.00 45.00 45.00 26.470588

52.60

Total 180.00 106.00 154.00   180.00

Increase the default MEA amount for a Sale line in a Sale/Debook MEA allocation

  1. Determine the MEA amount for the Sale contract line that's associated with at least one Debook line for the same item.

    For example, say you have a Sales line for Item A with an Intacct-calculated MEA amount of 93.50. According to your company-specific MEA calculation process, you want the MEA amount to be 101.50. That's an increase of 8.00.

  2. Determine from which contract lines you are going to take the additional amount. You have the following options:
    • Decrease the Debook lines.

      In this example, we can decrease the Debook line for Item A from -18.70 to -26.70. This is a decrease of -8.00. If there were more than one Debook line for the same item, we could divide the decrease between the lines.

      MEA allocation - Preview

      MEA allocation preview
      Bundle noLine noItemRateQuantityMultiplierInclude with every invoiceExt txn valueFair value priceExt fair value priceMEA percentMEA amount
      11Item A10.00101--100.008.0080.0051.948051

      101.50

      12Item A10.00-21---20.008.00-16.00-10.389610-26.70
      13Item B50.0011--50.0045.0045.0026.470588

      52.60

      14Item B50.0011--50.0045.0045.0026.470588

      52.60

      Total180.00106.00154.00 180.00

    • Decrease the revenue for one or more Sale lines for items other than the Debook item.

      In this example, we can decrease the revenue for the Sale lines for Item B by 4.00 each. The new MEA amounts are 48.60.

      MEA allocation - Preview

      MEA allocation preview
      Bundle noLine noItemRateQuantityMultiplierInclude with every invoiceExt txn valueFair value priceExt fair value priceMEA percentMEA amount
      11Item A10.00101--100.008.0080.0051.948051

      101.50

      12Item A10.00-21---20.008.00-16.00-10.389610-18.70
      13Item B50.0011--50.0045.0045.0026.470588

      48.60

      14Item B50.0011--50.0045.0045.0026.470588

      48.60

      Total180.00106.00154.00 180.00

    • Decrease both the Debook line and one or more Sale lines for items other than the Debook item.

      In this example, we can decrease the Debook line by -4.00 and decrease the Sale lines for Item B by -2.00. The Debook line is now -22.70 and the Sale lines for Item B are 50.60.

      MEA allocation - Preview

      MEA allocation preview
      Bundle noLine noItemRateQuantityMultiplierInclude with every invoiceExt txn valueFair value priceExt fair value priceMEA percentMEA amount
      11Item A10.00101--100.008.0080.0051.948051

      101.50

      12Item A10.00-21---20.008.00-16.00-10.389610-22.70
      13Item B50.0011--50.0045.0045.0026.470588

      50.60

      14Item B50.0011--50.0045.0045.0026.470588

      50.60

      Total180.00106.00154.00 180.00

 

Decrease revenue for a Sale line in a Sale/Debook MEA allocation

  1. Determine the MEA amount for the Sale contract line that's associated with at least one Debook line for the same item.

    For example, say you have a Sales line for Item A with an Intacct-calculated MEA amount of 93.50. According to your company-specific MEA calculation process, you want the MEA amount to be 87.50. That's a decrease of -6.00.

  2. Determine to which contract lines you are going to give the additional amount. You have the following options:
    • Increase the Debook lines.

      In this example, we can increase the Debook line for Item A from -18.70 to -12.70. This is an increase of 6.00. If there were more than one Debook line for the same item, we could divide the increase between the lines.

      MEA allocation - Preview

      MEA allocation preview
      Bundle noLine noItemRateQuantityMultiplierInclude with every invoiceExt txn valueFair value priceExt fair value priceMEA percentMEA amount
      11Item A10.00101--100.008.0080.0051.948051

      88.50

      12Item A10.00-21---20.008.00-16.00-10.389610-12.70
      13Item B50.0011--50.0045.0045.0026.470588

      52.60

      14Item B50.0011--50.0045.0045.0026.470588

      52.60

      Total180.00106.00154.00 180.00

    • Increase the revenue for one or more Sale lines for items other than the Debook item.

      In this example, we can increase the revenue for the Sale lines for Item B by 3.00 each. The new MEA amounts are 55.60.

      MEA allocation - Preview

      MEA allocation preview
      Bundle noLine noItemRateQuantityMultiplierInclude with every invoiceExt txn valueFair value priceExt fair value priceMEA percentMEA amount
      11Item A10.00101--100.008.0080.0051.948051

      101.50

      12Item A10.00-21---20.008.00-16.00-10.389610-18.70
      13Item B50.0011--50.0045.0045.0026.470588

      55.60

      14Item B50.0011--50.0045.0045.0026.470588

      55.60

      Total180.00106.00154.00 180.00

    • Increase both the Debook line and one or more Sale lines for items other than the Debook item.

      In this example, we can increase the Debook line by 2.00 and increase each Sale lines for Item B by 2.00. The Debook line is now -16.70 and the Sale lines for Item B are both 54.60.

      MEA allocation - Preview

      MEA allocation preview
      Bundle noLine noItemRateQuantityMultiplierInclude with every invoiceExt txn valueFair value priceExt fair value priceMEA percentMEA amount
      11Item A10.00101--100.008.0080.0051.948051

      93.50

      12Item A10.00-21---20.008.00-16.00-10.389610-16.70
      13Item B50.0011--50.0045.0045.0026.470588

      54.60

      14Item B50.0011--50.0045.0045.0026.470588

      54.60

      Total180.00106.00154.00 180.00