gaurav-naik/andesit_karang_anyar

Andesit Karang Anyar

ERPNext customization for Andesit Karang Anyar

License

GPL v3

andesit_karang_anyar's Issues

WBT-Weighbridge Integration

Prepared and shared note: identifying and comparing alternate workflows.
Said's feedback awaited

Display Item Name in Purchase Invoice

ERPNext V7 displays only Item Code in the items grid of Purchase Invoice. Inspection of data revealed that most items for Purchase Invoices were entered via Item Name field and not selected in the Item Code link field.

Displaying Item Name field alongside Item Code was considered a viable solution.

Licence must be validated to have 12 digits

Client side + server side validation
ETA : 0.75 hours.

Only One row can be added/used for the WBW

Single row validation: WBW grid in Purchase Order doctype.
ETA: 0.75 hours.

Batch processing is to be done based on a filter of WBWs Issued on the day or a date range filter to be applied to both Customer and Supplier

"Use payment tool.
Customization: Automate Payment Amount allocation to line items.
Add date range filter for Sales Invoices.
OR Checkbox to include / exclude."
ETA: 5 hours

The second weighing will be active when the Purchase Receipt is created

Custom script: 4.6.1 + verify existence of purchase receipt.
ETA: 0.5 hours

Naming Conventions

Can we please name the App Weighbridge Management as Andesit Karang Anyar is the company name

When creating a Purchase Order and the supplier is selected, this selection must correspond to the Supplier in the WBW doctype and vice a versa for Sales Order but must correspond to Customer

"Custom script. Disallow selection of any supplier other than the one selected in WBW.
(Post WB-Link. PO will be autogenerated and supplier info will be set from WB info.)"
ETA: 0.75 hours

Driver Photo

"Replicate Address and Contact feature from Customer/Supplier

Set in Driver doctype?
Field and code to pull value into Vehicle Doctype.
Field below licence no field."
ETA : 5 hours.

Replicate 'Print Without Amount' feature of Delivery Note in Purchase Receipt Doctype

1. Add custom field 'Print Without Amount', type 'Check'. Must be checked by default. Value should be 1 or true.
2. Add custom script.
   In handler for refresh event, set the 'print_hide' property to True for fields associated with amount in Purchase Receipt and Purchase Receipt Item

Developer Notes:

1. Check behaviour of original feature in Delivery Note.
   Create a delivery note and save it. Click on the print icon before and after checking Print Without Amount field to true. (Printing Details section)
2. Refer to the function 'before_print' in delivery_note.py (Line 64) to see which fields to hide.
3. Fields to be hidden via custom script.
   Use the set_df_property() method.
   Refer to weighbridge_ticket.js

Driver Name instead of Driver License in WBT

@saidsl

Hi Said

Added a read-only field driver_name in WBT. It can be used directly in the report customization that you wanted to do.
The changes have not been released to the live server yet. Shall we go ahead with it or would you do it?

Thanks.

Weigh Bridge Ticket cannot be submitted until first weighing and second weighing have been recorded.

Custom script: WBW exists and WBW. First and Second wt have valid values.
ETA: 0.5 hours

Dashboard Reports

I added a Dashboard on http://test.andesitkaranganyar.com and it works fine. However, as the the reports are in SQL, I need some Query based reports to be made as follows.

1. Outstanding funds by customers
2. Funds to be paid to Creditors
3. Sales by Products By Day / Week / Month
4. P&L

This list may grow in the coming days

The developer of the Dashboard App has created some sample reports and whilst they work fine there are some modifications to be made, one being the representation of the figures, somehow there is a conversion being made and the Rp Values are being truncated to just 3 figures, as you can see from the screengrab below

You can obtain the Dashboard App from https://github.com/hercules-global/dashboard.git

Tare Weight Inclusion & Implementation

Based on the initial scope, the tare weight was to be obtained from the entered value in the Vehicle DocType, however, due to conditions on the site/field, this approach is subject to abuse, therefore, Tare Weight must now be obtained in the First or Second weighing depending on whether its an incoming or outgoing load.

Incoming Load = First Weighing --> Gross Weight
Incoming Load = Second Weighing --> Tare Weight
Result = GW - TW = Nett Weight
Nett Weight is what must match with the Qty in the Purchase order.

Outgoing Load = First Weighing --> Tare Weight
Outgoing Load = Second Weighing --> Gross Weight
Result = TW - GW = Nett Weight
Nett Weight is what must match with the Qty in the Sales Order.

We will retain the Tare Weight field in the Vehicle Doctype for Comparison and use it to validate the Vehicles.

WBW Cannot be created on its own.

"Disable Add New Row in grid on all relevant forms.
(PO, PR, PI, Payment, JV)
(SO, DN, SI, PR, JV)"
ETA: 5 hours.

Create Weighbridge Ticket doctype

Use test.andesitkaranganyar for reference.

Use separate link fields for Customer and Supplier.

When a vehicle is selected, only the drivers for that vehicle must appear.

"Add filter query to Driver field in WBW doctype.
(Post WB-Link: WBW will be auto-created at PO / SO. Driver will be set automatically from WB data.)"
ETA: 0.5 hours

Customer & Supplier Select

Replace dynamic link with separate link fields.
ETA: 0.5

Prerequisite: Issue #13

Implement Indonesian Translation

As the Indonesian language translation is not accurate, I need to modify the Indonesian Language File directly as it will take too long to do via the translation site https://translate.erpnext.com.

And how do we implement translations for the new app that has been created.

Can you please assist in installing/activating/setting up once I''ve completed the translation? or Advice how its done

Make Vehicle Doctype a simple (master) doctype.

Vehicle Doctype is currently implemented as a child doctype.
In the final app, it will be implemented as a master doctype.

The QTY value of the both POs & SOs must always correspond to the WBW.

Custom script. Compare values

The total of the First weighing Must match total Qty in Items (NOTE: this is reversal in SO, since its Tare Weight initially than loaded weight in second weighing)
The second weighing must match the Tare Weight entered in the Vehicle DocType. (NOTE: this is reversal in SO)

ETA: 2 hours.

Reporting

One of the items that was requested in the initial Brief was the need to create some custom scripted reports. The most immediate being

1. Purchase Order & Sales Order -- Total Row. Seems this is an issue with ERPNext and there is no resolution in the Forum how best to resolve
2. WBT -- Total Row. Same as above needs total row for Nett Weight

I will add to this list in the coming days,

Thanks Said

The second weighing cannot be active at the first weighing.

Custom script: Disable second weighing fields until first weighing is set.
ETA: 0.5 hours

Begin Migration of App

Hi Guys,

Seeing as how we are almost completed the bulk of the work, can we begin migration to the Live Server initially, which is at http://admin.andersitkaranganyar.com

Thanks