SBO_SP_PostTransactionNotice updates item's price but not detected by B1IF

[Javokhir_Isroilov]

Hi dear community members,

I have a question related to SAP B1 more technically:
While clients adding A/P invoice, they set sales price in the user defined field per item. After adding document my SBO_SP_PostTransactionNotice updates these items' price in the exact pricelist. I want to know what is the difference between this case and manual price change? Because SAP Customer Checkout has items synchronization job, it uses sap.POS.FetchMaterialList scenario in B1IF and 1st case it does not detect item's price changed, but if we change price manually  it detects. Which field of ITM1 I should update in procedure in order to be detected by B1IF?

Here is my procedure:

IF :object_type in ('18') AND (:transaction_type = 'A' OR :transaction_type = 'U') THEN

UPDATE "ITM1" T0
SET
"Price" = (
SELECT MAX(P."U_newPriceUZS")
FROM "PCH1" P
WHERE
P."ItemCode" = T0."ItemCode"
AND P."DocEntry" IN ( :list_of_cols_val_tab_del )
),
"Currency" = 'UZS'
WHERE
T0."PriceList" = '5'
AND EXISTS (
SELECT 1
FROM "PCH1" P
WHERE
P."ItemCode" = T0."ItemCode"
AND P."DocEntry" IN ( :list_of_cols_val_tab_del )
);

END IF;

SAP Business One, version for SAP HANA SAP Customer Checkout 

@Darius @elena_vavitsa @bikash_bansal 

[LoHa]

Hi,

just as information.

You are not allowed to fire update and delete queries on SAP B1 tables. You will loose your warranty

regards

Lothar