ZBA (ТМЦ): различия между версиями

Материал из JD Edwards E1
Перейти к навигации Перейти к поиску
м
 
(не показана 51 промежуточная версия этого же участника)
Строка 1: Строка 1:
−
Sales and Manufacturing
+
'''Корректировки нулевого баланса''' или '''Zero Balance Adjustments (ZBA)''' - корректировки суммы запасов в Главной книге, которые создаются некоторыми приложениями, если количество запасов становится равным нулю, в то время как в Главной книге еще остаются затраты.
 +
 
 +
Система создает корректирующую проводку в Главной книге, если кол-во запасов (On-Hand) становится равным нулю, а стоимость этого товара не становится равным нулю.
 +
 
 +
Система создает ZBA для всех Методов калькуляции запасов [inventory cost methods], указанных в F4105, кроме 07-Стандартный [Standard Cost], т.к. [[отклонение по стандартной стоимости]] имеет приоритет над отклонениями по корректировке нулевого баланса (в случае двух отклонений одно должно иметь приоритет над другим).
 +
 
 +
Шаги для повторения (пример через списание запасов):
 +
# Проверить настройки.
 +
# Выполнить корректировку/пополнение запасов, например, 10 шт. по стоимости $100. (P4114)
 +
# Выполнить списание запасов, например, 10 шт. по стоимости $90. (P4112)
 +
#: Система создает в ГК стандартные проводки списания...:
 +
#:: Дб 4124 (Expense or COGS):            $900.00
 +
#:: Кт 4122 (Inventory):                -$900.00
 +
#: ... и ZBA создает в ГК дополнительные проводки:
 +
#:: Дб 4128 (ZBA - Expense or COGS):      $100.00
 +
#:: Кт 4126 (ZBA - Inventory):          -$100.00
 +
 
 +
=== Запасы (Inventory) ===
 +
 
 +
;Используемые АИ (DMAAI):
 +
* 4126 – ZBA - Inventory
 +
* 4128 – ZBA - COGS or Expense
 +
 
 +
;Используемые приложения:
 +
* P4112 – Inventory Issues
 +
* P4113 – Inventory Transfers
 +
* P4114 – Inventory Adjustments
 +
* P4116 – Inventory Reclassification
 +
 
 +
;Сценарий:
 +
The inventory quantity goes to zero as a result of a an issue transaction, but there is still an amount remaining in the G/L.
 +
 
 +
;Почему запас изменил себестоимость:
 +
The cost in the transaction that reduces the quantity on hand to zero is different than it was when the quantity was originally received or adjusted in. This typically happens when an item’s Sales/Inventory cost value is updated, and subsequently the item goes out of stock.
 +
 
 +
;Шаги для повторения (пример через списание запасов):
 +
# Проверить настройки.
 +
# Выполнить корректировку/пополнение запасов, например, 10 шт. по стоимости $100. (P4114)
 +
# Выполнить списание запасов, например, 10 шт. по стоимости $90. (P4112)
 +
#: Система создает в ГК стандартные проводки списания...:
 +
#:: Дб 4124 (Expense or COGS):            $900.00
 +
#:: Кт 4122 (Inventory):                -$900.00
 +
#: ... и ZBA создает в ГК дополнительные проводки:
 +
#:: Дб 4128 (ZBA - Expense or COGS):      $100.00
 +
#:: Кт 4126 (ZBA - Inventory):          -$100.00
 +
 
 +
;Special scenario: If the transaction is not a reversal, the item is costed at level 3 (location/lot) and the transaction contains multiple lines for the same item and location/lot number but different costs, the error "Line causes a zero balance adjustment" (41010) will be issued to prevent an inaccurate ZBA calculation. The system is not designed to be able to calculate a ZBA accurately in a transaction containing multiple costs. Therefore, if inventory transactions containing multiple costs are necessary, they must be performed one at a time.
 +
 
 +
=== Закупка (Purchasing) ===
 +
;Используемые АИ (DMAAI):
 +
* 4400 – Inventory
 +
* 4405 – COGS or Expense
 +
 
 +
;Используемые приложения:
 +
* P4312 – Enter Receipts by Purchase Order or by Item
 +
 
 +
;Сценарий:
 +
