Insert a new Shipment Detail Line for a Misc Charge (1 reply and 1 comment)
Use an Aggregate; this is similar to the way the additional/shipping charges are added in Step 6 of the Sage300 Training Guide.
Please note that, the Calc Record should have the values:
- Set a formula on the 'Line number' field to SetFieldNull("Line number")
This will have the affect of clearing the value of the Line number. This is important as any value assigned to the 'Line number' field will make IMan search for an existing line and attempt to update it. - Follow the general steps described in the training manual for the LineType, Misc Charge and ExtendedAmount fields.
Thanks
Thanks, worked perfectly.
Greetings all,
Just looking for some preliminary design advice here please. My mission is to insert a new detail line to an existing shipment.
The detail line will be a Misc line (Linetype 2), and it needs to hold a value that sums up the tariff amount calculated for each line item. So right now I have a hierarchy that shows:
What's the recommended design for this? Aggregate transform? Additional hierarchy level that sums up the total tariff amount? Not sure how to create this new shipment line properly.
Thanks for the advice.
Arline