Tony
  • Male
  • Canada
Share

Tony's Discussions

ALCH_DATE_DIM table
12 Replies

Hello, “ALCH_DATE_DIM” table  exist in the Sage 300 database. This table is used in the sales analysis Container.at what time this table is created, (when activating or through an import)?Is there a…Continue

Started this discussion. Last reply by Nigel Naicker Oct 9, 2018.

Periods range in period formula
3 Replies

Hello,i'm using the TO function in a period range to consolidate the actuals in an income statement for periods 1, 2 and 3, but it doesn't seems to work.i'm following the procedures:There may be…Continue

Started this discussion. Last reply by Tony Aug 31, 2018.

copy data sheet1 to another sheet automatically
2 Replies

hello,is there a way to copy the sheet 1(data) to another sheet automatically.so what i'm trying to do is to generate commissions report with parameters that control the selection of the sales…Continue

Started this discussion. Last reply by Tony Aug 28, 2018.

 

Tony's Page

Latest Activity

Nigel Naicker replied to Tony's discussion ALCH_DATE_DIM table
"hmmm, then the only other thing i would suggest is contacting support, they would have to remote it in to get specific detail on the set up and hopefully can find your customer a solution."
Oct 9, 2018
Tony replied to Tony's discussion ALCH_DATE_DIM table
"the customer doesn't have the olap manager. regards,"
Oct 9, 2018
Nigel Naicker replied to Tony's discussion ALCH_DATE_DIM table
"if my memory serves me correct, you would have to run the cube in olap manager first, then run it in report manager. Sorry but my memory is very fuzzy on this, those cube reports are  pretty old."
Oct 9, 2018
Tony replied to Tony's discussion ALCH_DATE_DIM table
"it's my customer who is using it,but we wanted to understand the logic for that table, because it doesn't seems to update when creating the new financial year, and what procedure would create that table? regards,"
Oct 9, 2018
Nigel Naicker replied to Tony's discussion ALCH_DATE_DIM table
"aha i c, i thought that might be the case, is there any reason why you are using that report vs the standard sales master report?"
Oct 9, 2018
Tony replied to Tony's discussion ALCH_DATE_DIM table
"sorry i did a mistake, the report is the Sales analysis cube"
Oct 9, 2018
Tony replied to Tony's discussion ALCH_DATE_DIM table
"yes, and this is the container:"
Oct 9, 2018
Nigel Naicker replied to Tony's discussion ALCH_DATE_DIM table
"is this the report you are looking at? "
Oct 9, 2018
Tony replied to Tony's discussion ALCH_DATE_DIM table
"Hello, that's what i saw, and it wasn't modified by anyone: (([alch_date_dim]LEFT JOIN [alch_view_sales_anal] ON [alch_date_dim].[date_value] = CAST(CAST([alch_view_sales_anal].[INVDATE] AS varchar) AS datetime))INNER JOIN [CSCOM] ON…"
Oct 9, 2018
Nigel Naicker replied to Tony's discussion ALCH_DATE_DIM table
"Hi Tony, im looking at the container u mentioned above and this is what i see.  I don't see that ALCH_DIM table. Are you looking somewhere else? Or was this container edited by someone? [OESHDT]LEFT JOIN [ARCUS] ON [OESHDT].[CUSTOMER] =…"
Oct 9, 2018
Tony replied to Tony's discussion ALCH_DATE_DIM table
"Hello, It's the Sales Analysis Container3-0(AE-SQL), yes it is for the Sales Master 3-0(AE-SQL) standard report. regards,"
Oct 9, 2018
Nigel Naicker replied to Tony's discussion ALCH_DATE_DIM table
"Hi Tony, What Sales Analysis container is this? Is it for a standard report? "
Oct 8, 2018
Tony posted a discussion

ALCH_DATE_DIM table

Hello, “ALCH_DATE_DIM” table  exist in the Sage 300 database. This table is used in the sales analysis Container.at what time this table is created, (when activating or through an import)?Is there a script to create this table? how this table will be updated automatically upon creating new year?The issue is this table only have 3 Financial years at our customer,and  if we create the new GL financial year this table is not updated, so the sales analysis report doesn’t have the option to select…See More
Oct 5, 2018
Tony replied to Tony's discussion Periods range in period formula
"Thank you Prasad, i think that was the problem (YTD), i used actuals and it's working fine. thank you for your help. regards, Tony"
Aug 31, 2018
Prasad Thutta replied to Tony's discussion Periods range in period formula
"Hi Tony, I have done some investigation with regards to Period Ranges, My Findings as follow: Period Ranges Support on "Actual and Budget" Formulas Period Ranges DOES NOT Support on "ActualYTD, BudgetYTD, Opening Balance, and…"
Aug 31, 2018
Prasad Thutta replied to Tony's discussion Periods range in period formula
"Hi Tony, You seem to be following the correct steps,  May i ask you which product is this? Thanks Prasad"
Aug 31, 2018

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Accpac Intelligence

Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service