Financials

Hello, I have a released AR invoice that had the incorrect date entered. I have tried to correct the invoice date, which moved from July into June period, and when trying to release the corrected invoice I get an error;“Inserting 'Applications' record raised at least one error. Please review the errors. Unable to apply the document because the application period precedes the financial period of the document.”So it appears it is due to crossing to a prior period. How can I correct this AR invoice and get it in the correct financial period? 

 On the Print Invoices and Memos screen in Acumatica, is there a way to create individual PDFs for each invoice during bulk printing?

Balance left open on AR aging.   I have the below payments still showing available to apply to open invoices.  But when I click on the payment is has already been applied.  How do I clear this out in ACU   

is it possible to add the Project # to the Finance > Account Details > screen? I see that this is not a GI, so I am not quite sure how to edit this inquiry.  This matter is rather urgent, so any and all responses will be greatly appreciated? 

We have not been able to get our Acumatica bills to pull in the purchase orders.  There are open purchase orders, but when we click on the button to load them, nothing comes up.  We have tried checking and unchecking various boxes in the settings and can’t seem to get it to work.  Does anyone know what the settings have to be to have this functionality?  

Hi guys, do you know if there’s any way to set up a black list of creditors so that once we are in a conflict, the invoices to them will be suspended in any way? Thanks!

When a fixed asset is set up the asset class controls the depreciation method, once you have run a few depreciations can the method be changed to another calculation method for this asset? 

We are implementing the ACH (we are in Canadian localization). To do this we created an export scenario with CPA005.Everything has been tested and is functional with our bank.The export file always has the same name (required from our bank) for the same Originator ID.Let's say for example that we have 2 distinct batches, for the same Originator ID, #15 and #16. We export them with the "Export" action button in order.We have just noticed that when we export #16, and when we reopen #15, it is overwritten or at least seems to point to the file exported at #16. Is this normal?We believe that each batch should have its own file attached. And they shouldn't have any connection between the two?! Thanks

Hi,I have a payment missing in bank transaction history area and also did not come up in process bank transactions area so I could not match with payment. I checked payment area and all look ok. (payment gone through correct amount and correct date). Can anyone please help ? Thanks.

Hi all!For some reason, we have a warning on the timesheet for certain employees :Do you know where this warning comes from? I would like to correct it, it’s not needed in this caseThe employees use a labor item which is “Labor Item” type in Labor Rate Form PM209900, and aren’t set as “Employee” type in Labor Rate Form(So no hour quantity in the column “Regular hour by week”. The “Regular hour validation” is set to “Warning” in Employee form EP203000, but i dont understand where it takes the 57.5h?   Thanks  

Is there a way to easily CORRECT the Vendor Reference Number (ie. invoice #) of a Bill after it has been released and before it has been paid?  Currently the only way I see how to do this is to reverse the whole Bill.  This seems extremely unnecessary when what is needed is just an invoice # CORRECTION.  This is no different than changing the Due Date which, correctly so, is allowed.

I’m working with a partner, and were attempting to reconcile many months of inventory history to the Trial Balance Summary. We’re attempting to build generic inquiries to do this using the INTran and INTranSplit tables, extracting rows, grouping by our materials / lots / warehouses / locations to find that last transaction and filtering by Financial Period.  Our comparison results are sometimes close, but never tying out. The back story is that a number of inventory receipts and adjustment were done during various go-lives and onboarding events, and now the Finance department is concerned about being able to audit the the history, essentiallly using details to prove out the Trial Balance Summary report.Has anyone out there encountered this circumstance? Perhaps someone might shed some light on how the Trial Balance Report (especially Inventory Accounts) is calculated and relates to the transaction history?  Many thanks!

Upon Adding of New Restriction Groups,The system gave me this error.Would you help me to solve this issue? 

Client bought 8 (qty) fixed asset amounting to 8,221.71. When converted to fixed asset, the fixed asset transaction generated 9 asset IDs one of which amounts to only .03. So i tried to recalculate it manually.8221.71 total for 8 assets / 8 = 1027.71 each1027.71*8 = 8221.68.03 = value of 9th asset recordedIs my observation right?Is this really possible?how are we going to explain this to the client?

Hi Acumatica Team,I want to transfer a particular item from one Project to another Project but Acumatica gave me this error message. This is my project set upBalances :Purchase ReceiptsWould you help me to trace this error?Thank you! 

Good morning, while on the Credit Memo and Debit Memo screen in AR, when we add a row, the row automatically adds account 3030. How can we change this to be an account other than 3030? Note: we know how to change it after the row is added, we need to change it so when we add a row it automatically goes to another account other than 3030. See attached below for reference:Thanks!

Hi,What happens when landed cost is added to an item after the the inventory issuance? For example, our manufacture sends us an invoice for the landed costs associated with a PO after its been received. In some instances the landed cost has been received even after we’ve invoiced and sent those items  out to our customers. I’m curious as to what happens in Acumatica once I add the Landed Costs to those items after its been invoiced and shipped out. How are the landed costs expensed as COGS. -Edwin

Does anyone know why journal transactions from the AR Module wouldn’t automatically post to the GL if it’s set up to do so?  We have noticed that 3,666 transactions from a one week period in December have not posted to the GL. I’m relatively new to the position and at a loss as to why this would have happened.  Any help is greatly appreciated!  

We created a new subaccount to have sales orders split out into a new bucket for additional analysis.  Everything is flowing correctly going forward, but I would like to go back and reclass existing transactions (sales and materials) to get to the proper subaccount for historical comparison.  I can get to the sales numbers by running the sales order report and filtering to what is needed.  The part I am struggling with is how do I get to the materials cost to complete my bulk reclass entry?  I am not finding a way the 2 are connected by a reference number or some way I can get the data into a spreadsheet to identify the entry needed.  I would love if anyone has an idea of how I can make this happen!

Can someone help me to restrict the access of user to see only debit memos / debit memo but not to see payments under bills and adjustment??

Does anyone know of a way to extend a customer to a vendor if that vendor already exists? I know you can do it if they do not, but what if the vendor exists? Same for vendors to customers? 

Hi,I need to void a customer payment received back in few months ago. There is a field “Card/Account Nbr” which is empty and the system said it can not be blank. I try to enter something into it but can’t. Not sure what to do. Please help. Thank you. Raymond

I have a user uploading an Excel file into the journal transaction screen. If a subaccount in the file is inactive in Acumatica, it automatically changes to the subaccount of previous line. No warning or anything.  I tried recreating in my local test environment, and instead I get an error that subaccount is inactive. I don’t see any relevant differences in the settings. Anyone seen this or have an idea how to solve? Unfortunately upgrade was delayed so I can’t submit case with Acumatica. 

Hi Team,Good Day!As a practice our company used to print the payment voucher from the checks print process. (Kindly refer the following image 01)Image 01In that process one check is only allowed to print at only once. So if we have any issues with the print we are not able to reprint it also we are unable to track the issues.So my concern is, is there any other way to get the print of the payment voucher from the system ? (Without using the check printing process) Thanks & Regards / Yashodha

Our customer would like to apply payments by using a process for pay/release A/R invoices.For credit card there is “auto-apply payments” but this is not available for any other payment method.What do you suggest?