Financials

Team, I am struggling to explain Unposted Journal Transactions. I know there are some issues and some scenarios explained, but for normal people, why there is unposted transactions on the system? They are random, and can have a good explanation for my client, every now and then, when closing the month, there will be uposted journal transactions, and there will be no good answer for those. I have put a schedule to post every night unposted transactions to see if the problem goes away, but still want to have a good answer for them. Thank you. 

Hi,On Invoice screen using CampaignID field selector but After an upgrade to Acumatica ERP 2020 R2 it gets vanished.I saw the release note and it has removed the Campaign ID field,But it is the client's requirement, the client needs the Campaign ID field on Invoice Screen (SO303000).so what i need to do for this, can you Help me. 

Hi Team,Asking on your end if it is possible to add a new column from this screen. Regards,

The setup of the system allows AP to auto post when released.  Everything does that except 1 thing.  When we go to close out an invoice that we have completely paid with prepayments the system stops at the Posting stage.  We have to do close the AP this way because its the easiest way to get the money from Vendor deposits to COGS.  Is there a setting that would allow this to happen that we are missing?  This is the only type of transaction that doesnt work.P.S. The invoices are being created from PO’s for a project

We are seeing an error that I can no find any information on. “DR Error: Reallocation Pool data cannot be calculated, because the fair value price cannot be found for the combination of: the {INV ID} item, the EACH UOM, the USD currency, and the 3/14/2023 date.”This happens when we try to release an invoice. Any idea what could cause this?Thanks 

How do I re-print a check after it as been released?

Hi All,I am trying to figure out how to configure ACU so that taxes from PO invoices will post to the inventory account instead of to the AP accrual account. Does anyone know how to do this? Thanks!Jude

Hi Team,Do we have the concept of “Charge Back” concept in Acumatica? Thanks,

Dear Acumatica users and experts,Is there any way to make petty cash account as a cash account. The reason I asked because I would like to ask the possibility to access petty cash as a cash account in Receivables Module. The person-in-charge responsible for petty cash but we would like to restrict him/her to use only receivable module Thanks

Dear experts,Need to know on how to get Fix Asset’s Qty and show it FA Balance Report (FA630000) / Acu2021 R2 because in expression editor under Data Class “FixedAsset” the data field is not available.appreciated for any solution / work around on this.thanks in advance.

Wondering if I could get some help generating ARM reports with the account and subaccount info expanded.  I have my ARM reports built utilizing account classes as the data sources so I don’t have to manually add every account number onto the reports when we create new accounts.  This has worked well until now when I need to get subaccount details under each account. When I expand data as SUB it does not break it down by account but just give me a total for each subaccount within that account class.  I think I could make this happen by manually adding a line on my row set for every account and a line for  subaccounts under that but I’m hoping there is an easier way that also wouldn’t require as much maintenance in future if we add accounts etc.

I have tried to simulate both options but I end up with the same outcome. I expected that upon choosing “suspend”, depreciation would not be computed. 

Right now we have a few allocation rules that are setup to capture cost, every hour, for certain cost codes that get time applied to them from Time Entry. For example… if cost code 00-0010 (cost type Labor) gets entered on time entry for 4 hours - accumulate $400 of cost. The issue is 00-0010 (cost code) E (cost type) is the cost code that automatically gets created for $400. Is there a way we can dictate what cost code those allocation rules accumulate cost towards? Ex: 00-0010 - Cost Code Labor (L) - Cost Type gets selected during time entry, that $400 goes towards 00-2000 Equipment.Seems silly they wouldn’t allow us to dictate where those costs get tracked?

Hello!  Have any of you combined the the Quick checks and Regular checks in one inquiry?  We are new to Acumatica but don’t understand why the “check list” isn’t the check list?   Thanks, Kay740-418-5250 (cell)khowe@stockmeister.com

In scenario where Vendor requires prepayment in full amount of PO, the associated Prepayment Request functionality does not populate terms nor calculate the Cash Discounts. If terms are 1/10/30 the system only calculates and processes cash discounts when processing an Actual Bill. In case where prepayment % is less than 100% it takes the Full Cash Discount on Final Payment when Bill is entered. Entering the Bill in advance and paying the Bill less cash discount to solve the transaction issue does not resolve the Accounting for what is really a prepayment transaction. Any ideas on how to process a prepayment less a cash discount at the time of prepayment?

Hi, Do we have a standard or customized report do generate from Acumatica, where we can see the breakdown of the Cost of Goods sold (COGS)? This report needs to have the direct costs (PO cost) and the indirect costs (Freight, Customer duty, SST, Demurrage, etc) separately?Example :  Or else, is there a way to record the indirect costs (From landed costs) to a separate GL account without including it in the Inventory account? Thanks in advance 

Hi all, I wanted to create an Automation Schedule to release specific types of invoices. I would schedule it to the next minute when I test. I kept conditions simple as it is my initial test. I created a bunch of invoices with varying dollar amounts.This condition successfully released invoices with $0. However, after I deleted the “amount” condition trying to release the rest of the invoices, it would not release the rest of the invoices. Additionally, it shows “0 times executed” and shows no history when I click “view history,”

Hi, Some users are receiving the below error message when attempting to open up a new receipt in Acumatica, does anyone know what could be causing this issue?  

Hi, I’ve had a request to expand our purchase order unit cost from 3 to 5 decimal places… is this possible? The only place I see for precision is in Currencies.  My concern is that even if I could expand from 3 to 5, all our other costs are 3 decimal places, would this cause an issue?  

Does Acumatica support using a manual card reader through Authorize.net or is using a third party app like Repay or EBizCharge required?

I am getting the below error when trying to post an AP invoice. This is not a new item or new purchase type. It has been done numerous times in the past so not sure what is causing the issue now and how to fix. I am not seeing anything on the Posting class that looks “off”. Any thoughts on how to fix?   

Client created and posted a bank reconciliation for 01-31-2023.They then voided that bank reconciliation and now want to re-do it.But the attempt errors out with a message that the Reconciliation Date must be greater than the previously released Reconciliation.  I don’t know how to go about re-creating the 01/31/2023 reconciliation unless anyone on this board has a suggestion for me.   

Is there a way to manually close/complete a purchase order without having to enter a AP Bill?

Does anyone know of or have a good report for Net Sales? Things that include month and year profit along with year to date.I know there is the Sales Profitability but I was looking to see what others have created or have used.  Thank you!