Financials

Hi,Is there a way to check which user create a journal in the system and when it was created? Thank you. Regards, Raymond

Hi group ! ,I am almos a new Acumatica End user( and not a VAR). I asked this question without having a clear answer(var).We did our GoLive on Acumatica 7 months ago now and it is going well. We haven't asked users too much to archive all PDF documents in the forms, at least for the beginning.For the moment, we are attaching the PDFs of the important AP bills, let say ± 10% of them, but not all without exception. I would like us to do phase 2, which would be to archive all AP bills in PDF without exception. However I am always concerned about space usage.What will happen when we bounce the max space? When it will arive, Should we export/delete somes files? If I need to export/delete files, Is the choice of file to delete will be easy & convenient? (Eg: sorting by date, document type)? Or the solution is to take a bigger package with acumatica, and so on when we will bounce again...I'm wondering if there are many of you who upload PDF invoices to all AP invoices or if we are the on

A client with SOX compliance requirements, but a small accounting group, needs to make sure that a JE created by one person is posted by someone else.  This is for their internal controls and outside Auditors.  An approval flow would be ideal rather than security roles. 

Hi, user meet an issue when doing an AP bill,there is a bill with vendor A, but employee1  already help to make the full payment.Right now, they want to use the same ap bill to pay back the amount to the employee1 to clear the amount which still owed to the Vendor A.Scenarios:Vendor still = Vendor Abut the amount in checks and payments screen pay to Employee1Is it able to do it?

I created a new Non-stock item to use for expense claims, but the “Current Cost” is not updating even though I saved the item with the new cost and current date. (see screen shot).  Why did that not update the current cost? 

I am not able to edit an existing “ONHOLD” Bill, has anyone run into this issue today?  My Bills that are in the “OPEN” status don’t have the PAY option available either.  I can create a new bill but as soon as I save it the amount is not transferring over to the AMOUNT box.ThanksHolly

Hello - I want to set an approval process for “normal” PO’s. However, I want to exclude the process for Drop-Ship POs. What is the best way to do this?I have some automation that will generate the PO for our drop ships.When I turn on an approval for the Normal PO I start getting an error regarding the lack of an owner on the PO. 

Acumatica has as a 1099 Box selection - MISC 07/NEC 02 - Direct Sales.  Is there any documentation on this or does someone know how / where this box should be used ?  I have found that using this Box on AP bills does not print on either 1099 form.  Is this a big?IRS says… You may either file Form 1099-MISC (box 7) or Form 1099-NEC (box 2) to report sales totaling $5,000 or more of consumer products to a person on a buy-sell, a deposit-commission, or other commission basis for resale.  

How do I clear/delete the child PO of a Blanket PO that has been deleted and no longer available? Child PO is still showing on Hold with Error: An Invalid Argument has been specified. Parameter Name: blanketRow. Visually, the child PO is completely blank.  

I’m trying to automate the monthly revaluation of GL accounts in foreign currency. Screenshot below is what I came up with for the filter. What I’m not sure about is the financial period. I’d like it to be relative like the date, but my understanding is that checkbox only works for date fields. Anyone know if there’s a way to make it default to current period so it doesn’t have to be manually changed every time?  

Situation - a business has a long term loan, a mortgage loan, where the monthly payment is fixed and the split between principal and interest varies each month based on the mortgage amortization schedule. The monthly loan payments to the lender are set up to be made via PAD direct from the company bank account.I can create the first monthly mortgage payment as a journal transaction and then create a recurring transaction from the journal transaction.  Generate recurring transactions will create the monthly payment journal transactions, but only the 1st payment will be correct. The finance user will need to edit the 2nd and future journal transactions and correct the principal and interest distribution amounts manually, according to the amounts from the amortization schedule.Is there a better way to configure this?I suppose the Balanced 1st journal transaction could be exported to Excel and the future monthly payment transactions be added into the Excel sheet with the correct split betw

Hi, I incorrectly press “refund” to a customer “credit memo” in Acumatica. Is there a way to reverse the action? If not, how do I correct the mistake? Thank you. Raymond

Is there a way to build a GI which would look at total demand for a given item. We are trying to capture inventory items which we have marked as Inactive but still sit on various forms (POs, BOMs, etc.).

Dear All,please advise me  for this case:I creates an Invoice on screen SO303000 without SO/Shipment. This SO also chooses inventory idBut I don’t want to generate an inventory issue. Thanks alot!  

We have a client who wants to import data for invoices through import scenario.  However, they would like to not have to select each resultant invoice and print.  They would rather the system print the invoices generated from the import scenario automatically.  I inserted and selected the print and email function but it does not print.  Have I inserted this in the incorrect place or what whould you suggest?If there is a way to print all invoice from a mass release that would work as well, but how is this done?Or is a better way?Thanks. 