The inventory quantity goes to zero as a result of a negative quantity on a purchase order being received or a receipt is reversed and there is still a positive or negative cost for the item in the G/L.
 +
 
 +
;Почему запас изменил себестоимость:
 +
The cost in the transaction that reduces the quantity on hand to zero is different than it was when the quantity was originally received or adjusted in. This typically happens when an item’s Sales/Inventory cost value is updated, and subsequently the item goes out of stock.
 +
 
 +
;Шаги для повторения (пример через списание запасов - Отрицательное ЗНЗ):
 +
# Проверить настройки.
 +
# Выполнить корректировку/пополнение запасов, например, 25 шт. по стоимости $5. (P4114)
 +
# Создать отрицательный ЗНЗ, например, -25 шт. по стоимости $4. (P4310)
 +
# Оприходовать отрицательный ЗНЗ со строкой -25 шт. по стоимости $4. (P4312)
 +
#: Система создает в ГК стандартные проводки ...:
 +
#:: Дб 4310 (Inventory):              -$100.00
 +
#:: Кт 4320 (Received Not Vouchered):  $100.00
 +
#: ... и ZBA создает в ГК дополнительные проводки:
 +
#:: Дб 4400 (ZBA - Inventory):        -$25.00
 +
#:: Кт 4405 (ZBA - COGS or Expense):    $25.00
 +
 
 +
=== Продажа (Sales) и Производство (Manufacturing) ===
  
 
Prior to an enhancement in EnterpriseOne 9.2, the Sales system was not designed to create journal entries for zero balance adjustments. A zero balance (ZBA) adjustment record is written in the Item Ledger (F4111) since average cost in F4105 is different than the transaction cost. Thus, the difference will be written in F4111 as the ZBA. The P4205 and R42800 are both capable of creating a ZBA transaction in the Cardex to record any cost corrections, but R42800 will not generate journal entries for the cost change. Manual entries for the cost change are required to updated the General Ledger.
 
Prior to an enhancement in EnterpriseOne 9.2, the Sales system was not designed to create journal entries for zero balance adjustments. A zero balance (ZBA) adjustment record is written in the Item Ledger (F4111) since average cost in F4105 is different than the transaction cost. Thus, the difference will be written in F4111 as the ZBA. The P4205 and R42800 are both capable of creating a ZBA transaction in the Cardex to record any cost corrections, but R42800 will not generate journal entries for the cost change. Manual entries for the cost change are required to updated the General Ledger.
  
−
In 9.2, enhanced functionality for zero balance adjustments in sales has been added. See 2640788.1
+
In 9.2, enhanced functionality for zero balance adjustments in sales has been added (See 2640788.1) for Sales Update (R42800) and Inventory Integrity.
  
 
The Manufacturing system does not invoke zero balance adjustment functionality. For Actual Costed work orders using Cost Method 09 or 02, the Manufacturing Accounting Journal Entries (R31802A) and Manufacturing Work Order Variance (R31804) Journal Entries Reports will report any adjustments necessary and restate costs as needed.
 
The Manufacturing system does not invoke zero balance adjustment functionality. For Actual Costed work orders using Cost Method 09 or 02, the Manufacturing Accounting Journal Entries (R31802A) and Manufacturing Work Order Variance (R31804) Journal Entries Reports will report any adjustments necessary and restate costs as needed.
  
−
До Application EnterpriseOne 9.2 модуль Продажи не был разработан для создания записей журнала для корректировок нулевого баланса. Запись корректировки нулевого баланса (ZBA) записывается в книгу учета товаров (F4111), поскольку средняя стоимость в F4105 отличается от стоимости транзакции. Таким образом, разница будет записана в F4111 как ZBA. P4205 и R42800 оба способны создавать транзакцию ZBA в Cardex для записи любых корректировок стоимости, но R42800 не будет создавать записи журнала для изменения стоимости. Для обновления Главной книги требуются ручные записи для изменения стоимости.
+
---
 +
 
 +
'''До Application EnterpriseOne 9.2''' модуль Продажи не был разработан для создания записей журнала для корректировок нулевого баланса. Запись корректировки нулевого баланса (ZBA) записывается в книгу учета товаров (F4111) с момента как средняя себестоимость в F4105 отличается от себестоимости транзакции. Таким образом, разница будет записана в F4111 как ZBA. P4205 и R42800 оба способны создавать транзакцию ZBA в Cardex для записи любых корректировок стоимости, но R42800 не будет создавать журнальные записи для изменения стоимости. Для обновления Главной книги требуется использовать ручные записи для изменения стоимости.
 +
 
 +
