Insert Function

leopdurr

I have 3 BO
Invoice
LineItems
Fees

Invoice is Link to LineItem using ref: myInvoice - Multiple allow 1 invoice have several line items.
LineItem is link to Fee using ref: myFees

I want to Create and Invoice using a Rule that will Automatically Load a Set of Fees that I selected using PICK ONE OR MORE FROM function from a Query List of Fees

How can I construct my Rule to Insert the Fees that I choose inside my LineItems Automatically when Creating and Invoice.

This is what I have for me rule

PICK ONE OR MORE FROM 'Feelist' (This work it show the list of fees)
CREATE Invoice (This work)
INSERT Fee IN Invoice.myLineItem (This does not work)
EDIT Invoice (This work)

Can anyone help me with accomplishing this task.

Leopold

rocketman

First - after 2 CREATE, your invoice may have more than one line item in it, so your line 3 (INSERT) won't know which line item to apply the fee to, Also, you need to specify which attribute in LineItems will hold the fees (for this example I'll assume it LineItems.Fee so your logic needs a bit of refining.

Secondly, Do you want each line item on 1 invoice to have the same fee or do you want to change the fee according to the item you are invoicing. The way you were heading with your rule, you would end up with the same fee for each line item which may not be what you want.

Please provide more detailed information so we can help you better

leopdurr

This is what I want to accomplish.

FeeList Query.

Item 1 $50.00
Item 2 $1.00
Item 3 $5.00
Item 4 $9.50
Item 5 $0.00

I then PICK (Item 1, Item 3, Item 5) from my Query

After I choose those Items I want to Insert these 3 Items inside Invoice.myLineItem to Create the Invoice

Invoice:

Fee Qty Price
Item 1 1 $50.00
Item 3 2 $5.00
Item 5 1 $0.00

The problem is that. How can I get the Items I selected to Build my Invoice LineItems?

BobK

Leopold,

Have you tried picking just 1 fee from the Feelist to see if that works.

My guess is that INSERT only works with 1 record.

leopdurr

I am getting a message that it cannot find the reference. I dont think my INSERT rule is constructed correctly.

LineItem have a reference to FEE and not invoice.

How should the rule be constructed?

leopdurr

The message I a getting is that

Attribute myInvoice (Which is my Ref to LineItem) Not fount in Object Fee

rocketman

I think what you need to be looking at is to make LineItem.fee a drop down list which is created from the contents of the fees BO

Then as you are entering each line you can select a different fee for each item.

then set a rule in the BO something like lineitem.total =lineitem.fee.amount x lineitem.quantity

jacklcs

FeeList Query.

Item 1 $50.00
Item 2 $1.00
Item 3 $5.00
Item 4 $9.50
Item 5 $0.00

i then PICK (Item 1, Item 3, Item 5) from my Query

Create a Process:

PICK ONE OR MORE FROM 'Find Fee'
CREATE LINEITEM FOR EACH Fee WITH LINEITEM.MYFEEID=FEE, LINEITEM.FEEAMOUNT=FEE, LINEITEM.MYINVOICEID=INVOICE

IN THE BO OF LINEITEM CREATE THE RULE: - lineitem.total =lineitem.fee.amount x lineitem.quantity

If you want to fixed the quantity, then create the rule.

Hope it help..

thanks.

rocketman

yep - that should do it. Nice code Jacklcs

leopdurr

Brilliant!!! 😃

Thank you so much. The FOR EACH parameter was the key I had tried the CREATE before but it was only creating 1 row.
Is there any section in the Documentation that have these PARAMETERS for each Function?

Thanks again Yet another reason why I love the Product the level of support from my fellow developers and AwareIM Team

Thanks again
Leopold