You’re offline. This is a read only version of the page.
295
Use 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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,232
Super User 2024 Season 2
#2
Martin Dráb
230,064
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (