I cant find the link from the tables you gave, Im confused because there is no link between the table AP Invoice table which is OPCH and AP Downpayment Invoice which is ODPO,
Since we don't use AP Downpayment Invoice, the ODPO table is empty. I could not verify any links. My suggetion is to run a query like:
Select T1.DocNum, T0.BaseRef, T0.TrgetEntry From DPO1 T0 Inner Join ODRO T1 ON T1.DocEntry = T0.DocEntry
to see what numbers are in the table. If all Base and Target regrences are empty, then there is no direct link between any tables. Only reconciliation take care of them.
I have tried that already, if we follow the process, First we enter the Downpayment from AP Down module, after that we go to the AP Invoice and we click the button Total Down Payment to call the amount from Downpayment, we cant see the Base Entry and Target entry since both have different module but we can see they must have be a connection since Ap Invoice can call the payment from Downpayment and there must be a connection between them but I cant see how.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.