x Want to participate? Join the group to interact

  • Invoice Matching Data

    Can anyone tell me where, in the database, I can find the invoice matching data? I am looking at the GACCENTRYD table but it seems to have some holes in the data. Any guidance would be much appreciated. Regards, Dave

  • Payment and invoices not matching properly

    We have a problem with one of our sites where, every now and then, a payment doesn't seem to match properly and we can't figure out why. For the latest case, the symptoms visible in GACCDUDATE were: - Payment: PAYLOC/CUR = 0, TMPCUR/LOC = 0, FLGCLE =…

  • ACCOUNTING TASK HAVE 1062 RECORDS UNDER MATCHING

    Good day We have 1062 records under matching. I tried all the tricks for articles I found in Sage City. There records dont disappear. Any ideas?

  • How to handle a purchase credit memo created with site different from purchase invoice?

    A user has created a Purchase Credit Memo (PCM) for a Purchase Invoice (PI) , but has created the PCM with site that is different to the site of the PI. 1. As far as I'm aware, it's not possible to match the PCM with the PI in this situation. Please…

  • BP NET SETTLEMENT WITH DIFFERENT CURRENCIES

    Hi guys, What about using the BP NET SETTLEMENT in the Financials AP/AR, but in this case the customer/supplier has documents in EUR and also in USD? In this object it is mandatory to fill in one currency, therefore we cannot mix currencies. Any solution…

  • How to check a transaction is matched or not

    Dear Sagians, If you want to know weather a financial transaction such as invoice or payment is matched or not and if matched what is the match letter. Go to Financial > Inquiries > Entries and type the appropriate criteria then click search option…

  • AR Import and Auto matching

    Hi Guys, Just wondering if this functionality is available either as an addon or within sage x3. Basically for parent/child customer accounts the head office will make 1 payment that covers multiple child account invoices. We can manage the with…

  • Entry of purchasing invoice

    I'm wondering if there is a way to link a purchase invoice to a receipt after the invoice has already been entered. Since the receipt is done using the purchase order, can the invoice be entered using the purchase order and then manually or automatically…

  • Automated matching of foreign currency invoices - MTCBATCH table not clearing out - Open item being matched

    Hi, I have a client that has a mix of suppliers with different currencies. The home currency is AUD. This is the scenario. The client pays the non-AUD suppliers from the AUD bank account. There are two issues. The matching table retains the record…

  • Accounting Task (VAPLCE) - Journals stuck and matching issues

    Hi, We keep on having this issue at several clients. We keep on having journals that won't post in the one column and journals stuck in the matching column too on VALPCE. I tried adding a screenshot below to illustrate. I know there are many ways…

*Community Hub is the new name for Sage City