Jump to content

Conversions or Matrix Table problems


This topic is 6637 days old. Please don't post here. Open a new topic instead.

Recommended Posts


I had this unsolved problem I'd like to solve with the 7's update I'm building.

Basically, the company buy and sell items.

In the Catalog Table, each item has a Manufacturer Packaging and a Purchase Unit as a standard.

But the sale units may differ from the purchase units, and depending wether the product is bought from the Manufacturer or from a Wholesaler, they may be up to 3 possible Purchase/Selling unit systems entered in the line items, but the result entered should always reflect our price policy.

Examples :

1) a pot of glue of 25 Kgs

purchaseUnit ??? Kgs

saleUnit : pot (of 25 Kgs)

2 pots of glue (25 Kgs) purchased 2 x 25 x .5

Link to comment
Share on other sites

I understand this might not have been correctly explained.

Here's a file that should explain better what I'm looking for.

Thanks for any input. smirk.gif

The attachment was updated. Each product selected has a comment field where I did say what the result of the conversions should be, but I have no clue at the moment how to evaluate this at the fly.


Link to comment
Share on other sites

--Case Solved--

For information, the solution is rather complex.

It requires that each possible switch be stored in a separate Table with for example :

Category ??? Tiles

PurchaseUnit : SqM

SellingUnit : PC

Conversion Formulae

A link to that table on both the Category, Purchase Unit and SellingUnit, and an auto-entered value set to recalculate (with a flag included to lock it) includind nested Evaluation ( ) and Lookup ( ) function.

The formulae evaluated from the context of each Table is like PurchasePrice / Nbitems, each being a field looked up (in line items) to which I'd append the Table Name and the semicolons.

Link to comment
Share on other sites

This topic is 6637 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.