Hello,
I want to ask how can I get any document like “bill of goods” or something like that when I transfer goods from one warehouse to another. That’s 2 different places where works different people there should be a document when transfer goods between them.
Regards,
Rumen
HubZ
September 15, 2021, 3:36pm
2
Hello,
You may find smthg that is not yet implemented but developped :
opened 05:23PM - 15 Apr 18 UTC
Feature request
hacktoberfest-accepted
good first issue
# Feature Request
The stock movement module in its current state is incomplete … and very limited in functionality.
I think we need to restructure this module so that it complies with the standards and respects the processes of the movements of stock in most organizations.
In the first step we must add a new table to list the movements by: _operation / **operation_type** / date / inventory_code / warehouse out/ warehouse in / user / sender / receiver /..._
This table** (**) ** to rebuild from the current stock_movement table.
The **types of operations** are generally like the following: (to be added in a new table of constants llx_c_stock_mouvement_type)
- **Exit movement:** currently it's done in the article sheet.
- **Movement of entry:** currently it's done in the article sheet.
- **Transfer movement:** The transfer movement normally has to be entered by the storekeeper of the source depot and received by the warehouse keeper of the destination depot + signature between the two warehouse workers + other additional information (Carrier, registration number of the truck ...) .
- **And finally an inventory movement:** the purpose of this movement is to perform outputs or inputs depending on the state of the system stock and the physical inventory.
The movements of stocks must be tracked and monitored by the internal control services and also by the accountants for this to have printed and signed documents is an obligation. So we must also add the generator of pdf in the management of the movements of stock.
A log of all movements is very important too (this is the current case of stock_movement) you just have to add a pdf generator to print them monthly or annually (add a periodic filter?).
There may be other details that have escaped me, but it's already a very important step to achieve this module for a good ERP.
Best regards & good work
(**) A proposal:
CREATE TABLE `llx_stock_mouvement_list` (
`rowid` int(11) NOT NULL auto_increment,
`tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`datem` datetime default NULL,
`eatby` date default NULL,
`sellby` date default NULL,
`fk_entrepot` int(11) NOT NULL,
`total` double(24,8) default '0.00000000',
`type_mouvement` smallint(6) default NULL,
`fk_user_author` int(11) default NULL,
`label` varchar(255) default NULL,
`inventorycode` varchar(128) default NULL,
`fk_origin` int(11) default NULL,
`origintype` varchar(32) default NULL,
PRIMARY KEY (`rowid`),
KEY `idx_stock_mouvement_fk_product` (`fk_product`),
KEY `idx_stock_mouvement_fk_entrepot` (`fk_entrepot`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
You have to try to implement it yourself or contact an integrator of the community that could help !
That’s a “trendy” request I have seen many developments arround it in the Github
Hello,
HubZ
September 19, 2021, 7:54am
4
So you must develop it if you cant adapt it to your needs. Thougt it would be useful and easy. You’re welcome.
