Is there any option on how to include credit memo in the price list comparison in SAP Business One?

[former_member592380]

Dear All,

Can any one has an idea on how to display credit memos in the price comparison list in SAP Business One? I would appreciate for your kind support.

Thanks in advance

Biniam

[kvbalakumar · Accepted solution]

Hi,

We can't modify the SAP's default report (especially this report). Rather you can create a custom report with your needs!

If you are referring "Last Prices Report", then it already has Credit Memo as an option.

Regards,

Bala

[former_member592380 · Accepted solution]

Dear Balakumar,

I thank you for your quick response and support. How can I create a custom report according to my needs? Do you have any hint?

Thank you in advance

Biniam

[kvbalakumar · Accepted solution]

Hi,

You may use the below as a starting point and feel free to add additional fields.

SELECT TOP(10) T0.DocNum, T0.DocDate,T1.ItemCode, T1.Price
FROM dbo.ORIN T0 
INNER JOIN dbo.RIN1 T1 ON T1.DocEntry = T0.DocEntry
WHERE T1.ItemCode = [%0] AND T0.CardCode = [%1]
ORDER BY T0.DocDate DESC

Regards,

Bala

[former_member592380 · Accepted solution]

Thanks alot