Matched Tables? Custom Inventory Allocation Excel Report

(0) Share

Report

Posted on by KirkLivermont

5,985

Hello,

I would like to make a custom excel report with all Inventory Allocations (SOP and Inventory) that I can then add some additional information to. The information I have found about Matched Tables is all related to joining work and history tables however I think by matching the sales transactions amount work table to the Assembly Transactions table I will end up with a list of inventory allocations from both SOP and Inventory with 1 line for each transaction.

If anyone has any reference materials for using matched tables in this manner (or a suggestion for a better way to accomplish this) I would appreciate it.

Thank you,

Kirk

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

KirkLivermont 5,985 on at

Like (0)

Report

RE: Matched Tables? Custom Inventory Allocation Excel Report

I should have tried working on this just a little longer before I posted the question here. Where I was struggling was which tables should be matched to which and how to link them.

Kirk