Run AP Wire Posting in SQL Query Analyzer



Solution ID = KB-345

Goal : Run AP Wire Posting in SQL Query Analyzer

Version = Syteline7.05.00

Module : SLACCT

Fact : Run AP Wire Posting in SQL Query Analyzer. AP Wire Posting

Database : SQL

Cause

Running AP Wire Posting and it is not posting and there are no errors

Fix

Run AP Wire Posting in SQL Query Analyzer

Run this in Query Analyzer against the application database with the problem.  Replace the Bank Code 'BK1' with the correct bank code from the database:
set nocount on
begin tran
declare @SessionID uniqueidentifier
set @SessionID = dbo.SessionIDSp()
exec wirepostcreatettsp null,NULL,NULL,null,'BK1', W,null, null, @SessionID
rollback tran