Resolved for our customer, stopped real time sync for refunds and sales orders then did a manual prepare and process this imported the returns and refunds turned real time sync back on this is now working for us.
Did you ever find a solution for this @DavidEichner I have the same issue, no return order created no errors in sync history. It is adding “Modified Externally, sync not needed” to the original order that was imported into Acumatica from Shopify.
Thanks @miguel80 for looking at this, customer is ok with the solution as is, I will play around with sub reports for the future, thanks again much appreciated.
Hi @miguel80, still have the issue, I have uploaded the report any support is appreciated.
HI, @BenjaminCrisman, thanks for the reply, yes I have tried that, cant seem to find a way to print the 3 detail sections in the order required, will keep testing and .come back if I get a solution
Acumatica have advised this will be fixed in 2023R1 at the earliest, If you need to import project quotes in the meantime you can log a support case and they have a fix they can deploy after the project quotes have been imported.
Thanks for the help everyone, Acumatica have come back and confirmed this as a known issue and investigating it further
@gauravsharma96Just a quick check here, have you verified that the segmented key for PROJECT is also checked for Auto Number? It is strange that the first one works and subsequent ones do not. Hi Yes have double checked it is very strange first one works then does not
Hi @manikantad18 , thanks for looking at this file attached
2022R1 -Build 22.110.0018
Hi, you can change the control account on the chart of account form if you have access to it, what is the reason you need to disable it as it may have been used so could cause issues changing it
The issue will be the program needs to link to the correct receipt so it can correct FIFO without knowing all the numbers don't think it can be automated
Hi, I had the same issue trying to correct inventory transactions for the history valuation report, could not find a way to automate the process, in the end got the customer to stop processing at month end removed all stock and added them back in (using issue and receipt) with correct cost price which resolved it for them moving forward, but this way they cant get correct figures in the report further back than when it was corrected.They has thousands of adjustments they needed so for them this was the best solution.
Does it show any errors in business event history?
Hi,How was the stock brought in, we had a similar issue it turned out stock had been allocated to project x which we transfer from project x to the relevant project which resolved it.
Thanks for the help Acumatica support have confirmed it is not possible will look into alternative solutions for the customer: “I have checked this further and found no other workaround for the scenario mentioned.- The cost entries are generated on release of PO receipt and IN receipt and not at the time of AP bill release- AP bill release hits only Inventory purchase accrual account and not actual expense account linked to the non stock item- Hence, only alternate option to enable use of actual cost is to avoid creating PO receipt”
Hello, I expect the difference is being caused by how purchase price variance and/or discounts post. For example, difference in price on a bill versus the PO should post to PPV, Purchase Price Variance. Optionally, the difference could be posted to a discount account in your case, and the Discount account may not have a project account group attached in the Chart of Accounts. My suggestion is to start by looking at the GL batch produced by your AP Bill to see exactly what the debits and credits are, to what accounts. Identify to what account the 10% discount/PPV posted and see whether it has an Account Group populated on the Chart of Accounts. If the account identified does not have an account group, then it’s not identified as being a project-related posting and cannot update your projects. Thanks for the suggestion Laura, have done that now and added the GL account to the account group and tested with same result, a ticket has been raised with Acumatica support will post solutio
Already have an account? Login
Enter your 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.