Hello team,
I have been looking out if I can create a debit adj to reverse an AP bill of a non project code & then create a new AP bill under a project.
Let me know if you have any other suggestions on this.
Thanks in advance.
Solved
How to reverse an AP bill of non project code so that I can record an AP bill under a project code?
Best answer by Laura02
Hello
If you have a Debit adjustment with no project and you’d like to replace it with a Debit Adjustment with project populated, you may reverse the Debit Adjustment and enter it again.
Most Debit Adjustments may be reversed with [...] More actions menu, Reverse. If Reverse is not available for your Debit Adjustment, simply enter a Credit Adjustment to match the Debit Adjustment in AP Bills & Adjustments screen: same date, same vendor , same amount, etc. Then copy the original Debit Adjustment to a new Debit Adjustment and change the Project field.
Laura
Hello
Yes, you can create a debit adjustment and apply it to the AP bill.
Or else you can directly reverse the AP bill; it automatically creates a debit adjustment.
Please test this on test tenant first.
1 person likes this
MuthumaliDhanushika27 wrote:
Hello
Yes, you can create a debit adjustment and apply it to the AP bill.
Or else you can directly reverse the AP bill; it automatically creates a debit adjustment.
Please test this on test tenant first.
is it possible to run a sql script where i can modify the project Codes?
+19Hello
No, not recommended to run any script to update project code from X to a project. There is more impact in other tables of the database, transaction creation in projects module, update of project on the GL transactions for the document, etc. to consider. Definitely not recommended to use SQL to update transactions.
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Hey
1 person likes this
+19Hello
If you have a Debit adjustment with no project and you’d like to replace it with a Debit Adjustment with project populated, you may reverse the Debit Adjustment and enter it again.
Most Debit Adjustments may be reversed with [...] More actions menu, Reverse. If Reverse is not available for your Debit Adjustment, simply enter a Credit Adjustment to match the Debit Adjustment in AP Bills & Adjustments screen: same date, same vendor , same amount, etc. Then copy the original Debit Adjustment to a new Debit Adjustment and change the Project field.
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.