'''Начиная с Application EnterpriseOne 9.2''' была добавлена ​​расширенная функциональность для ZBA в продажах для Sales Update (R42800) и Inventory Integrity.
 +
 +
;Sales Update (R42800)
 +
Sales Update (R42800) has been enhanced in the 9.2 release to create zero balance adjustment account ledger entries (F0911) for all cost methods. Logic to validate new AAIs 4226 (Inventory) and 4228 (Expense or COGS) has been added to Sales Update (R42800).
 +
 
 +
;Inventory Integrity
 +
Inventory integrity reports have been modified to utilize the new AAIs 4226 (Inventory) and 4228 (Expense or COGS) to identify any integrity issue between the Item Ledger (F4111) and the Account Ledger (F0911) for zero balance adjustment entries so that these can be identified, if any exist and corrected for the differences.
 +
 
 +
 
 +
; New AAIs Added for Zero Balance Adjustment
 +
* '''Inventory (4226)''' - Provides the inventory offset account for journal entries that are created for zero balance adjustments. During sales update, the system debits this account to record the cost adjustments in the Account Ledger table (F0911) when the on-hand quantity is zero while there is still a cost in the G/L.
 +
* '''Expense or COGS (4228)''' - Provides the expense or cost of goods offset account for journal entries that are created for zero balance adjustments. During sales update, the system credits this account to record the cost adjustments in the Account Ledger table (F0911) when the on-hand quantity is zero while there is still a cost in the G/L.
 +
 
 +
=== Inventory Cost Levels and ZBA Adjustments ===
 +
Starting with 8.11 SP1, if the Inventory Cost Level is set to 2 (Item/Branch Only), then you will see a Zero Balance Adjustment in Item Ledger only when on hand quantity for the entire Branch goes to zero. If the Inventory Cost Level is set to 3 (Item/Branch/Location/Lot), then ZBA will occur for every location that goes to zero on hand quantity.
 +
 
 +
Prior to 8.11 SP1, the ZBA is created every time the on hand quantity becomes zero for a location regardless of the Inventory Cost Level.
 +
 
 +
=== Non-creation of ZBA due to rounding in the F4111 ===
 +
When a Purchase Order is created for an item for which the Primary UOM and Purchasing UOM differ and the user
 +
overrides unit cost for Purchasing, the unit cost for Primary UOM is calculated by the system using the UOM conversion
 +
set up. This calculated unit cost is rounded off to number of decimal places defined in Data Dictionary for UNCS (4) and
 +
is updated in Item Cost (F4105) file. When inquiring in the Cardex (F4111), the Extended Amount in header differs
 +
from the Extended Amount in detail. Thereafter, when a full inventory issue is made for that item then the Cardex is
 +
updated with an extended amount. There may seem to be a discrepancy due to difference between PO Receipt (P4312)
 +
and Inventory Issue (P4112). But this difference is resulting from rounding issues and is not a basis to generate zero
 +
balance transactions.
 +
 
 +
Когда Заказ на закупку создается для товара, для которого основная ЕИ и ЕИ закупки различаются, и пользователь переопределяет себестоимость для закупки, себестоимость основной ЕИ рассчитывается системой с использованием настройки преобразования единиц измерения. Эта рассчитанная себестоимость единицы измерения округляется до количества десятичных знаков, определенного в словаре данных для UNCS (4), и обновляется в файле стоимости товара (F4105). При запросе в Cardex (F4111) расширенная сумма в заголовке отличается от расширенной суммы в деталях. После этого, когда для этого товара выполняется полный отпуск инвентаря, Cardex обновляется с расширенной суммой. Может показаться, что существует расхождение из-за разницы между поступлением заказа на закупку (P4312) и отпуском инвентаря (P4112). Но эта разница возникает из-за проблем округления и не является основанием для создания транзакций с нулевым балансом.
 +
 
 +
----
 +
 
 +
=== Illustration of Calculations===
 +
 
 +
# Create an item with Primary UOM as EA, Secondary and Purchasing UOM as BX (No dual UOM setup).
 +
