Financials

We are trying to get the number of days an invoice is outstanding.  I am trying to use  =(([ARInvoice.DRSchedCntr]) - Today()) to get the numbers of days, but I get an error.  What would be a better formula?

A Customer sent a check and we recorded the payment for $200. The check was deposited to the bank and a Bank Deposit in Acumatica which included the $200 check was created. A few days later the bank came back with a correction stating the check was written for $20 not $200. We voided the $200 payment then created a $20 payment and created a corresponding Bank Deposit. Is there a step we are missing? The original deposit with the $200 payment is still equal to the original deposit we created so our bank rec is off by $180. Please help me identify what step is missing

Hi Acumatica,May I link a document and line notes in a generic inquiry?Thanks!

Edit Branch in Bills and Adjustment.  How can I edit the option for branch in Bills and Adjustment? 

We want to be able to use Projects to document activities for Research and Development (R&D) tax credits.  I expect that the labor expenses will be the largest component of the R&D credit, with materials and prototyping materials the next largest component.   With the R&D Tax credit Solid documentation is required, but we need to be able to keep it simple as well for the engineers. Need to keep the tasks down to a minimum otherwise the engineers will not properly record their time.  Has anyone setup an internal R&D Project using the projects module?  Are there any tips to share, especially when generating the cost for auditors.

I’ve found several entries here for this, but haven’t found a solution yet.Requirement:Enter Start and End Period (can be anything up to 12 periods and can cross fiscal years/calendars) The data in each period’s column display just the turnover for that period (not the ending balance at that period)I have found good formulas to suppress printing periods not in the parameter selection. However, I cannot figure out how to get just the turnover for that period when I use a start and ending period in the parameter. Thank you in advance!

Hey everyone - My AP report does not run in alphabetical order but rather by Vendor ID chronological order and it drives me nuts!! Tried to fix it myself on the report designer but I can’t find where the sorting feature is for the data in that column. Can someone offer some assistance?  I only run AP in summary form. 

The client requires a prepayment before production begins and full payment before delivery.  Is there a good way to set up this kind of term?

