Financials

Can a debit adjustment in AP be applied in any way when the amount owing to the vendor is zero (0)?The credit for the bill in questions has already been settled.

We are a manufacturing company with a heavy drop shipping business. While we have materials that come into our building that are purchased, received, and paid via the AP process, we are struggling with a streamlined process for drop ship POs. Currently, our purchasing department enters the PO and once the Accounting team receives the invoice, we enter the PO Receipt and creates the AP bill manually. We cannot auto-create the PO Receipt once the PO is printed/emailed to the vendor because we need the “proof” it has been sent to our customer. How are other Acumatica customers handling a similar process? Ideas?

Hi All,I’m trying to get more granular detail behind the discounts that we’re running through the system.The idea is that I should be able to report on discounts by Customer, Warehouse, InventoryID, DiscountCode (Line Level) , DiscountCode(Group Level). We are currently running multiple concurrent group level discounts with quite specific conditions so there are some instances where a single SO line has 3 group level discounts applied to it. Is there a table/ query that would allow me to see which lines on the SO a single group level discount code/ discount sequence has been a applied. Ideal Outcome:  Thanks in advance

are there any ways to reverse and apply memo multiple released invoices at once using Import by Scenario. Thank you.

Hi, is there any way/workaround to put in SO for customers on Credit Hold? We want to put in the orders as status “Credit Hold”, so our Shipping Dept. will know not to ship items until customers balance is cleared. If we won’t put in orders for customers on Credit Hold we’ll for sure not get their order, rather to put in their order as on Credit Hold and then collect their balance?! 

 Hi, I’ve tried to adapt the instructions shown in this example for controlling access to releasing Journal Transaction to AP Bills & Adjustments, but I’m not having any success.How to set up Release button for certain users only? | Community  When I look at the user’s access none of their other roles are changing these values, but the user still has access to the Release button on the Bills & Adjustment screen.Am I missing another element that needs to be revoked?Thank you!

Hi CommunityI imported some assets with GL Update off, but now need to post these transaction to integrate with GL. Plus the asset is showing unreleased transactions and I can't calculate the depreciation.I can't see any transactions to release although they are displaying as unposted. Is there any way I can correct this please? Many thanks 

Is there a report/ inquiry in Acumatica that shows the check# and invoices it was applied to by vendor? For example: 

Since we updated to 2024 R1 and checks now print in whatever order, they are no longer showing up in the Checks and Payments screen in numerical order (in the payment ref. column) See attached.Is there a way to fix this?Thank you,Gretchen 

We activated Shipped Not Invoiced account for our Sales Orders and it is now causing us problems. We have two entities. Entity A buys from Entity B and sells to end customer. Entity B sells to Entity A and sells to other customers. When Entity B sells to Entity A - it should hit account 50110 - COGS. When Entity B sells to any other customer, it should hit 50940 - Finished Goods COGS. We had set this up by assigning COGS based on item class, which was set to 50940, but in the customer record for entity A we set the COGS account as 50110.  However, now that we have started using a Shipped Not Invoiced account, the system seems to ignore the COGS settings per above. All shipments are flowing to 50940 and is no longer considering the configuration above? Is this a known issue? Does the Shipped Not Invoiced functionality prevent you from specifying the COGS accounts at the customer records levels? Could my set up be wrong somewhere?

Hi,I am looking for an Import scenario to ‘Cancel Invoice’ and Release the Credit Memo. Assume the payment applied to the Invoice is voided.Thank youScreenshots for referencePlease find the attached Import Scenario.

Hello ARM Experts,I have come across a situation in ARM that have not been able to find a way to overcome the challenge. Here is the scenario:In a single tenant I have quite a few companies and branches that their “Fiscal Year End” falls into different calendar months. Almost every month I have a company with “Fiscal Year End”. So, our master calendar is set up to be Jan through Dec. In my report “Unit Set” I have created all my companies and branches as per their hierarchy. Everything works just fine with one caveat. I can not manage to display the “Calendar Date Equivalent” of “Financial Period” of each “Unit” on the report header.As you know when we run the ARM report (24R2), we can opt to run the report either by company’s “Financial Period” or “Master Calendar”. When we use the “Master Calendar”, the data is retrieved from beginning of the “Calendar Year” through the “Start Period” selected in the ARM report. Take this for example. If a company “Fiscal Year End” is Oct 31, when we