Hi AllWe are currently implementing a new business module - Subscription Fee for customers. This means that we will receive upfront payment from customers. From a financial perspective, we need to split the subscription fee into 12 monthly installments to accurately capture revenue each month.I'm not sure if anyone knows whether Acumatica can support this type of subscription fee module.If not, is there an integrator that can support and integrate it into Acumatica?I hope to hear from you soon."  

We have discovered that we have duplicate IN journals being created.  So far we have found them to be on Moves, Materials, Purchase orders and Adjustments.  It isn’t every time but is a couple of times a day.  Values of the journals vary significantly.  It is across our users, so not limited to one user.The journals are identical, one auto releases and the other sits in ‘unposted’ status.Has anyone had similar happen?  

Having an issue with the Reassign process when approving AP bills.Bills are assigned using our Approval Map and occasionally a bill needs to be reassigned to someone outside the Approval Map. Our approvers need to put the bill on hold and enter the correct project task and cost code. Once they remove the hold they are no longer the assigned approver (the Approval Map assigns it back to the original approver).  Ideally the bill needs to be put on hold to edit and keep the reassigned approver – any help on how to make this work would be appreciated.

We are in the middle of config and we are very disappointed and surprised to know that Acumatica does not print ACH remittances when payments are released. This is a core step in any payment processing. When you are paying vendors, any system prompts you to PRINT cheques or ACH remittances. This is normal “process flow” regardless of the payment method. Why couldnt ACH payment do the same (i.e. prompt us to print remittance details)??? This is very standard step/process - it is normal to print file copy of ACH remittances so they could be attached with invoices paid.Would you please share some input? Any help would be appreciated. Wouldn’t it make more sense to normalize the ACH payment process flow to include printing remittances?????? 

Dear all, Please help to define 2 cases of Terms as bellow:Case 1: If Invoice date is between 1 to 15, Invoice due date is end of month + 10 daysIf Invoice date is between 16 to 30, Invoice due date is 25 days from next monthexample: Invoice date is 10/12/2023, Due date is 9/01/24Invoice date is 17/12/2023, Due date is 25/01/24Case 2:If Invoice date is between 1 to 15, Invoice due date is end of month + 30 days If Invoice date is between 16 to 30, Invoice due date is 45 days  from next monthexample: Invoice date is 10/12/2023, Due date is 30/01/24Invoice date is 17/12/2023, Due date is 15/02/24Thanks you so much!

We have a client that had an error on their production orders and accidentally applied overhead to all of their outside processes. it was not realized until the production orders were completed (NOT Closed), but there are roughly 1000 production orders that were effected. They tried to do a WIP adjustment to offset the costs, but that was not effective, as it was reversed when the production order was completed. If anyone has any thoughts on how to best remove these, that would be helpful.

Hello - We have found a check at one of our properties “On Hold” from 12-2022 (screenshot 1). When I go to open this check, I get this error message, “Object reference not set to an instance of an object”. I have found this check applied to a Bill, with the status of “Open”, and I cannot delete the bill or clear the application. When I select “Pay”, I get the same error message “Object reference not set to an instance of an object”Additionally, I have found a debit adjustment referenced to this Bill in 09-2023, seemingly attempting to reverse the error. But I am unable to apply the Bill to the Debit Adj, or release it. (screenshot 3 and 4))Does anyone know a workaround so I can find this check and delete it? (A second check had already been cut and paid for the same time period)Thanks! Bill with the Check Applied and the Debit Adj  

clients receive emails from their customers with a PDF of a remittance.  If we can copy the AP doc recognition service and use it for AR. This would be nice and save time.   The service needs to recognize the Name and Customer ID

We have an invoice that is showing a Status of Balanced, and when we try to release it we receive the following error.Error: Inserting 'Applications' record raised at least one error. Please review the errors. The total application amount, including the cash discount and the write-off amounts, cannot be negative. We have looked though the entire order and cannot figure out what the issue is. We have looked at other invoices that have been completed and we can not find any differences.Anyone have an idea what this error message is refering to or where we need to look to fine the problem.Thank you!

Client has a customer that has a 5% discount code on all orders. When a sales order is created the discount is applied and is under the discount details tab, which is automatically taken of the sales order amount However, in a situation where the customer is returning stock and a return for credit sales order is created the RC sales order does not include the discount amount in the credit, so the original sales order amount is displayed in the RC sales order: Is there a way for the discount to pull through on a credit memo or RC sales order if discount has been applied with a discount code and not on the line item itself?