Can’t delete a sub account. Can’t figure out where to find the rest of them so i can delete them.  2/3/2022 6:54:58 PM Warning at ParentDeletingHandler.cs:159:RaiseConstaintViolationException():Subaccount (00  -   -) cannot be deleted because it is referenced in multiple tables. 1: Currency (USD) - Foreign key Currency(aRProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 2: Currency (USD) - Foreign key Currency(aPProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 3: Location (118, MAIN) - Foreign key Location(cSalesSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 4: Location (118, MAIN) - Foreign key Location(cDiscountSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 5: Location (118, MAIN) - Foreign key Location(cRetainageSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute 

We use Acumatica in retail, receiving inventory and matching bills later to receipts. How to reconcile balance at the end of the month of clearing account to Balance Sheet? I cannot see any generic reports that will allow me to do that. Any ideas? 

We had an invoice 400.94 and our customer paid 400.95 what is the best way to correct this in our system? Do we create a credit memo on the invoice or can we do a -.01 in the write off amount?

Hi everyoneWe have an issue with reversing migrated fixed assets in bulk. hoping that someone could offer some ides. We have over 100 fixed assets migrated that need to be reversed. The issue is that these assets contains fixed asset transactions that had both no GL batch (from migration - purchase+ and depreciation +) and GL batch (depreciation + after migration).If we reverse this fixed asset with GL turned on, it will also create GL transactions reversing purchase and depreciation from migration. solution 1) Reverse with GL turned on, find a way to journal back the purchase transactions that should not have GL batch.  Issue: unable to identify reversal transitions against original. system does not create a reference. solution 2) reverse with GL turned on. when fixed asset is migrated again correctly, leave GL on. system will create purchase transaction with GL to make up for the asset account balance. issue: will not be able to migrate “depreciation to period” and “accumulated depre

I am no sure what I am missing in configuration but I cannot select a project on an expense receipt or claim. I can see the project field but only default X is listed. Furthermore, the project task field does not display. I have configured a corporate credit card and non project related expenses are working as expected. Any ideas as to what I am missing?

Hi everyone,I’m running into a multi-currency issue in Acumatica. I have a GL account that’s in CAD. The foreign currency balance on the account is CAD $0.00, but the base currency (USD) shows a balance of -1,094.84.I’ve reviewed the transactions, and everything seems closed out in CAD, but this lingering USD balance remains. I tried revaluation, but it didn’t fix the issue.How can I adjust this without affecting the foreign currency balance?Any guidance or best practices would be greatly appreciated!Thanks in advance,

  Sometimes you may need to include information about payments made against a specific invoice into a printed Invoice form. Here is how to do it:You need to create a simple report that includes payment information you’d like to see. In order to do that, use Report Designer (to learn more about the report designer please refer to Report Designer Training or Acumatica Help website). The report needs to contain information from ARPayment table (the table that contains data about payments in Acumatica). However, you want to have the payments that are applied to the specific Invoice, so you need to also have ARAdjust table (that table contains data about links between Invoices and Payments) as a part of your dataset: The relation between the ARAdjust and ARPayment is the following: And finally you need to filter the dataset using the Invoice details. To do that use Invoice DocType and RefNbr parameters:  Finally, add the fields you’d like to have in your “Payments” section: Now you can save

Hello,As anyone overcome the challenge of Quickbooks’ subaccount functionality when converting to Acumatica?  Within QB, when one or more accounts is made a subaccount of another(i.e. parent) account then the balances of the subaccounts will roll up into the balance of the parent.  Many users of QB leverage this functionality for fund accounting especially with cash assets where they have a single interest bearing account at the bank but need to maintain separation for earmarks (e.g. restricted, capital projects, special events, etc).  The problem is not setting up the separate accounts in Acumatica or reporting but with reconciling to the bank statement.  From what I can tell, Acumatica only offers a one-to-relationship between a cash account and a GL account and therefore have not found a way to link the transactions in the fund accounts to the cash account.   

Hello all.I have been working on ARM report & I have an individual GL Account that has figures in both Debit & Credit but different set of trxns. I’m looking to post the debit side of the amount under Expenses section & the later into Credits - Income. Kindly lmk how we can achieve this?

Hi Team,While releasing the “ Inventory Receipt”, I am getting the error ” GL Error: Missing Account Mapping for Branch 'CAPITAL ' and 'PRODWHOLE '” . Kindly suggest the missing one here.

Did the credit memo process change with version 2024 R2?  I can’t add return lines as previously done in R1 version.  Thanks! 

Hello All,  We are trying to figure out if there is a way to switch the cash accounts for all existing vendors in Acumatica? We have all new vendors set up to default to this new account but need our existing vendors to also be switched to this new default account. Thanks! 

We use the parent billing account/child account structure for customers that have a parent billing account and numerous employees that order online from us. This structure works well for being able to roll up the invoices for all child accounts to the parent, and for applying parent payments to the parent and child customer account invoices.Some of our parent accounts want to pay by the same credit card for all parent and child account invoices. Is it possible to use the parent customer credit card payment method to auto-process credit card payments for its children as well?Patrick

Hi GuysHoping someone can help with this query.In some instances, we have to manually create a credit note adjustment as the standard way of reversing will not work due to the UK having CIS (UK Tax for Construction).When manually creating the credit note, we cannot add the PO number and therefore, does not deduct the credit amount off the PO to leave a remaining balance.There seems to be ‘Add Subcontract’ but we use ‘Drop-ship’ as this option defaults to the site address where the other PO types do not.Is there any way to get the PO added when manually creating a credit adjustment? Thanks  

I am trying to connect APInvoice and EPAapproval tables in generic inquiry but both tables can’t be directly joined. I already read some topics here 3 years ago that they can directly connect two tables with note ID. Based on this photo.Is there some kind of modification or setups do I need to do. Thanks community

Hello everyone! I would like to gather some inputs regarding this scenario:Base currency = PhpClient creates a prepayment document directly from the purchase order being created (in $). Suppose that the prepayment created would have an exchange rate of 1$ = 56Php. The prepayment created that time is not yet processed with payment since they still have to buy dollar in their local bank.Now, after a week, they were able to buy a dollar but it is no longer 56php, it was already at 58Php. in the Checks and Payments screen, the cross rate column is changed to 58php but the payment cannot proceed since the system will not allow the prepayment valued at 56php to be paid at 58php. Is there any other way to process this kind of transactions? 

Hello,I am need to definitions for the ItemCostHistory table.  Acumatica help does not have table definitions so I am reaching out to the community for some help.See screenshots belowThank you.