Hi,
Can anyone help; I am trying to design a report for Job control in Sage line 500 using the sales and costs data in sage, can anyone tell me the correct tables I should be using to do this. Or if someone has designed one that works correctly maybe you could let me take a look at it
Many thanks
Mark Beardsell
Sage Line 500 Job Costing
2 posts
• Page 1 of 1
Sage Line 500 Job Costing
by mbeardsell » Tue Jun 26, 2007 2:23 pm
- mbeardsell
- Posts: 1
- Joined: Tue Jun 26, 2007 2:15 pm
by or-8 » Fri Sep 05, 2008 11:15 am
Depends on the detail you want to get to....
Sales histories are in opsahistm
(Sales orders are not)
I tend to use the MRP table for future orders/forecasts mrgrpdm.
(mrmrprm for forecasts that have been processed by MRP )
Standard and Current costs are in stockm and are split into Labour, Material,Overhead and Outwork if you only need parts of it. (There is a total for Standard and a total for current)
Could be built in Excel with live links to Sage server (if your are using SQL)
Can you expand on ' Job Control'...
Gordon OR8
Sales histories are in opsahistm
(Sales orders are not)
I tend to use the MRP table for future orders/forecasts mrgrpdm.
(mrmrprm for forecasts that have been processed by MRP )
Standard and Current costs are in stockm and are split into Labour, Material,Overhead and Outwork if you only need parts of it. (There is a total for Standard and a total for current)
Could be built in Excel with live links to Sage server (if your are using SQL)
Can you expand on ' Job Control'...
Gordon OR8
-
or-8 - Posts: 31
- Joined: Fri Sep 05, 2008 11:07 am
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest