Financials

Client is doing testing from 22R2 to 23R2 and came across the warning “The selected project is billed using pro forma invoices. Manually created AR document will not be tracked in the project budget on the Projects (PM301000) form and will not be shown in the project-related reports.”We see the data on the budget lines of the project so we are wondering what this warning means. After doing some research in the community and release notes I don’t see what they are talking about. Could someone enlighten me? 

Looking for report ideas or recommendations to get to close rates by customer (Percentage of opportunities are being won by customer in quantity and dollars).  Thoughts? 

Hi,Is there a report in Acumatica that show a summary of payment and by types made for a select period of time?Thank you.Raymond

I forgot to lock the period for AP and there were some transactions posted AFTER the cash reconciliation was completed.Is there a report that can be run to see what entries were made after the cash recon was completed? 

Is there a way to directly invoice non-stock items through a Sales Order without creating a shipment? We have non-stock items that are job specific and need to be on the Sales Order. These non-stock items are not tangible products and do not require shipments.  We would prefer to steer clear from creating fake shipments and invoicing through AR since we would like to have a document that is connected to the specific Sales Order.  Thank you!

Hello all,I was wondering if there is a way to offset a "Purchase Recipt" against a "Purchase Return" so the “Enter AP Bill” goes away without the need to really enter AP bill? The case is it happens that users accidently enter a purchase receipt and release it but then realise something is wrong (i.e. a wrong vendor is selected). Considering the document is released then it can not be deleted so they enter a purchase return. But, considering in reality there is no invoice or credit memo and simply a user error has caused the issue the need for this offset arise. Any way out-of-the-box we can make this work?

Hi All,Is it possible to add a new Customer Status, to this drop down called “Legal” that behaves the same way as the “Inactive” status throughout the system? If so, how do I do it thxDries

We have two companies, soon to be three, setup on Acumatica and they do not share customers at all. We have been using the “Restrict Visibility” field to make it so that employees can only access customers that are a part of their company. Unfortunately, people forget to fill in this field all the time, leading us to have to go through manually figuring out what company they belong to every now and then. I looked into trying to auto-fill this field using customer classes, but the customer classes are shared between companies, so that’s not an option. I decided to turn to coding and try to use PXDefault to pull the branch/company from what the user is signed into, but I can’t get it to work and it just keeps throwing the following error. If anyone could give me a hand, that would be great.The multi-part identifier "Customer.COrgBAccountID" could not be bound. Here is my codenamespace PX.Objects.AR{ [PXNonInstantiatedExtension] public class AR_Customer_ExistingColumn : PXCacheExten

Once we match our transactions with the bank feed, is there any way on the transaction screen, to see if it has been matched to a bank feed transaction ? i.e. in the bank feed, we are able to see the AP document from the “Process Bank Transactions” page.However, on the AP document, are we able to see the corresponding bank feed item?

Hi Community,Our customers need line item taxing details for audits, and we use Avalara for tax calculations. We’ve heard that Acumatica doesn’t store line item taxing info, but we’ve seen this feature in other systems.Can anyone confirm if this feature is on Acumatica’s roadmap? If not, is there a workaround?Thank you.

the two companies need to have independent Customers, Vendors, invoices, PO etc…  How can this be setup  

While working on entering the employees into "Employee Payroll Settings", there are a couple of setup concerns/questions: The system is allowing me to enter all Social Security #s as the same number. I'm not getting an error message that the number is a duplicate or already used.  One of our employees' tax setups in Sage has their Federal Withholding at an "Additional 25%"...not a dollar amount.  The PR Settings does not allow a percentage...only an amount.Please refer to the below screenshot 

Getting this error when trying to add SalesOrder , not sure what is meant by this errorTax DEFAULTID was not imported. Error: The DEFAULTID tax cannot be applied to the document because there are no document lines whose tax category contains the DEFAULTID taxI already have  the  DEFALUTID tax defined and linked to the Tax Category correctly

How can we display due dates for Prepayments? Any suggestions ?

Hi,We are building an integration to Acumatica from iPaaS.com and are encountering an issue - we are not able to attribute payment to an order. We have tried multiple sets of sample data, but still can not figure it out. Here are some notes related to the sample data sets we have tried: u100 basic company - has cash accounts but sales orders are not enabled u100 has sales orders enabled but cash accounts are not displaying in UI Neither has existing sales orders to attempt adding a payment to Here are screenshots of the demo cash account configuration:Unfortunately, its the same as our original company:It cannot be added as payment:We created another account which is not defined as a cash account, but the same error occurs. We looked through the documentation and found https://help.acumatica.com/(W(2))/Wiki/Print.aspx?pageid=29cf6881-e21f-4130-94fb-f10bfd511ff7 where it says:  "You indicate that an account is used as a control account for a particular subledger by selecting the sub

When making a two-step transfer, there are more lines in the journal entry than the lines in the transfer, which are divided into many lines. 

Any idea how to tie out consolidated Cash Flow to Balance Sheet with multi-currencies? We have a client having branches in two different countries and trying to build consolidated reports.

Hi Team, Is there any user guide for the consolidation of financial statements in Acumatica ? Thank You & Best RegardsYashodha

Hi All, Were else can I check for unreleased docs. I have already checked the Release AM docs and Release Production orders.  

Hello all,I have been trying out the Incoming Doc feature. This is the following document. I have the Inventory ID mentioned in the description itself. The inventory ID is “SH038” where the rest is the inventory description, but still it is getting recognized as transaction description. How can make it get recognized under Inventory ID and the rest under transaction description.Also it has a sales tax and freight amount. How can I set this up so that my tax & freight is recorded under the same account as that of the Inventory ID. 

I would like to add an step in the AP Bills approval when the difference in price between the vendor’s invoice and the PO receipt is greater than 10%. I can only find in the AP Bills approval map an option for PO PPV Amount is greater/less/ than a particular amount but not nothing that I can use for %. Any ideas on how to handle this?  

Hi all,We are working on an implementation where everything is billed in advance.Projects is being used to track costs/revenue and margins and we would like to setup the Project to Bill in advance for next month.However, I cannot see an easy way to do this. We setup monthly recurring billing on our Projects and then when we go to the Run Project Billing screen, it only lets us bill retrospectively.I've tried changing the next billing date to today when setting up the project, which seems to work, but in the Run Project Billing screen the from and to dates show as being this past month. So it still looks like we are Billing retrospectively.As a bit of extra info, we are using Acumatica to track on monthly/quarterly/yearly Software subscriptions. We are billed by the suppliers in advance and need to ideally be able to Bill the Clients in advance.Any help and advice would be greatly appreciated.Many thanks,

Hello,Does anyone have an export scenario for EFT file for Canadian localization?Tried to use the base Acumatica export scenario, but that is throwing errors when exporting the file in batch payments screenAny help would be appreciatedThanks,Swetha Reddy 

hello all,Can anyone guide me out as to where can  i find the company’s or branches’ bank account details? i know about how to set the up for Vendor part but for own company where I can setup?Thanks.

Acumatica returns “Object reference not set to an instance of an object.” when I attempt to filter by a portion of the batch number using “Contains” in Batch Payment Nbr. field of Cash Account Details screen. If I use “Equals” with the entire batch number, Acumatica returns “No Records Found.” I end up having to filter by “Is Not Empty” to narrow the results down to payment batches only. From there, I can clearly see the very same batch number that Acumatica could not find with “Equals” or “Contains.” How do we fix this? Thanks!