Hi All
We have recently found a rather bad bug in B1 Budget that, if you have customers live on this module cause the budget month distribution to be incorrect.
Who is affected?
If you are running a B1UP version higher than 6.0.2 you might be affected (version lower than that is not affected).
I might be affected. How do I check?
Please run the following SQL sentence against the database:
Code:
SELECT
T1.U_BOY_YEAR AS BudgetYear,
T1.Name AS BudgetName,
T0.U_BOY_DATA_KEY,
T0.U_BOY_DEBIT+T0.U_BOY_CREDIT AS EnteredValue,
(SELECT SUM(TS0.U_BOY_CREDIT+TS0.U_BOY_DEBIT) FROM [@BOY_90_BUD_ENTRY_M] TS0 WHERE TS0.U_BOY_ENTRY_FK = T0.Code) AS DistributedValue
FROM [@BOY_90_BUD_ENTRY] T0
JOIN [@BOY_90_BUD] T1 ON T0.U_BOY_BUDGET_FK = T1.Code
WHERE (T0.U_BOY_DEBIT+T0.U_BOY_CREDIT) <> (SELECT SUM(TS0.U_BOY_CREDIT+TS0.U_BOY_DEBIT) FROM [@BOY_90_BUD_ENTRY_M] TS0 WHERE TS0.U_BOY_ENTRY_FK = T0.Code)
T1.U_BOY_YEAR AS BudgetYear,
T1.Name AS BudgetName,
T0.U_BOY_DATA_KEY,
T0.U_BOY_DEBIT+T0.U_BOY_CREDIT AS EnteredValue,
(SELECT SUM(TS0.U_BOY_CREDIT+TS0.U_BOY_DEBIT) FROM [@BOY_90_BUD_ENTRY_M] TS0 WHERE TS0.U_BOY_ENTRY_FK = T0.Code) AS DistributedValue
FROM [@BOY_90_BUD_ENTRY] T0
JOIN [@BOY_90_BUD] T1 ON T0.U_BOY_BUDGET_FK = T1.Code
WHERE (T0.U_BOY_DEBIT+T0.U_BOY_CREDIT) <> (SELECT SUM(TS0.U_BOY_CREDIT+TS0.U_BOY_DEBIT) FROM [@BOY_90_BUD_ENTRY_M] TS0 WHERE TS0.U_BOY_ENTRY_FK = T0.Code)
If the SQL give any results back then please contact Boyum Support on support@boyum-it.com with the following information:
- SAP version used
- B1UP version used
- Result of the above query