Excel On Steroids         
It is currently Sun Sep 05, 2010 2:41 am

All times are UTC + 2 hours




 Page 1 of 1 [ 2 posts ] 
Author Message
 Post subject: Pastel BIC Evo Sales Master
PostPosted: Tue Jul 21, 2009 3:53 pm 

Joined: Thu Jul 31, 2008 10:08 am
Posts: 17
the sales master only pulls stock related sales, is there another report that shows "GL" sales from OE? one I could download maybe ?

thanks


Offline
 Profile E-mail  
 
 Post subject: Re: Pastel BIC Evo Sales Master
PostPosted: Fri Jul 24, 2009 11:06 am 
Site Admin
User avatar

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)


Offline
 Profile E-mail  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 2 posts ] 

All times are UTC + 2 hours


Who is online

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

Search for:
Jump to:  
cron
phpBB skin developed by: John Olson
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group