| Description |
*Steps to replicate:*
# Restore Customer's database
# Setup Easy Automation
# Use this data
# !pastedImage_d125123_0.png|height=533,width=409!
# Import the invoice
# Print the invoice
*Issue* :
Previous tickets called for the ability to roll raw materials belonging to the same recipe (subFormula) into the finished good on the Invoice Print (aka One Line Print).
Through testing Derek and I discovered that the fields were successfully created on the tblARInvoiceDetail table but they are not getting populated.
!pastedImage_d125123_1.png|height=251,width=339!
*Accepted* :
Also, the raw materials are not getting rolled into the subFormula item on the invoice. Here's what we need to do:
# Populate the strSubFormula field within the tblARInvoiceDetail with the contents of the json field.
## Keep in mind that there could be more than one subFormula on a given invoice.
## Ignore the intSubLocationId for now.
# Modify the Invoice Print to group and sum all raw materials into their parent subFormula.
## You must calculate the individual raw material total prices first and then sum all for the subFormula total price.
### subFormula Shipped = Sum(rawQtyShipped) using base UOM
### subFormula Total = Sum(rawQtyShipped * rawPrice)
### subFormula Unit Price = subFormula Total ($) ÷ subFormula Shipped
## Note: this should be safe to do without a config because no one else is using the strSubFormula field.
### In other words, the invoice print should not group items unless this field is populated.
Assuming that the above subFormula only has two raw materials, the invoice print should look like the following:
!pastedImage_d125123_2.png|height=404,width=774!
However, the invoice within the UI should remain the same. In other words, all raw materials would show on the invoice entry screen.
|