In VI is there a way to export a purchase order's Total

Question

I'm working on trying to export purchase orders that need to contain both line detail as well as the Total Amount of the PO but it appears the Total Amount is not a selectable field in either PO_PurchaseOrderDetail or PO_PurchaseOrderHeader. The client is on SAGE 100 v2018.

PRSpeed · Accepted Answer

Thank you for the reply BigLouie. What ended up being the issue was me not selecting the "Display Read Only Fields For Export" was not checked in the "Options" section of my VI job. When you suggested selecting those fields, I couldn't find them...that's when it dawned on me that they just weren't being displayed.

Sage 100

In VI is there a way to export a purchase order's Total

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING