Jkahsfjkas

Symptom
Inventory accounts or inventory-related accounts might be incorrectly defined in the company database. For example, an inventory account, which is a balance account, may have been used as a Profit & Loss account such as negative inventory adjustment account, revenue account, exchange rate differences account, allocation account, and so on.
The following account settings in SAPBusiness One should be reviewed and approved by your accountant:
1.  Account settings in G/L account determination
2. Account settings in Warehouse setup
3. Account settings in Item Group setup
4. Account settings per item, in case the G/L account determination in Item Master Data is set by item level.

Cause
Incorrect account settings.

Solution
Execute the below scripts for retrieving the completelist of incorrect usage of inventory accounts in G/L account determination, Item Group /Warehouse definition, Item Master Data:
/**
* U_Check inventory accounting setting
*
*
*/

IF object_id('[tempdb]..##Fields') IS NOT NULL DROP TABLE [##Fields]

CREATE TABLE ##Fields
(
    FieldName VARCHAR(50)
);

INSERT INTO ##Fields VALUES ('SaleCostAc'         )
INSERT INTO ##Fields VALUES('TransferAc'         )
INSERT INTO ##Fields VALUES ('RevenuesAc'         )
INSERT INTO ##Fields VALUES ('VarianceAc'         )
INSERT INTO ##Fields VALUES ('DecreasAc '         )
INSERT INTO ##Fields VALUES ('IncreasAc '         )
INSERT INTO ##Fields VALUES ('ExpensesAc'         )
INSERT INTO ##Fields VALUES ('EURevenuAc'         )
INSERT INTO ##Fields VALUES ('EUExpensAc'         )
INSERT INTO ##Fields VALUES('FrRevenuAc'         )
INSERT INTO ##Fields VALUES ('FrExpensAc'         )
INSERT INTO ##Fields VALUES ('ExmptIncom'         )
INSERT INTO ##Fields VALUES ('PriceDifAc'         )
INSERT INTO ##Fields VALUES ('ExchangeAc'         )
INSERT INTO ##Fields VALUES ('BalanceAcc'         )
INSERT INTO ##Fields VALUES ('PurchaseAc'         )
INSERT INTO ##Fields VALUES ('PurchOfsAc'         )
INSERT INTO##Fields VALUES ('PAReturnAc'         )
INSERT INTO ##Fields VALUES ('ShpdGdsAct'         )
INSERT INTO ##Fields VALUES ('VatRevAct '         )
INSERT INTO ##Fields VALUES ('DecresGlAc'         )
INSERT INTO ##Fields VALUES ('IncresGlAc'         )
INSERT INTO ##Fields VALUES ('StokRvlAct'         )
INSERT INTO ##Fields VALUES ('StkOffsAct'         )
INSERT INTO ##Fields VALUES ('WipAcct   '        )
INSERT INTO ##Fields VALUES ('WipVarAcct'         )
INSERT INTO ##Fields VALUES ('CostRvlAct'         )
INSERT INTO ##Fields VALUES ('CstOffsAct'         )
INSERT INTO ##Fields VALUES ('ExpClrAct '         )
INSERT INTO ##Fields VALUES ('ExpOfstAct'         )
INSERT INTO ##Fields VALUES ('ARCMAct   '         )
INSERT INTO ##Fields VALUES ('ARCMFrnAct'         )
INSERT INTO ##Fields VALUES('ARCMEUAct '         )
INSERT INTO ##Fields VALUES ('ARCMExpAct'         )
INSERT INTO ##Fields VALUES ('APCMAct   '         )
INSERT INTO ##Fields VALUES ('APCMFrnAct'         )
INSERT INTO ##Fields VALUES ('APCMEUAct '         )
INSERT INTO ##Fields VALUES ('RevRetAct '         )
INSERT INTO ##Fields VALUES ('NegStckAct'         )
INSERT INTO ##Fields VALUES ('StkInTnAct'         )
INSERT INTO##Fields VALUES ('PurBalAct '         )
INSERT INTO ##Fields VALUES ('WhICenAct '         )
INSERT INTO ##Fields VALUES ('WhOCenAct '         )

DECLARE  @QueryTempl NVARCHAR(MAX)
DECLARE  @sql NVARCHAR(MAX)
DECLARE  @ret NVARCHAR(1)

SET @QueryTempl =
N'
DECLARE @FieldName varchar(50)
DECLARE @num int
SET @num = 0

DECLARE zX CURSOR SCROLL
FOR SELECT FieldName FROM ##Fields

/*first record*/
OPEN zXFETCH NEXT FROM zX INTO @FieldName

IF object_id(''[tempdb]..##TmpTable'') IS NOT NULL DROP TABLE [##TmpTable]

/*for */
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE  @sql1 NVARCHAR(MAX)
DECLARE  @sql2 NVARCHAR(MAX)

SET @sql1 =
''
Select ''$ErrorMsg'' as ''''Scenarios'''', $DispFields1, ''''$FieldName same as Inventory Account       '''' as ''''Details''''
INTO ##TmpTable
from $Table
where...