# In UOM conversion, set up the conversion as 1 BX equal to 600 EA.
 +
# At Purchase Orders (P4310) application, enter a Domestic order for the new item with the Transaction quantity/UOM = 45000/EA, Secondary quantity/UOM = 75/BX, Purchasing UM = BX and override the unit cost to $141.5094. So, the extended amount will be $10,613.21 (= 75 BX * 141.5094)
 +
# At PO Receipts (P4312) application, receive this order. On receipt, the unit cost for EA will be calculated as $141.5094/600 = 0.235849 which will be rounded off to number of decimal places defined in DD for UNCS (4) and then this value will be updated to Item Cost (F4105) file.
 +
# Consequently, in Cost Revisions (P4105) application all the costs i.e. 02 Sales/Inventory, 08 Purchasing and 01 Last-in costs will be updated as 0.2358. (=$141.5094/600).
 +
# In Cardex, the system will update the transaction quantity as 45000 EA, unit cost as 0.2358 and extended amount as $10613.21. However, on Work with Item Ledger form in Cardex header, the Quantity On Hand value will be $10,611.00 (0.2358 * 45000). A difference of $2.21 ($10613.21 -$10,611.00) will appear between value in header and value in detail.
 +
#*On performing a full inventory issue for 45000 EA at a cost of 0.2358, the Cardex will be updated with the extended amount as $10,611. No zero balance adjustment entry will be generated. However, in the cardex detail there will still be a balance of $2.21 due to the difference between PO Receipt (P4312) and Inventory Issue (P4112).
 +
 
 +
----
 +
=== eason for the Difference in Item Ledger/Cardex (F4111)===
 +
 
 +
This is an aspect that is caused by rounding off when calculating the Unit Cost. As stated, the item does not have a unit cost when the Purchase Order is entered. When the order is received for an extended amount (i.e. 75 * 141.5049 = $10613.21), the unit cost is calculated by the system (i.e. 0.235849) and rounded off to 4 decimal places (i.e. 0.2358) and is updated in Item Cost (F4105) file. When viewing the Cardex, the Quantity On hand value field displayed on the header is calculated by multiplying quantity and F4105 unit cost (i.e. 45000 * 0.2358 = $10611). Since the unit cost has been rounded off we see the effects of the rounding when the value is calculated. This is a scenario that could happen irrespective of the number of decimals used for rounding.
 +
----
 +
=== Conclusion===
 +
 
 +
To eliminate the residual amounts, a change was made to allow an Amount Only adjustment using Inventory Adjustments (P4114). The functionality is part of base functionality beginning with release 9.0.
 +
 
 +
== Doc ID 2640788.1 ==
 +
==== Summary ====
 +
 
 +
Sales Update (R42800) has been enhanced in the 9.2 release to create zero balance adjustment general ledger entries (F0911) for all cost methods. Prior to the enhancement, zero balance adjustments were written only for cost method 07, standard cost. The enhancement was requested in Bug 10746070 - ZERO BALANCE ADJUSTMENT.
 +
 
 +
=== Solution===
 +
 
 +
==== Overview ====
 +
 
 +
Historically, zero balance adjustments created at Shipment Confirmation (P4205) or Sales Update (R42800) did not update the Account Ledger (F0911). There were no Automatic Accounting Instructions (AAIs) to record the entries. As a result, zero balance adjustments in the Item Ledger did not reconcile and the Account Ledger was incorrect. Sales Update was not creating the General Ledger entry for cost methods other than cost method 07, standard cost, for zero balance adjustments.
 +
 
 +
==== Sales Update (R42800)====
 +
 
 +
Sales Update (R42800) has been enhanced in the 9.2 release to create zero balance adjustment account ledger entries (F0911) for all cost methods. Logic to validate new AAIs 4226 (Inventory) and 4228 (Expense or COGS) has been added to Sales Update (R42800).
 +
Inventory Integrity
 +
 
 +
Inventory integrity reports have been modified to utilize the new AAIs 4226 (Inventory) and 4228 (Expense or COGS) to identify any integrity issue between the Item Ledger (F4111) and the Account Ledger (F0911) for zero balance adjustment entries so that these can be identified, if any exist and corrected for the differences.
 +
 
 +
-----
 +
 
 +
==== Enhancement ESUs Available ====
 +
 
 +
