search

twanda / vertical-agriculture

Verticalization of Odoo for farms and agroindustries
GNU Affero General Public License v3.0
0 stars 1 forks source link

Customized Traceability Report #37

Open dastcaboz opened 2 years ago

dastcaboz commented 2 years ago

We need a customized traceability report for our reporting requirements with the authorities. This applies for each delivery to the port, i.e. the Pick Transfer from Stock to Output. Please see attached excel Fiche d'accompagnement.xlsx .

treviser commented 2 years ago

If I understand this correctly, this should be an amended equivalent of our incoming receipt. Can you please provide an english translation of the terms and the relation to the Odoo terms if possible? My questions at first sight for example:

dastcaboz commented 2 years ago

what is the chauffer (driver)? Is it the purchasing agent? If not, is it a new partner role? Not a new partner. Just the driver of the truck. If possible to resolve with a field without function in the Pick Operation.

What is coopérative? Is it the company or is it the warehouse? The Company. In this case SCOPACI.

What about the license plate and its relation to the driver? No fixed relation. If possible just an empty field without function. Truck and driver can change from delivery to delivery.

Num. Conaissement: is it our receipt number? This is number communicated to us by the authorities. Field without function on the Pick Operation.

What is the project? Our certification scheme. RA = Rainforsest Alliance. Could be several in the future. So it would be good to have a field like Analytic items with the option for several items.

What is poids net (net weight)? are these the weights before weight correction? I had a long discussion with the team about this. We have a serious problem in audits if this weight does not correspond to the initally registered weight before weight correction. The total of this weight must correspond to the total of all farmer lots on this list. If we use the inital weight, it will not correspond to the weight on the truck as weighed at the port. This puts this whole weight correction we have invested so much into question. I have no answer at this moment. Let me reflect on this.

dastcaboz commented 2 years ago

Can we separate the weight taken at our warehouse input from the farmer lots? So that the traceability is done on the original weight and our commercial relation with the pisteur on the weight taken at the warehouse input?

What do we do in this case with inventory corrections? If we cannot chnage the farmer lots in the warehouse. Could we use virtual vendor to balance?

treviser commented 2 years ago

