[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

A query about price matrix code



Folks,

I've written an oscommerce-ledgersmb bridge and it largely seems to work. At the moment it does the following:

1. Creates new parts in Ledgersmb based on items in oscommerce, including price matrix
2. Creates new customers in ledgersmb based on oscommerce
3. Creates new sales orders in ledgersmb based on orders received through the web site.
4. Updates website  parts inventory based on ledgersmb.

It runs as a regular cron job at whatever frequency you need. The only downside is that website inventory may lag real inventory.

I'm just about to start using this for real. I'm migrating my accounting system from gnucash to ledgersmb and during the testing I've come up with a problem with price matrices, which may be just my misunderstanding, but I can't seem to find what I am doing wrong. Basically, I create a generic price matrix for a part (no pricegroup, no customer specific) with breakpoints at various values. When I manually create a sales order or a quotation with a quantity that should trigger the price break I don't get a price reduction, just the basic list price. This happens whether I have entered a part with a price matrix manually, or via my bridge.

I'm running LedgerSMB V1.2.16 on Ubuntu Hardy. If this is a known problem, please accept my apologies and point me at the documentation.

Many thanks

Nigel