The enhanced functionality is available in the ESUs for the following Bugs. Both ESUs must be installed for the complete solution
 +
 
 +
* Bug 30337169
 +
* Bug 30672005
 +
 
 +
ESU Objects Updated
 +
* B4200520 Get Sales AAIs And Call F0911 Edit Line
 +
* D4200520 GetSalesAAIsAndCallF0911EditLine
 +
* D4208030A Fetch ZBA Cache
 +
* R42800 Sales Update
 +
* B4208030 Inventory and Sales Cache Fetch
 +
* B4100910 F4111 - Check Integrity With F0911
 +
----
 +
 
 +
==== New AAIs Added for Zero Balance Adjustment ====
 +
 
 +
Inventory (4226) - Provides the inventory offset account for journal entries that are created for zero balance adjustments. During sales update, the system debits this account to record the cost adjustments in the Account Ledger table (F0911) when the on-hand quantity is zero while there is still a cost in the G/L.
 +
 
 +
Expense or COGS (4228) - Provides the expense or cost of goods offset account for journal entries that are created for zero balance adjustments. During sales update, the system credits this account to record the cost adjustments in the Account Ledger table (F0911) when the on-hand quantity is zero while there is still a cost in the G/L.
 +
 
 +
Note: AAIs 4226 and 4228 need to be added to the environment after the ESUs are installed.
  
−
Начиная с Application EnterpriseOne 9.2 была добавлена ​​расширенная функциональность для корректировок нулевого баланса в продажах. См. 2640788.1
+
== Ссылки ==
 +
* E1: 41: Zero Balance Adjustments (Doc ID 625466.1)
 +
* E1: 42: Sales Update (R42800) Creates Zero Balance Adjustment General Ledger Entries (F0911) for All Cost Methods (Doc ID 2640788.1)

Текущая версия на 17:33, 20 января 2026

Корректировки нулевого баланса или Zero Balance Adjustments (ZBA) - корректировки суммы запасов в Главной книге, которые создаются некоторыми приложениями, если количество запасов становится равным нулю, в то время как в Главной книге еще остаются затраты.

Система создает корректирующую проводку в Главной книге, если кол-во запасов (On-Hand) становится равным нулю, а стоимость этого товара не становится равным нулю. 

Система создает ZBA для всех Методов калькуляции запасов [inventory cost methods], указанных в F4105, кроме 07-Стандартный [Standard Cost], т.к. отклонение по стандартной стоимости имеет приоритет над отклонениями по корректировке нулевого баланса (в случае двух отклонений одно должно иметь приоритет над другим).

Шаги для повторения (пример через списание запасов):

  1. Проверить настройки.
  2. Выполнить корректировку/пополнение запасов, например, 10 шт. по стоимости $100. (P4114)
  3. Выполнить списание запасов, например, 10 шт. по стоимости $90. (P4112)
    Система создает в ГК стандартные проводки списания...:
    Дб 4124 (Expense or COGS): $900.00
    Кт 4122 (Inventory): -$900.00
    ... и ZBA создает в ГК дополнительные проводки:
    Дб 4128 (ZBA - Expense or COGS): $100.00
    Кт 4126 (ZBA - Inventory): -$100.00

Запасы (Inventory)

Используемые АИ (DMAAI)
  • 4126 – ZBA - Inventory
  • 4128 – ZBA - COGS or Expense
Используемые приложения
  • P4112 – Inventory Issues
  • P4113 – Inventory Transfers
  • P4114 – Inventory Adjustments
  • P4116 – Inventory Reclassification
Сценарий

The inventory quantity goes to zero as a result of a an issue transaction, but there is still an amount remaining in the G/L.

Почему запас изменил себестоимость

The cost in the transaction that reduces the quantity on hand to zero is different than it was when the quantity was originally received or adjusted in. This typically happens when an item’s Sales/Inventory cost value is updated, and subsequently the item goes out of stock.

Шаги для повторения (пример через списание запасов)
  1. Проверить настройки.
  2. Выполнить корректировку/пополнение запасов, например, 10 шт. по стоимости $100. (P4114)
  3. Выполнить списание запасов, например, 10 шт. по стоимости $90. (P4112)
    Система создает в ГК стандартные проводки списания...:
    Дб 4124 (Expense or COGS): $900.00
    Кт 4122 (Inventory): -$900.00
    ... и ZBA создает в ГК дополнительные проводки:
    Дб 4128 (ZBA - Expense or COGS): $100.00
    Кт 4126 (ZBA - Inventory): -$100.00
