Kyle Martin Posted September 24 Share Posted September 24 We have purchasing workflows that are posting to a user defined book in the GL at each step. When I query the GLDETAIL object I can see the correct entries being returned but I'm trying to find a way to get back to the PODOCUMENT through the API to pull some custom field values. From the GLDETAIL the only 2 primary key fields appear to be BATCHKEY and BATCH_NO. I also pulled the related GLENTRY record, using the BATCHKEY, to get the RECORDNO of the GLENTRY. None of those values appear to be related to any of the fields on the PODOCUMENT or PODOCUMENTENTRY. We've done this before going from GLDETAIL that posted through AP, and then getting back to the PO through the AP Bill but the entry to the user defined book doesn't seem to work the same way. Through the UI I can drilldown to the PODOCUMENT from the journal entry. Does anyone know if the related fields are available in the API? Kyle Link to comment Share on other sites More sharing options...
Members Sterio, Louis Posted September 26 Members Share Posted September 26 You will have to query the GL Resolve relationship table with the GLENTRY KEY to retrieve the related PO document or PO Document line key. General Ledger Detail ERD | Sage Intacct Developer Link to comment Share on other sites More sharing options...
Kyle Martin Posted September 30 Author Share Posted September 30 Thank you Louis Link to comment Share on other sites More sharing options...
Recommended Posts