Financials

Acumatica allows for nonsense years to be entered such as 2222 and 2044 on AP and AR documents. How can this be prevented? 

How do we create Assignment and approval map? On the Assignment and approval map we only have option for adding approval and assignment separately and there is no place for adding assignment and Approval map  

 I applied a 100% discount to the purchase order, but the discount didn't appear in the Journal Transactions. However, this issue doesn't occur with the Sales order, as the Sales order cash discount is properly reflected in the Journal Transactions.please check the screenshot belowPurchase Order   Sales Order  

Is there a way or method in Acumatica that can prevent people from backdating documents? I know closing periods prevents posting in past periods, but our Controller wants to prevent the dates from changing.  He does daily reconciliation and it’s messing him up.  For example, in AP.  AP created a check on August 8.  They did not process the check until August 14.  When the controller runs the ending cash account balances on the 8th that check isn’t in there.  Then it throws off his numbers when she posted it on the 14th. 

are user rights required for outgoing email permission?  if so, what are the steps to assign rights to user?

Hi everyone.May I know what to do in this error? GL Error: Cannot update the record. The record InventoryItem (251-071) has been marked as deleted. Your changes will be lost.Scenario: sku 251-070 is wrong; it needs to be 251-071. However, 251-070 is linked to BigCommerce, so I don't want to create a brand new sku from scratch.Thank you.

Does anyone know if or how I can restrict what documents a user sees in “Incoming Documents”.  I need to restrict based on what company they are for.  I have different ap email addresses set up for each compay.

Hello, Seems like a simple question, but I’m at a loss on this one. So AP debit adjustments can easily be applied to AP bills….However I can not find a way to have a simple vendor credit adjustment applied to an invoice. There appears to be no similar process there credit adjustments can be applied to AP Bills. Can anyone assist? Thanks, Bob

In the use case of customers or suppliers having open on account or prepayment amounts it would save time and help keep customer accounts more tidy if these payments/prepayments could be allocated with a payment.For instance:Customer pays a deposit or stage payments prior to being invoiced eg $500Customer invoice is raised for products or services rendered eg $5000Customer payment to settle invoices is received for $4500 - It would help to be able to select both the above transactions during the application process leaving all transactions in a closed status.  Currently I don’t think payment or prepayments are available on the Doc. Type drop down list.I hope this makes sense.

Is there a way to have a branch ID be the same as an employee ID?If not, is there a way to rename branch ID’s or employee ID’s en masse?Thanks.

Error on Proft & Loss Period Sensitive Statement when date range goes from 2022-2023. So if I ran a P&L statement from April - November 2022 it would be fine or January - March 2023. But when I try to run a report across years this is how it shows up: 

Where do you enter quantity on hand for a stock item

Colleagues,Do any of you know if there's a setting that can be configured to make an expense receipt billable by default?Thank you! 

We are in the process of switching from authorize.net to PayFabric’s integration for credit card processing and AR automation in Acumatica. Our main reasons for changing are to simplify the payment process for counter sales since their credit card reader will feed directly into Acumatica and to hopefully improve AR collections with their ‘click to pay’ links on invoices and automated sending of past due reminders.Looking for feedback from anyone who has used or is currently using them.

Once i have reversed a fully depreciated or overly depreciated asset , how can i delete it from the system so i can re-create the same asset ?

Good day!I just wanted to ask about this kind of unusual error upon processing Master Financial Calendar.  The table shows that the data for the 12 months of 2024, from January to December, was aggregated into a single financial period which is 01-2024 while having a start date and end date of 1/1/2024 and 12/31/2024, respectively. May I know any workarounds or what should I do to correct this? Would love to hear your opinions on this matter. Thank you. 

Where can I get amonthly GL expense and revenue report. I need it in the following format Account Subaccount Jan-23 Feb-23 Mar-23 Apr-23 May-23 Jun-23 Jul-23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 4000 100-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 100 5000 125-000 1000 2000 3000 400 5500 700 800 900 100 1000 6000 500   

I have a number of reports that are printing formatted for legal size paper.  For example, the bank rec report.  How do I change this (and likely others) to print on letter size paper?Thanks in advance.

Hello, we recently upgraded to 2023 R1 from 2021 R1 or R2. Our third-party support company did the bank feeds migration and we have set up all our cards, but it is still not working. I have been told that there is data missing from what our bank is sending through Plaid to Acumatica. I can import the bank transactions, but it is not auto creating expense receipts due to the missing data. Is there a manual work around to create expense receipts? We are going over 3 weeks without expense receipts hitting our books/project costs. We need to get those costs into Acumatica. I don’t even see a way to manually import a file into Acumatica to get it to create expense receipts.Our third-party software provider has submitted a Case to Acumatica, but that was two weeks ago. I am hoping someone on here has a workaround that would work for us.Our bank is Wells Fargo. We have one main control account and then several sub accounts. Each sub account does have its own account number. In the previous ve

When creating a Purchase order from the sales orders is it possible to mark for PO  Sales order which are backorders

Hello fellow Acumatica users! :)Do any of you know where to add the TCC code from the IRS to submit 1099’s? Thanks,Kay

Selected an invoice for payment.  Created an ACH Batch.  Decided not to pay that item.Deleted the item from the Batch.  Processed remaining items in the batch and uploaded to the Bank.The invoice is now stuck in Pending Payment status and I’d like to remove that status so the item returns to Open Status.  Cannot find a way to do that.  Suggestions anyone?Mike

Currently bank recs are completed within Acumatica by a staff member and then reviewed by myself.We have a separate checklist where the staff member notes when it was completed, and then when I review it. I’m looking for an efficiency gain……………Is it possible to either set up an approval flow or possibly utilize the Task feature to accomplish a similar result?

I am looking for a way to hold inventory at $0 and $0.  This general idea is that I have used inventory that we want to bring into and out of a location.  With this inventory being used, we do not want to value it at all in our GL.  These inventory items have the same inventory ID as new items that we want to value. I’ve seen the options in the Warehouse Location to cost separately, but I am still seeing the value sitting when I run an inventory valuation report.