Special scenario
If the transaction is not a reversal, the item is costed at level 3 (location/lot) and the transaction contains multiple lines for the same item and location/lot number but different costs, the error "Line causes a zero balance adjustment" (41010) will be issued to prevent an inaccurate ZBA calculation. The system is not designed to be able to calculate a ZBA accurately in a transaction containing multiple costs. Therefore, if inventory transactions containing multiple costs are necessary, they must be performed one at a time.

Закупка (Purchasing)

Используемые АИ (DMAAI)
  • 4400 – Inventory
  • 4405 – COGS or Expense
Используемые приложения
  • P4312 – Enter Receipts by Purchase Order or by Item
Сценарий

The inventory quantity goes to zero as a result of a negative quantity on a purchase order being received or a receipt is reversed and there is still a positive or negative cost for the item in the G/L.

Почему запас изменил себестоимость

The cost in the transaction that reduces the quantity on hand to zero is different than it was when the quantity was originally received or adjusted in. This typically happens when an item’s Sales/Inventory cost value is updated, and subsequently the item goes out of stock.

Шаги для повторения (пример через списание запасов - Отрицательное ЗНЗ)
  1. Проверить настройки.
  2. Выполнить корректировку/пополнение запасов, например, 25 шт. по стоимости $5. (P4114)
  3. Создать отрицательный ЗНЗ, например, -25 шт. по стоимости $4. (P4310)
  4. Оприходовать отрицательный ЗНЗ со строкой -25 шт. по стоимости $4. (P4312)
    Система создает в ГК стандартные проводки ...:
    Дб 4310 (Inventory): -$100.00
    Кт 4320 (Received Not Vouchered): $100.00
    ... и ZBA создает в ГК дополнительные проводки:
    Дб 4400 (ZBA - Inventory): -$25.00
    Кт 4405 (ZBA - COGS or Expense): $25.00

Продажа (Sales) и Производство (Manufacturing)

Prior to an enhancement in EnterpriseOne 9.2, the Sales system was not designed to create journal entries for zero balance adjustments. A zero balance (ZBA) adjustment record is written in the Item Ledger (F4111) since average cost in F4105 is different than the transaction cost. Thus, the difference will be written in F4111 as the ZBA. The P4205 and R42800 are both capable of creating a ZBA transaction in the Cardex to record any cost corrections, but R42800 will not generate journal entries for the cost change. Manual entries for the cost change are required to updated the General Ledger.

In 9.2, enhanced functionality for zero balance adjustments in sales has been added (See 2640788.1) for Sales Update (R42800) and Inventory Integrity.

The Manufacturing system does not invoke zero balance adjustment functionality. For Actual Costed work orders using Cost Method 09 or 02, the Manufacturing Accounting Journal Entries (R31802A) and Manufacturing Work Order Variance (R31804) Journal Entries Reports will report any adjustments necessary and restate costs as needed.

---

До Application EnterpriseOne 9.2 модуль Продажи не был разработан для создания записей журнала для корректировок нулевого баланса. Запись корректировки нулевого баланса (ZBA) записывается в книгу учета товаров (F4111) с момента как средняя себестоимость в F4105 отличается от себестоимости транзакции. Таким образом, разница будет записана в F4111 как ZBA. P4205 и R42800 оба способны создавать транзакцию ZBA в Cardex для записи любых корректировок стоимости, но R42800 не будет создавать журнальные записи для изменения стоимости. Для обновления Главной книги требуется использовать ручные записи для изменения стоимости.

Начиная с Application EnterpriseOne 9.2 была добавлена ​​расширенная функциональность для ZBA в продажах для Sales Update (R42800) и Inventory Integrity.

Sales Update (R42800)

Sales Update (R42800) has been enhanced in the 9.2 release to create zero balance adjustment account ledger entries (F0911) for all cost methods. Logic to validate new AAIs 4226 (Inventory) and 4228 (Expense or COGS) has been added to Sales Update (R42800).

Inventory Integrity

