Financials

Hi Team,Regarding AR invoices and payments. How can I net out a debt adjustment with an overpayment? Here is the scenario: There was an overpayment to an invoice that resulted in a credit of $314.82 (ARP000016). Then we created a debit adj to recognize the overpayment $314.82(ADJ000002). How do we net the credit (ARP000016) and debit (ADJ000002)?  Thanks,Enrique

Hi there,I have added a third segment under subaccounts in our environment: 010, 020 and 030 under segment key 3 (also changed lookup mode to All Available so it can allow adding new segments on the fly = screen1).    But I can not see the values in GL. Only the separator (“-“) shows.Also, It would be great if the three departments can be restricted to use with 050-00 only, how would i see the values plus have it restricted?

Hello Everyone,We are working with Amazon as a vendor. They will send us a bill for X amount, let’s say $1000. They will also let us apply credits to that bill, let’s say for $200. We want to pay $800 but we also want to show the full $1000 on the bank rec.When I create a bill for $1000 and then a debit adjustment for $200, I only see $800 on my reconciliation statements. Is there a way around this to apply the $200 credit to also see it on the statement?Thanks

How are people applying handle fees? We have been manually adding a non-stock item to each order. Does anyone do this from an invoice level vs sales order level? How is this working for you?

Hi! I would like to ask if it is really possible to override tax amount in Payables Module - Bills and Adjustment. I tried doing it in one of our vendors (Vatinc) but it resulted to wrong value of entries. Can someone enlighten me on how to properly override tax amount.Gross Amount: P31,200.00Taxable Amt.: P27,678.51Tax Amt.: P3,321.49Withholding Tax: P276.82I attached the screenshots of the transaction.Thank you very much. 

Where are the permissions to allow the adding of contacts on the Customer and/or Business Accounts screens?  I can add contacts on the Contacts screen in the Marketing workspace.

Hi guys,If I record a transaction not in the base currency to a GL account (not a cash account) manually (not through AP or AR), and I want to do GL revaluation at the end of the period. How to add this particular account to the list of GL revaluations accounts? Because right now I could only see the cash accounts when I try to revalue GL accounts. Thanks!

Happy Friday, We are currently experiencing an interesting issue that the Freight and Freight Subaccount is not pulling in from the Default Customer Location (which pulled it from the customer class/customer).Here the Default Location:Here the New Location with the Checkbox same as Default marked: Not quite sure where I would find a setting or how would troubleshoot this. Cannot find anything in Receivables, Sales Order or CRM Preferences.Any ideas on how to resolve this issue?

after upgrading my acumatica website to version 2022 R1 im getting this error with the unposted documents reportwhen i click unposted documents in manage financial periods screen 

Is there any way to change the salesperson on a sales order after saving the record?Thank you!!

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?