Sage 100

I'm trying to import into SO_RecapByProductLineWhse, SO_RecapByWarehouse and SO_RecapByDivision.  It's Providex, not SQL.

These tables don't show up in VI Import Job Maintenance.  I thought I might be able to do a quick data dictionary tweak, but it doesn't seem to be the problem or I don't know what I'm doing there!

Why do I need to do this ... we've done a fiscal year change and many tables are updated by recalculating inventory history or running the "Martin & Associates" utility.  But these 3 tables have not been updated.

Any suggestions would be most welcome.

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------

From what i have observed, when viewing a table in the Data Dictionary Maintenance utility, if you click the "Custom Info" button and don't see a class object ending with "_bus" or the "Exclude from VI Import" option is checked, then you can't import into it via VI.

I don't see any class objects for those tables under MAS90\SO that end with "_bus" either.

I did find this in the KB so it looks like the only way to recalculate those files is to use Fiscal Year Maintenance and click the Recalculate button for each year.
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=20846

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Thank you for the input David.  I checked the KB article and it says that it does not update those other files.  So based on that, it appears that we won't be able to do this.  I'll have to use DFDM to wipe out conflicting/confusing data.

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 07-04-2022 12:32
From: David Speck II
Subject: Importing into SO_Recapxxx files

From what i have observed, when viewing a table in the Data Dictionary Maintenance utility, if you click the "Custom Info" button and don't see a class object ending with "_bus" or the "Exclude from VI Import" option is checked, then you can't import into it via VI.

I don't see any class objects for those tables under MAS90\SO that end with "_bus" either.

I did find this in the KB so it looks like the only way to recalculate those files is to use Fiscal Year Maintenance and click the Recalculate button for each year.
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=20846

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

It seems you can also use File > Run > SYZCON and get a handle to a new instance of the "SO_RecalcRecaps" class and call the RecalcSORecaps method without passing a year to it and it will recalculate for all years.


------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 07-04-2022 12:32
From: David Speck II
Subject: Importing into SO_Recapxxx files

From what i have observed, when viewing a table in the Data Dictionary Maintenance utility, if you click the "Custom Info" button and don't see a class object ending with "_bus" or the "Exclude from VI Import" option is checked, then you can't import into it via VI.

I don't see any class objects for those tables under MAS90\SO that end with "_bus" either.

I did find this in the KB so it looks like the only way to recalculate those files is to use Fiscal Year Maintenance and click the Recalculate button for each year.
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=20846

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

I would copy live company to a test company and test it.  I think the KB article is a little misleading because Beth Bowers and I had to do something similar when we made some changes for one client and we observed that recalculating from Fiscal Year Maintenance was the only easily accessible way to recalculate those SO Recap files.  I'm thinking the KB article is saying that the actual fiscal year and period values in the various history tables, like IM_ItemTransactionHistory, do not get updated.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 07-04-2022 12:51
From: David Speck II
Subject: Importing into SO_Recapxxx files

It seems you can also use File > Run > SYZCON and get a handle to a new instance of the "SO_RecalcRecaps" class and call the RecalcSORecaps method without passing a year to it and it will recalculate for all years.


------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 07-04-2022 12:32
From: David Speck II
Subject: Importing into SO_Recapxxx files

From what i have observed, when viewing a table in the Data Dictionary Maintenance utility, if you click the "Custom Info" button and don't see a class object ending with "_bus" or the "Exclude from VI Import" option is checked, then you can't import into it via VI.

I don't see any class objects for those tables under MAS90\SO that end with "_bus" either.

I did find this in the KB so it looks like the only way to recalculate those files is to use Fiscal Year Maintenance and click the Recalculate button for each year.
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=20846

------------------------------
David Speck II
Tennessee Software Solutions

@Robert White - Everything David said is correct​. I'll add to a few things:

1. There is no business object for these tables but the SO Sales Journal Update normally calls the SO Recalc Recaps program, at the time when you are prompted for printing the Recalc reports to run (based on what you have setup in S/O Options). Fortunately it can be run independently too.

2. I've manually run the SO_RecalcRecaps from SYZCON myself. Like David said you can either pass in a 4-digit year or pass in nothing to recalc all years. Just don't have any Recap file open in DFDM at the time and do run it in a copy company first. Should be fine.

