Financials

Good morning, I thought I would reach out to see if anyone is manually processing Amazon payments, and specifically how are you handling the Monthly Reserve withholding and subsequent release in the following month? Since each has an impact on the payment amount how are you applying those to payments?

With regard to employee expense payments, you can allow ACH payments to the employees by defining the ACH payment under Financial Settings on the Employee record in Configuration.  This is not an area you want the employee to access on their own, and not something you want to open to the AP department to keep updated.  It would be nice if the employee could choose their expense reimbursement method (if allowed), check or ACH, and allow them to maintain their own bank information for ACH payments.  That way they can also be responsible for upkeep if they change a bank account, etc.  This is obviously something that would need to be secure.

Hi guys,I tried to run project billing and generate an invoice, but it cannot be released and the error seems confusing (see below). Could anyone please tell me where’s possibly wrong? I don’t know what “objective reference” is and why it has anything to do with “field Branch ID”. Thanks! 

I have created a cash deposit with 5 credit card transactions in it.During reconciliation, I realized that I was looking at the wrong total and I had to void the cash deposit.  When I voided, it only voided 4 transactions, I cannot create another deposit, 5th transaction is not available to use, basically it’s locked. This is holding my BR from April.  Any idea how to address this?  Thank youSB

How can we limit the access of some vendors and P.Os related to the vendor?  

HiIs there anyway to check an uploaded budget BEFORE releasing against the Account/Subaccount combination. Basically run a P&L but on unreleased budget information.I would prefer Velixo but any inbuilt report would be fine.I have loaded some 15 unique branch budgets I want to check them before releasing on mass (as it will  save hours of error correction)Ideas?Cheers

HelloI’ve released a budget (in a ledger called FORECST) but now wish to replace this entirely.Can I simply load this via an Excel import and it will replace everything?Or can I load a zero budget and then load the correct values?Thanks

Has anyone been successful in implementing AP Document Recognition in a Production Environment on Premise or on Microsoft Azure?What about on AWS?In an On Premise instance the Incoming Documents screen is not “remembering” the user mapping for detail lines and in order for the Vendor to be “remembered” the vendor record must be manually edited. (2020 R2 Build 20.204.0031) In a Microsoft Azure instance the Incoming Documents screen is not “remembering” the Vendor or user mapping for detail lines. (2021 R1 Build 21.102.0070)

We are experiencing the following erorr, was wondering is someone would be able to help, ill exaplin the steps we did:A PO was entered to the wrong item code, and we had to reverse the PO and the bill that was entered to it.I sent a prepayment of 50% the PO on a check. Once we had to send the remaining balance, I went in to the PO to receive it, from there created an AP bill. once I created the bill the prepayment we had sent before, automatically applied to the bill leaving only the remaining balance for payment due.When doing the return of the PO (to reverse it out and close out) I did a return on the PO receipt which created a return receipt.Once a return is created on a PO receipt, it gives the option to create a debit adjustment. Debit adjustment was created.I then went to void the check so that the prepayment can open back up and I can apply the debit adjustment to close out the bill.I voided it but it stayed in balanced status and wouldn’t release giving error message “AP Error:

Hello,I have successfully created and used multiple group discount codes on a sales order.However, these are only printed as 1 “discount” on the sales order.  You can see each individual one in the Sales Order screen.  If a customization is required, can anyone point me in the right direction for what tables to utilize? They do not print at all on the invoice, the total is just different without printing anything saying why. On a different but related note, is it possible within a GI or report to show the discount amount given for Discount Code “XXX” for a given date range?  I don’t see any available reporting for discount codes. If it needs to be a custom report, can anyone point me to the correct tables? Thanks!

How do you determine the amount of your inventory sold versus unsold?

Since we have one Cash Account that uses over a dozen different Payment Methods (over a dozen corporate credit cards), a filter or column needs to be added so the Payment Method (credit card) used for each transaction is shown.Right now, it is very difficult to reconcile (Reconciliation Statements) or see what Checks or Quick Checks have already been entered (Cash Account Details) because the one credit card statement has separate sections for each each employee’s credit card purchases but the the transactions for the Cash Account are all mixed together without any way to see which Payment Method (credit card) was used.

