PM Aged Trail Balance

(0) Share

Report

Posted on by Rana Anas

Hello,

I want to add POPRCTNM From POP30300 table but i couldn't make a relationship in this report. Can Some Guide me how to make a relationship of Purchase ReceiptHist so i can able to use the field of POP30300 (POPRCTNM) IN PM Aged trial Balance.
Thanks in Advance

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: PM Aged Trail Balance

I do not think you can get it on the trial balance with options report because, as you stated, you cannot make the necessary relationships in Report Writer.

You would need to relate the PM Open Table with the Purchase Receipt History table and there isn't a secondary table key you can use to create the relationship.

I think you may need to use a different reporting tool like SSRS where you can create the relationships you need. You could also get a developer to create the report for you.

Leslie
Rana Anas 45 on at

Like (0)

Report

RE: PM Aged Trail Balance

yes i want to add all poprctnm from that table simple is that i require number in front of each vendor si i am able to know how many poprctnm is there
L Vail 65,271 on at

Like (0)

Report

RE: PM Aged Trail Balance

Hi,

The receipt and the payable is not a one-to-one relationship. A payables invoice can include receipts from multiple POs. Do you want to add all of the receipts that a particular PM was invoice matched to?

Leslie