the sales master only pulls stock related sales, is there another report that shows "GL" sales from OE? one I could download maybe ?
thanks
Fred
Post subject: Re: Pastel BIC Evo Sales Master
Posted: Fri Jul 24, 2009 11:06 am
Site Admin
Joined: Wed Aug 22, 2007 10:54 am Posts: 404 Location: Durban, South Africa
Why not modify the report you have to include the GL transaction type.
The Sales Master uses the following filters relevant to the actual transaction types returned:
Sales Filter <> 0 which feeds from expression (CASE WHEN [_bvARTransactionsFull].[Id] = 'JCI' THEN 1 ELSE [TrCodes].[bSalesFilter] END)
Transaction ID IsIn "JCI,ARTx,CBAR,Crn,Inv,OInv,POSC,POSI" which feeds from [_bvARTransactionsFull].[Id]
I would start by including the transaction type GL to the Transaction ID IsIN list - thus "JCI,ARTx,CBAR,Crn,Inv,OInv,POSC,POSI,GL" and see if that meets your requirment. (not sure how Sales filter will impact on this one)
Users browsing this forum: No registered users and 2 guests
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum