Skip to Content
avatar image
Vinoth D R

SAP Reports

Jan 18, 2018 at 04:59 PM | 67 Views | Last edit Jan 18, 2018 at 05:05 PM 2 rev.

My client having a requirement of below needs to identify the charges of the particular ledger.

Please help with that query

sample query

select oact.acctname as Account_Name,OACT.CurrTotal from OACT

where AcctCode IN('700904','700903')

Thanks

Vinoth

ledger.jpg (20.6 kB)
ledger.jpg (20.6 kB)
SAP Business One
SAP Business One SDK | SAP SQL Anywhere | Microsoft SQL Server | SQL | sap b1 | sap b1 query report with excel
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Vinoth D R
    Jan 19, 2018 at 05:59 AM

    Hi Jimmy,

    I want to execute the report in sql.

    can u please guide me.

    Thanks

    Vinoth

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Jimmy Liang
    Jan 19, 2018 at 12:16 AM

    Hi Vinoth,

    This report will need data from the JEs so you will need a join with JDT1.

    The grouping by Month/Qtr/Year will be achievable depends on where the report will be run, in B1 using query report, in a Crystal report or in Excel.

    For Crystal report or Excel, it's relatively easy to use a pivot table format and have the numbers grouped by the dates. If it's required to run as a query report, then you may use some PIVOT statement in your SQL script.

    Cheers,

    Jimmy

    Add comment
    10|10000 characters needed characters exceeded