How to get the purchase item tax schedule of any received/shipped item

(0) Share

Report

Posted on by Community Member

Dear All,

We have Dynamics GP 2015 R2 with SQL server 2014 R2.

We are using Purchase item tax schedule to record item level VAT in the purchase order.

We have a requirement which states that if any PO item is received from receiving transaction entry then we have to display the VAT amount associated with that received item (recorded in the Purchase order). I need to know how to link any received item from POP30310 (or POP10310) to POP10110 to get the item level purchase item tax schedule type.

We can't link based on item number because two items can have similar names/description (for non-inventoried items) and we also can't link ORD (in POP10110) to RCPTLNNM (in POP30310) as these can also be different.

Can any one help out in resolving this issue.

Best Regards,

Waliullah Bukhari

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

chadbruels 1,588 on at

Like (0)

Report

RE: How to get the purchase item tax schedule of any received/shipped item

Have you looked at the POP10500 table? I believe this has what you seek. The first four columns are PO Number, PO Line Number, POP Receipt Number, and Receipt Line Number.

Regards,

Chad Bruels

Supervisor - GP Developer

RSM US LLP