Sage 100

 View Only
  • 1.  A client on v2013 Adv has their A/P Options set to

    Posted 04-13-2016 13:05
    A client on v2013 Adv has their A/P Options set to post the Invoice Register in Detail to the G/L. It has been this way for awhile and they have been fine with it. However they recently installed eRequester and are saying ""it has caused our GL to show a line for each invoice instead of the total for the invoice"". Presumably it's the Expense Mgmt module of eRequester. They contacted eRequester and were told ""it was on the Sage side not theirs"". Then client contacted us to Request for Quote to change this behavior. I haven't contacted anyone yet and I don't really know what's going on at this point. Before I contact, has anyone else run into this issue or know of some hidden option in eRequester to not post to the G/L with the level of detail / granularity?


  • 2.  RE: A client on v2013 Adv has their A/P Options set to

    Posted 04-13-2016 13:18
    Are the importing AP invoices or PO invoices? Could that be the difference? I don't think erequester is doing anything special.


  • 3.  RE: A client on v2013 Adv has their A/P Options set to

    Posted 04-13-2016 13:35
    They're importing A/P invoices only. Jim do you happen to know if eRequester imports into data entry only like a BOI / VI import would or does it also post the register as well?


  • 4.  RE: A client on v2013 Adv has their A/P Options set to

    Posted 04-13-2016 13:59
    Not sure if it has changed, but eRequester used to use VI into data entry, only. The posting behavior came straight from Sage 100.


  • 5.  RE: A client on v2013 Adv has their A/P Options set to

    Posted 04-13-2016 14:42
    It can do both boi and vi but only imports into data entry.


  • 6.  RE: A client on v2013 Adv has their A/P Options set to

    Posted 04-13-2016 16:45
    Have you tried turning off the post in detail setup option in a test company? Curious what the posting behavior would be.


  • 7.  RE: A client on v2013 Adv has their A/P Options set to

    Posted 04-13-2016 16:50
    Very strange. Client has been running eRequester for several years now with no issue like this. But I am a little bit confused by what is happening. If they want the detail in the GL, then by definition they should be getting multiple lines per invoice posted in the same account. For example, a recent invoice of mine had about 20 lines distributed, six of which were for the same account. All six lines display in the GL. From you description of the issue, it sounds like the opposite is happening.


  • 8.  RE: A client on v2013 Adv has their A/P Options set to

    Posted 04-13-2016 17:47
    Thanks Jim and Bill - that makes a lot of sense! Doug your suggestion is exactly what I'm going to try tomorrow to post in Summary in a test company but also set the Posting Comment to be Vendor Name + InvoiceNo so they'll get the InvoiceNo that way. Clearly I didn't get the right info to begin with. Jeff I'm now looking at a snippet of their GL Detail report and it is showing multiple lines/invoice for the same GL acct like you mentioned. It's doing what it's supposed to. I'll clear this up with them tomorrow.