HiDoes anyone perhaps have an export scenario for the Singapore version of the Standard Chartered Bank payment file for Vendor Batch Payments?Or any tips on how to create one?Thanks heaps for any assistance you can give :)RegardsBev

How can I add the user ID column in the journey entry transaction reports by period or by account? And how can I inquire based on userID?Please advise. Thank you so much!Aaren

Does Acumatica offer a 1099-NEC form with 3 forms per page? Is there any plan to release this?

Hi guys, a question on multicurrency accounting.I transfered 1000 USD from the USD bank account to SGD bank account, I received 1350 SGD and there’s a gain of 1.16 SGD here (base currency is SGD). But in the journal transaction, the realized gain/loss from currency shows 0. Then I checked P&L, it actually shows the right amount of 1.16 gain in the statement. Anyone knows why’s it like that? Could there possibly be anything wrong with the journal transaction? Thanks! 

After running customer report, I found discrepancy in Tax code. Part of invoices had taxes included and other part not. Please help me to understand how I can crate adjustment invoices for taxes that needed to be collected.

Hi,Our customer collects prepayments from the same customer for two different purposes. And these two different prepayments, they credit to two ledger accounts in the current practice. How can I post prepayments to two ledger accounts receiving from the same customer. Is there any possible way  ? Thanks,Dulanjana 

I imported my bank transactions and for the first time I’m trying to create missing transactions directly from the the right side of the screen and created rules for recurring transactions with specific criteria so going forward I won’t have to manually input them as they’re validated and I know what they are.  However when I click ‘Process’ it won’t process them because it says the ‘extRefNbr’ cannot be empty.  This field gets automatically populated from the bank’s Quickbooks upload file and I can’t modify it.  Is there an option I’m missing to allow that field to be null or is there something else I’m doing wrong?  Thanks in advance for any help you can provide! 

Hi,In case the employee needs to get some cash in advance to go perform a job. how this works in Acumatica if we will know how the money was used after the fact and we need to track it in the system? Thank you 

Hi I would like make some Profit and Loss report (DPL)  figure in Dashboard for easy reference. example: revenue , gross profit , net profit.  Not sure who can share with me how to extract the figure to dashboard?  

I am wondering how to revalue inventory in ACU. I know I need to use the IN Adjust but still not getting the results I want. I have some items that have correct qty and the incorrect valuation. For these It would just have to remove all of the inventory at system cost, and when I add it back to I use IN Adj or IN receipt? I believe the issue I was having with IN adjust is the costing is tied to the receipt that you choose.We have a few items that have a value by no quantity. I am unable to do a IN adjust with a Qty of zero. The system does not create any transaction. How would I correct these issues?Thanks as always to a great community! 

Yesterday our client informed me that there is an issue with using Gmail for sending large volume email-based communications from Acumatica. They were trying to send some 4500 statement emails when they encountered the following Gmail error: Too many login attempts. Please try again later.  From my reading up, this error is possibly caused by each statement email sent creating a login attempt to the Gmail account. 2 questions on this:Does Accumatica have a config SMTPKeepAlive, which will allow the already created SMTP connection to be reused (without having to re-login each time)? If it does, is this configuration switched on? Is this an issue you have encountered before with Accumatica, and if so how was it resolved?

We have open prepayment from last year. Check has been cleared from the bank. It looks like the accountant didn’t know how to adjust with bill and they adjusted payment without clearing prepayment. Now I cannot void, the check number linked is reconciled and closed.  How can i adjust this prepayment and cleared it from open A/P?  Thank you,Shankar

I have a situation where Users create an Invoice and leave this in Balanced Mode, they are then able to print and email the invoice to the customer. Once done they subsequently receive cash payments from the customer, but then go and delete the invoice (because its still in balanced mode). This gives rise to fraud. How can I disable the ability to print or email an invoice in hold or Balanced mode, and only allow for the invoice to be printed / emailed once released into the system?