Creating invoice from backorder

joftech · Post by **joftech** » Wed Oct 25, 2006 12:00 pm

Hi Support,

What is the best way to generate an invoice form a list of line items that are backorders.

Thanks

Alan

aware_support2 · Post by **aware_support2** » Wed Oct 25, 2006 12:53 pm

Alan,

Could you please describe your scenario in more detail.

joftech · Post by **joftech** » Wed Oct 25, 2006 1:15 pm

I have a Business Object called Invoice and a Business Object called InvoiceLineItems.

InvoiceLineItems contains attributes with details of the item including qty ordered, qty suppleid and qtybackorder.

There is a rule qtybackorder=qty ordered-qty suppleid.

I have a quirie that generates a report listing those lineitems where qtybackorder>0, the list has the original invoice no cleintid etc

I would like to generate a new invoice from the report that was generated by the quiry that finds qtybackorder>0.

Alan

aware_support2 · Post by **aware_support2** » Wed Oct 25, 2006 1:52 pm

> I would like to generate a new invoice from the report that was generated by the quiry that finds qtybackorder>0.
1) By invoice here do you mean a report or an object?
2) If it is an object, for what purposes you intend to use it once it is constructed?
3) What values should the quantity attributes in line items for the new invoice have?

joftech · Post by **joftech** » Wed Oct 25, 2006 2:18 pm

1) By invoice here do you mean a report or an object?
I mean an onject.

2) If it is an object, for what purposes you intend to use it once it is constructed?
I intend to make a new invoice

3) What values should the quantity attributes in line items for the new invoice have?
The backorder qty and the clientID

Alan

aware_support2 · Post by **aware_support2** » Wed Oct 25, 2006 2:52 pm

Add a process CreateBackorderInvoice with no input and the following 3 rules in it:

1) FIND InvoiceLineItem WHERE InvoiceLineItem.QtyBackorder > 0
2) CREATE Invoice
3) CreateBackorderInvoiceLineItem

Add process CreateBackorderInvoiceLineItem with objects Invoice and InvoiceLineItem as its input. The object should have the following single rule:

CREATE InvoiceLineItem WITH InvoiceLineItem.Invoice = Invoice, InvoiceLineItem.QtyBackorder = ThisInvoiceLineItem.QtyBackorder, InvoiceLineItem.ClientID = ThisInvoiceLineItem.ClientID

To create a backorder invoice, start process CreateBackorderInvoice. Rule #3 of process CreateBackorderInvoice will be called for each item found in rule #1. Process CreateBackorderInvoiceLineItem will make a copy of the given item and attach the new item to the new invoice.

joftech · Post by **joftech** » Wed Nov 08, 2006 10:58 am

Hi Support,

Still having a problem wiht the back orders. I setup the rules as suggested.

I get the following error in when testing.

Operation error. Value of CatalogueNo must be provided

CatalogueNo is the link to stock business object.

Alan

joftech · Post by **joftech** » Wed Nov 08, 2006 11:53 am

Hi,

Ok I fixed the error problem.

One question. I do not want to have to tell the system which invoices to use.
The system should knoe from the query Find Backorder.

I however get a list which asks for user input.

How do I overcome this.

Alan