Skip to Content
0
Jan 26, 2023 at 02:30 PM

QUERY TO SHOW THE NET SALES VALUE REPORT BY CUSTOMER ON CRYSTAL REPORT IN SAP BUSINESS ONE

48 Views

Good day,

I have a client that created a discount as a service item but it's not checked as Inventory item but anytime they create an ar invoice they select the discount so they want a report that will show them the net sales value report with the discount included in the report such that it will give them the Total gross minus the Discount which will give the net sales value.

So i need a query that will display the net sales value in SAP in Crystal Report format.

Hope to get your response.