Inventory integrity reports have been modified to utilize the new AAIs 4226 (Inventory) and 4228 (Expense or COGS) to identify any integrity issue between the Item Ledger (F4111) and the Account Ledger (F0911) for zero balance adjustment entries so that these can be identified, if any exist and corrected for the differences.


New AAIs Added for Zero Balance Adjustment
  • Inventory (4226) - Provides the inventory offset account for journal entries that are created for zero balance adjustments. During sales update, the system debits this account to record the cost adjustments in the Account Ledger table (F0911) when the on-hand quantity is zero while there is still a cost in the G/L.
  • Expense or COGS (4228) - Provides the expense or cost of goods offset account for journal entries that are created for zero balance adjustments. During sales update, the system credits this account to record the cost adjustments in the Account Ledger table (F0911) when the on-hand quantity is zero while there is still a cost in the G/L.

Inventory Cost Levels and ZBA Adjustments

Starting with 8.11 SP1, if the Inventory Cost Level is set to 2 (Item/Branch Only), then you will see a Zero Balance Adjustment in Item Ledger only when on hand quantity for the entire Branch goes to zero. If the Inventory Cost Level is set to 3 (Item/Branch/Location/Lot), then ZBA will occur for every location that goes to zero on hand quantity.

Prior to 8.11 SP1, the ZBA is created every time the on hand quantity becomes zero for a location regardless of the Inventory Cost Level.

Non-creation of ZBA due to rounding in the F4111

When a Purchase Order is created for an item for which the Primary UOM and Purchasing UOM differ and the user overrides unit cost for Purchasing, the unit cost for Primary UOM is calculated by the system using the UOM conversion set up. This calculated unit cost is rounded off to number of decimal places defined in Data Dictionary for UNCS (4) and is updated in Item Cost (F4105) file. When inquiring in the Cardex (F4111), the Extended Amount in header differs from the Extended Amount in detail. Thereafter, when a full inventory issue is made for that item then the Cardex is updated with an extended amount. There may seem to be a discrepancy due to difference between PO Receipt (P4312) and Inventory Issue (P4112). But this difference is resulting from rounding issues and is not a basis to generate zero balance transactions.

Когда Заказ на закупку создается для товара, для которого основная ЕИ и ЕИ закупки различаются, и пользователь переопределяет себестоимость для закупки, себестоимость основной ЕИ рассчитывается системой с использованием настройки преобразования единиц измерения. Эта рассчитанная себестоимость единицы измерения округляется до количества десятичных знаков, определенного в словаре данных для UNCS (4), и обновляется в файле стоимости товара (F4105). При запросе в Cardex (F4111) расширенная сумма в заголовке отличается от расширенной суммы в деталях. После этого, когда для этого товара выполняется полный отпуск инвентаря, Cardex обновляется с расширенной суммой. Может показаться, что существует расхождение из-за разницы между поступлением заказа на закупку (P4312) и отпуском инвентаря (P4112). Но эта разница возникает из-за проблем округления и не является основанием для создания транзакций с нулевым балансом.

Illustration of Calculations

  1. Create an item with Primary UOM as EA, Secondary and Purchasing UOM as BX (No dual UOM setup).
  2. In UOM conversion, set up the conversion as 1 BX equal to 600 EA.
  3. At Purchase Orders (P4310) application, enter a Domestic order for the new item with the Transaction quantity/UOM = 45000/EA, Secondary quantity/UOM = 75/BX, Purchasing UM = BX and override the unit cost to $141.5094. So, the extended amount will be $10,613.21 (= 75 BX * 141.5094)
  4. At PO Receipts (P4312) application, receive this order. On receipt, the unit cost for EA will be calculated as $141.5094/600 = 0.235849 which will be rounded off to number of decimal places defined in DD for UNCS (4) and then this value will be updated to Item Cost (F4105) file.
  5. Consequently, in Cost Revisions (P4105) application all the costs i.e. 02 Sales/Inventory, 08 Purchasing and 01 Last-in costs will be updated as 0.2358. (=$141.5094/600).
  6. In Cardex, the system will update the transaction quantity as 45000 EA, unit cost as 0.2358 and extended amount as $10613.21. However, on Work with Item Ledger form in Cardex header, the Quantity On Hand value will be $10,611.00 (0.2358 * 45000). A difference of $2.21 ($10613.21 -$10,611.00) will appear between value in header and value in detail.
    • On performing a full inventory issue for 45000 EA at a cost of 0.2358, the Cardex will be updated with the extended amount as $10,611. No zero balance adjustment entry will be generated. However, in the cardex detail there will still be a balance of $2.21 due to the difference between PO Receipt (P4312) and Inventory Issue (P4112).

