• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Adjust Due Date to a future date on Billing records due to COVID-19

sheeba

Member
We have a request from Business to move the Due Dates on the billings from 4/1/2020 to 6/1/2020

The Recurring billings have already been posted . And business does not want to unbill and rebill all of it again.

Please advise .
1. Would sql-ing the new due dates into JDE Billing tables work?
2. Which tables will need the Due dates sql-ed/updated?
3. Which date fields on JDE tables need to be considered for the due date updates
4. Is there any other way to update due dates other than via SQL
5. How do we make sure everything works as expected with this change to due dates on the tables?
6. What other tests should we run to make sure nothing breaks due to to this data update

Would appreciate a quick reply.
 

cribeiro

Member
Hello, hard times!!! Hope you and your family is safe!
So, you could use the P03B114 - Speed Status Change for AR, instead a SQL. You can select as many records as you want, click Global Update, select the new Due Date, and Press OK. It is done. In here you can also update the status, and many other fields as you can when you open the screen, please be aware you can see the Due Date and the Discount due date. (see attachment)
To get there:
>Accounts Receivable
> Daily Processing
> Manual Receipts Processing
 

Attachments

jdemes

Member
1. Yes
2. F03B11 AR Customer Ledger
3. RPDDJ Due Date and the audit fields - something like this:

update pddta.f03B11
set rpddj=120153, --6/1/2020
rpuser='SHEEBA', rppid='SQL', rpjobn='SQL', --AUDIT FIELDS
rpupmj=120080, rpupmt=084000 --TODAY'S DAY AND TIME
where rpddj=120092; --4/1/2020

4. Yes, P03B114 Speed Status Update. Search for and select all invoices with due date 4/1/2020, click Row > Global, enter Due Date 6/1/2020 and check the Update box, and click OK.
5. View invoices via P03B114 Speed Status Update or P03B2002 Customer Ledger Inquiry
6. Run R03B500X AR Statements, confirm the new due date, and send them to your customers
 
Last edited:
Top