Hello, It’s difficult to answer your question without knowing more. Every company is different and has different needs; there is no real “average”. Are you asking about manufacturing only? → your GL, AP, AR, Inventory, Sales Orders, Fixed Assets, Taxes, Reporting, Payroll, eCommerce, Time Entry, Purchasing, User Security and all other modules are already up and running on Acumatica (or will be handled in a different system), and you are configuring only manufacturing basic production processes in Acumatica? If your answer is Yes, only basic manufacturing module... then maybe it is possible to implement manufacturing in 45 days, with sufficient internal resources at your company and sufficient resources at your partner’s company. (Anything can be done with sufficient resources, correct? How many human resources do you have working on implementing this system?) I do not think 45 days is achievable if GL, AP, AR, Inventory, Sales Orders, Fixed Assets, Taxes, Reporting, Payroll, eComme
Thank you , I did do the reversal as advised and produced the desired results
The solution is by copy the report Historical Inventory Valuation into “Inventory Valuation by Period” and adjust the report little bit to make it looks like report Inventory Valuation and add the Filter ItemHistLast.FinYtdQty NotEqual 0. Please see attached the modified report. Then you have to make Balance Sheet for Inventory tally with this report by journal adjustment. Great report, can I make a custom report from this one that just shows a line item, branch, quantity, unit cost and line total and then exclude the General ledger details?
Instead of displaying [ARInvoice.CuryDocBal] for example, try something like this: iif([ARInvoice.DocType] = ‘Credit Memo’, [ARInvoice.CuryDocBal]*-1,[ARInvoice.CuryDocBal]) Laura Thank you this resolved my issue
Hi @kudzaim20 Import Scenario looks good to me. @vkumar Correct me If I’m wrong here. I have just enabled the “Commit” on the last row that is the <Action: Save> line, I will monitor to see if import speed has improved.
Hi @kudzaim20 Pease send your import scenario as well. If ‘commit’ is checked on most columns, it will try save the data for each column mapped ( commit enabled). Regards, I have also attached a screenshot of the import scenario
Hi @kudzaim20 Pease send your import scenario as well. If ‘commit’ is checked on most columns, it will try save the data for each column mapped ( commit enabled). Regards, I have attached the import scenario in xml format
Hi @kudzaim20 Ideally it should NOT take that much time. Also, have you tried with the “Parallel Processing” option in the import scenario? Let me try the “Parallel Processing” route and see what happens What does the “Parallel Processing” option do?
Hi @kudzaim20 Ideally it should NOT take that much time. Also, have you tried with the “Parallel Processing” option in the import scenario? Let me try the “Parallel Processing” route and see what happens
Running 2021 R2Build 21.201.0086The only maintenance work carried out was to truncate the SMPerformanceInfoSQL Table and shrink my AcumaticaDB database file.
Thanks find attached the xml file
Find attached the import scenario
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.