Question

How do you get GLPOSTED field to show true in InvcHead

  • 10 February 2021
  • 2 replies
  • 71 views
E

Hi all,

I am trying to pull some AR invoice information into XL Connect.  I only want to pull invoices posted to the General Ledger.  In XL Connect I am using the AR Invoice Summary by Invoice Date; I can return the invoice amount if I use GLPOSTED = YES but if I use Posted = Yes (I tried TRUE also), I get no results (or = $0).  When I run a BAQ on InvcHead, I have invoices that show true as posted but not GL posted.  How to get them both to show as posted?  I tried by closing the period in Epicor and changing the earliest apply.  

Here is the BAQ results 

Does anyone how to use posted in XL Connect or how to get the GLposted = True for posted records?

 

Thank you in advance.

2 replies

M

I have never used the GLPosted field - only the posted one.  However, when I look at the records in my database, the GLPosted field appears to be inconsistent!  And that has been the case since we started using the software.  I am not at all sure what the purpose of the field, and I know it doesn’t help you with your problem, but I am seeing the same results you are.

Michelle Thompson Systems Administrator Vektek LLC Emporia KS 620-487-9135
E

Thank you for letting me know.  I will work on using the Posted field.

Reply


Terms & Conditions