Description |
Changes to do for this ticket
# Add field 'Bill Received Quantity By' in Item -> Location setup
# Add field 'Cost UOM' in Receipt
# Move Line Total after Net field
# If 'Bill Received Quantity By' is 'Quantity', calculate Line total as 'Quantity to Receive' x Cost. Cost should be converted to 'Receipt UOM' for calculation.
# If 'Bill Received Quantity By' is 'Net' ,
## calculate Line Total as 'Net x Cost'.
## Cost should be converted to 'Gross/Net UOM' for calculation.
## Net field has to be mandatory.
## Pass Net Weight as Billed Qty to Voucher Entry.
## Pass Cost converted to 'Gross/Net UOM' to Voucher Entry.
## 'Add Receipt' button in Voucher Entry should also get d & e.
# If Cost is pulled from Contract, do not allow to change Cost or Cost UOM.
# Do Posting changes.
# For existing implementations use 'Bill Received Quantity By' = 'Quantity' by default. No data fix required.
# There is no changes required in Voucher Entry screen.
Assuming these changes does not affect calculations of Other Charges.
Contract information:
!pastedImage_d46427_0.png! Receipt screen:
!pastedImage_d46427_1.png! See attached [^IC-1511.xlsx] file.
The Receipt and Bill detail (grid) should look like this:
!11-11-2015 2-05-42 PM.png!
* When adding a purchase contract in the IR detail:
** The Receipt UOM will come from Contract Sequence > Quantity > UOM.
** Cost UOM will come from Contract Sequence > Cash Price > UOM.
** Cost per Cost UOM will come from Contract Sequence > Cash Price.
** Cost UOM and Cost per Cost UOM are both locked. User can't edit it since it is coming contracts.
* Calculating the line total:
** If Cost UOM and Receipt UOM are the same, calculate line total from Qty.
** Else if there is a Gross/Net UOM, then the system will calculate from Weight.
** Else, the system will calculate from Qty.
* When adding items when Inventory Receipt type is 'Direct':
** Cost per Cost UOM and Cost UOM becomes editable.
** When the Receipt UOM is changed, the Cost UOM will also change the same value. Ex. if the user changed it from *Bags of 60 kgs* to *Bags of 20 lbs* , the Cost UOM should become *Bags of 20 lbs.*
|