Share
Report
295Use this SP View to make Smartlist Sales Journal Distrtibution
create view ABC_Sales_Distribution
as
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
I have the same question (0)
All responses (
Answers (