@dastcaboz ...those who can read have a clear advantage... :-( I did not realize that you are talking about the pick deliveries to the harbor, mistakenly I thought about the incoming receipts...

dastcaboz commented 2 years ago

The report is for the pick deliveries to the harbor. But it relates all back to the incoming deliveries from the farmer. To correspond to audit requirements the initial weight must remain the same throughout the traceabilty to the harbour.

At the same time we need to know the eact incoming weight, as this is important for our commercial relatiuon to the buying agent.

Ein harte Nuss das !!

treviser commented 2 years ago

what is the chauffer (driver)? Is it the purchasing agent? If not, is it a new partner role? Not a new partner. Just the driver of the truck. If possible to resolve with a field without function in the Pick Operation.

OK, no issue then, as you proposed, just two additional fields in the pick operation (driver and license plate)

Num. Conaissement: is it our receipt number? This is number communicated to us by the authorities. Field without function on the Pick Operation.

It would be the easiest, if we could use the pick slip number created by Odoo. It is unique by design.

What is the project? Our certification scheme. RA = Rainforsest Alliance. Could be several in the future. So it would be good to have a field like Analytic items with the option for several items.

You could define projects accordingly (I'd have to install the project app) and then we could assign the related analytical account.

What is poids net (net weight)? are these the weights before weight correction? I had a long discussion with the team about this. We have a serious problem in audits if this weight does not correspond to the initally registered weight before weight correction. The total of this weight must correspond to the total of all farmer lots on this list. If we use the inital weight, it will not correspond to the weight on the truck as weighed at the port. This puts this whole weight correction we have invested so much into question. I have no answer at this moment. Let me reflect on this.

We could take the original pick slip before weight correction at the harbor and create a "fake" slip which reports the original weight at the farm's location of each contained lot. This means that we take the weight registered in the original incoming receipt before applying the incoming weight correction. This original weight is permanently saved in the database because it is the first movement in the stock keeping and the weight correction is always a separate operation with its automatically created additional movement.

dastcaboz commented 2 years ago

We could take the original pick slip before weight correction at the harbor and create a "fake" slip which reports the original weight at the farm's location of each contained lot.

I thought about this. But then the total weight of the original farm deliveries does not correspond to the weight of the Pick and the difference to the weight measured at the port might be too large. During audit they compare these weights.

treviser commented 2 years ago

We could take the original pick slip before weight correction at the harbor and create a "fake" slip which reports the original weight at the farm's location of each contained lot.

I thought about this. But then the total weight of the original farm deliveries does not correspond to the weight of the Pick and the difference to the weight measured at the port might be too large. During audit they compare these weights.

Well, that is mathematically impossible, just plain simple.

treviser commented 2 years ago

The only way out of this mess is probably by weighing the incoming farmer lots separatedly, which by itself means that the produce of the farmer must be packed in bags and these bags must be identifiable by the farmer.

dastcaboz commented 2 years ago

This is unfortunately not possible currently.

dastcaboz commented 2 years ago

I think we have to go ahead with what we have. i.e. weight correction option at warehouse entry.

To make things simple with reports:

dastcaboz commented 2 years ago

Another question we never tested: How does odoo handles stock corrections in our case? Logically it should do the same as with weight corrections?

dastcaboz commented 2 years ago

Is there any progress on customized traceability report?

treviser commented 2 years ago

AuthoritiesPickDeliverySlip.xlsx @dastcaboz Please check the translated report and provide a meaningful english report title.

@candidroot This is an additional report based on the Odoo pick delivery slip. It has to be provided to the authorities for pick deliveries delivered to the harbour. It requires to add additional fields to the pick operation after creation of the pick delivery. The original weights are the original weights of the incoming lots per farmer with their original weights before a weight correction if any. @dastcaboz I'm not sure about the number of bags, does it relate to the original "bush bags" from the original receipt to the warehouse or is it just to be entered manually based on "Export bags" at the time of loading of the truck?

treviser commented 2 years ago

@dastcaboz What does Project mean and what is it related to, or is it simply a manually entered field without any relation? You know that we can create projects and/or analytical accounts to relate to, if that is of any interest.

danielstaehli commented 2 years ago

Project means the certification scheme. Currently our operations are Ranforest Alliance (RA) certified. This can change in the future or a second or third certificate might get added. On the delivery slip only one Certification scheme is displayed, depending on the certification under which the customer buys. Could be thta customer A buys Rainforest Alliance, customer B buys Fairtrade.

At this time I would leave this a field without a relation. We have to discuss, if this will change in the future.

dastcaboz commented 2 years ago

I have added a new column with the # of the lot. The # of bags and the weight must correspond to the original lot at reception. AuthoritiesPickDeliverySlip.xlsx

treviser commented 2 years ago

@dastcaboz Please be aware:

It is important to be as specific and clear as possible :-)

dastcaboz commented 2 years ago

You are right. I adapted the fields in the report. AuthoritiesPickDeliverySlip.xlsx

treviser commented 2 years ago

@candidroot Any news on this?

candidroot commented 2 years ago

@treviser can you elaborate this report ? i need more details.

treviser commented 2 years ago

@candidroot related to the excel-delivery slip provided above, can you please be more specific about what is not clear to you?

dastcaboz commented 2 years ago

Where do you stand with this issue?

candidroot commented 2 years ago

@treviser From where we need to fetch the "Loading Date (Pick)" and "ID of Pick Delivery" ? is it new fields and manualy data fill?

candidroot commented 2 years ago

@treviser how can we get farmer from picking ? we need to link farmer and receipt. pleae provide your input

treviser commented 2 years ago

@treviser how can we get farmer from picking ? we need to link farmer and receipt. pleae provide your input

@candidroot Hi Siddharth the pick operation is a a manual push delivery from the warehouse to the harbour and it is processed FIFO, so we have a list of all lots in this delivery. The loading date is the delivery date of this delivery and the ID is the Odoo-Delivery-ID preferably.

candidroot commented 2 years ago

@treviser how can we get farmer from picking ? we need to link farmer and receipt. pleae provide your input

can you provide your answer for this?

dastcaboz commented 2 years ago

@candidroot Hi Siddharth, Trevi is unfortunately at the hospital. I will get in touch with you next week to see how we will procede. Happy new year to you. Best regards, Daniel