eason for the Difference in Item Ledger/Cardex (F4111)

This is an aspect that is caused by rounding off when calculating the Unit Cost. As stated, the item does not have a unit cost when the Purchase Order is entered. When the order is received for an extended amount (i.e. 75 * 141.5049 = $10613.21), the unit cost is calculated by the system (i.e. 0.235849) and rounded off to 4 decimal places (i.e. 0.2358) and is updated in Item Cost (F4105) file. When viewing the Cardex, the Quantity On hand value field displayed on the header is calculated by multiplying quantity and F4105 unit cost (i.e. 45000 * 0.2358 = $10611). Since the unit cost has been rounded off we see the effects of the rounding when the value is calculated. This is a scenario that could happen irrespective of the number of decimals used for rounding.

Conclusion

To eliminate the residual amounts, a change was made to allow an Amount Only adjustment using Inventory Adjustments (P4114). The functionality is part of base functionality beginning with release 9.0.

Doc ID 2640788.1

Summary

Sales Update (R42800) has been enhanced in the 9.2 release to create zero balance adjustment general ledger entries (F0911) for all cost methods. Prior to the enhancement, zero balance adjustments were written only for cost method 07, standard cost. The enhancement was requested in Bug 10746070 - ZERO BALANCE ADJUSTMENT.

Solution

Overview

Historically, zero balance adjustments created at Shipment Confirmation (P4205) or Sales Update (R42800) did not update the Account Ledger (F0911). There were no Automatic Accounting Instructions (AAIs) to record the entries. As a result, zero balance adjustments in the Item Ledger did not reconcile and the Account Ledger was incorrect. Sales Update was not creating the General Ledger entry for cost methods other than cost method 07, standard cost, for zero balance adjustments.

Sales Update (R42800)

Sales Update (R42800) has been enhanced in the 9.2 release to create zero balance adjustment account ledger entries (F0911) for all cost methods. Logic to validate new AAIs 4226 (Inventory) and 4228 (Expense or COGS) has been added to Sales Update (R42800). Inventory Integrity

Inventory integrity reports have been modified to utilize the new AAIs 4226 (Inventory) and 4228 (Expense or COGS) to identify any integrity issue between the Item Ledger (F4111) and the Account Ledger (F0911) for zero balance adjustment entries so that these can be identified, if any exist and corrected for the differences.

Enhancement ESUs Available

The enhanced functionality is available in the ESUs for the following Bugs. Both ESUs must be installed for the complete solution

  • Bug 30337169
  • Bug 30672005

ESU Objects Updated

  • B4200520 Get Sales AAIs And Call F0911 Edit Line
  • D4200520 GetSalesAAIsAndCallF0911EditLine
  • D4208030A Fetch ZBA Cache
  • R42800 Sales Update
  • B4208030 Inventory and Sales Cache Fetch
  • B4100910 F4111 - Check Integrity With F0911

New AAIs Added for Zero Balance Adjustment

Inventory (4226) - Provides the inventory offset account for journal entries that are created for zero balance adjustments. During sales update, the system debits this account to record the cost adjustments in the Account Ledger table (F0911) when the on-hand quantity is zero while there is still a cost in the G/L.

Expense or COGS (4228) - Provides the expense or cost of goods offset account for journal entries that are created for zero balance adjustments. During sales update, the system credits this account to record the cost adjustments in the Account Ledger table (F0911) when the on-hand quantity is zero while there is still a cost in the G/L. 

Note: AAIs 4226 and 4228 need to be added to the environment after the ESUs are installed.

Ссылки

  • E1: 41: Zero Balance Adjustments (Doc ID 625466.1)
  • E1: 42: Sales Update (R42800) Creates Zero Balance Adjustment General Ledger Entries (F0911) for All Cost Methods (Doc ID 2640788.1)
Источник — http://wiki.sgsproject.nichost.ru/index.php?title=ZBA_(ТМЦ)&oldid=109446