Month Wise Cash Accounting

(0) Share

Report

Posted on by Community Member Microsoft Employee

Can any one please write month wise function for me i want to develop a month wise cash accounting report.

please modify given below day wise function to month wise

DECLARE @OpeningAmt NUMERIC(19,2), @PdATE DATE

-- return

SET @Pdate = DATEADD(DD, -1 , @FromDate)

if (isnull(@FromDate, '1900-01-01') <> '1900-01-01')
begin

Declare @Opening table
(
TENDERTYPE int
--,store nvarchar(200)
, TenderName varchar(500)
, Opening numeric(19,2)
, NetSales decimal(28,2)
, DepositAmt numeric(19,2)
, ExpenseAmount numeric(19,2)
, Income numeric(19,2)
, Payments numeric(19,2)
)

insert into @Opening
EXEC [MtqRpt_TenderTotalsDynamic]
@PDataAreaID = @PDataAreaID,
@StoreId = @StoreId,
@FromDate = '1900-01-01',
@ToDate = @Pdate ,
@Terminal = @Terminal

select @OpeningAmt = sum( NetSales + Income - (DepositAmt + ExpenseAmount ) )
from @Opening
where TENDERTYPE = 1
end

please help out

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Month Wise Cash Accounting

Hi Axdynamcis,

Is a store a financial dimension in your company?

If so, you should be able to create this report in the Management Reporter out of the box.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Month Wise Cash Accounting

format is given below

but i need it store wise on monthly basis

Store Opening Amount Deposit Expense Closing

1 0 25000 0 25000

2 25000 50000 0 30000
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Month Wise Cash Accounting

Hi,

You have to help us here a bit and provide more details of what you try to achieve. What kind of report do you need? Why is it that you have to develop this? How should the report look like, etc.

Many thanks

Ludwig