Inventory per qty & costs 2

[robertLTT]

We are currently using ACCAPC 5.3A (Small Business Edition) (Build 45)(Service Pack 3), Pervasive database.

We need help to what report from IC module that we can generate in order to support our inventory amount in trial balance. Say our Finished Good Inventory totals $100,000 then we want to look for a report that has a breakdown per item qty & cost? We tried item valuation but our accpac vendor said that we can't use that report (we're confused), and trying to sell inventory stock card module but we're not ready to buy for now.

Any help will be greatly appreciated. Thank you.

 

[jayconverse]

Accpac uses a perpetual inventory system, so running the inventory valuation report changes over time. What some of my clients do is run the report at the end of the month, and save it in Excel. In deference to your vendor, the UniDevco Stock Card add-on does this seemlessly, plus a lot more.

If you want to run things yourself, you'll have to create a report against the ICHIST table that adds up all transactions from the beginning of time to the period-end date in question.

Jay Converse
IT Director
Systemlink, Inc.

 

[robertLTT]

Thanks Jay for the valuable info.

 

[robertoLTT]

Hi Jay,

Right now we're using ACCPAC inventory control to do our assemblies for our product which only computes how much direct raw materials has been used per product. On the otherhand, we're using Service Manager 5.3B by Technisoft (

http://www.technisoft.com.au/home.aspx)

to track down how much direct labor costs has been incurred per product. Our problem is that this Service Manager doesn't have a direct link to the inventory module of the ACCPAC so what happen say Product A material cost is $50 then labor cost is $100 we can't generate a crystal report or any report to link this two and come up with Product A total cost of $150. My question, is there an ACCPAC module that concentrate on job costing that will give us a report of total direct costs(material & labor) per item that will match the ending trial balance amount of finished goods inventory for a certain period?

Is there would be a problem if we change our current ACCPAC vendor?

 

[jayconverse]

What you're describing is manufacturing, not service. This is the product I would have recommmended:

http://www.misysinc.com/index.html

Jay Converse
IT Director
Systemlink, Inc.

 

[robertoLTT]

Thanks Jay.
I will consider your recommendation and discuss it with my boss.

 

[robertoLTT]

Another problem I've just discovered is that our inventory control module doesn't compute the right costs per item. It's because the way it was set-up we can sell items to go below zero, definitely the FIFO costing will have a wrong cost per item. Do you have any idea how we can correct this costs per item?

 

[ettienne]

Do not allow NEGATIVE inventory.
You will always have a problem if you allow negative inventory, turn it off in IC setup options.

 

[robertoLTT]

Do you any ways how we can correct this problem (costs)?

 

[robertoLTT]

I mean do you know any ways how to correct this problem? now that we have a wrong ending costs per item.

 

[jayconverse]

At this point, you can only do a detailed reconciliation (that's why cost accountants have jobs). Run Day-end, do an I/C Adustment batch to put things back in line, and run Day-end again. Then, change your costing method to one that's correct for your business.

Jay Converse
IT Director
Systemlink, Inc.

 

[SophiaSun]

We are using the misys for our manufacturing. And we didn't allow the negative inventory in system. But we also find the actual cost is not correct but the standard cost is correct. I don't know what result this and how can I find the reason. Would you please teach me?

 

[jayconverse]

Do you have any formal accounting training?

Jay Converse
IT Director
Systemlink, Inc.