Relating Customer to Order Header not working

rbross

Hello,

Working with External SQL DB and we are having to refresh some AwareIM tables with data from the external DB
I have a process that will go find all the orders for a part#. All this is working good. But then I need to get the relationship between the Order Header and the Customer. I have the relationship in both the Customer BO and Order Header BO. I have this rule that runs in a the process after the order header has been created.

FIND AIM_OrderHdr WHERE AIM_OrderHdr.customer_id=AIM_Customer.customer_id
AIM_OrderHdr.ps_AIM_Customer=AIM_Customer
ps=peer single
I have shortcuts in the order header BO pointing the the Customer Name but they are not showing any data?
I have the same issue with the Supplier BO, and the Order Line BO, Not getting the relationship created properly?
I have a feeling its a timing issue on how I am trying to establish the relationship because the entries in the BO are correct. "Vlad Approved!"

tford

1) How is the order header created?

I have this rule that runs in a the process after the order header has been created.

FIND AIM_OrderHdr WHERE AIM_OrderHdr.customer_id=AIM_Customer.customer_id
AIM_OrderHdr.ps_AIM_Customer=AIM_Customer

Where is this rule?

rbross

passing in AIM_Customer,AIM_OrderHdr & AIM_OrderLine, not sure if they are all needed?
The rule to create the order header is on the order line BO.
Rule On AIM_OrderlIne BO is:

IF AIM_OrderLine IS NEW
THEN
RelatesOrderLineWithOrderHdrs

Relate Order lines With Order Hdrs Process
Rule#1 FIND AIM_OrderHdr WHERE AIM_OrderHdr.order_no=AIM_OrderLine.order_no
Rule #2 Create if needed IF SEARCH_COUNT=0
THEN
FIND oe_hdr WHERE oe_hdr.order_no=AIM_OrderLine.order_no
CREATE AIM_OrderHdr WITH AIM_OrderHdr.order_no=oe_hdr.order_no,AIM_OrderHdr.customer_id=oe_hdr.customer_id,AIM_OrderHdr.order_date=oe_hdr.order_date,AIM_OrderHdr.po_no=oe_hdr.po_no

Rule#3 Relate order to order line
AIM_OrderLine.ob_AIM_OrderHdr=AIM_OrderHdr (this works)

Rule#4 Find Customer for Order
FIND AIM_OrderHdr WHERE AIM_OrderHdr.customer_id=AIM_Customer.customer_id IN BATCHES OF 1
AIM_OrderHdr.ps_AIM_Customer=AIM_Customer (This does not work)

rbross

It appears I was doing my FIND statement backwards. I had
FIND OrderHeader WHERE... =Customer...
it should be
FIND Customer WHERE Customer.customer_id=OrderHeader.customer_id
OrderHeader.customer=customer ( that worked)

customaware

That looks totally illogical to me Roger. :-/