Project Contract for WMS

The migration of Adempiere modules to iDempiere

Project Contract for WMS

Postby red1 » Wed Jul 26, 2017 1:04 pm

I am making another plugin that will sit on the WMS module. The idea is to reduce paper work and too many clicks to achieve a simple process of receiving contract supplies from a vendor.

Usually the WMS owner has a contract or forecast to get supplies regularly or based against a quota. The vendors may be in better position to say when they can deliver the goods and the only advance notice they can give is 2 hours or same day delivery.

In this case the WMS owner already knows its contractual long term lum sum to expect and may give out 'purchase order' requests verbally. The only real document other than the contractual understanding will be a 'DeliveryScheduleList' from the vendor.

This Project Contract basically takes the Delivery Schedule List and set to the contractual Project Order and back track generate a corresponding Purchase Order.

Then the WMS awaits the actual delivery and the WMS proper takes over. When all is done and Putaway is complete, its corresponding Material Receipts will be generated.

The Project Contract can then Issue back to Project the Material Receipt details. As this works on the back of a Project Order, it does overlap numerous items in the Project Order menu such as GeneratePO and IssueProject, and the WMS menu such as Order to Delivery Schedule. Thus this Project Contract merely saves the end user hassle of those extra windows and steps.

The processes are also run from the main Project Contract gear-wheel pull down list, rather than the main menu sub list. All for a more singular window end-user experience.

The final outcome will be a WMS process that is tracked by a Project ID. That also means up to account posting, the Project dimension can be utilised readily as Activity Based Costing (ABC).

The structure of this new plugin, as usual, will use the magic Ninja module maker. Below are the Excel data sets to kick it off.

PM_ModelMaker.png
PM_ModelMaker.png (73.28 KiB) Viewed 485 times
PM_CodeMaker.png
PM_CodeMaker.png (50.73 KiB) Viewed 485 times
red1
Site Admin
 
Posts: 2705
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Re: Project Contract for WMS

Postby red1 » Sat Jul 29, 2017 9:12 am

The plugin with model and code is done! Here are the screenshots and some explanations:

ContractPurchase.png
ContractPurchase.png (97.19 KiB) Viewed 464 times
This is the sub Purchase model under the Contract window to indicate this Purchase quota against the Contract quota let's say 100 pieces of Hoe. In the sub Purchase tab, user need not even fill it in but gives a verbal call to the vendor (this is how most traditional businesses are run) and awaits the vendor to send the shipment. Next the vendor prepares the goods and made a fax, or email with the intended shipment giving often as short as same day or two hours before it arrives.

ContractDelivery.png
ContractDelivery.png (67.77 KiB) Viewed 464 times
From the email or Excel attachment (this is the proposed method to avoid redundant work by user of input details again and making human errors) the item line quantities are put in. Nothing else to key in - no need product code (as it will be taken either from the Contract header or Purchase tab, price list etc. The system will take care of the rest and back-create the Purchase Order and the WMS Delivery Schedule lines automatically. Below are the two buttons from the Process icon to do so:

ContractProcess.png
ContractProcess.png (21.47 KiB) Viewed 462 times
And after running the first process:

DeliverySchedule.png
DeliverySchedule.png (103.59 KiB) Viewed 462 times
red1
Site Admin
 
Posts: 2705
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Re: Project Contract for WMS

Postby red1 » Mon Jul 31, 2017 8:18 am

And when you call up the Info-Window for drafted Delivery Schedule, it is all magically setup awaiting Received, and the Putaway List creation.

DeliveryScheduleInfoWindow.png
DeliveryScheduleInfoWindow.png (69.12 KiB) Viewed 450 times
After conducting Putaway, user can then return to the PM_Contract menu to Complete the WM_InOut in tandem during the Issue to Project process. All this makes life easier as the user can have a higher command and control view from the Contract window and leave WMS windows for floor operations. Later we shall have new working reports borrowed from the Project menu (as they are limited there not giving differences to quantitavely other than qualitatively).
red1
Site Admin
 
Posts: 2705
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Re: Project Contract for WMS

Postby red1 » Sun Sep 17, 2017 3:26 pm

Now, Invoice will also be automatically created during Issue Project Process. This is after it made sure the Material Receipt it created has no confirm stoppage. (So you need to go into the Document Type and set Material Receipt as Default and also at the Material Receipt with Confirmation, has its box bottom right box 'Ship/Receipt Confirmation' unchecked, just to be double sure. See image below.)

Screen Shot 2017-09-17 at 3.02.07 PM.png
Screen Shot 2017-09-17 at 3.02.07 PM.png (78.33 KiB) Viewed 244 times
If all goes well, you can check the new Invoice from the Drill Thru icon at the top window bar of the Purchase Order linked to the PM ContractPurhase tab. See below.

Screen Shot 2017-09-17 at 3.01.25 PM.png
Screen Shot 2017-09-17 at 3.01.25 PM.png (28.92 KiB) Viewed 244 times
Note also the WMS Delivery Schedule and Material Receipt docs are also linked nicely.
The sub tab of Purchase can also do the same two processes. The code will just process that tab record user is at. The Contract tab remains the same which goes thru all Purchases to see which has not been processed yet.
red1
Site Admin
 
Posts: 2705
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Re: Project Contract for WMS

Postby red1 » Tue Oct 03, 2017 4:51 pm

Source-Code:http://bitbucket.org/red1/org.pm.contract
Binary:http://sourceforge.net/projects/red1/files/Warehousing/ ContractPurchase_1.0.0.jar
Plugin Name in OSGi Console: ContractPurchase


The Contract Purchase now has an Info-Window that can reprocess BackOrders that happened during WMS receive. This Info-Window follows the same design as the BackOrder Info-Window. However this Contract model has consolidated OrderLines and thus cannot handle backorder from the WMS Info-Window. That is why i designed this Contract Purchase Info-Window to retrieve such backorder during WMS receive.

ContractPurchaseInfoWindow.png
ContractPurchaseInfoWindow.png (92.74 KiB) Viewed 146 times
You can see the difference in QtyReceived vs the QtyOrdered. This will make the row reappear here for generate again a fresh WM Delivery Schedule. To access this Info-Window, go to the newly installed plugin from the Main Menu and click on the Info-Window:

Screen Shot 2017-10-03 at 5.14.55 PM.png
Screen Shot 2017-10-03 at 5.14.55 PM.png (19.59 KiB) Viewed 143 times
red1
Site Admin
 
Posts: 2705
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia

Re: Project Contract for WMS

Postby red1 » Wed Oct 04, 2017 12:25 pm

Done test suite for ContractPurchase that has consolidated OrderLine due to master product at main tab level. Then 2nd test with Different Products at each ContractPurchaseDelivery tab turns out correct treatment.

Screen Shot 2017-10-04 at 12.22.35 PM.png
Screen Shot 2017-10-04 at 12.22.35 PM.png (64.63 KiB) Viewed 137 times
Next test, I will do a difference in receipt at WMS to affect a BackOrder.
red1
Site Admin
 
Posts: 2705
Joined: Tue Jul 06, 2004 3:01 pm
Location: Kuala Lumpur, Malaysia


Return to iDempiere

Who is online

Users browsing this forum: No registered users and 1 guest