Hello everyone! thanks for your work on this great accounting system, I would like to know if Manager can perform this task (I am sorry in case I am repeating thread). I purchase a product based on weight, that’s the way the supplier invoice it, but it comes packed in rolls, Manager has performed pe…

Do the quantities in weight and in rolls have a fixed proportion? I was thinking, but I still have to test itthat you can use Inventory Kits made up of two items: quantity in weight and cost per units quantity in rolls When you buy you have two register two lines for two items and when you sell …

Interesting idea! I didn’t know Manager could do that. Well, they do not have the same proportion, i.e. each roll has a different weight. So for example, the supplier invoice me 100 rolls for a total of 3,500 kg, when I enter the supplier invoice to the system, I put in the predetermined quantity fi…

This is an intriguing idea, @Davide . Leave it to you to think up another creative use for inventory kits. But I think there may be problems: Inventory kits are not represented in some of the built-in reports. Only their constituent items show up. But maybe you can circumvent that with custom repor…

Just few questions because I have two possible solutions and one is so much easier. can we assume that each inventory item typology has always the same conversion rate between weight and rolls? Example: 1 roll of Item A is 50kg - 1 roll of Item B is 75 kg do you always buy in weight? do you need t…

Sure! No, each team varies in itself, for example, I could have 2 rolls from item A and both will have different weight. Yes Yes I do. For example, on the selling invoice the input is: Item A - X kg. - X units - X price - Total All I would need from the system is to keep track of entries and exits…

Based on your answers to @Davide , I think you should switch to rolls as your unit of measure. If necessary, duplicate items measured in kilograms can be used for purchases. Then production orders can be used to immediately convert to rolls based on the ratio for the specific lot. You should investi…

Thanks Tut, well, I think it might not be practical because rolls of item A for example could weight in average 20 kg, when rolls in item B 27kg and item C 32 item D 40 and so on, and since my supplier makes this rolls out from commodities he buys in kg too, that’s why he sells in kg (pre cured trea…

@wmartinez , I had a much simpler approach in mind. And it does not matter that average weight per roll varies from product to product: You order, for example, 20 rolls. In communication with your supplier, you convey that you understand he will sell you X kilograms. (The only assumption at this p…

So I don’t think that inventory items will work for you. How about keeping the existing custom fields and create a report in Report Transformation that will do calculations also on those custom fields? Since you cannot share custom fields between purchase invoice and sales invoices you will have tw…

Thanks Tut, the first solution might definitely work, I could do that, I’ll give it a try and see if that suits us, and come back to you. I appreciate.

Update inventory for custom fields

Uncategorized

Davide September 23, 2020, 7:22pm 19

Please read this thread

There is no guide since everything is still WIP

Topic		Replies	Views
Cutstom column + quantity total in Sales invoice Uncategorized	5	2471	March 24, 2016
Multiple units of measure for inventory at electric store Uncategorized	6	773	July 5, 2021
Inventory Control Uncategorized	14	1122	March 9, 2021
Can I round-up inventory Quantities? Uncategorized	6	620	February 16, 2021
About 2 units Uncategorized	24	1051	August 17, 2022

Update inventory for custom fields

Related topics