SP View Sales Journal Distribution

(0) Share

Report

Posted on by Dedi Hermawan

295

Use this SP View to make Smartlist Sales Journal Distrtibution

create view ABC_Sales_Distribution

select
a.[SOP Type],
a.[Document ID],
a.[SOP Number],
a.[Sequence Number],
a.[Account Number],
a.[Account Description],
a.[Debit Amount],
a.[Credit Amount],
b.[Document Status] as [GL Status],
a.[TRX Source],
a.[Distribution Type],
a.[Posted Date],
a.[Customer Number] as [Customer ID],
a.[Customer Name]

from

dbo.SalesDistributions a
left join dbo.AccountTransactions b on a.[SOP Number] = b.[Originating Document Number]
go
GRANT SELECT ON ABC_Sales_Distribution TO DYNGRP

*This post is locked for comments