Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Contributor
trodgers47
Posts: 16
Registered: 11-23-2010
0

Mas90 4.4 file layouts

We recently updated to Mas90 4.4. I was using the inventory maintenace and inventory sales history files to create a simple report. Those files are no longer there and I can not file the correct files to create this report. I need the item code, itemc description and qty sold ytd.....the kicker is I want to only shoe items with a certain routing no. I can't seem to fine those two files that would work together. I started witht he CI Item but where is the file for qty sold ytd.
Switcher
BigLouie
Posts: 2,689
Registered: 10-28-2008
0

Re: Mas90 4.4 file layouts

As with the other modules that have switched to the business framework those fields no longer exist anywhere. Data is stored by year and period.

Big Louie No MBA but BMOC
--------------------------------------------------------------------------
You have enemies? Good. That means you've stood up for something in your life.
Sage MAS Partner
TomTarget
Posts: 1,752
Registered: 11-02-2008
0

Re: Mas90 4.4 file layouts

In other words,  your report has to calculate the YTD totals from the period data now.

Thomas H. Rogers, C.P.A.
Target System Technology, Inc. - Spokane, WA -
The best solution often comes not from answering the question asked, but understanding WHY the question was asked.
Contributor
trodgers47
Posts: 16
Registered: 11-23-2010
0

Re: Mas90 4.4 file layouts

What would be the file to calcuate the totals?
Moderator
Natasha
Posts: 180
Registered: 07-15-2009
0

Re: Mas90 4.4 file layouts

Try IM_ItemWhseHistoryByPeriod or IM_ItemCustomerHistoryByPeriod.

 

Natasha Chang

Sr. Software Engineer

Sage MAS90/200, Extended Solutions

Natasha Chang
Sr. Software Engineer
Sage 100 ERP