We are happy to introduce a new Help Documentation article that helps users navigate through different invoice reversal and pro forma correction options in Acumatica.The article also contains a diagram that illustrates these options. See the article in Acumatica Online Help.Many thanks to Education team for systemizing and communicating the knowledge! Dear community, you can leave your feedback on the article here in this thread. Thank you!
Hello Community;I’m creating a form to retrieve Invoices and Memos infos and calculate some taxes,I’m doing a Left join between ARInvoice table and MasterInvoice where master invoice is a table inherting from ARInvoice, like this : public class MasterInvoice : PX.Objects.AR.ARInvoice{}SelectFrom<ARInvoice> .LeftJoin<Customer>.On<ARInvoice.customerID.IsEqual<Customer.bAccountID» .LeftJoin<MasterInvoice>.On<ARInvoice.masterRefNbr.IsEqual<MasterInvoice.refNbr»The project is published successfully and the MasterInvoice fields are there, but those fields showing no data.Any ideas?
Looking to find out how to change the 2FA for Aatrix when running certified payroll. Can this be done withing Acumatica or is there a separate log in or contact?
With sales orders it’s easy to see if inventory is available and from which warehouse. In projects there is not warehouse specified. We often need to make substitutions or transfer items to fulfill project needs. Current plan is to create reports and a dashboard to help with this, but what are others doing to handle this issue in a more direct way? Has anyone customized Projects so the Cost and Revenue budget areas can have some of the inventory features available on Sales Orders? Or what other work around have you found? We are not using the Construction edition, but these are for small simple construction projects. But I’m also interested to know if the Construction edition has assisted with this issue.
We have a large landscaping client who is migrating from General Edition to Construction Edition. Implementation has been paused, however, because the client is disappointed in the lack of functionality of estimating. We are now vetting ISVs. ProEst is a possibility. RedTeam is only serving commercial contractors. Does anyone have any other suggestions for an ISV? One function our client needs is the ability to drop estimates into projects (not sales orders).
Hello,I have a small issue with landed cost as some of the landed cost goes into the Landed Cost Variance Account and it does not show in the Inventory Valuation report and the Average Cost in the Stock Items.Does anyone know the workflow to correct this issue?The final bill of the landed cost cost is entered after we received our goods and we start selling them right away.Landed Cost Variance AccountThe expense account to be used for this stock item to record the landed cost difference that occurred if landed costs are allocated to an item that has been sold. Thanks,Nelson
Hi, In my Acumatica 21.211.0033 I need to configure endpoint in such way that I will have an ability to generate Checks and Payments item with type Prepayment that will have ‘Documents to Apply’ table and ‘Orders’ tableI have already found and added ‘Documents to Apply’ tableBut I can’t find ‘Order’ table for checkes and payments. What’s it’s name ? Can it be added for using in creating new ‘Checks and Payment’ item with type ‘Prepayemnt’ ?I need something like this
I am currently doing a number of changes on a report in report designer.One of those changes was to remove a subreport that was two pages long. First I tried simply hiding it, setting visible to false. But that did not work.Next I tried deleting it completely.Once deleted, the report is no longer showing the 2 pages, but I now have 1 blank page at the end with only header/footer displayed - how do I get rid of this?
We are trying to update to 23R2 and I was told that one of my customizations will need to be recompiled in order to work with 23R2. What does this entail?
Hello,we have the salesforce sync setup on our Live(cloud) and a Sandbox(self hosted) and suddenly this morning both sites are giving us an error on the real time sync. None of the entities will “Start” on the Salesforce Sync page, and I see this error in trace:“Failed to connect Salesforce Bayeux client”These are connected to different salesforce sites, so I don't think it’s on the Salesforce end.could something have broken on the Acumatica server side?
Is there some way in Acumatica to warn users, during entry, that the Inventory ID exist in another row? ScenarioA clerk inputs a Sales Order, Invoice, or PO with numerous items, 30+, including Item A. Later on they get a request to ‘add’ Items B to the order but they inadvertently select Item A. So the order is now has two rows with Inventory ID Item A. Required behavior:A popup prompt to notifying user that the Inventory ID already exist on the document Place a warning icon adjacent to the duplicate Inventory IDs
I am in the process of desiging a new invoice and my question is what and where are the SOLine.DiscPrice and SOLine.CuryLineAmt. I have SOOrder and SOLine in the relationship and have tried a Left Joiin, Right Join, Inner Join and the report doubled up the line items, as there should have been two line items, there is now four. I do have ARTran and ARInvoice and have been experimenting with those, but I’m still a noob in Acumatica.
Get Started HERE and be sure toIntroduce Yourself
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.