o=new("SO_RecalcRecaps",%sys_ss)
x= o'RecalcSORecaps()
​PRINT x ! If x <> 1 then do next command to copy error to clipboard.
CLIP_BOARD WRITE o'LastErrorMsg$  ! Now paste into email or Notepad

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------

Original Message:
Sent: 07-04-2022 12:58
From: David Speck II
Subject: Importing into SO_Recapxxx files

I would copy live company to a test company and test it.  I think the KB article is a little misleading because Beth Bowers and I had to do something similar when we made some changes for one client and we observed that recalculating from Fiscal Year Maintenance was the only easily accessible way to recalculate those SO Recap files.  I'm thinking the KB article is saying that the actual fiscal year and period values in the various history tables, like IM_ItemTransactionHistory, do not get updated.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 07-04-2022 12:51
From: David Speck II
Subject: Importing into SO_Recapxxx files

It seems you can also use File > Run > SYZCON and get a handle to a new instance of the "SO_RecalcRecaps" class and call the RecalcSORecaps method without passing a year to it and it will recalculate for all years.


------------------------------
David Speck II
Tennessee Software Solutions


Original Message:
Sent: 07-04-2022 12:32
From: David Speck II
Subject: Importing into SO_Recapxxx files

From what i have observed, when viewing a table in the Data Dictionary Maintenance utility, if you click the "Custom Info" button and don't see a class object ending with "_bus" or the "Exclude from VI Import" option is checked, then you can't import into it via VI.

I don't see any class objects for those tables under MAS90\SO that end with "_bus" either.

I did find this in the KB so it looks like the only way to recalculate those files is to use Fiscal Year Maintenance and click the Recalculate button for each year.
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=20846

------------------------------
David Speck II
Tennessee Software Solutions

Thank you David for that SYZCON thingee.  Worked like a charm.  And thank you, too, Alnoor, for the input.

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 07-04-2022 13:22
From: Alnoor Cassim
Subject: Importing into SO_Recapxxx files

@Robert White - Everything David said is correct​. I'll add to a few things:

1. There is no business object for these tables but the SO Sales Journal Update normally calls the SO Recalc Recaps program, at the time when you are prompted for printing the Recalc reports to run (based on what you have setup in S/O Options). Fortunately it can be run independently too.

2. I've manually run the SO_RecalcRecaps from SYZCON myself. Like David said you can either pass in a 4-digit year or pass in nothing to recalc all years. Just don't have any Recap file open in DFDM at the time and do run it in a copy company first. Should be fine.

o=new("SO_RecalcRecaps",%sys_ss)
x= o'RecalcSORecaps()
​PRINT x ! If x <> 1 then do next command to copy error to clipboard.
CLIP_BOARD WRITE o'LastErrorMsg$  ! Now paste into email or Notepad

------------------------------
Alnoor Cassim

Email: alnoor.cassim@90minds.com
Ph:
------------------------------


Original Message:
Sent: 07-04-2022 12:58
From: David Speck II
Subject: Importing into SO_Recapxxx files

I would copy live company to a test company and test it.  I think the KB article is a little misleading because Beth Bowers and I had to do something similar when we made some changes for one client and we observed that recalculating from Fiscal Year Maintenance was the only easily accessible way to recalculate those SO Recap files.  I'm thinking the KB article is saying that the actual fiscal year and period values in the various history tables, like IM_ItemTransactionHistory, do not get updated.

------------------------------
David Speck II
Tennessee Software Solutions


Original Message:
Sent: 07-04-2022 12:51
From: David Speck II
Subject: Importing into SO_Recapxxx files

It seems you can also use File > Run > SYZCON and get a handle to a new instance of the "SO_RecalcRecaps" class and call the RecalcSORecaps method without passing a year to it and it will recalculate for all years.


------------------------------
David Speck II
Tennessee Software Solutions


Original Message:
Sent: 07-04-2022 12:32
From: David Speck II
Subject: Importing into SO_Recapxxx files

From what i have observed, when viewing a table in the Data Dictionary Maintenance utility, if you click the "Custom Info" button and don't see a class object ending with "_bus" or the "Exclude from VI Import" option is checked, then you can't import into it via VI.

I don't see any class objects for those tables under MAS90\SO that end with "_bus" either.

I did find this in the KB so it looks like the only way to recalculate those files is to use Fiscal Year Maintenance and click the Recalculate button for each year.
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=20846

------------------------------
David Speck II
Tennessee Software Solutions