Search options (Page 4 of 12)

Well, after looking around it looks like the Sales Reports -> Price Listing report is pretty close to what I need.

I like the GP% but would like to add an optional cost column.

But the Gross Profit is based upon the Material Cost (running  average)

If I have some large cost changes (which I have, one Rare Earth Material I rely upon has increased 5x-6x in the last year)
I would like to reset the average material_cost (stock_master) to actual cost.

I am thinking of a simple module that clears all material_cost and recomputes material_cost based on foriegn item_codes
and manufacturing BOM's

I could then re-run the Price Listing and check the GP to see what prices need to be adjusted.

The nice part is the report can be loaded in excel if needed...

Now... (finally a question)

Will updating the material cost to actual cost have any serious negative impact from an accounting point of view?
(like violate any Accounting 101 concepts)

or is it maybe just a Good Idea?

tom
ps. I also notice that last_cost is updated, but all of my actual_cost fields are 0, is that normal? Is actual_cost no longer used?
pps. actual_cost is only referenced in One place... read only... includes/ui/items_cart.inc   the constructor for class line_item

How can developers request values for modules they create?

Maybe set a range for local use and any others need to be allocated by the core development team?

tom

I just upgraded from 2.2.10 to 2.3.5 and had no problems.

But as always - BACKUP BACKUP BACKUP!

I also installed into a new directory and new database, mostly so I can run both side by side... just in case

tom

'define ('SS_IMPORTCUSTOMERS', 105<<8);'

I think a more important question is: Does the 105 have to be unique across all add-on modules?
Are we granted security permissions based upon that bit mask?

If two modules have the same SS_ value won't they be controlled together in the security settings?

Tom

I guess it will be a small module... or maybe a Report...

The closest thing I have found is Manufacturing-> Costed Bill Of Material Inquiry it is one item at a time, not a report.

But that uses the Unit Cost (I guess which is a running average from manufacturing)

I have gotten an updated price list for all my bulk products and would like to get all the manufactured items Unit Costs updated to match.
Then I can take the price list apply my markup and generate a sales price list...

It looks like I need to do a lot of this manually...

tom

I can't imagine that that has changed.

Is it possible that TB_PREF is wrong?

What company number are you working with?
Maybe the module install had TB_PREF set wrong?

tom

Under Sales->Manage Customer there is a pull down menu "Sales Type/Price List"

That pull down is a complete price list for all products.

These price lists are created under Sales->Sales Types
Once created you can edit the per item prices under Items and Inventory->Sales Pricing

I looked at the factor field in the Sales type and it seems to be used to automatically generate
a price based upon the Base Price using that factor if there is no Sales Pricing defined.
If there IS a Sales Pricing price entered it will use it (and ignore the factor)

You should be able to create a price list with the factor = 1.00 (100%) and then edit the
prices as you see fit under Items/Inventory -> Sales pricing

It is actually a helpful shortcut, if you know you can offer 5% off of any product you can use
a factor of 0.95, now if you have some items that you want to make 45% off you have to enter
that price by hand.

Any prices manually entered will have to be manually updated when prices change.

Tom

Could it be as simple as clearing the 'reconciled' field?

But there is still the question of where are the beginning/ending balances stored for each statement.

Perhaps a bank_trans transaction?

tom