Hi Acumatica Community,I’m exploring the capabilities of Acumatica’s AP Invoice Document Recognition and would love to see a video or demonstration that highlights the following:How the system processes inbound email attachments containing invoices (e.g., extracting data from emailed PDFs). How it works with scanned PDFs, particularly in terms of batch processing. Whether I can drag and drop multiple PDF invoices directly into Acumatica and have the system recognize and process them efficiently.If anyone knows of existing videos, tutorials, or documentation that visually showcases these features, please share. Seeing it in action would be immensely helpful for my understanding and evaluation!Thanks in advance!

In the initial set-up of Acumatica and Vendor Classes, a cash account was entered in the “Default Financial Settings” for each class.  Now, we are using a new cash account to pay vendors.  We have removed the default cash account in all classes so feel new Vendors added will not have a default cash account.  We were able to mass update the cash account for all open AP bills using GI.  We would now like to update all Vendor records either by removing the old cash account default (i.e. default cash account would be blank) or the new cash account. We tried using GI, adding the “location” data to the Vendor record but were unsuccessful in creating the needed relations to accomplish the mass update.  Any and all help to get this update completed as a mass update is appreciated.

It appears that AP recognition is not available on the sales demo instanceCan someone confirm if this is true / how to demo / test AP recognition ?

We have found when converting from an opportunity to a service order the salesperson name is wiped out.  We currently go into the finance tab and select the salesperson.  Anyone know why this is wiped out or if there is a way to prevent it?  Not a huge deal to re-enter it but it sometimes gets forgotten so it would be preferable to transfer over.  Thanks! 

Hi All, when I import Interest Account (4212), the system show “account cannot be mapped”. Does it mean I cannot import the balance for this account or what’s wrong? 

Hello Community,I feel like this should be simple - what have I missed?Unit set has only two company branches rolling up to a total. All Comp node has NO DATA SOURCE:Unit Set - 2 companies rolling up to All Companies node.Report ‘Building Blocks’:Result is: Both Companies print correctly but the All Companies Roll-up includes only the LAST company, Company 2:Why is Company 1 left out of the All Companies Roll-up? We have no Company Roles active. This is version 2023 R1, Build 23.114.0025 .Thank you!Laura

What does Recalculate Account Balances? I’m trying to create a bank reconciliation but I’m worried it will destroy the information. 

Hi,I noticed the Load Document Function is not available in the Cheques & Payment screen for Debit Adj. How can I enable this function?Load Documents Greyed Out 

hi everyone,Can anyone give me insight about this kind of error in AP Bill module - CM Error: An error occurred while saving Currency Info for the table 'APAdjust'we are currently using Acumatica Cloud ERP 2023 R2Build 23.211.0017 +Please see attached screenshot for your reference of my inquiryHoping for positive replyThank you-ggil   

When reviewing the Cash Account Details screen, the beginning and ending balances change when the Include Unreleased checkbox is checked or unchecked.  The debit and credit amounts do not change and there is no change in the listed documents.The first test was to set the start date back before the initial go-live date through to tomorrow’s date.  In that scenario, nothing changed when the Include Unreleased checkbox was toggled.Moving the start date up to 10/31 through tomorrow’s date started the beginning and ending balances to change.  As the date is moved up closer to today’s date, the amount of the change in the beginning and ending balances changes. I have reviewed the reconciliation statement that is on Hold and could not make any changes there that affected the beginning and ending balances, but I did note that the earliest unreconciled document was dated 10/31.  The difference in the begging and ending balances did not equal the amount of the un-reconciled document.When I look

Has anyone found (or created) a Project Cash Flow report? It would be great to see payments received, and bills paid by project.

We have client with a large volume of FA additions every month (hundreds).  We are looking for a way to automate, by import scenario or other method, to reconcile the unreconciled FA Accrual records to their corresponding purchases.  The Convert Purchases to Assets processing screen is not an option as it’s too manual for the client’s montly volume and does not appear to support the ability to select records effectively (there are no references to a specific index value for selection).  We’re looking at potentially creating a transaction screen that will specifically support the ability to run an import to associate purchases with newly created assets, but I would like to exhaust other options first.  Has anyone else encountered this dilema?  If so, how did you solve it?  

How do I configure Acumatica to send supplier payments via santander for electronic payments?where do i enter the supplier bank details as i can't see any fields for sort code and account number